diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-03-11 22:38:32 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-03-11 22:38:32 +0200 |
| commit | 431c76fe5592ead364542d8e6ae6ac20271c5a52 (patch) | |
| tree | fbfe4093d7a08c3533491443f9d5b179d928b17c /mysql-test | |
| parent | 31ea9df97e8163b5b785bef71ecadf9d8b37f802 (diff) | |
| parent | e5fdb09dd08b4af81b733631ab435bb1ca568761 (diff) | |
| download | mariadb-git-431c76fe5592ead364542d8e6ae6ac20271c5a52.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/mysql-3.23
into sanja.is.com.ua:/home/bell/mysql/work-rand-3.23
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 17 |
2 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 5ac5de05f97..dcb796b8e00 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -1793,3 +1793,4 @@ Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_par t2 0 PRIMARY 1 auto A 1199 NULL NULL t2 0 fld1 1 fld1 A 1199 NULL NULL t2 1 fld3 1 fld3 A NULL NULL NULL +1 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; |