Debian Codegraph @

mysql-test/suite/innodb_zip/r/large_blob.result

raw
1 #
2 # This tests the use of large blobs in InnoDB.
3 #
4 call mtr.add_suppression("Warning: a long semaphore wait");
5 SET GLOBAL innodb_file_per_table = OFF;
6 #
7 # System tablespace, Row Format = Redundant
8 #
9 CREATE TABLE t1 (
10 c1 INT DEFAULT NULL,
11 c2 LONGBLOB NOT NULL,
12 KEY k2 (c2(250), c1)
13 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
14 INSERT INTO t1 VALUES (1, '');
15 UPDATE t1 SET c2=@longblob;
16 DROP TABLE t1;
17 #
18 # System tablespace, Row Format = Compact
19 #
20 CREATE TABLE t1 (
21 c1 INT DEFAULT NULL,
22 c2 LONGBLOB NOT NULL,
23 KEY k2 (c2(250), c1)
24 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
25 INSERT INTO t1 VALUES (1, '');
26 UPDATE t1 SET c2=@longblob;
27 DROP TABLE t1;
28 SET GLOBAL innodb_file_per_table = ON;
29 #
30 # Separate tablespace, Row Format = Redundant
31 #
32 CREATE TABLE t1 (
33 c1 INT DEFAULT NULL,
34 c2 LONGBLOB NOT NULL,
35 KEY k2 (c2(250), c1)
36 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
37 INSERT INTO t1 VALUES (1, '');
38 UPDATE t1 SET c2=@longblob;
39 DROP TABLE t1;
40 #
41 # Separate tablespace, Row Format = Compact
42 #
43 CREATE TABLE t1 (
44 c1 INT DEFAULT NULL,
45 c2 LONGBLOB NOT NULL,
46 KEY k2 (c2(250), c1)
47 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
48 INSERT INTO t1 VALUES (1, '');
49 UPDATE t1 SET c2=@longblob;
50 DROP TABLE t1;
51 #
52 # Separate tablespace, Row Format = Compressed, Key Block Size = 2k
53 #
54 CREATE TABLE t1 (
55 c1 INT DEFAULT NULL,
56 c2 LONGBLOB NOT NULL,
57 KEY k2 (c2(250), c1)
58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=2;
59 INSERT INTO t1 VALUES (1, '');
60 UPDATE t1 SET c2=@longblob;
61 DROP TABLE t1;
62 #
63 # Separate tablespace, Row Format = Compressed, Key Block Size = 1k
64 #
65 CREATE TABLE t1 (
66 c1 INT DEFAULT NULL,
67 c2 LONGBLOB NOT NULL,
68 KEY k2 (c2(250), c1)
69 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1;
70 INSERT INTO t1 VALUES (1, '');
71 UPDATE t1 SET c2=@longblob;
72 DROP TABLE t1;
73 #
74 # Separate tablespace, Row Format = Dynamic
75 #
76 CREATE TABLE t1 (
77 c1 INT DEFAULT NULL,
78 c2 LONGBLOB NOT NULL,
79 KEY k2 (c2(250), c1)
80 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
81 INSERT INTO t1 VALUES (1, '');
82 UPDATE t1 SET c2=@longblob;
83 DROP TABLE t1;