Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug51378.result

raw
1 create table bug51378 (
2 col1 int not null,
3 col2 blob not null,
4 col3 time not null) engine = innodb;
5 create unique index idx on bug51378(col1, col2(31));
6 alter table bug51378 add unique index idx2(col1, col2(31));
7 Warnings:
8 Warning 1831 Duplicate index 'idx2' defined on the table 'test.bug51378'. This is deprecated and will be disallowed in a future release.
9 create unique index idx3 on bug51378(col1, col3);
10 SHOW CREATE TABLE bug51378;
11 Table Create Table
12 bug51378 CREATE TABLE `bug51378` (
13 `col1` int NOT NULL,
14 `col2` blob NOT NULL,
15 `col3` time NOT NULL,
16 UNIQUE KEY `idx3` (`col1`,`col3`),
17 UNIQUE KEY `idx` (`col1`,`col2`(31)),
18 UNIQUE KEY `idx2` (`col1`,`col2`(31))
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
20 drop index idx3 on bug51378;
21 SHOW CREATE TABLE bug51378;
22 Table Create Table
23 bug51378 CREATE TABLE `bug51378` (
24 `col1` int NOT NULL,
25 `col2` blob NOT NULL,
26 `col3` time NOT NULL,
27 UNIQUE KEY `idx` (`col1`,`col2`(31)),
28 UNIQUE KEY `idx2` (`col1`,`col2`(31))
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
30 alter table bug51378 add primary key idx3(col1, col2(31));
31 SHOW CREATE TABLE bug51378;
32 Table Create Table
33 bug51378 CREATE TABLE `bug51378` (
34 `col1` int NOT NULL,
35 `col2` blob NOT NULL,
36 `col3` time NOT NULL,
37 PRIMARY KEY (`col1`,`col2`(31)),
38 UNIQUE KEY `idx` (`col1`,`col2`(31)),
39 UNIQUE KEY `idx2` (`col1`,`col2`(31))
40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 drop table bug51378;
42 create table bug51378 (
43 col1 int not null,
44 col2 blob not null,
45 col3 time not null, primary key(col1, col2(31))) engine = innodb;
46 create unique index idx on bug51378(col1, col2(31));
47 SHOW CREATE TABLE bug51378;
48 Table Create Table
49 bug51378 CREATE TABLE `bug51378` (
50 `col1` int NOT NULL,
51 `col2` blob NOT NULL,
52 `col3` time NOT NULL,
53 PRIMARY KEY (`col1`,`col2`(31)),
54 UNIQUE KEY `idx` (`col1`,`col2`(31))
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 drop table bug51378;
57 create table bug51378 (
58 col1 int not null,
59 col2 int ) engine = innodb;
60 create unique index idx on bug51378(col1, col2);
61 SHOW CREATE TABLE bug51378;
62 Table Create Table
63 bug51378 CREATE TABLE `bug51378` (
64 `col1` int NOT NULL,
65 `col2` int DEFAULT NULL,
66 UNIQUE KEY `idx` (`col1`,`col2`)
67 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
68 drop table bug51378;