Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.16, 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
The processing result of the WHERE condition that contains a negative integer boundary value is incorrect. As a result, the query result is incorrect.
For example,
mysql> DROP TABLE IF EXISTS t0; |
Query OK, 0 rows affected (0.00 sec) |
|
|
mysql> CREATE TABLE `t0` ( |
-> `c0` tinyint NOT NULL, |
-> KEY `ic2` (`c0`) |
-> );
|
Query OK, 0 rows affected (0.01 sec) |
|
|
mysql> insert into t0 values (127),(-128); |
Query OK, 2 rows affected (0.00 sec) |
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
mysql> SELECT c0 FROM t0 WHERE (c0 NOT IN (126, -129)); |
+-----+ |
| c0 |
|
+-----+ |
| 127 |
|
+-----+ |
1 row in set (0.00 sec) |
|
The query result miss the -128.