[jifty-devel] jifty-dbi 0.71: Unknown operator 'REGEXP'

[Stanislav Sinyagin]

hi,

The following construct worked fine (with MySQL backend) with an old version (0.68 or so), and stopped working with jifty-dbi 0.71:
     $devices->limit(column => 'hostname',
                            operator => 'REGEXP',
                            value => $re,
                            entry_aggregator => 'OR');

Obviously line 1284 in lib/Jifty/DBI/Collection.pm produces that.

It will be great to have a workaround which allows non-ANSI SQL operators. 



regards,
stanislav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jifty.org/pipermail/jifty-devel/attachments/20110830/5e81d0b4/attachment.html>