mysql wont raise error when sub query in IN clause return empty resultset?

Question

when i write query with empty IN clause it raised an error. e.g select city where id in()

And if i write any sub query in IN clause which return empty resultset then it wont raise error.

e.g select city where id in(select id where name='abc') where sub query return empty resultset.

Can Anybody tell me what happen behind it??

i have read this but not convincing answer. Visit Empty IN clause parameter list in MySQL

Do you want to know how the inner workings of MySQL actually work? — AgRizzo, Oct 30 '13 at 17:45
yeah why not.. for now i am looking for answer of this question. — Dhruv Kapatel, Oct 30 '13 at 17:51

score 1 · Accepted Answer · answered Oct 30 '13 at 17:49

1

When you write IN() you make a syntax error. When you write some sub query the syntax is correct and no error are detected. In other words the empty result set cannot be detected by the parser ans so no message.

answered Oct 30 '13 at 17:49

deramko

2,807
1
18
27

mysql wont raise error when sub query in IN clause return empty resultset?

1 Answers1