Sunday, 11 June 2017

MySQL Connector/Node.js (xdevapi) - Expecting '.', '(' in Where clause

There's a table with two fields: id1 and id1 - and I need to select the rows where the values of both are not equal.

table
    .select('id1','id2')
    .where('id1 != id2')
    .execute(row => {
        console.log (row);
    });

For some reason, I get this error: (!)

id1 != id2
----^
Expecting '.', '(', got '!='

Why would it except '.' or '(' over there??

If i remove the where it works correctly (meaning - it simply returns all rows).

It looks like a kind of bug in the xdevapi package - but I couldn't fully find it (tried to debug the parser source and so on...)



via Yuval A.

No comments:

Post a Comment