diff options
author | unknown <brian@zim.(none)> | 2005-08-29 15:05:16 -0700 |
---|---|---|
committer | unknown <brian@zim.(none)> | 2005-08-29 15:05:16 -0700 |
commit | 341a08edd34dd4b8bb975af21d6531c1ef62f92d (patch) | |
tree | 6d5f2b5cf63fd7450ba88df0e2dc861f748bdef3 /mysql-test/t/archive.test | |
parent | 56b8fc52cfe81b22031ece94475d9a6f3fa663c2 (diff) | |
download | mariadb-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.test | 15 |
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; |