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/t/select.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/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 17 |
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; |