Debian Codegraph @

mysql-test/suite/innodb/r/truncate.result

raw
1 CREATE TABLE t (a SERIAL) ENGINE=InnoDB;
2 connect dml,localhost,root;
3 select * from t;
4 a
5 connection default;
6 TRUNCATE TABLE t;
7 disconnect dml;
8 DROP TABLE t;
9 #
10 # MDEV-17831 TRUNCATE TABLE removes ROW_FORMAT=COMPRESSED
11 #
12 CREATE TABLE t1 (a SERIAL) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
13 TRUNCATE TABLE t1;
14 SHOW TABLE STATUS;
15 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
16 t1 InnoDB # Compressed # # # # # # 1 # # NULL utf8mb4_uca1400_ai_ci NULL key_block_size=4 0 N
17 DROP TABLE t1;
18 #
19 # MDEV-17859 Operating system errors in file operations
20 # after failed CREATE
21 #
22 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
23 INSERT INTO t1 VALUES (1);
24 call mtr.add_suppression("InnoDB: (Operating system )?[Ee]rror number");
25 call mtr.add_suppression("InnoDB: Cannot create file '.*t1\\.ibd");
26 FLUSH TABLES;
27 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
28 ERROR 42S01: Table '`test`.`t1`' already exists
29 SELECT * FROM t1;
30 a
31 1
32 DROP TABLE t1;
33 #
34 # MDEV-17885 TRUNCATE on temporary table causes ER_GET_ERRNO
35 #
36 CREATE TEMPORARY TABLE t1 (a INT) ENCRYPTED=NO ENGINE=InnoDB;
37 INSERT INTO t1 VALUES(1);
38 TRUNCATE t1;
39 SELECT * FROM t1;
40 a
41 DROP TEMPORARY TABLE t1;
42 #
43 # MDEV-23705 Assertion 'table->data_dir_path || !space'
44 #
45 CREATE TABLE t(c INT) ENGINE=InnoDB;
46 ALTER TABLE t DISCARD TABLESPACE;
47 RENAME TABLE t TO u;
48 TRUNCATE u;
49 Warnings:
50 Warning 1814 Tablespace has been discarded for table `u`
51 TRUNCATE u;
52 DROP TABLE u;
53 #
54 # Test for a regression found during MDEV-25506 rewrite of DROP
55 #
56 CREATE TEMPORARY TABLE t1 (a INT) ENGINE=InnoDB;
57 LOCK TABLE t1 READ;
58 TRUNCATE TABLE t1;
59 TRUNCATE TABLE t1;
60 UNLOCK TABLES;
61 DROP TEMPORARY TABLE t1;
62 # End of 10.6 tests