Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
None
Description
It would be nice, if IN() without any parameter doesn't throw syntax error and return false instead. This would make easier writing scripts like DELETE / UPDATE ... WHERE (NOT) IN(?).
example:
SELECT 2 IN (0,3,5,7);
returns false
SELECT 2 IN ();
returns syntax error
false would be better
Also NOT IN() without parameter should return true. Optimizer also could replace this functions with true / false.