diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2009-10-13 21:50:08 +0500 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2009-10-13 21:50:08 +0500 |
| commit | bc7c439e6b496937f6862f1397e881bf639f71f7 (patch) | |
| tree | d344daa3939e5d85b448534e7f610a40f2026838 /mysql-test/r/type_date.result | |
| parent | 9824a0ca2729c24c684fed386ec1ccf2fa73cf09 (diff) | |
| download | mariadb-git-bc7c439e6b496937f6862f1397e881bf639f71f7.tar.gz | |
Backport of fix to bug #33629 into mysql-next-mr-bugfixing.
Bug #33629: last_day function can return null, but has 'not null' flag set for result
LAST_DAY and MAKEDATE functions are documented as
returning NULL value, but actually they was implemented
as returning NOT NULL typed values.
That caused a confusing error "ERROR 1048 (23000): Column
'...' cannot be null" on queries like:
SELECT 1 FROM (SELECT LAST_DAY('0')) a;
Diffstat (limited to 'mysql-test/r/type_date.result')
| -rw-r--r-- | mysql-test/r/type_date.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/type_date.result b/mysql-test/r/type_date.result index f96e07b0c5e..92be736ff9a 100644 --- a/mysql-test/r/type_date.result +++ b/mysql-test/r/type_date.result @@ -276,3 +276,25 @@ a 0000-00-01 drop table t1; End of 5.1 tests +# +# Bug #33629: last_day function can return null, but has 'not null' +# flag set for result +# +SELECT 1 FROM (SELECT LAST_DAY('0')) a; +1 +1 +Warnings: +Warning 1292 Incorrect datetime value: '0' +SELECT 1 FROM (SELECT MAKEDATE(2011,0)) a; +1 +1 +CREATE TABLE t1 AS +SELECT LAST_DAY('1970-01-01') AS f1, +MAKEDATE(1970, 1) AS f2; +DESCRIBE t1; +Field Type Null Key Default Extra +f1 date YES NULL +f2 date YES NULL +DROP TABLE t1; +# +End of 6.0 tests |