1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
--disable_warnings
DROP TABLE IF EXISTS `a`;
DROP TABLE IF EXISTS `aa`;
DROP TABLE IF EXISTS `c`;
--enable_warnings
CREATE TABLE `a` (
`pk` INT NOT NULL DEFAULT '0',
`col_enum_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
PRIMARY KEY (`pk`),
KEY `col_enum_key` (`col_enum_key`)
) ENGINE=InnoDB COLLATE = utf8_general_ci;
CREATE TABLE `aa` (
`pk` INT NOT NULL DEFAULT '0',
`col_int_not_null_key` INT NOT NULL,
PRIMARY KEY (`pk`),
KEY `col_int_not_null_key` (`col_int_not_null_key`)
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `aa` VALUES (1,-523436032),(2,1),(3,621543424),(4,880148480),(5,1963982848),(6,8),(7,1445462016),(8,0),(9,-747241472),(10,6);
CREATE TABLE `c` (
`pk` INT NOT NULL DEFAULT '0',
`col_int_key` INT DEFAULT NULL,
`col_enum_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
PRIMARY KEY (`pk`),
KEY `col_int_key` (`col_int_key`),
KEY `col_enum_key` (`col_enum_key`)
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `c` VALUES (1,NULL,'h');
--error 1691
SELECT X . `col_int_key` FROM `c` AS X LEFT JOIN `a` AS Y USING ( `col_enum_key` ) WHERE X . `col_enum_key` = ( SELECT `col_int_not_null_key` FROM `aa` WHERE `pk` = 5 ) LIMIT 8 ;
DROP TABLE `a`,`aa`,`c`;
|