You need to append "WITH DATA" or "WITH NO DATA" at the end of your create statement. http://www.monetdb.org/Documentation/Manuals/SQLreference/Tables Regards, Roberto On Mon, Jul 8, 2013 at 11:41 AM, Franck Routier wrote:

Hi,

I am trying to create a table as select, but it fails...

Here is the statement:

create table imagerie_ft as select dwhdim.*, dwhq135.q135 from dwhdim join dwhq135 on dwhdim.dwhcolcsu = dwhq135.dwhcolcsu;

The select alone works fine. The same statement with create view instead of create table works fine.

But the create table fails with:

Error: syntax error, unexpected SCOLON, expecting WITH in: "create table imagerie_ft as SQLState: 42000 ErrorCode: 0 Error: select dwhdim.*, dwhq135.q135 SQLState: 22000 ErrorCode: 0 Error: from dwhdim join dwhq135 on dwhdim.dwhcolcsu = dwhq135.dwhcolcsu;" SQLState: 22000 ErrorCode: 0

Should I report a bug, or is using the * in the statement for a create table a non supported sql idiom?

Franck

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list