50 lines
1.4 KiB
Plaintext
50 lines
1.4 KiB
Plaintext
|
|
--echo #
|
|
--echo # Bug #20582149 INVALID READ OF SIZE 1 IN PROTOCOL::NET_STORE_DATA
|
|
--echo #
|
|
|
|
CREATE TABLE t1 (f1 INT NOT NULL, f2 text,
|
|
PRIMARY KEY(f1)) PARTITION BY KEY() PARTITIONS 4;
|
|
|
|
INSERT INTO t1 VALUES(42,'Testing MySQL databases is a cool ');
|
|
INSERT INTO t1 VALUES(2,'Testing MySQL databases is a cool ');
|
|
INSERT INTO t1 VALUES(4,'Testing MySQL databases is a cool ');
|
|
|
|
select f1, f2 from t1 order by f1;
|
|
|
|
DROP TABLE IF EXISTS t1;
|
|
|
|
--echo #
|
|
--echo # Bug #20685835 INVALID READ OF BLOB MEMORY
|
|
--echo #
|
|
|
|
--echo # Test correlated subquery with LOB
|
|
CREATE TABLE t1 (f1 INT, f2 TEXT, f3 INT,
|
|
PRIMARY KEY(f1))
|
|
PARTITION BY HASH(f1) PARTITIONS 1;
|
|
|
|
INSERT INTO t1 VALUES(1,'1', 3);
|
|
INSERT INTO t1 VALUES(2,'2', 2);
|
|
INSERT INTO t1 VALUES(3,'3', 2);
|
|
|
|
SELECT DISTINCT f3 FROM t1
|
|
HAVING (SELECT 1 FROM t1 HAVING f2 LIMIT 1)
|
|
ORDER BY f3;
|
|
|
|
DROP TABLE t1;
|
|
|
|
--echo #
|
|
--echo # Bug #28491099 [FATAL] MEMORY BLOCK IS INVALID | INNODB: ASSERTION
|
|
--echo # FAILURE: UT0UT.CC:670
|
|
--echo #
|
|
set sql_mode='';
|
|
CREATE TABLE t1(a INT, b TEXT NOT NULL) PARTITION BY RANGE(a)
|
|
(PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (9),
|
|
PARTITION p2 VALUES LESS THAN MAXVALUE);
|
|
INSERT INTO t1(a) VALUES(0);
|
|
ALTER TABLE t1 ADD COLUMN c DATE NOT NULL;
|
|
ALTER TABLE t1 drop partition p0;
|
|
ALTER TABLE t1 ADD COLUMN d DATE NOT NULL;
|
|
DROP TABLE t1;
|
|
SET sql_mode = default;
|