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 On May 31, 2:02 pm, Lance <[email protected]> wrote: > 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....? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
