Debian Codegraph @

mysql-test/suite/maria/temporary.result

raw
1 CREATE TABLE t1 (b INT);
2 INSERT INTO t1 VALUES (5);
3 CREATE TEMPORARY TABLE t1 (a INT) ENGINE=Aria ROW_FORMAT=DYNAMIC;
4 INSERT INTO t1 VALUES (1);
5 DELETE FROM t1 LIMIT 2;
6 OPTIMIZE TABLE t1;
7 Table Op Msg_type Msg_text
8 test.t1 optimize status OK
9 CHECK TABLE t1;
10 Table Op Msg_type Msg_text
11 test.t1 check status OK
12 SELECT * FROM t1;
13 a
14 INSERT INTO t1 VALUES (1),(2);
15 CHECK TABLE t1;
16 Table Op Msg_type Msg_text
17 test.t1 check status OK
18 ALTER TABLE t1 CHANGE COLUMN IF EXISTS x x INT;
19 Warnings:
20 Note 1054 Unknown column 'x' in 't1'
21 ALTER TABLE t1;
22 DROP TEMPORARY TABLE t1;
23 DROP TABLE t1;