diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-08-15 15:48:49 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-08-15 15:48:49 +0300 |
| commit | 2f5ae7c536ae37a408f1e391ef21c743bd9b1b0e (patch) | |
| tree | 0c1e2cad9865042459bb5292f6f571ba22e6329f /mysql-test/t/order_by.test | |
| parent | 57745f96ce8b9c096b058e5241aa5e5b11c123c3 (diff) | |
| download | mariadb-git-2f5ae7c536ae37a408f1e391ef21c743bd9b1b0e.tar.gz | |
Bug #21302: Result not properly sorted when using an ORDER BY on a second table in a join
- undeterminstic tests fixed
mysql-test/r/order_by.result:
Bug #21302: Result not properly sorted when using an ORDER BY on a second table in a join
- more undeterminstic tests fixed
mysql-test/t/order_by.test:
Bug #21302: Result not properly sorted when using an ORDER BY on a second table in a join
- more undeterminstic tests fixed
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index f4498befa7e..1104c859ab8 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -589,7 +589,7 @@ INSERT INTO t1 VALUES (1,1), (2,2), (3,3); explain SELECT t1.b as a, t2.b as c FROM t1 LEFT JOIN t1 t2 ON (t1.a = t2.a AND t2.a = 2) ORDER BY c; -SELECT t1.b as a, t2.b as c FROM +SELECT t2.b as c FROM t1 LEFT JOIN t1 t2 ON (t1.a = t2.a AND t2.a = 2) ORDER BY c; |