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 SET GLOBAL innodb_file_per_table = OFF;
5 Warnings:
6 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
7 #
8 # System tablespace, Row Format = Redundant
9 #
10 CREATE TABLE t1 (
11 c1 INT DEFAULT NULL,
12 c2 LONGBLOB NOT NULL,
13 KEY k2 (c2(250), c1)
14 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
15 INSERT INTO t1 VALUES (1, '');
16 UPDATE t1 SET c2=@longblob;
17 DROP TABLE t1;
18 #
19 # System tablespace, Row Format = Compact
20 #
21 CREATE TABLE t1 (
22 c1 INT DEFAULT NULL,
23 c2 LONGBLOB NOT NULL,
24 KEY k2 (c2(250), c1)
25 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
26 INSERT INTO t1 VALUES (1, '');
27 UPDATE t1 SET c2=@longblob;
28 DROP TABLE t1;
29 SET GLOBAL innodb_file_per_table = ON;
30 Warnings:
31 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
32 #
33 # Separate tablespace, Row Format = Redundant
34 #
35 CREATE TABLE t1 (
36 c1 INT DEFAULT NULL,
37 c2 LONGBLOB NOT NULL,
38 KEY k2 (c2(250), c1)
39 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
40 INSERT INTO t1 VALUES (1, '');
41 UPDATE t1 SET c2=@longblob;
42 DROP TABLE t1;
43 #
44 # Separate tablespace, Row Format = Compact
45 #
46 CREATE TABLE t1 (
47 c1 INT DEFAULT NULL,
48 c2 LONGBLOB NOT NULL,
49 KEY k2 (c2(250), c1)
50 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
51 INSERT INTO t1 VALUES (1, '');
52 UPDATE t1 SET c2=@longblob;
53 DROP TABLE t1;
54 #
55 # Separate tablespace, Row Format = Compressed, Key Block Size = 2k
56 #
57 CREATE TABLE t1 (
58 c1 INT DEFAULT NULL,
59 c2 LONGBLOB NOT NULL,
60 KEY k2 (c2(250), c1)
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=2;
62 INSERT INTO t1 VALUES (1, '');
63 UPDATE t1 SET c2=@longblob;
64 DROP TABLE t1;
65 #
66 # Separate tablespace, Row Format = Compressed, Key Block Size = 1k
67 #
68 CREATE TABLE t1 (
69 c1 INT DEFAULT NULL,
70 c2 LONGBLOB NOT NULL,
71 KEY k2 (c2(250), c1)
72 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1;
73 INSERT INTO t1 VALUES (1, '');
74 UPDATE t1 SET c2=@longblob;
75 DROP TABLE t1;
76 #
77 # Separate tablespace, Row Format = Dynamic
78 #
79 CREATE TABLE t1 (
80 c1 INT DEFAULT NULL,
81 c2 LONGBLOB NOT NULL,
82 KEY k2 (c2(250), c1)
83 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
84 INSERT INTO t1 VALUES (1, '');
85 UPDATE t1 SET c2=@longblob;
86 DROP TABLE t1;