Debian Codegraph @

mysql-test/suite/innodb/t/partition-blob.test

raw
1
2 --echo #
3 --echo # Bug #20582149 INVALID READ OF SIZE 1 IN PROTOCOL::NET_STORE_DATA
4 --echo #
5
6 CREATE TABLE t1 (f1 INT NOT NULL, f2 text,
7 PRIMARY KEY(f1)) PARTITION BY KEY() PARTITIONS 4;
8
9 INSERT INTO t1 VALUES(42,'Testing MySQL databases is a cool ');
10 INSERT INTO t1 VALUES(2,'Testing MySQL databases is a cool ');
11 INSERT INTO t1 VALUES(4,'Testing MySQL databases is a cool ');
12
13 select f1, f2 from t1 order by f1;
14
15 DROP TABLE IF EXISTS t1;
16
17 --echo #
18 --echo # Bug #20685835 INVALID READ OF BLOB MEMORY
19 --echo #
20
21 --echo # Test correlated subquery with LOB
22 CREATE TABLE t1 (f1 INT, f2 TEXT, f3 INT,
23 PRIMARY KEY(f1))
24 PARTITION BY HASH(f1) PARTITIONS 1;
25
26 INSERT INTO t1 VALUES(1,'1', 3);
27 INSERT INTO t1 VALUES(2,'2', 2);
28 INSERT INTO t1 VALUES(3,'3', 2);
29
30 SELECT DISTINCT f3 FROM t1
31 HAVING (SELECT 1 FROM t1 HAVING f3 LIMIT 1)
32 ORDER BY f3;
33
34 DROP TABLE t1;
35
36 --echo #
37 --echo # Bug #28491099 [FATAL] MEMORY BLOCK IS INVALID | INNODB: ASSERTION
38 --echo # FAILURE: UT0UT.CC:670
39 --echo #
40 set sql_mode='';
41 CREATE TABLE t1(a INT, b TEXT NOT NULL) PARTITION BY RANGE(a)
42 (PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (9),
43 PARTITION p2 VALUES LESS THAN MAXVALUE);
44 INSERT INTO t1(a) VALUES(0);
45 ALTER TABLE t1 ADD COLUMN c DATE NOT NULL;
46 ALTER TABLE t1 drop partition p0;
47 ALTER TABLE t1 ADD COLUMN d DATE NOT NULL;
48 DROP TABLE t1;
49 SET sql_mode = default;