Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.3.2
-
None
-
None
Description
I run the following statements, in which these queries are expected to return consistent data with respect to their literal representation.
CREATE TABLE t1 (c1 bit,c2 tinyint, KEY i1 (c1), UNIQUE KEY i2 (c2,c1)); |
INSERT INTO t1 VALUES (true,0), (false,1); |
 |
SELECT ca5 FROM (SELECT c1 AS ca5 FROM t1 USE INDEX (i2)) AS ta1 GROUP BY ca5; -- {0,1} |
SELECT c1 AS ca5 FROM t1 USE INDEX (i2) GROUP BY ca5; -- {0x00,0x01} |
SELECT ca5 FROM (SELECT c1 AS ca5 FROM t1 USE INDEX (i1)) AS ta1 GROUP BY ca5; -- {0x00,0x01} |
SELECT c1 AS ca5 FROM t1 USE INDEX (i1) GROUP BY ca5; -- {0x00,0x01} |