Closed hugonoro closed 3 months ago
Was trying to parse a query with the format
SELECT * from <table> WHERE NOT EXISTS (SELECT * FROM <table> WHERE <field> = <value> AND field = <value>)
and I'm getting the error
Expected "!=", "#", "%", "&&", "(", "*", "+", ",", "-", "--", ".", "/", "/*", ";", "<", "<=", "<>", "=", ">", ">=", "AND", "BETWEEN", "FOR", "GROUP", "HAVING", "IN", "IS", "LIKE", "LIMIT", "NOT", "OR", "ORDER", "REGEXP", "RLIKE", "UNION", "glob", "||", [ \t\n\r], or end of input but "E" found.
From the error it seems EXISTS is definitely not one of the expected expressions.
EXISTS
Would it be possible to support this?
Was trying to parse a query with the format
SELECT * from <table> WHERE NOT EXISTS (SELECT * FROM <table> WHERE <field> = <value> AND field = <value>)and I'm getting the error
Expected "!=", "#", "%", "&&", "(", "*", "+", ",", "-", "--", ".", "/", "/*", ";", "<", "<=", "<>", "=", ">", ">=", "AND", "BETWEEN", "FOR", "GROUP", "HAVING", "IN", "IS", "LIKE", "LIMIT", "NOT", "OR", "ORDER", "REGEXP", "RLIKE", "UNION", "glob", "||", [ \t\n\r], or end of input but "E" found.From the error it seems
EXISTSis definitely not one of the expected expressions.Would it be possible to support this?