Bug #13994 | "NOT IN" in query fails | ||
---|---|---|---|
Submitted: | 13 Oct 2005 6:14 | Modified: | 13 Oct 2005 6:51 |
Reporter: | Naveen Kumar | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.7 | OS: | Any (ALL) |
Assigned to: | Bugs System | CPU Architecture: | Any |
[13 Oct 2005 6:14]
Naveen Kumar
[13 Oct 2005 6:51]
Jorge del Conde
Hi! I was unable to reproduce this bug in 5.0.13: mysql> select User from user; +----------+ | User | +----------+ | jorge | | public | | root | | user1 | | user2 | | | | root | | | | pippo1 | | root | | testuser | | jorge | +----------+ 12 rows in set (0.00 sec) mysql> select User from user where User not in ('jorge'); +----------+ | User | +----------+ | public | | root | | user1 | | user2 | | | | root | | | | pippo1 | | root | | testuser | +----------+ 10 rows in set (0.00 sec) mysql> select User from user where User not in ('jorge', 'root'); +----------+ | User | +----------+ | public | | user1 | | user2 | | | | | | pippo1 | | testuser | +----------+ 7 rows in set (0.00 sec)