"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/693309.result" (6 May 2012, 2112 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 `aa`;
    2 DROP TABLE IF EXISTS `bb`;
    3 CREATE TABLE `aa` (
    4 `pk` INT NOT NULL AUTO_INCREMENT,
    5 `col_char_1024` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,
    6 `col_int` INT DEFAULT NULL,
    7 `col_text_not_null` TEXT NOT NULL COLLATE utf8_general_ci,
    8 `col_bigint_key` BIGINT DEFAULT NULL,
    9 `col_int_not_null` INT NOT NULL,
   10 PRIMARY KEY (`pk`),
   11 KEY `col_bigint_key` (`col_bigint_key`)
   12 ) ENGINE='InnoDB' COLLATE='utf8_general_ci';
   13 INSERT INTO `aa` VALUES (1,'w',9,'',NULL,-1974206464),(2,'n',-1692139520,'',NULL,3),(3,'r',4,'',-2842897264777625600,-274595840),(4,'PUKQU',9,'',NULL,295501824),(5,'not',-1091567616,'',3557843705622691840,9),(6,'NZDDR',126156800,'',-4628011567076605952,2),(7,'have',534904832,'',-5755881798756204544,-1601306624),(8,'OGLVA',8,'',NULL,-1770323968),(9,'didn\'t',NULL,'',NULL,256311296),(10,'t',NULL,'',-5719290051783819264,4);
   14 CREATE TABLE `bb` (
   15 `col_char_10_not_null_key` VARCHAR(10) NOT NULL COLLATE utf8_general_ci,
   16 `col_bigint_key` BIGINT DEFAULT NULL,
   17 `pk` INT NOT NULL AUTO_INCREMENT,
   18 `col_text_key` TEXT COLLATE utf8_general_ci DEFAULT NULL,
   19 `col_int_not_null_key` INT NOT NULL,
   20 PRIMARY KEY (`pk`),
   21 KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
   22 KEY `col_bigint_key` (`col_bigint_key`),
   23 KEY `col_text_key` (`col_text_key`(255)),
   24 KEY `col_int_not_null_key` (`col_int_not_null_key`)
   25 ) ENGINE='InnoDB' COLLATE='utf8_general_ci';
   26 INSERT INTO `bb` VALUES ('DCJRX',NULL,1,'',1),('x',NULL,2,'',1),('ZMHDL',-647673921411219456,3,'',-1536425984),('SJGHS',-5702401553181179904,4,'',-1443495936),('his',NULL,5,'',2),('m',4,6,'',0),('i',NULL,7,'',8),('d',8,8,'',476315648),('from',NULL,9,'',5),('h',NULL,10,'',5);
   27 SELECT DISTINCT OUTR . `col_char_1024` AS X FROM AA AS OUTR WHERE ( OUTR . `col_bigint_key` , OUTR . `col_int` ) IN ( SELECT DISTINCT INNR . `col_int_not_null_key` AS X , INNR . `col_bigint_key` AS Y FROM BB AS INNR WHERE INNR . `col_text_key` <> INNR . `col_char_10_not_null_key` OR OUTR . `col_bigint_key` < 1  ) AND ( OUTR . `pk` > 2 XOR OUTR . `col_text_not_null` > 'f' )  ORDER BY OUTR . `col_int_not_null` , OUTR . `pk`;
   28 X
   29 DROP TABLE `aa`,`bb`;