I am trying to create a filter criteria for a view using regular expression but it seams that it is not working.
For example I want to check if Nid is odd or even number. To achieve that I can use regular expression '$' to check if Nid ends with even number.
If I select from DB following statement it returns 1 - so it is correct
SELECT 26 REGEXP '$'
But if I create a filter criteria as a 'Regular expression" and pass value '$' (I have tried with and without quotes), then view does not return any value.
In some views I get following error
SQLSTATE: Syntax error or access violation: 1139 Got error 'empty (sub)expression' from regexp
Could you please explain what I am doing wrong?
Or is this really a bug?
I am using
Drupal 7.17 with XAMPP v3.1.0
DB server: 5.5.27 - MySQL Community Server (GPL)
Web server: Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
Thanks In Advance,