Debian Codegraph @

mysql-test/suite/innodb/r/innodb-large-prefix.result

raw
1 #
2 # Bug #12699505 MEMORY LEAK IN ROW_CREATE_INDEX_FOR_MYSQL()
3 #
4 CREATE TABLE t1(a int not null,key(a,a)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
5 ERROR 42S21: Duplicate column name 'a'
6 CREATE TABLE t1(a int,b text,key(b(768))) ENGINE=InnoDB DEFAULT CHARSET=latin1
7 ROW_FORMAT=COMPACT;
8 ERROR 42000: Specified key was too long; max key length is 767 bytes
9 CREATE TABLE t1(a int not null,b text) ENGINE=InnoDB DEFAULT CHARSET=latin1
10 ROW_FORMAT=COMPACT;
11 INSERT INTO t1 VALUES (1,''),(2,''),(3,''),(4,''),(5,''),(6,''),(7,'');
12 CREATE INDEX t1aa ON t1(a,a);
13 ERROR 42S21: Duplicate column name 'a'
14 CREATE INDEX t1b ON t1(b(768));
15 ERROR 42000: Specified key was too long; max key length is 767 bytes
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `a` int NOT NULL,
20 `b` text
21 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
22 SELECT * FROM t1;
23 a b
24 1
25 2
26 3
27 4
28 5
29 6
30 7
31 DROP TABLE t1;
32 CREATE TABLE t2(a int primary key, b text) ENGINE=InnoDB DEFAULT CHARSET=latin1
33 ROW_FORMAT=COMPACT;
34 INSERT INTO t2 VALUES (1,''),(2,''),(3,''),(4,''),(5,''),(6,''),(7,'');
35 CREATE INDEX t2aa ON t2(a,a);
36 ERROR 42S21: Duplicate column name 'a'
37 CREATE INDEX t2b ON t2(b(768));
38 ERROR 42000: Specified key was too long; max key length is 767 bytes
39 SELECT * FROM t2;
40 a b
41 1
42 2
43 3
44 4
45 5
46 6
47 7
48 DROP TABLE t2;