Given the following SQL run against the connection string
jdbc:h2:mem:;MODE=MSSQLServer;IGNORECASE=TRUE
CREATE SCHEMA dbo;
CREATE TABLE dbo.foo (
date date NOT NULL,
value numeric(28,9) NOT NULL,
PRIMARY KEY ( date )
);
We end up with a table which can be addressed in the following ways & the
appropriate combinations of schema/table:
- dbo.foo
- DBO.FOO
- [DBO].[FOO]
But [dbo].[foo] does not work.
When running this against SQL Server with case insensitive collation all
four forms work.
If I turn on DATABASE_TO_UPPER=false then when
JdbcDatabaseMetaData#getTables is executed we end up passing around DBO.foo
and are unable to fetch any metadata.
It would be great if one or both of these behaviors were updated to be
consistent with SQL Server.
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
