diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/bdb.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/bdb.test | 11 |
2 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result index cc6a974b192..87bc36fb215 100644 --- a/mysql-test/r/bdb.result +++ b/mysql-test/r/bdb.result @@ -1210,3 +1210,10 @@ a b 3 three 4 four drop table t1, t2; +create table t1 (a int, b varchar(30), primary key(a)) engine = bdb; +insert into t1 values (1,'one'); +commit; +truncate t1; +select * from t1; +a b +drop table t1; diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 42729034d41..de156cc2305 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -850,3 +850,14 @@ insert into t2 (a, b) select a, b from t1 where (a, b) in (select a, b from t1); select * from t2; drop table t1, t2; + +# +# Bug #4304: TRUNCATE <table of type BDB> , wrong result +# + +create table t1 (a int, b varchar(30), primary key(a)) engine = bdb; +insert into t1 values (1,'one'); +commit; +truncate t1; +select * from t1; +drop table t1; |