Debian Codegraph @

mysql-test/suite/innodb/t/innodb-large-prefix.test

raw
1
2 --echo #
3 --echo # Bug #12699505 MEMORY LEAK IN ROW_CREATE_INDEX_FOR_MYSQL()
4 --echo #
5 # The leak would only be triggered if
6 # ha_innobase::max_supported_key_part_length() were set
7 # higher than the limit used in row_create_index_for_mysql().
8
9 --error ER_DUP_FIELDNAME
10 CREATE TABLE t1(a int not null,key(a,a)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11 -- error ER_TOO_LONG_KEY
12 CREATE TABLE t1(a int,b text,key(b(768))) ENGINE=InnoDB DEFAULT CHARSET=latin1
13 ROW_FORMAT=COMPACT;
14 CREATE TABLE t1(a int not null,b text) ENGINE=InnoDB DEFAULT CHARSET=latin1
15 ROW_FORMAT=COMPACT;
16 INSERT INTO t1 VALUES (1,''),(2,''),(3,''),(4,''),(5,''),(6,''),(7,'');
17 --error ER_DUP_FIELDNAME
18 CREATE INDEX t1aa ON t1(a,a);
19 -- error ER_TOO_LONG_KEY
20 CREATE INDEX t1b ON t1(b(768));
21 SHOW CREATE TABLE t1;
22 SELECT * FROM t1;
23 DROP TABLE t1;
24
25 CREATE TABLE t2(a int primary key, b text) ENGINE=InnoDB DEFAULT CHARSET=latin1
26 ROW_FORMAT=COMPACT;
27 INSERT INTO t2 VALUES (1,''),(2,''),(3,''),(4,''),(5,''),(6,''),(7,'');
28 --error ER_DUP_FIELDNAME
29 CREATE INDEX t2aa ON t2(a,a);
30 -- error ER_TOO_LONG_KEY
31 CREATE INDEX t2b ON t2(b(768));
32 SELECT * FROM t2;
33 DROP TABLE t2;