From 2f790c9be5ae1324443bec899ef7f7ba5c0d81f1 Mon Sep 17 00:00:00 2001
From: unknown <monty@hundin.mysql.fi>
Date: Sat, 4 May 2002 11:11:00 +0300
Subject: Fixed bug in ISNULL(not_null_expression)

Docs/manual.texi:
  Changlelog
---
 mysql-test/t/func_isnull.test | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 mysql-test/t/func_isnull.test

(limited to 'mysql-test/t/func_isnull.test')

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;
-- 
cgit v1.2.1