Merge lp:~mmcm/akiban-server/sql-in-subquery-wo-project into lp:~akiban-technologies/akiban-server/trunk
Proposed by
Mike McMahon
Status: | Merged |
---|---|
Approved by: | Nathan Williams |
Approved revision: | 2732 |
Merged at revision: | 2732 |
Proposed branch: | lp:~mmcm/akiban-server/sql-in-subquery-wo-project |
Merge into: | lp:~akiban-technologies/akiban-server/trunk |
Diff against target: |
57 lines (+26/-0) 4 files modified
src/main/java/com/akiban/sql/optimizer/rule/ASTStatementLoader.java (+13/-0) src/test/resources/com/akiban/sql/optimizer/rule/parse/README.txt (+2/-0) src/test/resources/com/akiban/sql/optimizer/rule/parse/in-5.expected (+9/-0) src/test/resources/com/akiban/sql/optimizer/rule/parse/in-5.sql (+2/-0) |
To merge this branch: | bzr merge lp:~mmcm/akiban-server/sql-in-subquery-wo-project |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Nathan Williams | Approve | ||
Review via email: mp+179053@code.launchpad.net |
Description of the change
Handle subquery predicates with VALUES.
IN (1,2) is a special kind of node.
IN (SELECT x FROM ...) has a Project which is used to extract the comparison operand for the semi-join.
IN (VALUES 1,2) is somewhere in between. The Project isn't there, but enough information is to form the identical plan to the first case. Add that.
See new test and note that the expected result is identical to in-l3.
To post a comment you must log in.
Simple enough.