Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
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.