blob: fea4d67eba4e46c5c2bccdb3ea2e27437c76e237 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
source include/have_tokudb.inc;
# verify that truncate table leaves the table empty and sets the row count
# to zero.
--disable_warnings
drop table if exists t;
--enable_warnings
create table t (a int, b int, primary key (a)) engine=tokudb;
insert into t values (1,2),(2,4),(3,8);
select * from t;
select TABLE_ROWS from information_schema.tables where table_schema='test' and table_name='t';
truncate table t;
select * from t;
select TABLE_ROWS from information_schema.tables where table_schema='test' and table_name='t';
drop table t;
|
