diff options
| author | monty@hundin.mysql.fi <> | 2002-05-04 11:11:00 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-05-04 11:11:00 +0300 |
| commit | 5463fdfe284813697a6f74b4190e7f03fa989115 (patch) | |
| tree | da662aa27b5b9ef26a18d821e330f932f761b25d /mysql-test/t/func_isnull.test | |
| parent | 2453d43ab090875149a35ed5e5b4bb84583cd988 (diff) | |
| download | mariadb-git-5463fdfe284813697a6f74b4190e7f03fa989115.tar.gz | |
Fixed bug in ISNULL(not_null_expression)
Diffstat (limited to 'mysql-test/t/func_isnull.test')
| -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; |