Debian Codegraph @

mysql-test/suite/innodb/r/partition-blob.result

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