diff options
Diffstat (limited to 'mysql-test/main/type_year.result')
-rw-r--r-- | mysql-test/main/type_year.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/type_year.result b/mysql-test/main/type_year.result index 71285418588..1792cd5b7d4 100644 --- a/mysql-test/main/type_year.result +++ b/mysql-test/main/type_year.result @@ -587,3 +587,29 @@ DROP TABLE t1; # # End of 10.4 tests # +# +# Start of 10.5 tests +# +# +# MDEV-20384 Assertion `field.is_sane()' failed in Protocol_text::store_field_metadata +# +CREATE TABLE t1 (a YEAR); +INSERT INTO t1 VALUES (2000),(2001); +SELECT MAX( NULLIF( a, 1970 ) ) AS f FROM t1; +f +2001 +SELECT NULLIF(a, 1970) AS f FROM t1 ORDER BY a; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def f 13 4 4 Y 32928 0 63 +f +2000 +2001 +SELECT MAX(NULLIF(a, 1970)) AS f FROM t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def f 8 4 4 Y 32928 0 63 +f +2001 +DROP TABLE t1; +# +# End of 10.5 tests +# |