Thank you for the quick reply. I can quite believe there are errors in my
SQL which build 198 did not find but build 200 does.
I tried following the instructions to download and build h2 using Eclipse.
When Eclipse built the project it came up with 2 errors both in h2.util:
Bits.java the 'public final class Bits' had 'The type Bits is already
defined'
NetUtils2.java 'public final class NetUtils2' had 'The type NetUtils2 is
already defined'
Anyway I ran 'build jar' and it completed successfully.
On test it threw out some of my SQL with a syntax error. I was going to use
the console to try out the statements to find the error but the .jar built
does not have the tools within it so I can not run the console with the new
build.
Am I missing something.
On Sunday, 12 July 2020 03:37:15 UTC+1, Evgenij Ryazanov wrote:
>
> Hello.
>
> It looks like you're trying to execute multiple commands at once and you
> have a table value constructor after some data definition command:
>
> try (Connection c = DriverManager.getConnection("jdbc:h2:mem:1")) {
> c.createStatement().execute("CREATE TABLE TEST(); VALUES 1");
> }
>
> H2 returns result only from the first command, others are executed, but
> their results aren't returned, so such combination of commands has very low
> meaning.
>
> Anyway, there was a bug in H2. It should be fixed in current H2. You can
> build H2 from the current sources to test it.
> https://github.com/h2database/h2database
> https://h2database.com/html/build.html#building
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/3005e633-be46-4fc1-ac29-7c14a26e317eo%40googlegroups.com.
