1--source include/have_partition.inc
2
3--echo #
4--echo # MDEV-8652: Partitioned table creation problem when
5--echo # creating from procedure context twice in same session
6--echo #
7
8
9DELIMITER |;
10
11CREATE PROCEDURE p1()
12BEGIN
13  DROP TABLE IF EXISTS t1 ;
14
15  CREATE TABLE t1 (
16    id INT PRIMARY KEY
17  )
18  PARTITION BY RANGE (id) (
19    PARTITION P1 VALUES LESS THAN (2),
20    PARTITION P2 VALUES LESS THAN (3)
21  );
22END |
23
24DELIMITER ;|
25
26call p1();
27call p1();
28
29drop procedure p1;
30drop table t1;
31
32--echo #
33--echo # End of 10.2 tests
34--echo #
35
36