Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Join Index error
 
From:   David Clough

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016