I made this patch because I have come across valid MySQL script that failed to execute on H2. Here is script extract:
drop schema if exists ourprice; create schema if not exists ourprice; use ourprice; There're other MySQL things that do not work for H2, I will provide patches accordingly. On Feb 13, 3:42 am, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks! As far as I know, the MySQL "USE" statement means switch the > current "database". The term "database" in MySQL is the "catalog" in the > database meta data (DatabaseMetaData.getTables and so on). For H2, the > "schema" means "schema" in the database meta data. So I'm not sure if it's > the right thing to do (to switch the H2 "schema" when for MySQL it means > switch the current "catalog" or "database). MySQL doesn't seem to support > the concept of "schemas", so it might be OK. > > What do others think about this? > > Regards, > Thomas > > > > > > > > On Sunday, February 12, 2012, Nikolaev, Igor wrote: > > Hi! > > > I have implemented MySQL USE clause support and created a corresponding > > patch. > > > -- > > 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]<javascript:_e({}, 'cvml', > > '[email protected]');> > > . > > To unsubscribe from this group, send email to > > [email protected] <javascript:_e({}, 'cvml', > > 'h2-database%[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.
