Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
DROP TABLE IF EXISTS t1; |
DROP VIEW IF EXISTS v1; |
CREATE TABLE t1 (pk INT NOT NULL, d DATE NOT NULL); |
CREATE VIEW v1 AS SELECT * FROM t1; |
INSERT INTO t1 VALUES (1,'2018-06-22'),(2,'2018-07-11'); |
SELECT GREATEST(pk, d) FROM t1; |
+-----------------+
|
| GREATEST(pk, d) |
|
+-----------------+
|
| 2018-06-22 |
|
| 2018-07-11 |
|
+-----------------+
|
SELECT GREATEST(pk, d) FROM v1; |
+-----------------+
|
| GREATEST(pk, d) |
|
+-----------------+
|
| NULL |
|
| NULL |
|
+-----------------+
|
Looks wrong. Expected to get the same results with the table and with the view.
Attachments
Issue Links
- relates to
-
MDEV-19699 Server crashes in Item_null_result::field_type upon SELECT with ROLLUP on constant table
- Closed