 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Nov 2004 @ 07:57:10 GMT
| 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.
| |
