Debian Codegraph @

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

raw
1 --connect (con1,localhost,root,,)
2 --echo # Create database and tables
3 CREATE DATABASE testdb;
4 USE testdb;
5
6 CREATE TABLE t1 ( id int );
7 INSERT INTO t1 VALUES (1);
8 INSERT INTO t1 SELECT * FROM t1;
9 INSERT INTO t1 SELECT * FROM t1;
10 INSERT INTO t1 SELECT * FROM t1;
11 INSERT INTO t1 SELECT * FROM t1;
12 INSERT INTO t1 SELECT * FROM t1;
13
14 CREATE TABLE t2 ( id int );
15 INSERT INTO t2 SELECT * FROM t1;
16
17 CREATE TABLE t3 (
18 id INT
19 )
20 PARTITION BY RANGE (id) (
21 PARTITION p0 VALUES LESS THAN (1000),
22 PARTITION p1 VALUES LESS THAN (2000),
23 PARTITION p2 VALUES LESS THAN (3000)
24 );
25 INSERT INTO t3 VALUES (800);
26 INSERT INTO t3 VALUES (1500);
27 INSERT INTO t3 VALUES (2300);
28
29 BEGIN;
30 SELECT COUNT(*) FROM t1;
31
32 --connect (con2,localhost,root,,)
33 --echo # Alter the partition table.
34 ALTER TABLE testdb.t3 ADD COLUMN name varchar(10);
35
36 --connection con1
37 --echo # SELECT COUNT(*) must fail as the table definition is changed.
38 --error ER_TABLE_DEF_CHANGED
39 SELECT COUNT(*) FROM testdb.t3;
40
41 --echo # SELECT * must fail as the table definition is changed.
42 --error ER_TABLE_DEF_CHANGED
43 SELECT * FROM testdb.t3;
44
45 --echo # Clean up
46 DROP DATABASE testdb;