diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-05-04 11:11:00 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-05-04 11:11:00 +0300 |
| commit | 2f790c9be5ae1324443bec899ef7f7ba5c0d81f1 (patch) | |
| tree | da662aa27b5b9ef26a18d821e330f932f761b25d /mysql-test/t | |
| parent | 1a1c4485a2e9512498709b6210375f9a3e8fedc9 (diff) | |
| download | mariadb-git-2f790c9be5ae1324443bec899ef7f7ba5c0d81f1.tar.gz | |
Fixed bug in ISNULL(not_null_expression)
Docs/manual.texi:
Changlelog
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_isnull.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_isnull.test b/mysql-test/t/func_isnull.test new file mode 100644 index 00000000000..bd3bcd8d04c --- /dev/null +++ b/mysql-test/t/func_isnull.test @@ -0,0 +1,10 @@ +# +# test of ISNULL() +# + +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)); +drop table t1; |