Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.3.2
-
x86 and macOS
Description
CREATE TABLE t0 (
c0 decimal(10, 0) NOT NULL,
c1 float unsigned zerofill NOT NULL,
PRIMARY KEY (c0, c1)
);
INSERT INTO t0 VALUES (-2068985011, 0.75245386), (-668435082, 0.19411194), (-500731198, 0.39079505), (0, 0), (0, 0.9938275), (12196703, 970789000), (919009011, 0.28699672), (1069380201, 0.2576304);
SELECT t0.c0 FROM t0 GROUP BY t0.c0, t0.c1 OR '' HAVING NOT t0.c0;
Expected:
----
c0 |
----
0 |
0 |
----
Result:
MariaDB [testdb]> SELECT t0.c0 FROM t0 GROUP BY t0.c0, CAST(t0.c1 AS DATE), t0.c0 OR '' HAVING NOT (t0.c0);
ERROR 2013 (HY000): Lost connection to server during query