summaryrefslogtreecommitdiff
path: root/mysql-test/r/truncate.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-08-24 17:24:23 +0200
committerunknown <serg@serg.mylan>2004-08-24 17:24:23 +0200
commit46fad71c1136131ea13ff5af8d80e49325528132 (patch)
tree35c94403332fed86012546db775d8817473f7435 /mysql-test/r/truncate.result
parentc04c5196b8917f36b9b07a0205ea198d75bf516b (diff)
parent009fcf12cabf8a810a914c56b9abe8e8645dae8d (diff)
downloadmariadb-git-46fad71c1136131ea13ff5af8d80e49325528132.tar.gz
manually merged
BitKeeper/etc/logging_ok: auto-union mysql-test/r/binary.result: Auto merged mysql-test/r/truncate.result: Auto merged mysql-test/t/binary.test: Auto merged mysql-test/t/truncate.test: Auto merged mysys/my_lib.c: Auto merged strings/my_vsnprintf.c: Auto merged support-files/Makefile.am: Auto merged
Diffstat (limited to 'mysql-test/r/truncate.result')
-rw-r--r--mysql-test/r/truncate.result21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/truncate.result b/mysql-test/r/truncate.result
index d777bd184b2..74a6cb72cc6 100644
--- a/mysql-test/r/truncate.result
+++ b/mysql-test/r/truncate.result
@@ -31,4 +31,25 @@ SELECT * from t1;
a
1
2
+delete from t1;
+insert into t1 (a) values (NULL),(NULL);
+SELECT * from t1;
+a
+3
+4
+drop table t1;
+create temporary table t1 (a integer auto_increment primary key);
+insert into t1 (a) values (NULL),(NULL);
+truncate table t1;
+insert into t1 (a) values (NULL),(NULL);
+SELECT * from t1;
+a
+1
+2
+delete from t1;
+insert into t1 (a) values (NULL),(NULL);
+SELECT * from t1;
+a
+3
+4
drop table t1;