Comment 1 for bug 588408

I made an attempt to port the patch over. Also the tests (also attached).

However... not sure if this is anything:

--- /home/stewart/drizzle/working/tests/r/bug588408.result 2010-06-02 06:50:31.242011816 +0300
+++ /home/stewart/drizzle/working/tests/r/bug588408.reject 2010-06-02 06:59:48.430702393 +0300
@@ -118,7 +118,7 @@
 id select_type table type possible_keys key key_len ref rows Extra
 1 PRIMARY <derived2> system NULL NULL NULL NULL 0 const row not found
 3 SUBQUERY t2 ALL NULL NULL NULL NULL 2
-2 DERIVED NULL NULL NULL NULL NULL NULL NULL no matching row in const table
+2 DERIVED empty1 ALL NULL NULL NULL NULL 1

 #
 # 5) Test that subquery materialization is setup for query with
@@ -142,8 +142,9 @@
 SELECT v
 FROM t2);
 id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
+1 PRIMARY t1 index NULL PRIMARY 4 NULL 2 Using where; Using index
 3 SUBQUERY t2 ALL NULL NULL NULL NULL 2
+2 SUBQUERY t3 index PRIMARY PRIMARY 4 NULL 1 Using where; Using index
 #
 # Cleanup for BUG#46680
 #