Archives of the TeradataForum

Message Posted: Mon, 10 Jul 2006 @ 09:48:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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);

_______________________
Dave Clough
Database Designer
Express ICS

www.tnt.com

	<Prev	Next>		<<First	<Prev	Next>	Last>>