in-list conatins too many commas

[GoogleCodeExporter]

SELECT q.qid, question, gid FROM questions as q WHERE (select count(*) from 
answers as a where a.qid=q.qid and scale_id=0)=0 and sid=11929 AND type IN 
('F', 'H', 'W', 'Z', '1') and q.parent_qid=0

goes wrong, the in-list contains commas, so we will get from the creator:

SELECT q.qid,question,gid FROM questions q WHERE (SELECT count(*) FROM answers 
a WHERE a.qid = q.qid and scale_id = 0) = 0 and sid = 11929 AND type IN ('F',, 
,'H',, ,'W',, ,'Z',, ,'1') and q.parent_qid = 0

Version:
https://www.phosco.info/publicsvn/php-sql-parser/tags/20120217

Original issue reported on code.google.com by pho...@gmx.de on 22 Feb 2012 at 3:13

[GoogleCodeExporter]

Issue solved in version
https://www.phosco.info/publicsvn/php-sql-parser/trunk

Original comment by pho...@gmx.de on 22 Feb 2012 at 4:13

[GoogleCodeExporter]

Accepted fixed codebase.

Original comment by greenlion@gmail.com on 12 Mar 2012 at 10:48

• Changed state: Fixed