diff options
Diffstat (limited to 'mysql-test/r/func_isnull.result')
| -rw-r--r-- | mysql-test/r/func_isnull.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_isnull.result b/mysql-test/r/func_isnull.result new file mode 100644 index 00000000000..20ddc87ee78 --- /dev/null +++ b/mysql-test/r/func_isnull.result @@ -0,0 +1,7 @@ +drop table if exists t1; +create table t1 (id int auto_increment primary key not null, mydate date not null); +insert into t1 values (0,"2002-05-01"),(0,"2002-05-01"),(0,"2002-05-01"); +flush tables; +select * from t1 where isnull(to_days(mydate)); +id mydate +drop table t1; |