create table as fails

Roberto Cornacchia roberto.cornacchia at gmail.com
Mon Jul 8 13:30:34 CEST 2013


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 <franck.routier at axege.com>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 at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130708/77d9f383/attachment.html>


More information about the users-list mailing list