Error: create table as currently does not support identity columns

Database
N/A

Error: create table as currently does not support identity columns

I have this very simple code and it's works two days ago, but now not O_o

 

CREATE MULTISET VOLATILE TABLE tt_temp,NO LOG AS

(

select * from table_SpecialInfo ) WITH DATA ON COMMIT PRESERVE ROWS;

 

What's wrong now? PLease help!

4 REPLIES
N/A

Re: Error: create table as currently does not support identity columns

Well, the error message clearly states that CREATE TABLE AS is not supported for tables with identity.

When it was running successfully before you cloned a different table without identity

N/A

Re: Error: create table as currently does not support identity columns

Hello Dima,

You're right -  this very simple code

Try this:

CREATE MULTISET VOLATILE TABLE tt_temp,NO LOG AS

(

select table_SpecialInfo .* from table_SpecialInfo ) WITH DATA ON COMMIT PRESERVE ROWS;

 

N/A

Re: Error: create table as currently does not support identity columns

TNX A LOT!!!

 

it' works!

N/A

Re: Error: create table as currently does not support identity columns

Caution, CREATE TABLE AS SELECT will result in all columns being NULLable and the first column as Primary Index, which might be very bad.