Hello Thomas,
When creating a table using double-quotes for the field names we're getting
create table failures if 2 (or more) columns happen to have the same name
but with varied case. I would have thought this should work:
CREATE TABLE foo ( "field1" VARCHAR, "Field1" VARCHAR )
Duplicate column name "Field1"; SQL statement:
<http://localhost:8082/query.do?jsessionid=ae5a26b0c18d47e0c77c44f861f4f54d#>
CREATE TABLE foo ( "field1" VARCHAR, "Field1" VARCHAR ) [42121-193]
<http://localhost:8082/query.do?jsessionid=ae5a26b0c18d47e0c77c44f861f4f54d#>
42S21/42121
I did some further testing and noticed we connect to the database with the
DATABASE_TO_UPPER=FALSE flag. So I tried again *without* this flag, and the
same statement works in this case. Looking at the meta-data after it shows
both columns with the correct case.
FYI this is on 1.4.193. It seems perhaps we shouldn't set that flag since
we can achieve our case sensitive needs by using double-quotes.
--
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.
