"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/639716.result" (6 May 2012, 1362 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 DROP TABLE IF EXISTS `a`;
    2 DROP TABLE IF EXISTS `aa`;
    3 DROP TABLE IF EXISTS `c`;
    4 CREATE TABLE `a` (
    5 `pk` INT NOT NULL DEFAULT '0',
    6 `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,
    7 PRIMARY KEY (`pk`),
    8 KEY `col_enum_key` (`col_enum_key`)
    9 ) ENGINE=InnoDB COLLATE = utf8_general_ci;
   10 CREATE TABLE `aa` (
   11 `pk` INT NOT NULL DEFAULT '0',
   12 `col_int_not_null_key` INT NOT NULL,
   13 PRIMARY KEY (`pk`),
   14 KEY `col_int_not_null_key` (`col_int_not_null_key`)
   15 ) ENGINE=InnoDB COLLATE = utf8_general_ci;
   16 INSERT INTO `aa` VALUES (1,-523436032),(2,1),(3,621543424),(4,880148480),(5,1963982848),(6,8),(7,1445462016),(8,0),(9,-747241472),(10,6);
   17 CREATE TABLE `c` (
   18 `pk` INT NOT NULL DEFAULT '0',
   19 `col_int_key` INT DEFAULT NULL,
   20 `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,
   21 PRIMARY KEY (`pk`),
   22 KEY `col_int_key` (`col_int_key`),
   23 KEY `col_enum_key` (`col_enum_key`)
   24 ) ENGINE=InnoDB COLLATE = utf8_general_ci;
   25 INSERT INTO `c` VALUES (1,NULL,'h');
   26 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 ;
   27 ERROR HY000: Received an invalid enum value '1963982848'.
   28 DROP TABLE `a`,`aa`,`c`;