Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2004 @ 07:57:10 GMT


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


Subj:   Re: Create table as in V2R5
 
From:   Michael Tarajos

We ran the same SQL in V2R4 and the attributes are copied when doing a sub query, in V2R5 the attributes are not copied.

For example if the first attribute has compression set, in V2R4 when get an error when doing CREATE TABLE AS (SELECT attribute ...) because the CREATE TABLE AS defaults the primary index to be the first attribute selected, and you cannot have compression on the index, in V2R5, because the attribute options are not checked, the same SQL that gets the error in V2R4 works.



     
  <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: 15 Jun 2023