diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-03-17 07:41:22 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-03-17 07:41:22 +0100 |
commit | 019f7425b70bb992bf6446a3c9a1dda041a4440d (patch) | |
tree | 16373a6476dcbace09c29dcf2155092dd37a781c /mysql-test/r/partition_pruning.result | |
parent | 926b0f54c9b0f261460e886969dde9bbf1916852 (diff) | |
download | mariadb-git-019f7425b70bb992bf6446a3c9a1dda041a4440d.tar.gz |
MDEV-4281 Assertion `maybe_null && item->null_value' fails in make_sortkey on CASE with different return types, GROUP_CONCAT, GROUP BY
Fix Item::get_date() to mark the item NULL when returning an error.
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
-rw-r--r-- | mysql-test/r/partition_pruning.result | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index d5594c7453e..f60c87aa351 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -1906,9 +1906,10 @@ INSERT INTO t1 VALUES (1, '2009-01-01'), (2, NULL); # test with an invalid date, which lead to item->null_value is set. EXPLAIN PARTITIONS SELECT * FROM t1 WHERE b < CAST('2009-04-99' AS DATETIME); id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 SIMPLE t1 p20090401 ALL NULL NULL NULL NULL 2 Using where Warnings: Warning 1292 Incorrect datetime value: '2009-04-99' +Warning 1292 Incorrect datetime value: '2009-04-99' DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, |