search

rickywu-posh / php-sql-parser

Automatically exported from code.google.com/p/php-sql-parser
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

in-list conatins too many commas #29

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
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 commented 8 years ago 
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 commented 8 years ago 
Accepted fixed codebase.

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