Dear H2 community
There is a DB I cannot change, whose DML and DDL we use in both its native form and for H2. We use H2 for unit tests, by means of Hibernate ORM. As it turns out, one column is named INTERVAL. It is a reserved SQL keyword, so when H2 prepares a query, such as: SELECT columnA, columnB, INTERVAL, columnC FROM TABLE T it fails with a Syntax Error. But if I step through with a debugger, and change that query to SELECT columnA, columnB, "INTERVAL", columnC FROM TABLE T then the query is executed fine. Is there a way to have columns be quoted ? It would be great if there was a switch for it. Can I override the default implementation of org/h2/table.ColumnResolver#getColumnName(Column) ? Thanks. Ciao, derweil, -- Carlo -- 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/937fd283-52c5-46e0-8e86-b05f6fe9b19cn%40googlegroups.com.
