summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_sp.result
blob: 585e2c7ab9dab0ed0eab970cb811044486de4237 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#
# MDEV-8652: Partitioned table creation problem when
# creating from procedure context twice in same session
#
CREATE PROCEDURE p1()
BEGIN
DROP TABLE IF EXISTS t1 ;
CREATE TABLE t1 (
id INT PRIMARY KEY
)
PARTITION BY RANGE (id) (
PARTITION P1 VALUES LESS THAN (2),
PARTITION P2 VALUES LESS THAN (3)
); 
END |
call p1();
call p1();
drop procedure p1;
drop table t1;
#
# End of 10.2 tests
#