rocksdb/r/partition.result

CREATE TABLE t1 (i INT, j INT, k INT, PRIMARY KEY (i)) ENGINE = ROCKSDB PARTITION BY KEY(i) PARTITIONS 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
Warning	1287	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
Warning	1287	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Table	Op	Msg_type	Msg_text
test.t1	optimize	status	OK
test.t1	optimize	warning	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
test.t1	analyze	warning	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Table	Op	Msg_type	Msg_text
test.t1	repair	status	OK
test.t1	repair	warning	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
test.t1	check	warning	The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
Warning	1287	The partition engine, used by table 'test.TEMP0', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
Warning	1287	The partition engine, used by table 'test.VAR_SAMP', is deprecated and will be removed in a future release. Please use native partitioning instead.
SHOW TABLES;
Tables_in_test
TEMP0
VAR_POP
VAR_SAMP
t1
SELECT * FROM t1 ORDER BY i LIMIT 10;
i	j	k
1	1	1
2	2	2
3	3	3
4	4	4
5	5	5
6	6	6
7	7	7
8	8	8
9	9	9
10	10	10
SELECT COUNT(*) FROM t1;
COUNT(*)
1000
CREATE TABLE ti(
id INT,
amount DECIMAL(7,2),
tr_date DATE
) ENGINE=ROCKSDB
PARTITION BY HASH(MONTH(tr_date))
PARTITIONS 6;
Warnings:
Warning	1287	The partition engine, used by table 'test.ti', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE members (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
email VARCHAR(35),
joined DATE NOT NULL
) ENGINE=ROCKSDB
PARTITION BY KEY(joined)
PARTITIONS 6;
Warnings:
Warning	1287	The partition engine, used by table 'test.members', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE members_2 (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
email VARCHAR(35),
joined DATE NOT NULL
) ENGINE=ROCKSDB
PARTITION BY RANGE(YEAR(joined)) (
PARTITION p0 VALUES LESS THAN (1960),
PARTITION p1 VALUES LESS THAN (1970),
PARTITION p2 VALUES LESS THAN (1980),
PARTITION p3 VALUES LESS THAN (1990),
PARTITION p4 VALUES LESS THAN MAXVALUE
);
Warnings:
Warning	1287	The partition engine, used by table 'test.members_2', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE t2 (val INT)
ENGINE=ROCKSDB
PARTITION BY LIST(val)(
PARTITION mypart VALUES IN (1,3,5),
PARTITION MyPart VALUES IN (2,4,6)
);
ERROR HY000: Duplicate partition name MyPart
CREATE TABLE employees (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT NOT NULL,
store_id INT NOT NULL
) ENGINE=ROCKSDB
PARTITION BY RANGE (store_id) (
PARTITION p0 VALUES LESS THAN (6),
PARTITION p1 VALUES LESS THAN (11),
PARTITION p2 VALUES LESS THAN (16),
PARTITION p3 VALUES LESS THAN MAXVALUE
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_2 (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT NOT NULL,
store_id INT NOT NULL
) ENGINE=ROCKSDB
PARTITION BY RANGE (job_code) (
PARTITION p0 VALUES LESS THAN (100),
PARTITION p1 VALUES LESS THAN (1000),
PARTITION p2 VALUES LESS THAN (10000)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_2', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_3 (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT,
store_id INT
) ENGINE=ROCKSDB
PARTITION BY RANGE (YEAR(separated)) (
PARTITION p0 VALUES LESS THAN (1991),
PARTITION p1 VALUES LESS THAN (1996),
PARTITION p2 VALUES LESS THAN (2001),
PARTITION p3 VALUES LESS THAN MAXVALUE
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_3', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE quarterly_report_status (
report_id INT NOT NULL,
report_status VARCHAR(20) NOT NULL,
report_updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=ROCKSDB
PARTITION BY RANGE (UNIX_TIMESTAMP(report_updated)) (
PARTITION p0 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-01-01 00:00:00') ),
PARTITION p1 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-04-01 00:00:00') ),
PARTITION p2 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-07-01 00:00:00') ),
PARTITION p3 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-10-01 00:00:00') ),
PARTITION p4 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-01-01 00:00:00') ),
PARTITION p5 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-04-01 00:00:00') ),
PARTITION p6 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-07-01 00:00:00') ),
PARTITION p7 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-10-01 00:00:00') ),
PARTITION p8 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-01-01 00:00:00') ),
PARTITION p9 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.quarterly_report_status', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_4 (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT,
store_id INT
) ENGINE=ROCKSDB
PARTITION BY LIST(store_id) (
PARTITION pNorth VALUES IN (3,5,6,9,17),
PARTITION pEast VALUES IN (1,2,10,11,19,20),
PARTITION pWest VALUES IN (4,12,13,14,18),
PARTITION pCentral VALUES IN (7,8,15,16)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_4', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE h2 (
c1 INT,
c2 INT
) ENGINE=ROCKSDB
PARTITION BY LIST(c1) (
PARTITION p0 VALUES IN (1, 4, 7),
PARTITION p1 VALUES IN (2, 5, 8)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.h2', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO h2 VALUES (3, 5);
ERROR HY000: Table has no partition for value 3
CREATE TABLE rcx (
a INT,
b INT,
c CHAR(3),
d INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a,d,c) (
PARTITION p0 VALUES LESS THAN (5,10,'ggg'),
PARTITION p1 VALUES LESS THAN (10,20,'mmm'),
PARTITION p2 VALUES LESS THAN (15,30,'sss'),
PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rcx', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE r1 (
a INT,
b INT
) ENGINE=ROCKSDB
PARTITION BY RANGE (a)  (
PARTITION p0 VALUES LESS THAN (5),
PARTITION p1 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.r1', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO r1 VALUES (5,10), (5,11), (5,12);
Warnings:
Warning	1287	The partition engine, used by table 'test.r1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE rc1 (
a INT,
b INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a, b) (
PARTITION p0 VALUES LESS THAN (5, 12),
PARTITION p3 VALUES LESS THAN (MAXVALUE, MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rc1', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO rc1 VALUES (5,10), (5,11), (5,12);
Warnings:
Warning	1287	The partition engine, used by table 'test.rc1', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT (5,10) < (5,12), (5,11) < (5,12), (5,12) < (5,12);
(5,10) < (5,12)	(5,11) < (5,12)	(5,12) < (5,12)
1	1	0
CREATE TABLE rx (
a INT,
b INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS (a)  (
PARTITION p0 VALUES LESS THAN (5),
PARTITION p1 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rx', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO rx VALUES (5,10), (5,11), (5,12);
Warnings:
Warning	1287	The partition engine, used by table 'test.rx', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE rc2 (
a INT,
b INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a,b) (
PARTITION p0 VALUES LESS THAN (0,10),
PARTITION p1 VALUES LESS THAN (10,20),
PARTITION p2 VALUES LESS THAN (10,30),
PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rc2', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE rc3 (
a INT,
b INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a,b) (
PARTITION p0 VALUES LESS THAN (0,10),
PARTITION p1 VALUES LESS THAN (10,20),
PARTITION p2 VALUES LESS THAN (10,30),
PARTITION p3 VALUES LESS THAN (10,35),
PARTITION p4 VALUES LESS THAN (20,40),
PARTITION p5 VALUES LESS THAN (MAXVALUE,MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rc3', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE rc4 (
a INT,
b INT,
c INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a,b,c) (
PARTITION p0 VALUES LESS THAN (0,25,50),
PARTITION p1 VALUES LESS THAN (10,20,100),
PARTITION p2 VALUES LESS THAN (10,30,50),
PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.rc4', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT (0,25,50) < (10,20,100), (10,20,100) < (10,30,50);
(0,25,50) < (10,20,100)	(10,20,100) < (10,30,50)
1	1
CREATE TABLE rcf (
a INT,
b INT,
c INT
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(a,b,c) (
PARTITION p0 VALUES LESS THAN (0,25,50),
PARTITION p1 VALUES LESS THAN (20,20,100),
PARTITION p2 VALUES LESS THAN (10,30,50),
PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)
);
ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
CREATE TABLE employees_by_lname (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT NOT NULL,
store_id INT NOT NULL
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS (lname)  (
PARTITION p0 VALUES LESS THAN ('g'),
PARTITION p1 VALUES LESS THAN ('m'),
PARTITION p2 VALUES LESS THAN ('t'),
PARTITION p3 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_by_lname', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE employees_by_lname PARTITION BY RANGE COLUMNS (lname)  (
PARTITION p0 VALUES LESS THAN ('g'),
PARTITION p1 VALUES LESS THAN ('m'),
PARTITION p2 VALUES LESS THAN ('t'),
PARTITION p3 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_by_lname', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE employees_by_lname PARTITION BY RANGE COLUMNS (hired)  (
PARTITION p0 VALUES LESS THAN ('1970-01-01'),
PARTITION p1 VALUES LESS THAN ('1980-01-01'),
PARTITION p2 VALUES LESS THAN ('1990-01-01'),
PARTITION p3 VALUES LESS THAN ('2000-01-01'),
PARTITION p4 VALUES LESS THAN ('2010-01-01'),
PARTITION p5 VALUES LESS THAN (MAXVALUE)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_by_lname', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE customers_1 (
first_name VARCHAR(25),
last_name VARCHAR(25),
street_1 VARCHAR(30),
street_2 VARCHAR(30),
city VARCHAR(15),
renewal DATE
) ENGINE=ROCKSDB
PARTITION BY LIST COLUMNS(city) (
PARTITION pRegion_1 VALUES IN('Oskarshamn', 'Högsby', 'Mönsterås'),
PARTITION pRegion_2 VALUES IN('Vimmerby', 'Hultsfred', 'Västervik'),
PARTITION pRegion_3 VALUES IN('Nässjö', 'Eksjö', 'Vetlanda'),
PARTITION pRegion_4 VALUES IN('Uppvidinge', 'Alvesta', 'Växjo')
);
Warnings:
Warning	1287	The partition engine, used by table 'test.customers_1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE customers_2 (
first_name VARCHAR(25),
last_name VARCHAR(25),
street_1 VARCHAR(30),
street_2 VARCHAR(30),
city VARCHAR(15),
renewal DATE
) ENGINE=ROCKSDB
PARTITION BY LIST COLUMNS(renewal) (
PARTITION pWeek_1 VALUES IN('2010-02-01', '2010-02-02', '2010-02-03',
'2010-02-04', '2010-02-05', '2010-02-06', '2010-02-07'),
PARTITION pWeek_2 VALUES IN('2010-02-08', '2010-02-09', '2010-02-10',
'2010-02-11', '2010-02-12', '2010-02-13', '2010-02-14'),
PARTITION pWeek_3 VALUES IN('2010-02-15', '2010-02-16', '2010-02-17',
'2010-02-18', '2010-02-19', '2010-02-20', '2010-02-21'),
PARTITION pWeek_4 VALUES IN('2010-02-22', '2010-02-23', '2010-02-24',
'2010-02-25', '2010-02-26', '2010-02-27', '2010-02-28')
);
Warnings:
Warning	1287	The partition engine, used by table 'test.customers_2', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE customers_3 (
first_name VARCHAR(25),
last_name VARCHAR(25),
street_1 VARCHAR(30),
street_2 VARCHAR(30),
city VARCHAR(15),
renewal DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE COLUMNS(renewal) (
PARTITION pWeek_1 VALUES LESS THAN('2010-02-09'),
PARTITION pWeek_2 VALUES LESS THAN('2010-02-15'),
PARTITION pWeek_3 VALUES LESS THAN('2010-02-22'),
PARTITION pWeek_4 VALUES LESS THAN('2010-03-01')
);
Warnings:
Warning	1287	The partition engine, used by table 'test.customers_3', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_hash (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT,
store_id INT
) ENGINE=ROCKSDB
PARTITION BY HASH(store_id)
PARTITIONS 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_hash', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_hash_1 (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT,
store_id INT
) ENGINE=ROCKSDB
PARTITION BY HASH( YEAR(hired) )
PARTITIONS 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_hash_1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE t1_hash (
col1 INT,
col2 CHAR(5),
col3 DATE
) ENGINE=ROCKSDB
PARTITION BY HASH( YEAR(col3) )
PARTITIONS 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.t1_hash', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE employees_linear_hash (
id INT NOT NULL,
fname VARCHAR(30),
lname VARCHAR(30),
hired DATE NOT NULL DEFAULT '1970-01-01',
separated DATE NOT NULL DEFAULT '9999-12-31',
job_code INT,
store_id INT
) ENGINE=ROCKSDB
PARTITION BY LINEAR HASH( YEAR(hired) )
PARTITIONS 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.employees_linear_hash', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE t1_linear_hash (
col1 INT,
col2 CHAR(5),
col3 DATE
) ENGINE=ROCKSDB
PARTITION BY LINEAR HASH( YEAR(col3) )
PARTITIONS 6;
Warnings:
Warning	1287	The partition engine, used by table 'test.t1_linear_hash', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE k1 (
id INT NOT NULL PRIMARY KEY,
name VARCHAR(20)
) ENGINE=ROCKSDB
PARTITION BY KEY()
PARTITIONS 2;
Warnings:
Warning	1287	The partition engine, used by table 'test.k1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE k2 (
id INT NOT NULL,
name VARCHAR(20),
UNIQUE KEY (id)
) ENGINE=ROCKSDB
PARTITION BY KEY()
PARTITIONS 2;
Warnings:
Warning	1287	The partition engine, used by table 'test.k2', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE tm1 (
s1 CHAR(32) PRIMARY KEY
) ENGINE=ROCKSDB
PARTITION BY KEY(s1)
PARTITIONS 10;
Warnings:
Warning	1287	The partition engine, used by table 'test.tm1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE tk (
col1 INT NOT NULL,
col2 CHAR(5),
col3 DATE
) ENGINE=ROCKSDB
PARTITION BY LINEAR KEY (col1)
PARTITIONS 3;
Warnings:
Warning	1287	The partition engine, used by table 'test.tk', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE ts (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) )
SUBPARTITIONS 2 (
PARTITION p0 VALUES LESS THAN (1990),
PARTITION p1 VALUES LESS THAN (2000),
PARTITION p2 VALUES LESS THAN MAXVALUE
);
Warnings:
Warning	1287	The partition engine, used by table 'test.ts', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE ts_1 (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s2,
SUBPARTITION s3
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s4,
SUBPARTITION s5
)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.ts_1', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE ts_2 (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s2,
SUBPARTITION s3
)
);
ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s2,
SUBPARTITION s3
)
)' at line 11
CREATE TABLE ts_3 (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s2,
SUBPARTITION s3
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s4,
SUBPARTITION s5
)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.ts_3', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE ts_4 (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s2,
SUBPARTITION s3
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s4,
SUBPARTITION s5
)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.ts_4', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE ts_5 (
id INT,
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE(YEAR(purchased))
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0a,
SUBPARTITION s0b
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s1a,
SUBPARTITION s1b
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s2a,
SUBPARTITION s2b
)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.ts_5', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE trb3 (
id INT,
name VARCHAR(50),
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990),
PARTITION p1 VALUES LESS THAN (1995),
PARTITION p2 VALUES LESS THAN (2000),
PARTITION p3 VALUES LESS THAN (2005)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.trb3', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE trb3 PARTITION BY KEY(id) PARTITIONS 2;
Warnings:
Warning	1287	The partition engine, used by table 'test.trb3', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE tr (
id INT,
name VARCHAR(50),
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990),
PARTITION p1 VALUES LESS THAN (1995),
PARTITION p2 VALUES LESS THAN (2000),
PARTITION p3 VALUES LESS THAN (2005)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.tr', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO tr VALUES
(1, 'desk organiser', '2003-10-15'),
(2, 'CD player', '1993-11-05'),
(3, 'TV set', '1996-03-10'),
(4, 'bookcase', '1982-01-10'),
(5, 'exercise bike', '2004-05-09'),
(6, 'sofa', '1987-06-05'),
(7, 'popcorn maker', '2001-11-22'),
(8, 'aquarium', '1992-08-04'),
(9, 'study desk', '1984-09-16'),
(10, 'lava lamp', '1998-12-25');
Warnings:
Warning	1287	The partition engine, used by table 'test.tr', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT * FROM tr WHERE purchased BETWEEN '1995-01-01' AND '1999-12-31';
id	name	purchased
3	TV set	1996-03-10
10	lava lamp	1998-12-25
ALTER TABLE tr DROP PARTITION p2;
Warnings:
Warning	1287	The partition engine, used by table 'test.tr', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT * FROM tr WHERE purchased BETWEEN '1995-01-01' AND '1999-12-31';
id	name	purchased
Warnings:
Warning	1287	The partition engine, used by table 'test.tr', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE members_3 (
id INT,
fname VARCHAR(25),
lname VARCHAR(25),
dob DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE( YEAR(dob) ) (
PARTITION p0 VALUES LESS THAN (1970),
PARTITION p1 VALUES LESS THAN (1980),
PARTITION p2 VALUES LESS THAN (1990)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.members_3', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE members_3 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2000));
Warnings:
Warning	1287	The partition engine, used by table 'test.members_3', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE members_3 ADD PARTITION (PARTITION n VALUES LESS THAN (1960));
ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
CREATE TABLE clients (
id INT,
fname VARCHAR(30),
lname VARCHAR(30),
signed DATE
) ENGINE=ROCKSDB
PARTITION BY HASH( MONTH(signed) )
PARTITIONS 12;
Warnings:
Warning	1287	The partition engine, used by table 'test.clients', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE clients COALESCE PARTITION 4;
Warnings:
Warning	1287	The partition engine, used by table 'test.clients', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE clients_lk (
id INT,
fname VARCHAR(30),
lname VARCHAR(30),
signed DATE
) ENGINE=ROCKSDB
PARTITION BY LINEAR KEY(signed)
PARTITIONS 12;
Warnings:
Warning	1287	The partition engine, used by table 'test.clients_lk', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE clients COALESCE PARTITION 18;
ERROR HY000: Cannot remove all partitions, use DROP TABLE instead
ALTER TABLE clients ADD PARTITION PARTITIONS 6;
Warnings:
Warning	1287	The partition engine, used by table 'test.clients', is deprecated and will be removed in a future release. Please use native partitioning instead.
CREATE TABLE trb1 (
id INT,
name VARCHAR(50),
purchased DATE
) ENGINE=ROCKSDB
PARTITION BY RANGE(id) (
PARTITION p0 VALUES LESS THAN (3),
PARTITION p1 VALUES LESS THAN (7),
PARTITION p2 VALUES LESS THAN (9),
PARTITION p3 VALUES LESS THAN (11)
);
Warnings:
Warning	1287	The partition engine, used by table 'test.trb1', is deprecated and will be removed in a future release. Please use native partitioning instead.
INSERT INTO trb1 VALUES
(1, 'desk organiser', '2003-10-15'),
(2, 'CD player', '1993-11-05'),
(3, 'TV set', '1996-03-10'),
(4, 'bookcase', '1982-01-10'),
(5, 'exercise bike', '2004-05-09'),
(6, 'sofa', '1987-06-05'),
(7, 'popcorn maker', '2001-11-22'),
(8, 'aquarium', '1992-08-04'),
(9, 'study desk', '1984-09-16'),
(10, 'lava lamp', '1998-12-25');
Warnings:
Warning	1287	The partition engine, used by table 'test.trb1', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE trb1 ADD PRIMARY KEY (id);
Warnings:
Warning	1287	The partition engine, used by table 'test.trb1', is deprecated and will be removed in a future release. Please use native partitioning instead.
DROP TABLE t1;
DROP TABLE VAR_POP;
DROP TABLE TEMP0;
DROP TABLE VAR_SAMP;
DROP TABLE ti;
DROP TABLE members;
DROP TABLE members_2;
DROP TABLE employees;
DROP TABLE employees_2;
DROP TABLE employees_3;
DROP TABLE quarterly_report_status;
DROP TABLE employees_4;
DROP TABLE h2;
DROP TABLE rcx;
DROP TABLE r1;
DROP TABLE rc1;
DROP TABLE rx;
DROP TABLE rc2;
DROP TABLE rc3;
DROP TABLE rc4;
DROP TABLE employees_by_lname;
DROP TABLE customers_1;
DROP TABLE customers_2;
DROP TABLE customers_3;
DROP TABLE employees_hash;
DROP TABLE employees_hash_1;
DROP TABLE t1_hash;
DROP TABLE employees_linear_hash;
DROP TABLE t1_linear_hash;
DROP TABLE k1;
DROP TABLE k2;
DROP TABLE tm1;
DROP TABLE tk;
DROP TABLE ts;
DROP TABLE ts_1;
DROP TABLE ts_3;
DROP TABLE ts_4;
DROP TABLE ts_5;
DROP TABLE trb3;
DROP TABLE tr;
DROP TABLE members_3;
DROP TABLE clients;
DROP TABLE clients_lk;
DROP TABLE trb1;
#
# PS-5174: Check COMPRESSED COLUMNS support on partitioned tables
#
SET @dictionary_data = 'one' 'two' 'three' 'four';
CREATE COMPRESSION_DICTIONARY numbers (@dictionary_data);
CREATE TABLE comp1(
id BIGINT UNSIGNED NOT NULL,
a VARCHAR(250) COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY numbers DEFAULT NULL
) ENGINE = ROCKSDB
PARTITION BY RANGE (id) (
PARTITION p1 VALUES LESS THAN (100),
PARTITION p2 VALUES LESS THAN MAXVALUE
);
ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'COMPRESSED COLUMNS'
DROP COMPRESSION_DICTIONARY numbers;