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 | e67eb77b13f722e00da721d1e620a6e8f882b4b3 (patch) | |
| tree | da662aa27b5b9ef26a18d821e330f932f761b25d /mysql-test | |
| parent | 10729adbf50768d371c955777622d1fc420a4fe1 (diff) | |
| download | mariadb-git-e67eb77b13f722e00da721d1e620a6e8f882b4b3.tar.gz | |
Fixed bug in ISNULL(not_null_expression)
Docs/manual.texi:
Changlelog
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_isnull.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/func_isnull.test | 10 |
2 files changed, 11 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..deaeaaf71c9 --- /dev/null +++ b/mysql-test/r/func_isnull.result @@ -0,0 +1 @@ +id mydate 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; |