When was REGEXP_SUBSTR added to H2?

207 views
Skip to first unread message

Peter Borissow

unread,
Jul 1, 2023, 7:42:35 AM7/1/23
to 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:

Thanks,
Peter

Evgenij Ryazanov

unread,
Jul 1, 2023, 8:44:50 AM7/1/23
to H2 Database
Hello!

It was added in H2 2.0.202.

Peter Borissow

unread,
Jul 1, 2023, 9:44:49 AM7/1/23
to H2 Database
Thank you!


Carlo Dapor

unread,
Jul 1, 2023, 1:30:27 PM7/1/23
to h2-da...@googlegroups.com
Dear Peter, dear H2 community


A quick look up gives 2 commits/merges:

and

If you squint a little, you can see the tags associated it with it:
So, my best guess it, it got ready for version 2.0.202.

Be careful when upgrading from 1.4.x to 2.0.x.
The meta-tables have changed, meaning, when indentifying which is your default schema is done differently now, just to name one difference.

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 h2-database...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1769368369.572741.1688211746668%40mail.yahoo.com.
Reply all
Reply to author
Forward
0 new messages