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...
On 1 June 2012 06:22, Sergi Vladykin <[email protected]> wrote:
> 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.
>
>
--
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.
