diff options
Diffstat (limited to 'mysql-test/suite/storage_engine/truncate_table.result')
| -rw-r--r-- | mysql-test/suite/storage_engine/truncate_table.result | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/truncate_table.result b/mysql-test/suite/storage_engine/truncate_table.result new file mode 100644 index 00000000..eac58272 --- /dev/null +++ b/mysql-test/suite/storage_engine/truncate_table.result @@ -0,0 +1,41 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +TRUNCATE TABLE t1; +INSERT INTO t1 (a,b) VALUES (1,'a'), (2,'b'), (3,'c'); +TRUNCATE TABLE t1; +SELECT a,b FROM t1; +a b +DROP TABLE t1; +CREATE TABLE t1 (a <INT_COLUMN> KEY AUTO_INCREMENT, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +SHOW TABLE STATUS LIKE 't1'; +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 +t1 # # # # # # # # # 1 # # # # # # # # N +INSERT INTO t1 (c) VALUES ('a'),('b'),('c'); +SHOW TABLE STATUS LIKE 't1'; +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 +t1 # # # # # # # # # 4 # # # # # # # # N +TRUNCATE TABLE t1; +SHOW TABLE STATUS LIKE 't1'; +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 +t1 # # # # # # # # # 1 # # # # # # # # N +INSERT INTO t1 (c) VALUES ('d'); +SHOW TABLE STATUS LIKE 't1'; +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 +t1 # # # # # # # # # 2 # # # # # # # # N +SELECT a,c FROM t1; +a c +1 d +DROP TABLE t1; +CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'); +HANDLER t1 OPEN AS h1; +HANDLER h1 READ FIRST; +a b +1 a +TRUNCATE TABLE t1; +HANDLER h1 READ NEXT; +ERROR 42S02: Unknown table 'h1' in HANDLER +HANDLER t1 OPEN AS h2; +HANDLER h2 READ FIRST; +a b +DROP TABLE t1; |