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
commita49c12f5152791042eeecac19db9054ad845e3dd (patch)
tree35c94403332fed86012546db775d8817473f7435 /mysql-test/r/truncate.result
parent62a63815e119807134de74edb78e478b75a6b874 (diff)
parent9d1a9d72cba1aa828e631f520540411d7508a4e0 (diff)
downloadmariadb-git-a49c12f5152791042eeecac19db9054ad845e3dd.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;