Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-11-25 Thread mfulton
Thank you for the quick merge! On Monday, November 24, 2014 11:06:34 PM UTC-7, Noel Grandin wrote: Hi Thank you for your patch, this has been merged! Regards, Noel On 2014-11-25 02:08 AM, mfu...@familysearch.org javascript: wrote: I have also tried out 1.4.181 as I have some scripts

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-11-24 Thread Noel Grandin
Hi Thank you for your patch, this has been merged! Regards, Noel On 2014-11-25 02:08 AM, mful...@familysearch.org wrote: I have also tried out 1.4.181 as I have some scripts that specify use /db_name/. I believe the syntax is USE /db_name/ where USE is a reserved word and /db_name/

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-08-08 Thread Fabreax
Hello, I downloaded the version 1.4.181 of H2 because I need USE schema_name but the MySQL compatibility seems to be on USE SCHEMA schema_name which is not valid on MySQL. Is it ok ? Le lundi 28 juillet 2014 21:15:29 UTC+2, Thomas Mueller a écrit : Hi, Thanks! The patch is merged now.

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Noel Grandin
org.h2.command.Parser is the class you want. On 2014-07-28 12:08 AM, Karl Pietrzak wrote: I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. -- You received this message because you are

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Thomas Mueller
Hi, I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. Yes, that would be the Parser class, method parsePrepared. The statement use schema x would be the same as set schema x I believe. A simple

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Karl Pietrzak
On Mon, Jul 28, 2014 at 2:10 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. Yes, that would be the Parser class, method

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Thomas Mueller
Hi, Thanks! The patch is merged now. Regards, Thomas On Mon, Jul 28, 2014 at 4:39 PM, Karl Pietrzak kap4...@gmail.com wrote: On Mon, Jul 28, 2014 at 2:10 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I can definitely submit a patch, especially if someone can send me the

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-27 Thread Karl Pietrzak
On Sat, Jul 26, 2014 at 2:34 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, As far as I can tell, you are the first person to ask for this feature. I think it should be relatively easy to change the parser to support this (use schema would just be an alias for set schema).

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-26 Thread Thomas Mueller
Hi, As far as I can tell, you are the first person to ask for this feature. I think it should be relatively easy to change the parser to support this (use schema would just be an alias for set schema). Patches are welcome! Regards, Thomas On Sat, Jul 26, 2014 at 1:13 AM, Karl Pietrzak

[h2] USE SCHEMA not supported in MySQL mode?

2014-07-25 Thread Karl Pietrzak
Hi everyone! I came across something and was wondering what everyone thought. It looks like USE SCHEMA is not support (you're supposed to SET SCHEMA), even in MySQL compatibility mode. Is this intentional? I was hoping to take MySQL Workbench dumps and use them in h2 without having to