[h2] Re: Is there a way to quote columns ?

2023-07-01 Thread Evgenij Ryazanov
Hello! You need to quote column names in your application, there is nothing to do on H2 side. If you use Hibernate ORM, you can force quotation of all identifiers with hibernate.globally_quoted_identifiers setting. In the worst case you can add ;NON_KEYWORDS=INTERVAL to JDBC URL, but this sett

[h2] Is there a way to quote columns ?

2023-07-01 Thread Catull
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,

Re: [h2] When was REGEXP_SUBSTR added to H2?

2023-07-01 Thread Carlo Dapor
Dear Peter, dear H2 community A quick look up gives 2 commits/merges: https://github.com/h2database/h2database/commit/8026534b4669516cbdc3f18daa0ec8836cde0175 and https://github.com/h2database/h2database/commit/cd77e0a9e5f961de5eeda4a05858f2de8bd0533c If you squint a little, you can see the tag

Re: [h2] Re: When was REGEXP_SUBSTR added to H2?

2023-07-01 Thread 'Peter Borissow' via H2 Database
Thank you! On Saturday, July 1, 2023 at 08:44:54 AM EDT, Evgenij Ryazanov wrote: Hello! It was added in H2 2.0.202. -- 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,

[h2] Re: When was REGEXP_SUBSTR added to H2?

2023-07-01 Thread Evgenij Ryazanov
Hello! It was added in H2 2.0.202. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web v

[h2] When was REGEXP_SUBSTR added to H2?

2023-07-01 Thread 'Peter Borissow' via H2 Database
Dear H2 community,    When was REGEXP_SUBSTR added to H2? I have a really old version of H2 (1.4.197)  and I'm getting a RuntimeException: Function "REGEXP_SUBSTR" not found when I try to use it in a query. I have tried searching the change logs but the history seems incomplete:https://www.h2da