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 | |
| 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')
| -rw-r--r-- | mysql-test/r/order_by.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/order_by.test | 2 |
2 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index ee3d49ed3e0..64653de5e9c 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -862,13 +862,13 @@ ORDER BY c; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using temporary; Using filesort 1 SIMPLE t2 const PRIMARY PRIMARY 4 const 1 -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; -a c -1 NULL -3 NULL -2 2 +c +NULL +NULL +2 explain SELECT t1.b as a, t2.b as c FROM t1 JOIN t1 t2 ON (t1.a = t2.a AND t2.a = 2) ORDER BY c; 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; |