Comment 2 for bug 628912

CONFIRMED.

// RUN AS TEST CASE

./test-run --suite=broken 628912.test
Logging: ./test-run --suite=broken 628912.test
Drizzle Version 2010.09.1746
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
================================================================================
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
--------------------------------------------------------------------------------

broken.628912 [ fail ]
drizzletest: The specified result file does not exist: '/home/tdavies/hacking/dizzle/drizzle_latest/tests/suite/broken/r/628912.result'

The result from queries just before the failure was:
< snip >
`col_int_not_null` int NOT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `aa` VALUES (1,-1974206464),(2,3),(3,-274595840),(4,295501824),(5,9),(6,2),(7,-1601306624),(8,-1770323968),(9,256311296),(10,4);
CREATE TABLE `bb` (
`pk` int NOT NULL DEFAULT '0',
`col_char_1024_not_null` varchar(1024) NOT NULL,
`col_text` text,
`col_char_10_not_null_key` varchar(10) NOT NULL,
`col_char_1024_not_null_key` varchar(1024) NOT NULL,
`col_int_not_null_key` int NOT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;
INSERT INTO `bb` VALUES (1,'o',NULL,'DCJRX','IHTVZ',1),(2,'a',NULL,'x','a',1),(3,'have',NULL,'ZMHDL','s',-1536425984),(4,'u',NULL,'SJGHS','d',-1443495936),(5,'o',NULL,'his','TTNNK',2),(6,'r',NULL,'m','GKTRR',0),(7,'on',NULL,'i','ZZDWO',8),(8,'IMULJ',NULL,'d','up',476315648),(9,'DXSXG',NULL,'from','would',5),(10,'y',NULL,'h','JNAFV',5);
CREATE TABLE `cc` (
`pk` int NOT NULL DEFAULT '0',
`col_char_10_key` varchar(10) DEFAULT NULL,
`col_bigint_key` bigint DEFAULT NULL,
`col_char_1024_not_null_key` varchar(1024) NOT NULL,
`col_int_key` int DEFAULT NULL,
`col_char_10` varchar(10) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci;

More results from queries before failure can be found in /home/tdavies/hacking/dizzle/drizzle_latest/tests/var/log/628912.log

Aborting: broken.628912 failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers

// RUN IN CLIENT:
// LAST COMMAND GIVEN...

drizzle> SELECT SQL_SMALL_RESULT table1 . `col_bigint_key` AS field1
    -> FROM ( CC AS table1 RIGHT JOIN ( ( BB AS table2 LEFT JOIN BB AS table3
    -> ON (table3 . `col_char_10_not_null_key` = table2 . `col_char_1024_not_null` ) ) )
    -> ON (table3 . `col_char_10_not_null_key` = table2 . `col_text` ) )
    -> WHERE
    -> ( EXISTS ( ( SELECT SUBQUERY1_t1 . `col_char_10` AS SUBQUERY1_field1
    -> FROM ( CC AS SUBQUERY1_t1 STRAIGHT_JOIN AA AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `col_int_not_null` = SUBQUERY1_t1 . `pk` ) ) ) ) )
    -> AND ( table1 . `col_char_1024_not_null_key` = 'o' AND table1 . `col_char_1024_not_null_key` = table3 . `col_char_10_not_null_key` )
    -> AND ( table1 . `col_int_key` != table3 . `col_int_not_null_key`
    -> AND table3 . `col_char_1024_not_null_key` > 'h' )
    -> ORDER BY table1 . `col_char_10_key` , table2 .`pk` DESC , field1 , table1 . `col_bigint_key` DESC, field1 LIMIT 1 OFFSET 3;
ERROR:
drizzle_state_read:lost connection to server (EOF)
No connection. Trying to reconnect...
ERROR:
drizzle_state_connect:could not connect
ERROR:
Can't connect to the server

drizzle> show tables;
No connection. Trying to reconnect...
ERROR:
drizzle_state_connect:could not connect
ERROR:
Can't connect to the server