Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a ENUM('0x'));
|
INSERT INTO t1 VALUES ('0x');
|
SELECT a IS TRUE AS a0, COALESCE(a) IS TRUE AS a1, LEAST(a,a) IS TRUE AS a2, (SELECT a FROM t1) IS TRUE AS a3 FROM t1;
|
returns:
+----+----+----+----+
|
| a0 | a1 | a2 | a3 |
|
+----+----+----+----+
|
| 1 | 0 | 1 | 0 |
|
+----+----+----+----+
|
Expect to get the same result for all columns.