Gecko [ 122.154.134.11 ]

Name	Size	Permission
methods1.inc	6.92 KB	-rw-r--r--
part_blocked_sql_funcs_main.in...	8.81 KB	-rw-r--r--
part_supported_sql_funcs_delet...	2.67 KB	-rw-r--r--
part_supported_sql_funcs_main....	8.5 KB	-rw-r--r--
partition.pre	19.73 KB	-rw-r--r--
partition_10.inc	2.7 KB	-rw-r--r--
partition_11.inc	975 B	-rw-r--r--
partition_12.inc	2.51 KB	-rw-r--r--
partition_20.inc	2.63 KB	-rw-r--r--
partition_alter1_1.inc	3.43 KB	-rw-r--r--
partition_alter1_1_2.inc	3.04 KB	-rw-r--r--
partition_alter1_2.inc	5.98 KB	-rw-r--r--
partition_alter2_1.inc	7.03 KB	-rw-r--r--
partition_alter2_2.inc	7.01 KB	-rw-r--r--
partition_alter3.inc	8.26 KB	-rw-r--r--
partition_alter4.inc	6.72 KB	-rw-r--r--
partition_alter_1.inc	3.97 KB	-rw-r--r--
partition_alter_11.inc	6.79 KB	-rw-r--r--
partition_alter_13.inc	7.11 KB	-rw-r--r--
partition_alter_41.inc	7.21 KB	-rw-r--r--
partition_auto_increment.inc	22.89 KB	-rw-r--r--
partition_basic.inc	5.09 KB	-rw-r--r--
partition_basic_symlink.inc	2.23 KB	-rw-r--r--
partition_bigint.inc	1.75 KB	-rw-r--r--
partition_binary.inc	3.2 KB	-rw-r--r--
partition_bit.inc	3.46 KB	-rw-r--r--
partition_blob.inc	1.48 KB	-rw-r--r--
partition_blocked_sql_funcs.in...	5.3 KB	-rw-r--r--
partition_char.inc	3.08 KB	-rw-r--r--
partition_check.inc	43.69 KB	-rw-r--r--
partition_check_drop.inc	2.95 KB	-rw-r--r--
partition_check_read.inc	3.02 KB	-rw-r--r--
partition_check_read1.inc	2.87 KB	-rw-r--r--
partition_check_read2.inc	2.43 KB	-rw-r--r--
partition_cleanup.inc	1.29 KB	-rw-r--r--
partition_date.inc	2.13 KB	-rw-r--r--
partition_datetime.inc	2.14 KB	-rw-r--r--
partition_decimal.inc	2.57 KB	-rw-r--r--
partition_directory.inc	6.87 KB	-rw-r--r--
partition_double.inc	1.17 KB	-rw-r--r--
partition_engine.inc	11.48 KB	-rw-r--r--
partition_enum.inc	1.88 KB	-rw-r--r--
partition_float.inc	1.2 KB	-rw-r--r--
partition_int.inc	1.46 KB	-rw-r--r--
partition_key_16col.inc	1.51 KB	-rw-r--r--
partition_key_32col.inc	3.6 KB	-rw-r--r--
partition_key_4col.inc	597 B	-rw-r--r--
partition_key_8col.inc	1.01 KB	-rw-r--r--
partition_layout.inc	386 B	-rw-r--r--
partition_layout_check1.inc	3.31 KB	-rw-r--r--
partition_layout_check2.inc	3.08 KB	-rw-r--r--
partition_mediumint.inc	1.44 KB	-rw-r--r--
partition_methods1.inc	11.42 KB	-rw-r--r--
partition_methods2.inc	11.01 KB	-rw-r--r--
partition_mgm.inc	16.33 KB	-rw-r--r--
partition_set.inc	1.86 KB	-rw-r--r--
partition_smallint.inc	1.38 KB	-rw-r--r--
partition_supported_sql_funcs....	9.63 KB	-rw-r--r--
partition_syntax.inc	27.65 KB	-rw-r--r--
partition_syntax_1.inc	3.69 KB	-rw-r--r--
partition_syntax_2.inc	1.81 KB	-rw-r--r--
partition_text.inc	1.33 KB	-rw-r--r--
partition_time.inc	2.08 KB	-rw-r--r--
partition_timestamp.inc	2.61 KB	-rw-r--r--
partition_tinyint.inc	1.33 KB	-rw-r--r--
partition_trigg1.inc	4.56 KB	-rw-r--r--
partition_trigg2.inc	2.36 KB	-rw-r--r--
partition_trigg3.inc	3.22 KB	-rw-r--r--
partition_value.inc	7.24 KB	-rw-r--r--
partition_varbinary.inc	3.02 KB	-rw-r--r--
partition_varchar.inc	3 KB	-rw-r--r--
partition_year.inc	958 B	-rw-r--r--

Code Editor : partition_alter_41.inc

