summaryrefslogtreecommitdiff
path: root/mysql-test/t/archive.test
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2005-08-29 15:05:16 -0700
committerunknown <brian@zim.(none)>2005-08-29 15:05:16 -0700
commit341a08edd34dd4b8bb975af21d6531c1ef62f92d (patch)
tree6d5f2b5cf63fd7450ba88df0e2dc861f748bdef3 /mysql-test/t/archive.test
parent56b8fc52cfe81b22031ece94475d9a6f3fa663c2 (diff)
downloadmariadb-git-341a08edd34dd4b8bb975af21d6531c1ef62f92d.tar.gz
Added support for delete_all_rows() for archive. This fixes bug #12836.
mysql-test/r/archive.result: Update for test case to make sure that TRUNCATE and DELETE function(hah!) as designed. mysql-test/t/archive.test: Add TRUNCATE and DELETE support. sql/examples/ha_archive.cc: Added delete_all_rows() support. sql/examples/ha_archive.h: Added delete_all_rows() support. sql/handler.h: Added flags for fast delete support for archive and federated.
Diffstat (limited to 'mysql-test/t/archive.test')
-rw-r--r--mysql-test/t/archive.test15
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test
index ca8a870dac0..f10ff0f648e 100644
--- a/mysql-test/t/archive.test
+++ b/mysql-test/t/archive.test
@@ -1310,6 +1310,19 @@ rename table t3 to t4;
select * from t4 where fld3='bonfire';
select count(*) from t4;
-drop table t1, t2, t4;
# End of 4.1 tests
+
+#
+# For bug #12836
+# Delete was allowing all rows to be removed
+DELETE FROM t2;
+SELECT * FROM t2;
+INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
+INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
+INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
+SELECT * FROM t2;
+TRUNCATE TABLE t2;
+SELECT * FROM t2;
+
+drop table t1, t2, t4;