Smalltalk › Frameworks & Tools › GLORP

OraclePlatform defines REGEXP_LIKE but not DB2Platform

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

jtuchel

OraclePlatform defines REGEXP_LIKE but not DB2Platform

Hi there,

I am not sure if the Glorp maintainers at Cincom are following this list, but I have a suggestion for the DB2Platform. DB2 has added REGEXP_LIKE quite a while ago, so Glorp should add this to the functions of the DB2 Platform in #initializeFunctions.

This line should be copied from OraclePlatform>>#initializeFunctions to DB2Platform>>#initializeFunctions

functions at: #regexMatches: put: (PrefixFunction named: 'REGEXP_LIKE').

In my VA Smalltalk image and the officially shipped version of GLorp in VA Smalltalk, this is not the case. I haven't checked in VW or Pharo (which, to my knowledge, also is behind the VW version). I tried in VAST and this works fine.

I also haven't checked if AdabasLikePlatform, MySQLPlatform etc. should add the function as well - I don't know if these databases also support REGEXP_LIKE...

Joachim

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/glorp-group.
For more options, visit https://groups.google.com/d/optout.

jtuchel

Re: OraclePlatform defines REGEXP_LIKE but not DB2Platform

Thanks Niall,

not a problem to have it later. I know how to add it myself, just wanted
to make sure this gets into the base someday.

Joachim

Am 12.11.18 um 19:25 schrieb Niall Ross:

> Dear Joachim,
>    good point. It is too late to add this to the Glorp 8.3.2 version
> but it will be in the Glorp 9.0 version. Thanks for mentioning.
>
>                Yours faithfully
>                      Niall Ross
>
> -------- Forwarded Message --------
> Subject:     OraclePlatform defines REGEXP_LIKE but not DB2Platform
> Date:     Fri, 9 Nov 2018 02:20:05 -0800 (PST)
> From:     jtuchel <[hidden email]>
> Reply-To:     [hidden email]
> To:     glorp-group <[hidden email]>
>
> Hi there,
>
> I am not sure if the Glorp maintainers at Cincom are following this
> list, but I have a suggestion for the DB2Platform. DB2 has added
> REGEXP_LIKE quite a while ago, so Glorp should add this to the
> functions of the DB2 Platform in #initializeFunctions.
>
> This line should be copied from OraclePlatform>>#initializeFunctions
> to DB2Platform>>#initializeFunctions
>
> functions at: #regexMatches: put: (PrefixFunction named: 'REGEXP_LIKE').
>
> In my VA Smalltalk image and the officially shipped version of GLorp
> in VA Smalltalk, this is not the case. I haven't checked in VW or
> Pharo (which, to my knowledge, also is behind the VW version). I tried
> in VAST and this works fine.
> I also haven't checked if AdabasLikePlatform, MySQLPlatform etc.
> should add the function as well - I don't know if these databases also
> support REGEXP_LIKE...
>
>
> Joachim
> --
>
>

Benoit St-Jean

Re: OraclePlatform defines REGEXP_LIKE but not DB2Platform

In reply to this post by jtuchel

MySQL supports REGEXP_LIKE as of version 8.0.

Previously, it was known as REGEXP and/or RLIKE depending on the versions

On Friday, 9 November 2018 05:20:05 UTC-5, jtuchel wrote:

Hi there,

I am not sure if the Glorp maintainers at Cincom are following this list, but I have a suggestion for the DB2Platform. DB2 has added REGEXP_LIKE quite a while ago, so Glorp should add this to the functions of the DB2 Platform in #initializeFunctions.

This line should be copied from OraclePlatform>>#initializeFunctions to DB2Platform>>#initializeFunctions

functions at: #regexMatches: put: (PrefixFunction named: 'REGEXP_LIKE').

In my VA Smalltalk image and the officially shipped version of GLorp in VA Smalltalk, this is not the case. I haven't checked in VW or Pharo (which, to my knowledge, also is behind the VW version). I tried in VAST and this works fine.

I also haven't checked if AdabasLikePlatform, MySQLPlatform etc. should add the function as well - I don't know if these databases also support REGEXP_LIKE...

Joachim