From 66f426c0635d16f7f594f6bf867e13e5cba18500 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 16 May 2002 23:35:09 +0300 Subject: Fixed some compilation problems in last changeset Docs/manual.texi: Small changes regarind user resources client/mysqlbinlog.cc: Applied patch to support --database mysql-test/r/func_isnull.result: New test results mysql-test/r/join.result: New test results mysql-test/r/show_check.result: New test results mysql-test/r/type_datetime.result: New test results mysql-test/r/type_decimal.result: New test results mysql-test/r/type_float.result: New test results mysys/my_gethostbyname.c: Fixed type on last push mysys/my_pthread.c: Fixed type on last push sql/sql_select.cc: Fixed bug in LIMIT handling --- mysql-test/r/func_isnull.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/func_isnull.result') diff --git a/mysql-test/r/func_isnull.result b/mysql-test/r/func_isnull.result index deaeaaf71c9..20ddc87ee78 100644 --- a/mysql-test/r/func_isnull.result +++ b/mysql-test/r/func_isnull.result @@ -1 +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; -- cgit v1.2.1