Range test fails randomly

[Lee Bieber]

We are getting random failures with the range test, sometimes with the valgrind run, somes on regular test runs.

See http://hudson.drizzle.org/job/Drizzle-valgrind-build/79/console for an example

main.range [ fail ] ==21353== Memcheck, a memory error detector.
==21353== Copyright (C) 2002-2008, and GNU GPL'd, by Julian Seward et al.
==21353== Using LibVEX rev 1884, a library for dynamic binary translation.
==21353== Copyright (C) 2004-2008, and GNU GPL'd, by OpenWorks LLP.
==21353== Using valgrind-3.4.1-Debian, a dynamic binary instrumentation framework.
==21353== Copyright (C) 2000-2008, and GNU GPL'd, by Julian Seward et al.
==21353== For more details, rerun with: -v
==21353==
--- /home/drizzle/hudson/workspace/Drizzle-valgrind-build/tests/r/range.result 2009-11-09 21:30:00.019458283 +0300
+++ /home/drizzle/hudson/workspace/Drizzle-valgrind-build/tests/r/range.reject 2009-11-27 22:58:48.369458418 +0300
@@ -418,20 +418,20 @@
 test.t2 analyze status OK
 explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0;
 id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range uid_index uid_index 4 NULL # Using where
-1 SIMPLE t2 ref uid_index uid_index 4 test.t1.uid #
+1 SIMPLE t2 range uid_index uid_index 4 NULL # Using where
+1 SIMPLE t1 ref uid_index uid_index 4 test.t2.uid #
 explain select * from t1, t2 where t1.uid=t2.uid AND t2.uid > 0;
 id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range uid_index uid_index 4 NULL # Using where
-1 SIMPLE t2 ref uid_index uid_index 4 test.t1.uid #
+1 SIMPLE t2 range uid_index uid_index 4 NULL # Using where
+1 SIMPLE t1 ref uid_index uid_index 4 test.t2.uid #
 explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0;
 id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range uid_index uid_index 4 NULL # Using where
-1 SIMPLE t2 ref uid_index uid_index 4 test.t1.uid #
+1 SIMPLE t2 range uid_index uid_index 4 NULL # Using where
+1 SIMPLE t1 ref uid_index uid_index 4 test.t2.uid #
 explain select * from t1, t2 where t1.uid=t2.uid AND t2.uid != 0;
 id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range uid_index uid_index 4 NULL # Using where
-1 SIMPLE t2 ref uid_index uid_index 4 test.t1.uid #
+1 SIMPLE t2 range uid_index uid_index 4 NULL # Using where
+1 SIMPLE t1 ref uid_index uid_index 4 test.t2.uid #
 select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0;
 id name uid id name uid
 1001 A 1 1001 A 1

drizzletest: Result content mismatch