summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-12-06 17:16:35 +0200
committerunknown <monty@mysql.com>2004-12-06 17:16:35 +0200
commit19a95482195a158425c66ac629d07da53e4fc1b6 (patch)
tree5cfc0009e76810724a4db2904e75e2db2506bd46 /mysql-test/r/heap.result
parenta4a69f73126d247a519a50f5ba21357ce13839fe (diff)
parenta1fba2daccee3c7c5d46cded39fda7ee7f0d6eae (diff)
downloadmariadb-git-19a95482195a158425c66ac629d07da53e4fc1b6.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.0
into mysql.com:/home/my/mysql-5.0 ndb/src/kernel/blocks/dblqh/DblqhMain.cpp: Auto merged sql/sql_show.cc: Auto merged
Diffstat (limited to 'mysql-test/r/heap.result')
-rw-r--r--mysql-test/r/heap.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result
index e741a6859c7..6756be84bb0 100644
--- a/mysql-test/r/heap.result
+++ b/mysql-test/r/heap.result
@@ -240,3 +240,12 @@ SELECT * FROM t1;
pseudo date
ZoomZip 1101106546
DROP TABLE t1;
+create table t1(a char(2)) engine=memory;
+insert into t1 values (NULL), (NULL);
+delete from t1 where a is null;
+insert into t1 values ('2'), ('3');
+select * from t1;
+a
+3
+2
+drop table t1;