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 | b0a3c1c905039d68aa54de2bd0b571a032fe373b (patch) | |
| tree | fbfe4093d7a08c3533491443f9d5b179d928b17c /mysql-test | |
| parent | 8218d49dce232d645bec1f68f87a0e96307e0593 (diff) | |
| parent | 8162aec6b9155d0e97d58a0b9c43716ce7adb320 (diff) | |
| download | mariadb-git-b0a3c1c905039d68aa54de2bd0b571a032fe373b.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; |