fixed bug of unchecked random part of WHERE clause (bug #142)

mysql-test/r/select.result:
  test of random WHERE clause
mysql-test/t/select.test:
  test of random WHERE clause
sql/sql_select.cc:
  fixed bug of unchecked random part of WHERE clause

1 files changed, 16 insertions, 1 deletions

diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test
index cdb6ee57e0f..2caadd99dbb 100644
--- a/mysql-test/t/select.test
+++ b/mysql-test/t/select.test
@@ -1713,7 +1713,22 @@ show full columns from t2 from test like 's%';
 show keys from t2;
 
 #
+# random in WHERE clause
+#
+
+drop table t1;
+CREATE TABLE t1 (
+  id mediumint(8) unsigned NOT NULL auto_increment,
+  pseudo varchar(35) NOT NULL default '',
+  PRIMARY KEY  (id),
+  UNIQUE KEY pseudo (pseudo)
+);
+INSERT INTO t1 (pseudo) VALUES ('test');
+INSERT INTO t1 (pseudo) VALUES ('test1');
+SELECT 1 from t1 where rand() > 2;
+
+#
 # Drop the test tables
 #
 
-drop table t4, t3,t2, t1;
+drop table t4, t3, t2, t1;