Details
Description
Testcase (run MTR test with --cursor-protocol):
CREATE TABLE t1 (a TIMESTAMP(4), b TIMESTAMP DEFAULT 0) ENGINE=MyISAM; |
INSERT IGNORE INTO t1 (a) VALUES ('2001-01-01'),('2003-01-01'); |
SELECT MIN(b)-a FROM t1; |
SELECT (SELECT MIN(b) FROM t1) - a FROM t1; |
DROP TABLE t1; |
Expected result:
SELECT MIN(b)-a FROM t1; |
MIN(b)-a |
-20010101000000.0000
|
SELECT (SELECT MIN(b) FROM t1) - a FROM t1; |
(SELECT MIN(b) FROM t1) - a |
-20010101000000.0000
|
-20030101000000.0000
|
Actual result:
SELECT MIN(b)-a FROM t1; |
MIN(b)-a |
0.0000
|
SELECT (SELECT MIN(b) FROM t1) - a FROM t1; |
(SELECT MIN(b) FROM t1) - a |
0.0000
|
0.0000
|
Attachments
Issue Links
- relates to
-
MDEV-31005 Make working cursor-protocol
- In Progress