Debian Codegraph @

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

raw
1 # Create database and tables
2 CREATE DATABASE testdb;
3 USE testdb;
4 CREATE TABLE t1 ( id int );
5 INSERT INTO t1 VALUES (1);
6 INSERT INTO t1 SELECT * FROM t1;
7 INSERT INTO t1 SELECT * FROM t1;
8 INSERT INTO t1 SELECT * FROM t1;
9 INSERT INTO t1 SELECT * FROM t1;
10 INSERT INTO t1 SELECT * FROM t1;
11 CREATE TABLE t2 ( id int );
12 INSERT INTO t2 SELECT * FROM t1;
13 CREATE TABLE t3 (
14 id INT
15 )
16 PARTITION BY RANGE (id) (
17 PARTITION p0 VALUES LESS THAN (1000),
18 PARTITION p1 VALUES LESS THAN (2000),
19 PARTITION p2 VALUES LESS THAN (3000)
20 );
21 INSERT INTO t3 VALUES (800);
22 INSERT INTO t3 VALUES (1500);
23 INSERT INTO t3 VALUES (2300);
24 BEGIN;
25 SELECT COUNT(*) FROM t1;
26 COUNT(*)
27 32
28 # Alter the partition table.
29 ALTER TABLE testdb.t3 ADD COLUMN name varchar(10);
30 # SELECT COUNT(*) must fail as the table definition is changed.
31 SELECT COUNT(*) FROM testdb.t3;
32 ERROR HY000: Table definition has changed, please retry transaction
33 # SELECT * must fail as the table definition is changed.
34 SELECT * FROM testdb.t3;
35 ERROR HY000: Table definition has changed, please retry transaction
36 # Clean up
37 DROP DATABASE testdb;