Archives of the TeradataForum
Message Posted: Mon, 10 Jul 2006 @ 09:48:34 GMT
Anyone instantly know what this error means when applied to the following Join Index definition :
CREATE JOIN INDEX DEVNAD_T.ACCOUNT_JI1, FALLBACK AS SELECT a1.COU_ID, a1.ACC_ID, a1.ACG_ID, n1.NAD_ID, n1.NAM_NM FROM DEVNAD_T."ACCOUNT" a1 LEFT JOIN DEVNAD_T.NAD n1 ON ( a1.COU_ID = n1.COU_ID AND a1.ACC_ID = n1.ACC_ID AND a1.ACG_ID = n1.ACG_ID ) PRIMARY INDEX (COU_ID, ACC_ID);
"5464: Error in Join Index DDL, Only satisfiable conditions that have constant and/or inequality conditions anded to at least one equality join between columns from different tables which are of the same type are allowed in the ON clause."
What a mouthful !
For information, all columns are Char, all are the same length and all are Not Null on the 'a1' side.
When I compare it to the Help example, it doesn't look too different :
CREATE JOIN INDEX CustOrdIdx, FALLBACK AS SELECT c.CustId, c.Name, o.OrderDate, o.Status, o.Special FROM Customer c LEFT JOIN Orders o ON o.CustId = c.CustId PRIMARY INDEX (CustId);
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|