• unknown's avatar
    manually merged · a49c12f5
    unknown authored
    BitKeeper/etc/logging_ok:
      auto-union
    mysql-test/r/binary.result:
      Auto merged
    mysql-test/r/truncate.result:
      Auto merged
    mysql-test/t/binary.test:
      Auto merged
    mysql-test/t/truncate.test:
      Auto merged
    mysys/my_lib.c:
      Auto merged
    strings/my_vsnprintf.c:
      Auto merged
    support-files/Makefile.am:
      Auto merged
    a49c12f5
truncate.result 1.11 KB
drop table if exists t1;
create table t1 (a integer, b integer,c1 CHAR(10));
insert into t1 (a) values (1),(2);
truncate table t1;
select count(*) from t1;
count(*)
0
insert into t1 values(1,2,"test");
select count(*) from t1;
count(*)
1
delete from t1;
select * from t1;
a	b	c1
drop table t1;
select count(*) from t1;
ERROR 42S02: Table 'test.t1' doesn't exist
create temporary table t1 (n int);
insert into t1 values (1),(2),(3);
truncate table t1;
select * from t1;
n
drop table t1;
truncate non_existing_table;
ERROR 42S02: Table 'test.non_existing_table' doesn't exist
create table t1 (a integer auto_increment primary key);
insert into t1 (a) values (NULL),(NULL);
truncate table t1;
insert into t1 (a) values (NULL),(NULL);
SELECT * from t1;
a
1
2
delete from t1;
insert into t1 (a) values (NULL),(NULL);
SELECT * from t1;
a
3
4
drop table t1;
create temporary table t1 (a integer auto_increment primary key);
insert into t1 (a) values (NULL),(NULL);
truncate table t1;
insert into t1 (a) values (NULL),(NULL);
SELECT * from t1;
a
1
2
delete from t1;
insert into t1 (a) values (NULL),(NULL);
SELECT * from t1;
a
3
4
drop table t1;