Arithmetic operators in WHERE clause in fields.ini
igorjar opened this issue · 0 comments
igorjar commented
The use of arithmetic operators (ie. +-*/ operators) in the WHERE
clause of the SELECT
statement in the fields.ini file causes error as support for arithmetic operators is currently added only in select columns.
As a temporary workaround use subquery in the WHERE
clause (eg. instead of WHERE foo.f1 = foo.f2 +1
use WHERE foo.f1=(SELECT foo.f2 +1 FROM dual)
. (It seems that in Xataface you cannot omit the FROM
clause here so use dual
as a dummy table.)