Hi Thomas, 2014-02-12 19:46 GMT+01:00 Thomas Mueller <[email protected]>:
> Hi, > > The column_list is more a comment currently, maybe it should be removed. > Or maybe deprecated ;-) On a side-note, there seems to be also an issue related to case-sensitivity in that column. A user reported this issue to me: https://groups.google.com/d/msg/jooq-user/3y_emw5nDx0/uHF5xid9QbEJ Which he experienced when using a JDBC URL like this: jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;IGNORECASE=true It seems that COLUMN_LIST shows inconsistent casing with other INFORMATION_SCHEMA tables, when that flag is active. I wonder if the following could be used? > > select c.table_schema, c.table_name, > c.unique_index_name, c.column_list, > i.column_name > from information_schema.constraints c, > information_schema.indexes i > where c.table_schema = i.table_schema > and c.table_name = i.table_name > and c.unique_index_name = i.index_name; > Good idea, I'll give this a shot! -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
