create memory table can't use the complicate select with "not persistent" option?

[Lance]

Hi,
The sql
create memory table test1 as select * from table1 inner join
table2... not persistent
can not work....

1 Remove the "not persistent" ,it can work....
2 Remove the join ,it can work... Create memory table test1 as
select * from table1 not persistent also can work..
Does the create memory table can't use the complicate select (such
as join) with "not persistent " option....?

[Sergi Vladykin]

Hi,

Please look at http://h2database.com/html/grammar.html#create_table
As you can see from railroad diagram full table definition including
'not persistent' option should go before 'as select...' statement. If
it can work in ways other than that it is probably a bug.

Sergi

[Lance]

Thanks.
     I append the "not persistent" option to the end of sql because the the pdf doc i reference to is old version 1.2.124)...
     The new doc has fixed this issue.
     but the sql can't work on 1.4.154  no matter append the option before the "select" or end) , i have to download the 1.3.166,it can work now...
 
   

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[Lance]

My mistak...the sql can't work on 1.3.154  rather than 1.4.154