From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/parts/inc/partition_value.inc | 163 +++++++++++++++++++++++++ 1 file changed, 163 insertions(+) create mode 100644 mysql-test/suite/parts/inc/partition_value.inc (limited to 'mysql-test/suite/parts/inc/partition_value.inc') diff --git a/mysql-test/suite/parts/inc/partition_value.inc b/mysql-test/suite/parts/inc/partition_value.inc new file mode 100644 index 00000000..79c4d6b8 --- /dev/null +++ b/mysql-test/suite/parts/inc/partition_value.inc @@ -0,0 +1,163 @@ +################################################################################ +# inc/partition_value.inc # +# # +# Purpose: # +# Tests around "exotic" values calculated by the partitioning function # +# # +#------------------------------------------------------------------------------# +# Original Author: mleich # +# Original Date: 2006-04-11 # +# Change Author: # +# Change Date: # +# Change: # +################################################################################ + + +--echo +--echo This test relies on the CAST() function for partitioning, which +--echo is not allowed. Not deleting it yet, as it may have some useful +--echo bits in it. See Bug #30581, "partition_value tests use disallowed +--echo CAST() function" +--echo + +--disable_parsing + +--echo +--echo #======================================================================== +--echo # Calculation of "exotic" results within the partition function +--echo # outside of SIGNED BIGINT value range, 0, NULL +--echo # column used in partitioning function has type CHAR +--echo #======================================================================== +--echo # 1. HASH() +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings +# +eval CREATE TABLE t1 ( +$column_list +) +PARTITION BY HASH(CAST(f_char1 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)) PARTITIONS 8; +let $my_val= 2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= -2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= 0; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +# let $my_val= NULL; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES(NULL,NULL,NULL,NULL,NULL); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 IS NULL; +DROP TABLE t1; +# +--echo # 2. RANGE() +eval CREATE TABLE t1 ( +$column_list +) +PARTITION BY RANGE(CAST(f_char1 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)) +(PARTITION p0 VALUES LESS THAN (0), + PARTITION p1 VALUES LESS THAN (1000000), + PARTITION p2 VALUES LESS THAN MAXVALUE); +let $my_val= 2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= -2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= 0; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +# let $my_val= NULL; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES(NULL,NULL,NULL,NULL,NULL); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 IS NULL; +DROP TABLE t1; +--echo # 3. LIST() +eval CREATE TABLE t1 ( +$column_list +) +PARTITION BY LIST(CAST(f_char1 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)) +(PARTITION p0 VALUES IN (0), + PARTITION p1 VALUES IN (NULL), + PARTITION p2 VALUES IN (CAST( 2147483646 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)), + PARTITION p3 VALUES IN (CAST(-2147483646 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER))); +let $my_val= 2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= -2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +let $my_val= 0; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 = '$my_val'; +# let $my_val= NULL; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES(NULL,NULL,NULL,NULL,NULL); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char1 IS NULL; +DROP TABLE t1; +# +--echo # 4. Partition by RANGE(...) subpartition by HASH() +eval CREATE TABLE t1 ( +$column_list +) +PARTITION BY RANGE(CAST(f_char1 AS SIGNED INTEGER)) +SUBPARTITION BY HASH(CAST(f_char2 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)) SUBPARTITIONS 4 +(PARTITION p0 VALUES LESS THAN (0), + PARTITION p1 VALUES LESS THAN MAXVALUE); +let $my_val= 2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'1','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +let $my_val= -2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'-1','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +let $my_val= 0; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'$my_val','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +# let $my_val= NULL; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES(NULL,NULL,NULL,NULL,NULL); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 IS NULL; +DROP TABLE t1; +# +--echo # 5. Partition by LIST(...) subpartition by HASH() +eval CREATE TABLE t1 ( +$column_list +) +PARTITION BY LIST(CAST(f_char1 AS SIGNED INTEGER)) +SUBPARTITION BY HASH(CAST(f_char2 AS SIGNED INTEGER) * CAST(5.0E+18 AS SIGNED INTEGER)) SUBPARTITIONS 4 +(PARTITION p0 VALUES IN (NULL), + PARTITION p1 VALUES IN (1)); +let $my_val= 2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'1','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +let $my_val= -2147483646; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'1','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +let $my_val= 0; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES($my_val,$my_val,'1','$my_val','#$my_val#'); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 = '$my_val'; +# let $my_val= NULL; +eval INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig) +VALUES(NULL,NULL,NULL,NULL,NULL); +eval SELECT COUNT(*) = 1 FROM t1 WHERE f_char2 IS NULL; +DROP TABLE t1; +# + +--enable_parsing -- cgit v1.2.3