summaryrefslogtreecommitdiff
path: root/mysql-test/t/null.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-04-05 20:55:06 -0700
committerunknown <jimw@mysql.com>2005-04-05 20:55:06 -0700
commit566460ac64e03b2d5f44961e352965ca24bdb911 (patch)
treeb8285491e42dccf4487710f0b23b4056dbe867b9 /mysql-test/t/null.test
parent5cdec5d6ba0c3fac2fe312da3e98c9506091a0a7 (diff)
downloadmariadb-git-566460ac64e03b2d5f44961e352965ca24bdb911.tar.gz
Update tests after merge of bug fix.
mysql-test/r/null.result: Update results mysql-test/r/show_check.result: Update results mysql-test/r/strict.result: Update results mysql-test/t/null.test: Fix default for smallint column. mysql-test/t/show_check.test: Fix default for bool column.
Diffstat (limited to 'mysql-test/t/null.test')
-rw-r--r--mysql-test/t/null.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test
index 934b165f604..4cd20979319 100644
--- a/mysql-test/t/null.test
+++ b/mysql-test/t/null.test
@@ -59,7 +59,7 @@ drop table t1;
#
# Test inserting and updating with NULL
#
-CREATE TABLE t1 (a varchar(16) NOT NULL default '', b smallint(6) NOT NULL default '', c datetime NOT NULL default '0000-00-00 00:00:00', d smallint(6) NOT NULL default 0);
+CREATE TABLE t1 (a varchar(16) NOT NULL default '', b smallint(6) NOT NULL default 0, c datetime NOT NULL default '0000-00-00 00:00:00', d smallint(6) NOT NULL default 0);
INSERT INTO t1 SET a = "", d= "2003-01-14 03:54:55";
UPDATE t1 SET d=1/NULL;
UPDATE t1 SET d=NULL;