Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (d DATE) ENGINE=MyISAM; |
INSERT INTO t1 VALUES ('2018-12-12'); |
SELECT d, CHARSET(d) AS f FROM t1 GROUP BY d; |
SELECT d, CHARSET(d) AS f FROM t1 GROUP BY d WITH ROLLUP; |
The first query returns:
+------------+--------+
|
| d | f |
|
+------------+--------+
|
| 2018-12-12 | binary |
|
+------------+--------+
|
The second query returns:
+------------+--------+
|
| d | f |
|
+------------+--------+
|
| 2018-12-12 | latin1 |
|
| NULL | binary |
|
+------------+--------+
|
Looks wrong. Expect equal values in the column "f" in all queries.
Attachments
Issue Links
- relates to
-
MDEV-17830 Server crashes in Item_null_result::field_type upon SELECT with CHARSET(date) and ROLLUP
- Closed