diff options
| author | unknown <igor@olga.mysql.com> | 2007-04-03 22:24:57 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-04-03 22:24:57 -0700 |
| commit | 201a343a7106d73dc35b825764af15a50e0b879d (patch) | |
| tree | 2fce445cd79ac12743f1ee44b8611e6594450116 /mysql-test/t/order_by.test | |
| parent | da037917b22ad522062ddcb15f96bc6249084fd3 (diff) | |
| parent | e488e6f23a14490b619d5bbbf2fc4db65dc4b9ef (diff) | |
| download | mariadb-git-201a343a7106d73dc35b825764af15a50e0b879d.tar.gz | |
Merge olga.mysql.com:/home/igor/mysql-4.1-opt
into olga.mysql.com:/home/igor/mysql-5.0-opt
mysql-test/r/order_by.result:
Manual merge
mysql-test/t/order_by.test:
Manual merge
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 6ad62ee8127..3e8fa07dfb7 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -658,6 +658,12 @@ SELECT IF(a IN (1,2), a, '') as x1, IF(a NOT IN (1,2), a, '') as x2 SELECT IF(a IN (1,2), a, '') as x1, IF(a NOT IN (1,2), a, '') as x2 FROM t1 GROUP BY x1, IF(a NOT IN (1,2), a, ''); +# The remaining queries are for better coverage +SELECT a, a IN (1,2) FROM t1 ORDER BY a IN (1,2); +SELECT a FROM t1 ORDER BY a IN (1,2); +SELECT a+10 FROM t1 ORDER BY a IN (1,2); +SELECT a, IF(a IN (1,2), a, a+10) FROM t1 + ORDER BY IF(a IN (3,4), a, a+10); DROP TABLE t1; # End of 4.1 |