diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_partition_myisam.result')
| -rw-r--r-- | mysql-test/suite/gcol/r/gcol_partition_myisam.result | 121 |
1 files changed, 121 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_partition_myisam.result b/mysql-test/suite/gcol/r/gcol_partition_myisam.result new file mode 100644 index 00000000..e54b0ad8 --- /dev/null +++ b/mysql-test/suite/gcol/r/gcol_partition_myisam.result @@ -0,0 +1,121 @@ +SET @@session.default_storage_engine = 'MyISAM'; +drop table if exists t1; +# Case 1. Partitioning by RANGE based on a non-stored generated column. +CREATE TABLE t1 ( +a DATE NOT NULL, +b int generated always as (year(a)) virtual +) +PARTITION BY RANGE( b ) ( +PARTITION p0 VALUES LESS THAN (2006), +PARTITION p2 VALUES LESS THAN (2008) +); +insert into t1 values ('2006-01-01',default); +insert into t1 values ('2007-01-01',default); +insert into t1 values ('2005-01-01',default); +select * from t1; +a b +2005-01-01 2005 +2006-01-01 2006 +2007-01-01 2007 +# Modify the expression of generated column b +ALTER TABLE t1 modify b int generated always as (year(a)-1) virtual; +select * from t1; +a b +2005-01-01 2004 +2006-01-01 2005 +2007-01-01 2006 +drop table t1; +# Case 2. Partitioning by LIST based on a stored generated column. +CREATE TABLE t1 (a int, b int generated always as (a % 3 ) stored) +PARTITION BY LIST (a+1) +(PARTITION p1 VALUES IN (1), PARTITION p2 VALUES IN (2)); +insert into t1 values (1,default); +select * from t1; +a b +1 1 +select * from t1; +a b +1 1 +drop table t1; +# Case 3. Partitioning by HASH based on a non-stored generated column. +CREATE TABLE t1 ( +a DATE NOT NULL, +b int generated always as (year(a)) virtual +) +PARTITION BY HASH( b % 3 ) PARTITIONS 3; +insert into t1 values ('2005-01-01',default); +insert into t1 values ('2006-01-01',default); +select * from t1; +a b +2005-01-01 2005 +2006-01-01 2006 +# Modify the expression of generated column b +ALTER TABLE t1 modify b int generated always as (year(a)-1) virtual; +select * from t1; +a b +2005-01-01 2004 +2006-01-01 2005 +drop table t1; +# +# Bug#21779011 INVALID READS AND SENDING RANDOM SERVER MEMORY BACK +# TO CLIENT +# +CREATE TABLE t ( +c INTEGER GENERATED ALWAYS AS (2) VIRTUAL, +d INTEGER, +KEY (d) +) PARTITION BY KEY (d) PARTITIONS 2; +INSERT INTO t (d) VALUES (1),(1),(2),(2); +SELECT c FROM t WHERE d >= 1 GROUP BY d LIMIT 2; +c +2 +2 +DROP TABLE t; +# +# Bug#21779554: CHECK_MISPLACED_ROWS BOGUS "FOUND A MISPLACED ROW" +# AND CRASHES +# +CREATE TABLE t(a INT,b INT GENERATED ALWAYS AS (1) VIRTUAL,c INT) +PARTITION BY KEY (b)PARTITIONS 6; +INSERT INTO t VALUES(); +CHECK TABLE t EXTENDED; +Table Op Msg_type Msg_text +test.t check status OK +FLUSH TABLES; +CHECK TABLE t EXTENDED; +Table Op Msg_type Msg_text +test.t check status OK +DROP TABLE t; +# +# MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols +# +CREATE TABLE t1 ( +a INT, +b INT, +c BIT(4) NOT NULL DEFAULT b'0', +pk INTEGER AUTO_INCREMENT, +d BIT(4) AS (c) VIRTUAL, +PRIMARY KEY(pk), +KEY (b,d) +) PARTITION BY HASH(pk); +INSERT INTO t1 () VALUES (),(); +UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk; +DROP TABLE t1; +# +# MDEV-26220 Server crashes with indexed by prefix virtual column +# +CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(20), c CHAR(20) AS (b), +KEY (c(10),a)) PARTITION BY HASH(pk); +INSERT INTO t1 (pk,a,b) VALUES (1,10,'foo'),(2,11,'baz'); +SELECT a FROM t1; +a +11 +10 +DROP TABLE t1; +DROP VIEW IF EXISTS v1,v2; +DROP TABLE IF EXISTS t1,t2,t3; +DROP PROCEDURE IF EXISTS p1; +DROP FUNCTION IF EXISTS f1; +DROP TRIGGER IF EXISTS trg1; +DROP TRIGGER IF EXISTS trg2; +set sql_warnings = 0; |