Debian Codegraph @

mysql-test/suite/innodb/t/truncate.test

raw
1 --source include/have_innodb.inc
2
3 CREATE TABLE t (a SERIAL) ENGINE=InnoDB;
4
5 connect (dml,localhost,root);
6 # At the end of this statement, close_thread_tables()
7 # should add the open table handle to the table definition cache (tdc).
8 select * from t;
9
10 connection default;
11 # This should purge the handle from the tdc;
12 # otherwise ha_innobase::truncate() would hang,
13 # waiting for the reference count to drop to 0.
14 TRUNCATE TABLE t;
15 disconnect dml;
16
17 DROP TABLE t;
18
19 --echo #
20 --echo # MDEV-17831 TRUNCATE TABLE removes ROW_FORMAT=COMPRESSED
21 --echo #
22 --disable_query_log
23 SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed;
24 SET GLOBAL innodb_read_only_compressed=OFF;
25 --enable_query_log
26 CREATE TABLE t1 (a SERIAL) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
27 TRUNCATE TABLE t1;
28 --replace_column 3 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 #
29 SHOW TABLE STATUS;
30 --disable_query_log
31 SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed;
32 --enable_query_log
33 DROP TABLE t1;
34
35 --echo #
36 --echo # MDEV-17859 Operating system errors in file operations
37 --echo # after failed CREATE
38 --echo #
39 let $MYSQLD_DATADIR= `select @@datadir`;
40 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
41 INSERT INTO t1 VALUES (1);
42 call mtr.add_suppression("InnoDB: (Operating system )?[Ee]rror number");
43 call mtr.add_suppression("InnoDB: Cannot create file '.*t1\\.ibd");
44 FLUSH TABLES;
45 --move_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/hidden.frm
46 --error ER_TABLE_EXISTS_ERROR
47 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
48 --move_file $MYSQLD_DATADIR/test/hidden.frm $MYSQLD_DATADIR/test/t1.frm
49 SELECT * FROM t1;
50 DROP TABLE t1;
51
52 --echo #
53 --echo # MDEV-17885 TRUNCATE on temporary table causes ER_GET_ERRNO
54 --echo #
55 CREATE TEMPORARY TABLE t1 (a INT) ENCRYPTED=NO ENGINE=InnoDB;
56 INSERT INTO t1 VALUES(1);
57 TRUNCATE t1;
58 SELECT * FROM t1;
59 DROP TEMPORARY TABLE t1;
60
61 --echo #
62 --echo # MDEV-23705 Assertion 'table->data_dir_path || !space'
63 --echo #
64 CREATE TABLE t(c INT) ENGINE=InnoDB;
65 ALTER TABLE t DISCARD TABLESPACE;
66 RENAME TABLE t TO u;
67 TRUNCATE u;
68 TRUNCATE u;
69 DROP TABLE u;
70
71 --echo #
72 --echo # Test for a regression found during MDEV-25506 rewrite of DROP
73 --echo #
74 CREATE TEMPORARY TABLE t1 (a INT) ENGINE=InnoDB;
75 LOCK TABLE t1 READ;
76 TRUNCATE TABLE t1;
77 TRUNCATE TABLE t1;
78 UNLOCK TABLES;
79 DROP TEMPORARY TABLE t1;
80
81 --echo # End of 10.6 tests