################################################################################
# inc/partition_alter_11.inc                                                   #
#                                                                              #
# Purpose:                                                                     #
#   Check ALTER partitioned table and the state of the table afterwards        #
#   The partitioning function use the column f_int1                            #
#                                                                              #
#   For all partitioning methods                                               #
#        PARTITION BY HASH/KEY/LIST/RANGE                                      #
#        PARTITION BY RANGE/LIST ... SUBPARTITION BY HASH/KEY ...              #
#   do                                                                         #
#     1. Create the partitioned table                                          #
#     2. Execute inc/partition_alter_1.inc, which will                     #
#        - Insert the first half of the table t0_template into t1              #
#        - Execute the ALTER TABLE statement                                   #
#        - Insert the second half of the table t0_template into t1             #
#        - Execute the usability test inc/partition_check.inc              #
#        - Drop the table t1                                                   #
#   done                                                                       #
#                                                                              #
#   The parameters                                                             #
#        $unique -- PRIMARY KEY or UNIQUE INDEXes to be created within the     #
#                   CREATE TABLE STATEMENT                                     #
#        $alter  -- ALTER TABLE statement, which has to be executed            #
#   have to be set before sourcing this routine.                               #
#   Example:                                                                   #
#          let $unique= , UNIQUE INDEX uidx1 (f_int1);                         #
#          let $alter= ALTER TABLE t1 DROP UNIQUE INDEX uidx1;                 #
#          inc/partition_alter1.inc                                        #
#                                                                              #
# Attention: The routine inc/partition_alter_13.inc is very similar        #
#            to this one. So if something has to be changed here it            #
#            might be necessary to do it also there                            #
#                                                                              #
#------------------------------------------------------------------------------#
# Original Author: mleich                                                      #
# Original Date: 2006-03-05                                                    #
# Change Author:                                                               #
# Change Date:                                                                 #
# Change:                                                                      #
################################################################################

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

let $partitioning= ;
#----------- PARTITION BY HASH
if ($with_partitioning)
{
let $partitioning= PARTITION BY HASH(f_int1) PARTITIONS 2 (partition part_1, partition part_2);
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY KEY
if ($with_partitioning)
{
let $partitioning= PARTITION BY KEY(f_int1) PARTITIONS 5 (partition part_1, partition part_2, partition part_3, partition part_4, partition part_5);
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY LIST
if ($with_partitioning)
{
let $partitioning= PARTITION BY LIST(MOD(f_int1,4))
(PARTITION part_3 VALUES IN (-3),
 PARTITION part_2 VALUES IN (-2),
 PARTITION part_1 VALUES IN (-1),
 PARTITION part_N VALUES IN (NULL),
 PARTITION part0 VALUES IN (0),
 PARTITION part1 VALUES IN (1),
 PARTITION part2 VALUES IN (2),
 PARTITION part3 VALUES IN (3));
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY RANGE
if ($with_partitioning)
{
--disable_query_log
eval SET @aux = 'PARTITION BY RANGE(f_int1)
(PARTITION parta VALUES LESS THAN (0),
PARTITION part_1 VALUES LESS THAN ($max_row_div4),
PARTITION part_2 VALUES LESS THAN ($max_row_div2),
PARTITION part_3 VALUES LESS THAN ($max_row_div2 + $max_row_div4),
PARTITION part_4 VALUES LESS THAN ($max_row),
PARTITION part_5 VALUES LESS THAN $MAX_VALUE)';
let $partitioning= `SELECT @aux`;
--enable_query_log
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY RANGE -- SUBPARTITION BY HASH
if ($with_partitioning)
{
--disable_query_log
eval SET @aux =
'PARTITION BY RANGE(f_int1 DIV 2) SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
(PARTITION part_1 VALUES LESS THAN (0),
PARTITION part_2 VALUES LESS THAN ($max_row_div4),
PARTITION part_3 VALUES LESS THAN ($max_row_div2),
PARTITION part_4 VALUES LESS THAN $MAX_VALUE)';
let $partitioning= `SELECT @aux`;
--enable_query_log
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY RANGE -- SUBPARTITION BY KEY
if ($with_partitioning)
{
--disable_query_log
eval SET @aux = 'PARTITION BY RANGE(f_int1) SUBPARTITION BY KEY(f_int1)
(PARTITION part_1 VALUES LESS THAN (0)
(SUBPARTITION subpart11, SUBPARTITION subpart12),
PARTITION part_2 VALUES LESS THAN ($max_row_div4)
(SUBPARTITION subpart21, SUBPARTITION subpart22),
PARTITION part_3 VALUES LESS THAN ($max_row_div2)
(SUBPARTITION subpart31, SUBPARTITION subpart32),
PARTITION part_4 VALUES LESS THAN $MAX_VALUE
(SUBPARTITION subpart41, SUBPARTITION subpart42))';
let $partitioning= `SELECT @aux`;
--enable_query_log
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY LIST -- SUBPARTITION BY HASH
if ($with_partitioning)
{
let $partitioning= PARTITION BY LIST(ABS(MOD(f_int1,3))) SUBPARTITION BY HASH(f_int1 + 1)
(PARTITION part_1 VALUES IN (0)
  (SUBPARTITION sp11, SUBPARTITION sp12),
 PARTITION part_2 VALUES IN (1)
  (SUBPARTITION sp21, SUBPARTITION sp22),
 PARTITION part_3 VALUES IN (2)
  (SUBPARTITION sp31, SUBPARTITION sp32),
 PARTITION part_4 VALUES IN (NULL)
  (SUBPARTITION sp41, SUBPARTITION sp42));
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

#----------- PARTITION BY LIST -- SUBPARTITION BY KEY
if ($with_partitioning)
{
--disable_query_log
eval SET @aux =
'PARTITION BY LIST(ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY(f_int1) SUBPARTITIONS $sub_part_no
(PARTITION part_1 VALUES IN (0),
 PARTITION part_2 VALUES IN (1),
 PARTITION part_3 VALUES IN (NULL))';
let $partitioning= `SELECT @aux`;
--enable_query_log
}
eval CREATE TABLE t1 (
$column_list
$unique
)
$partitioning;
--source suite/parts/inc/partition_alter_1.inc

${this.title}

Code Editor : partition_alter_41.inc