| --! qt:dataset:src1 |
| --! qt:dataset:src |
| -- SORT_QUERY_RESULTS |
| |
| EXPLAIN |
| SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) |
| SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; |
| |
| SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) |
| SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; |
| |
| |
| EXPLAIN |
| SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) |
| SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; |
| |
| SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) |
| SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; |