IN clause does not work

[amullins]

Trying to execute a simple query that contains an IN clause.

SELECT * FROM mysql_driver WHERE id IN (1,2,3)

This is the error I'm receiving:

ERROR: failed to execute the MySQL query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''{1,2,3}')))' at line 1

If I retrieve the ids with a subquery, it works.

SELECT * FROM mysql_driver WHERE id IN (SELECT id FROM mysql_driver WHERE id < 4)

[ibrarahmad]

I have fixed the issue. I will push the fix after some testing.

Currently working on regression test cases so don't want to push anything
before the comprehensive test cases.

On Wed, Nov 12, 2014 at 8:04 PM, Andrew Mullins notifications@github.com
wrote:

Trying to execute a simple query that contains an IN clause.

SELECT * FROM mysql_driver WHERE id IN (1,2,3)

This is the error I'm receiving:

ERROR: failed to execute the MySQL query:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''{1,2,3}')))'
at line 1

If I retrieve the ids with a subquery, it works.

SELECT * FROM mysql_driver WHERE id IN (SELECT id FROM mysql_driver WHERE id < 4)

—
Reply to this email directly or view it on GitHub
#23.

Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com

[ibrarahmad]

I pushed a fix along with the test cases. "NOT IN" with sub-select will not work. I have created a new case for that and will push the fix for that ASAP.

Isseue: #24 "NOT IN with Sub-select is not working"