Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
This script:
CREATE OR REPLACE TABLE t1 (a INT, KEY(a)); |
INSERT INTO t1 VALUES (1),(2),(3); |
SELECT * FROM t1 WHERE a BETWEEN NAME_CONST('x',1) AND NAME_CONST('y',2); |
returns a correct result:
+------+
|
| a |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
Now I change the name in the second NAME_CONST() from 'x' to 'y', the script returns a wrong result:
CREATE OR REPLACE TABLE t1 (a INT, KEY(a)); |
INSERT INTO t1 VALUES (1),(2),(3); |
SELECT * FROM t1 WHERE a BETWEEN NAME_CONST('x',1) AND NAME_CONST('x',2); |
+------+
|
| a |
|
+------+
|
| 1 |
|
+------+
|