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 Note 1831 Duplicate index `idx2`. 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(11) 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_uca1400_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(11) 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_uca1400_ai_ci
30 alter table bug51378 add primary key idx3(col1, col2(31));
31 Warnings:
32 Warning 1280 Name 'idx3' ignored for PRIMARY key.
33 SHOW CREATE TABLE bug51378;
34 Table Create Table
35 bug51378 CREATE TABLE `bug51378` (
36 `col1` int(11) NOT NULL,
37 `col2` blob NOT NULL,
38 `col3` time NOT NULL,
39 PRIMARY KEY (`col1`,`col2`(31)),
40 UNIQUE KEY `idx` (`col1`,`col2`(31)),
41 UNIQUE KEY `idx2` (`col1`,`col2`(31))
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
43 drop table bug51378;
44 create table bug51378 (
45 col1 int not null,
46 col2 blob not null,
47 col3 time not null, primary key(col1, col2(31))) engine = innodb;
48 create unique index idx on bug51378(col1, col2(31));
49 SHOW CREATE TABLE bug51378;
50 Table Create Table
51 bug51378 CREATE TABLE `bug51378` (
52 `col1` int(11) NOT NULL,
53 `col2` blob NOT NULL,
54 `col3` time NOT NULL,
55 PRIMARY KEY (`col1`,`col2`(31)),
56 UNIQUE KEY `idx` (`col1`,`col2`(31))
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
58 drop table bug51378;
59 create table bug51378 (
60 col1 int not null,
61 col2 int ) engine = innodb;
62 create unique index idx on bug51378(col1, col2);
63 SHOW CREATE TABLE bug51378;
64 Table Create Table
65 bug51378 CREATE TABLE `bug51378` (
66 `col1` int(11) NOT NULL,
67 `col2` int(11) DEFAULT NULL,
68 UNIQUE KEY `idx` (`col1`,`col2`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 drop table bug51378;