# 11:58:30 Query: SELECT OUTR . `datetime_key` AS X FROM C AS OUTR WHERE OUTR . `varchar_nokey` IN ( SELECT INNR . `varchar_nokey` AS Y FROM CC AS INNR WHERE INNR . `int_nokey` <> 0 ORDER BY INNR . `int_key` ) AND OUTR . `varchar_key` < 'a' HAVING X = '2003-03-15 10:22:07' ORDER BY OUTR . `pk` , OUTR . `pk` failed: result length mismatch between servers (0 vs. 3) --- /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server0.dump 2009-05-31 11:58:30.000000000 -0400 +++ /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server1.dump 2009-05-31 11:58:30.000000000 -0400 @@ -0,0 +1,3 @@ +0000-00-00 00:00:00 +2001-01-13 00:00:00 +2008-09-11 00:00:00 # 11:58:32 Simplified query: SELECT `datetime_key` X FROM C WHERE `varchar_nokey` IN ( `varchar_nokey` ) AND `varchar_key` < 'a' HAVING X ORDER BY `pk` # 12:19:07 Query: SELECT OUTR . `int_key` AS X FROM C AS OUTR WHERE OUTR . `varchar_nokey` IN ( SELECT INNR . `varchar_key` AS Y FROM CC AS INNR WHERE INNR . `int_nokey` <> 4 ORDER BY INNR . `pk` ) AND OUTR . `varchar_key` < 'a' HAVING X = NULL ORDER BY OUTR . `pk` , OUTR . `pk` failed: result length mismatch between servers (0 vs. 3) --- /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server0.dump 2009-05-31 12:19:07.000000000 -0400 +++ /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server1.dump 2009-05-31 12:19:07.000000000 -0400 @@ -0,0 +1,3 @@ +0 +1 +2 # 12:19:09 Simplified query: SELECT `int_key` X FROM C WHERE `varchar_nokey` IN ( `varchar_key` ) AND `varchar_key` < 'a' HAVING X ORDER BY `pk` # 12:23:22 Query: SELECT OUTR . `pk` AS X FROM B AS OUTR WHERE OUTR . `int_key` IN ( SELECT DISTINCT INNR . `int_key` AS Y FROM CC AS INNR WHERE INNR . `int_nokey` <= 7 ) AND OUTR . `varchar_key` > 'd' HAVING X = '2008-05-07 17:20:21' ORDER BY OUTR . `pk` , OUTR . `pk` failed: result length mismatch between servers (0 vs. 2) --- /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server0.dump 2009-05-31 12:23:22.000000000 -0400 +++ /var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-///randgen1711-server1.dump 2009-05-31 12:23:22.000000000 -0400 @@ -0,0 +1,2 @@ +1 +2 # 12:23:23 Simplified query: SELECT `pk` X FROM B WHERE `int_key` AND `varchar_key` > 'd' HAVING X = '2008-05-07 17:20:21' ORDER BY `pk