Debian Codegraph @

mysql-test/suite/parts/inc/partition_syntax_2.inc

raw
1 ################################################################################
2 # inc/partition_syntax_2.inc #
3 # #
4 # Purpose: #
5 # Auxiliary script, only useful when sourced by inc/partition_syntax.inc. #
6 # #
7 #------------------------------------------------------------------------------#
8 # Original Author: mleich #
9 # Original Date: 2006-05-11 #
10 # Change Author: #
11 # Change Date: #
12 # Change: #
13 ################################################################################
14
15 if (`SELECT @@session.default_storage_engine NOT IN('ndbcluster')`)
16 {
17 --error ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
18 eval CREATE TABLE t1 (
19 $column_list,
20 $unique_index
21 )
22 $partition_scheme;
23 --error ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
24 eval CREATE TABLE t1 (
25 $column_list,
26 PRIMARY KEY(f_int1,f_int2), $unique_index
27 )
28 $partition_scheme;
29 }
30 if (`SELECT @@session.default_storage_engine IN('ndbcluster')`)
31 {
32 eval CREATE TABLE t1 (
33 $column_list,
34 $unique_index
35 )
36 $partition_scheme;
37 eval $insert_all;
38 --source suite/parts/inc/partition_check.inc
39 DROP TABLE t1;
40 eval CREATE TABLE t1 (
41 $column_list,
42 PRIMARY KEY(f_int1,f_int2), $unique_index
43 )
44 $partition_scheme;
45 eval $insert_all;
46 --source suite/parts/inc/partition_check.inc
47 DROP TABLE t1;
48 }