Bug in filters (MySQL)


#1

I am using version 2.0.4

The following gives me parsing error:
filter : (agency_id = 95) and ((lat * 2) > 35)

If I don’t multiply the field LAT by 2, the filter works.
filter : (agency_id = 95) and (lat > 35)

In version 1, the filter worked and I did not get an error.
This is the MySQL query (which works):
select * from agency_employees where (agency_id = 95) and ((lat * 2) > 35);

Is this a bug or am I doing something wrong?


#2

Hi,

could you give the code of the call?
Is the filter in simple quotes or double quotes?
Have you tried to scape the *?
Instead of filter, did you try use expression ?

Just guessing.