diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 19:23:32 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 19:23:32 +0100 |
| commit | 5122e43a935a75a232b08b39e14b01e892bebb7e (patch) | |
| tree | bf029669526b271a00b6ebc07f670723b42bf5f8 /mysql-test/r/func_time.result | |
| parent | 6998bacfb34ba23c3298510ec86ff7e4b06b9261 (diff) | |
| download | mariadb-git-5122e43a935a75a232b08b39e14b01e892bebb7e.tar.gz | |
lp:737450 Second Assertion `item->null_value' failed in 5.1-micro
implement Item_func_min_max::get_date()
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 1ada270b326..039640a5036 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -1527,3 +1527,9 @@ NULL Warnings: Warning 1292 Incorrect datetime value: '0000-00-00' drop table t1; +create table t1 (f2 time not null, f3 datetime, f4 int not null, f5 timestamp); +insert ignore t1 values ('04:38:11','0000-00-00 00:00:00',0,'0000-00-00 00:00:00'); +select least(greatest(f3, f2, f4), f5) from t1; +least(greatest(f3, f2, f4), f5) +0000-00-00 00:00:00 +drop table t1; |