summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap.result
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-12-06 11:38:56 +0200
committermonty@mysql.com <>2004-12-06 11:38:56 +0200
commit0de4777187a869b4a070ba1e0da28a2ffe1abf05 (patch)
treea7bb331b7dac7ac2b3cda915e99bb8c1333f4fec /mysql-test/r/heap.result
parent86508ad9690c61e806acf308b57c6431b1a2dd99 (diff)
parentdededf09fa8cb1096549e74f543c84b81e413066 (diff)
downloadmariadb-git-0de4777187a869b4a070ba1e0da28a2ffe1abf05.tar.gz
Merge with 4.1
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;