shannah/xataface

Arithmetic operators in WHERE clause in fields.ini

igorjar opened this issue · 0 comments

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.)