diff options
| author | unknown <serg@serg.mylan> | 2005-04-14 18:14:54 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-04-14 18:14:54 +0200 |
| commit | 1403fb000b58a171b094a93b35c4f93123c15b19 (patch) | |
| tree | 962ce86bfc4a780ef1e0ff19b8cc6f2b4366be91 /mysql-test | |
| parent | 28a1851629725f312edc604b191197ccd33df63e (diff) | |
| download | mariadb-git-1403fb000b58a171b094a93b35c4f93123c15b19.tar.gz | |
TRUNCATE is always a transaction on itself. pretent we're in auto-commit mode
bug#8151
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/innodb.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/innodb.test | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index c282ec68c78..f00679801f8 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -821,6 +821,7 @@ truncate table t1; Can't execute the given command because you have active locked tables or an active transaction commit; truncate table t1; +truncate table t1; select * from t1; a insert into t1 values(1),(2); diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index 34eabcc22df..2c8002ea841 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -528,6 +528,7 @@ insert into t1 values(1),(2); truncate table t1; commit; truncate table t1; +truncate table t1; select * from t1; insert into t1 values(1),(2); delete from t1; |