Add support for SQL SIMILAR TO?

[Christian Carlow <ch...@gmail.com>]

Is support for SQL SIMILAR TO worth a JIRA?  I read somewhere that it
isn't as widely implemented across SQL servers but is supposedly part of
the standard.  I was hoping to be able to perform a BETWEEN/LIKE
query.  

Re: Add support for SQL SIMILAR TO?

[Jacques Le Roux <ja...@les7arts.com>]

Hi Christian,

See my answer at https://issues.apache.org/jira/browse/OFBIZ-6137

Thinking about it, another thing we could do would be to have sets of optional features (like SQL predicate) by DBMS (for instance most of the main 
DBMS support "SIMILAR TO"). With a default system property sets to "Derby"
It's a bit ambitious, but seems doable. We could then support OOTB separately say at least Derby, Postgres, MySQL and MSSQL which are the ones we hear 
most about here.

I have created https://issues.apache.org/jira/browse/OFBIZ-6138 for that

Jacques

Le 06/03/2015 19:26, Christian Carlow a écrit :
> Is support for SQL SIMILAR TO worth a JIRA?  I read somewhere that it
> isn't as widely implemented across SQL servers but is supposedly part of
> the standard.  I was hoping to be able to perform a BETWEEN/LIKE
> query.
>
>