You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/15 08:56:12 UTC
[GitHub] [shardingsphere] jingshanglu commented on a change in pull request #8604: Add ExpressionAssert for WhereClause, IdentifierValueAssert for ExpectedOwner and TableAssert for UpdateStatementAssert.
jingshanglu commented on a change in pull request #8604:
URL: https://github.com/apache/shardingsphere/pull/8604#discussion_r543144771
##########
File path: shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/sql/loader/SQLCasesLoader.java
##########
@@ -117,7 +117,7 @@ private String getLiteralSQL(final String sql, final List<?> parameters) {
if (null == parameters || parameters.isEmpty()) {
return sql;
}
- return String.format(sql.replace("%", "$").replace("?", "%s"), parameters.toArray()).replace("$", "%").replace("%%", "%").replace("'%'", "'%%'");
+ return String.format(sql.replace("%", "$$").replace("?", "%s"), parameters.toArray()).replace("$$", "%").replace("%%", "%").replace("'%'", "'%%'");
Review comment:
@lwtdev
What is the purpose of such a change?
##########
File path: shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/resources/case/dml/select-pagination-group-by-order-by.xml
##########
@@ -128,991 +166,1364 @@
</from>
<projections start-index="7" stop-index="15">
<column-projection name="user_id" start-index="7" stop-index="15">
- <owner name="i" start-index="7" stop-index="7" />
+ <owner name="i" start-index="7" stop-index="7"/>
</column-projection>
</projections>
<where start-index="105" stop-index="160" literal-stop-index="161">
- <and-predicate>
- <predicate start-index="111" stop-index="129">
- <column-left-value name="user_id" start-index="111" stop-index="119">
- <owner name="o" start-index="111" stop-index="111" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="0" start-index="125" stop-index="125" />
- <parameter-marker-expression value="1" start-index="128" stop-index="128" />
- <literal-expression value="1" start-index="125" stop-index="125" />
- <literal-expression value="2" start-index="128" stop-index="128" />
- </in-right-value>
- </predicate>
- <predicate start-index="135" stop-index="160" literal-stop-index="161">
- <column-left-value name="order_id" start-index="135" stop-index="144">
- <owner name="o" start-index="135" stop-index="135" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="2" start-index="154" stop-index="154" />
- <between-literal-expression value="9" start-index="154" stop-index="154" />
- <and-parameter-marker-expression value="3" start-index="160" stop-index="160" />
- <and-literal-expression value="10" start-index="160" stop-index="161" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="111" stop-index="160"
+ literal-stop-index="161">
+ <left>
+ <in-expression start-index="111" stop-index="129">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="111" stop-index="119">
+ <owner name="o" start-index="111" stop-index="111"/>
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="124" stop-index="129">
+ <items>
+ <literal-expression value="1" start-index="125"
+ stop-index="125"/>
+ <parameter-marker-expression value="0" start-index="125"
+ stop-index="125"/>
+ </items>
+ <items>
+ <literal-expression value="2" start-index="128"
+ stop-index="128"/>
+ <parameter-marker-expression value="1" start-index="128"
+ stop-index="128"/>
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="135" stop-index="160"
+ literal-stop-index="161">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="135" stop-index="144">
+ <owner name="o" start-index="135" stop-index="135"/>
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="154" stop-index="154"/>
+ <parameter-marker-expression value="2" start-index="154"
+ stop-index="154"/>
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="160" stop-index="161"/>
+ <parameter-marker-expression value="3" start-index="160"
+ stop-index="160"/>
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="user_id" start-index="171" stop-index="179" literal-start-index="172" literal-stop-index="180">
- <owner name="i" start-index="171" stop-index="171" literal-start-index="172" literal-stop-index="172" />
+ <column-item name="user_id" start-index="171" stop-index="179" literal-start-index="172"
+ literal-stop-index="180">
+ <owner name="i" start-index="171" stop-index="171" literal-start-index="172"
+ literal-stop-index="172"/>
</column-item>
</group-by>
<order-by>
- <column-item name="item_id" order-direction="DESC" start-index="190" stop-index="198" literal-start-index="191" literal-stop-index="199">
- <owner name="i" start-index="190" stop-index="190" literal-start-index="191" literal-stop-index="191" />
+ <column-item name="item_id" order-direction="DESC" start-index="190" stop-index="198"
+ literal-start-index="191" literal-stop-index="199">
+ <owner name="i" start-index="190" stop-index="190" literal-start-index="191"
+ literal-stop-index="191"/>
</column-item>
</order-by>
- <limit start-index="205" stop-index="214" literal-start-index="206" literal-stop-index="215">
- <offset value="5" parameter-index="4" start-index="211" stop-index="211" literal-start-index="212" literal-stop-index="212" />
- <row-count value="3" parameter-index="5" start-index="214" stop-index="214" literal-start-index="215" literal-stop-index="215" />
+ <limit start-index="205" stop-index="214" literal-start-index="206"
+ literal-stop-index="215">
+ <offset value="5" parameter-index="4" start-index="211" stop-index="211"
+ literal-start-index="212" literal-stop-index="212"/>
+ <row-count value="3" parameter-index="5" start-index="214" stop-index="214"
+ literal-start-index="215" literal-stop-index="215"/>
</limit>
</select>
- <select sql-case-id="select_pagination_with_top_and_group_by_and_order_by" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_and_group_by_and_order_by"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="158">
<top-projection alias="rownum_" start-index="22" stop-index="70">
- <top-value value="3" parameter-index="0" start-index="26" stop-index="26" />
+ <top-value value="3" parameter-index="0" start-index="26"
+ stop-index="26"/>
</top-projection>
<column-projection name="item_id" start-index="84" stop-index="92">
- <owner name="i" start-index="84" stop-index="84" />
+ <owner name="i" start-index="84" stop-index="84"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="95" stop-index="104">
- <owner name="o" start-index="95" stop-index="95" />
+ <column-projection name="order_id" alias="order_id" start-index="95"
+ stop-index="104">
+ <owner name="o" start-index="95" stop-index="95"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="119" stop-index="126">
- <owner name="o" start-index="119" stop-index="119" />
+ <column-projection name="status" alias="status" start-index="119"
+ stop-index="126">
+ <owner name="o" start-index="119" stop-index="119"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="139" stop-index="147">
- <owner name="o" start-index="139" stop-index="139" />
+ <column-projection name="user_id" alias="user_id" start-index="139"
+ stop-index="147">
+ <owner name="o" start-index="139" stop-index="139"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="165" stop-index="173" name="t_order" alias="o" />
+ <simple-table start-index="165" stop-index="173" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="180" stop-index="193" name="t_order_item" alias="i" />
+ <simple-table start-index="180" stop-index="193"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="198" stop-index="218">
- <column-left-value name="user_id" start-index="198" stop-index="206">
- <owner name="o" start-index="198" stop-index="198" />
+ <column-left-value name="user_id" start-index="198"
+ stop-index="206">
+ <owner name="o" start-index="198" stop-index="198"/>
</column-left-value>
- <column-right-value name="user_id" start-index="210" stop-index="218">
- <owner name="i" start-index="210" stop-index="210" />
+ <column-right-value name="user_id" start-index="210"
+ stop-index="218">
+ <owner name="i" start-index="210" stop-index="210"/>
</column-right-value>
</predicate>
<predicate start-index="224" stop-index="246">
- <column-left-value name="order_id" start-index="224" stop-index="233">
- <owner name="o" start-index="224" stop-index="224" />
+ <column-left-value name="order_id" start-index="224"
+ stop-index="233">
+ <owner name="o" start-index="224" stop-index="224"/>
</column-left-value>
- <column-right-value name="order_id" start-index="237" stop-index="246">
- <owner name="i" start-index="237" stop-index="237" />
+ <column-right-value name="order_id" start-index="237"
+ stop-index="246">
+ <owner name="i" start-index="237" stop-index="237"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="248" stop-index="303" literal-stop-index="304">
- <and-predicate>
- <predicate start-index="254" stop-index="272">
- <column-left-value name="user_id" start-index="254" stop-index="262">
- <owner name="o" start-index="254" stop-index="254" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="268" stop-index="268" />
- <parameter-marker-expression value="2" start-index="271" stop-index="271" />
- <literal-expression value="1" start-index="268" stop-index="268" />
- <literal-expression value="2" start-index="271" stop-index="271" />
- </in-right-value>
- </predicate>
- <predicate start-index="278" stop-index="303" literal-stop-index="304">
- <column-left-value name="order_id" start-index="278" stop-index="287">
- <owner name="o" start-index="278" stop-index="278" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="297" stop-index="297" />
- <and-parameter-marker-expression value="4" start-index="303" stop-index="303" />
- <between-literal-expression value="9" start-index="297" stop-index="297" />
- <and-literal-expression value="10" start-index="303" stop-index="304" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="254" stop-index="303" literal-stop-index="304">
+ <left>
+ <in-expression start-index="254" stop-index="272">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="254" stop-index="262">
+ <owner name="o" start-index="254" stop-index="254" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="267" stop-index="272">
+ <items>
+ <literal-expression value="1" start-index="268" stop-index="268" />
+ <parameter-marker-expression value="1" start-index="268" stop-index="268" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="271" stop-index="271" />
+ <parameter-marker-expression value="2" start-index="271" stop-index="271" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="278" stop-index="303" literal-stop-index="304">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="278" stop-index="287">
+ <owner name="o" start-index="278" stop-index="278" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="297" stop-index="297" />
+ <parameter-marker-expression value="3" start-index="297" stop-index="297" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="303" stop-index="304" />
+ <parameter-marker-expression value="4" start-index="303" stop-index="303" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="item_id" start-index="314" stop-index="322" literal-start-index="315" literal-stop-index="323">
- <owner name="i" start-index="314" stop-index="314" literal-start-index="315" literal-stop-index="315" />
+ <column-item name="item_id" start-index="314" stop-index="322"
+ literal-start-index="315" literal-stop-index="323">
+ <owner name="i" start-index="314" stop-index="314"
+ literal-start-index="315" literal-stop-index="315"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="333" stop-index="354" literal-start-index="334" literal-stop-index="355">
- <and-predicate>
- <predicate start-index="339" stop-index="354" literal-start-index="340" literal-stop-index="355">
- <column-left-value start-index="339" stop-index="350" literal-start-index="340" literal-stop-index="351" name="rownum_">
- <owner start-index="339" stop-index="342" literal-start-index="340" literal-stop-index="343" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="354" stop-index="354" value="5" />
- <literal-expression start-index="355" stop-index="355" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="339" stop-index="354" literal-start-index="340" literal-stop-index="355">
+ <left>
+ <column name="rownum_" start-index="339" stop-index="350" literal-start-index="340" literal-stop-index="351">
+ <owner name="row_" start-index="339" stop-index="342" literal-start-index="340" literal-stop-index="343" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="355" stop-index="355" />
+ <parameter-marker-expression value="5" start-index="354" stop-index="354" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_percent_with_ties_and_group_by_and_order_by" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_percent_with_ties_and_group_by_and_order_by"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="176">
<top-projection alias="rownum_" start-index="22" stop-index="88">
- <top-value value="3" parameter-index="0" start-index="26" stop-index="26" />
+ <top-value value="3" parameter-index="0" start-index="26"
+ stop-index="26"/>
</top-projection>
<column-projection name="item_id" start-index="102" stop-index="110">
- <owner name="i" start-index="102" stop-index="102" />
+ <owner name="i" start-index="102" stop-index="102"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="113" stop-index="122">
- <owner name="o" start-index="113" stop-index="113" />
+ <column-projection name="order_id" alias="order_id" start-index="113"
+ stop-index="122">
+ <owner name="o" start-index="113" stop-index="113"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="137" stop-index="144">
- <owner name="o" start-index="137" stop-index="137" />
+ <column-projection name="status" alias="status" start-index="137"
+ stop-index="144">
+ <owner name="o" start-index="137" stop-index="137"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="157" stop-index="165">
- <owner name="o" start-index="157" stop-index="157" />
+ <column-projection name="user_id" alias="user_id" start-index="157"
+ stop-index="165">
+ <owner name="o" start-index="157" stop-index="157"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="183" stop-index="191" name="t_order" alias="o" />
+ <simple-table start-index="183" stop-index="191" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="198" stop-index="211" name="t_order_item" alias="i" />
+ <simple-table start-index="198" stop-index="211"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="216" stop-index="236">
- <column-left-value name="user_id" start-index="216" stop-index="224">
- <owner name="o" start-index="216" stop-index="216" />
+ <column-left-value name="user_id" start-index="216"
+ stop-index="224">
+ <owner name="o" start-index="216" stop-index="216"/>
</column-left-value>
- <column-right-value name="user_id" start-index="228" stop-index="236">
- <owner name="i" start-index="228" stop-index="228" />
+ <column-right-value name="user_id" start-index="228"
+ stop-index="236">
+ <owner name="i" start-index="228" stop-index="228"/>
</column-right-value>
</predicate>
<predicate start-index="242" stop-index="264">
- <column-left-value name="order_id" start-index="242" stop-index="251">
- <owner name="o" start-index="242" stop-index="242" />
+ <column-left-value name="order_id" start-index="242"
+ stop-index="251">
+ <owner name="o" start-index="242" stop-index="242"/>
</column-left-value>
- <column-right-value name="order_id" start-index="255" stop-index="264">
- <owner name="i" start-index="255" stop-index="255" />
+ <column-right-value name="order_id" start-index="255"
+ stop-index="264">
+ <owner name="i" start-index="255" stop-index="255"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="266" stop-index="321" literal-stop-index="322">
- <and-predicate>
- <predicate start-index="272" stop-index="290">
- <column-left-value name="user_id" start-index="272" stop-index="280">
- <owner name="o" start-index="272" stop-index="272" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="286" stop-index="286" />
- <parameter-marker-expression value="2" start-index="289" stop-index="289" />
- <literal-expression value="1" start-index="286" stop-index="286" />
- <literal-expression value="2" start-index="289" stop-index="289" />
- </in-right-value>
- </predicate>
- <predicate start-index="296" stop-index="321" literal-stop-index="322">
- <column-left-value name="order_id" start-index="296" stop-index="305">
- <owner name="o" start-index="296" stop-index="296" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="315" stop-index="315" />
- <and-parameter-marker-expression value="4" start-index="321" stop-index="321" />
- <between-literal-expression value="9" start-index="315" stop-index="315" />
- <and-literal-expression value="10" start-index="321" stop-index="322" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="272" stop-index="321" literal-stop-index="322">
+ <left>
+ <in-expression start-index="272" stop-index="290">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="272" stop-index="280">
+ <owner name="o" start-index="272" stop-index="272" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="285" stop-index="290">
+ <items>
+ <literal-expression value="1" start-index="286" stop-index="286" />
+ <parameter-marker-expression value="1" start-index="286" stop-index="286" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="289" stop-index="289" />
+ <parameter-marker-expression value="2" start-index="289" stop-index="289" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="296" stop-index="321" literal-stop-index="322">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="296" stop-index="305">
+ <owner name="o" start-index="296" stop-index="296" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="315" stop-index="315" />
+ <parameter-marker-expression value="3" start-index="315" stop-index="315" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="321" stop-index="322" />
+ <parameter-marker-expression value="4" start-index="321" stop-index="321" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="item_id" start-index="332" stop-index="340" literal-start-index="333" literal-stop-index="341">
- <owner name="i" start-index="332" stop-index="332" literal-start-index="333" literal-stop-index="333" />
+ <column-item name="item_id" start-index="332" stop-index="340"
+ literal-start-index="333" literal-stop-index="341">
+ <owner name="i" start-index="332" stop-index="332"
+ literal-start-index="333" literal-stop-index="333"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="351" stop-index="372" literal-start-index="352" literal-stop-index="373">
- <and-predicate>
- <predicate start-index="357" stop-index="372" literal-start-index="358" literal-stop-index="373">
- <column-left-value start-index="357" stop-index="368" literal-start-index="358" literal-stop-index="369" name="rownum_">
- <owner start-index="357" stop-index="360" literal-start-index="358" literal-stop-index="361" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="372" stop-index="372" value="5" />
- <literal-expression start-index="373" stop-index="373" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="357" stop-index="372" literal-start-index="358" literal-stop-index="373">
+ <left>
+ <column name="rownum_" start-index="357" stop-index="368" literal-start-index="358" literal-stop-index="369">
+ <owner name="row_" start-index="357" stop-index="360" literal-start-index="358" literal-stop-index="361" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="373" stop-index="373" />
+ <parameter-marker-expression value="5" start-index="372" stop-index="372" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_and_group_by_and_order_by_and_parentheses" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_and_group_by_and_order_by_and_parentheses"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="160">
<top-projection alias="rownum_" start-index="22" stop-index="72">
- <top-value value="3" parameter-index="0" start-index="27" stop-index="27" />
+ <top-value value="3" parameter-index="0" start-index="27"
+ stop-index="27"/>
</top-projection>
<column-projection name="item_id" start-index="86" stop-index="94">
- <owner name="i" start-index="86" stop-index="86" />
+ <owner name="i" start-index="86" stop-index="86"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="97" stop-index="106">
- <owner name="o" start-index="97" stop-index="97" />
+ <column-projection name="order_id" alias="order_id" start-index="97"
+ stop-index="106">
+ <owner name="o" start-index="97" stop-index="97"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="121" stop-index="128">
- <owner name="o" start-index="121" stop-index="121" />
+ <column-projection name="status" alias="status" start-index="121"
+ stop-index="128">
+ <owner name="o" start-index="121" stop-index="121"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="141" stop-index="149">
- <owner name="o" start-index="141" stop-index="141" />
+ <column-projection name="user_id" alias="user_id" start-index="141"
+ stop-index="149">
+ <owner name="o" start-index="141" stop-index="141"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="167" stop-index="175" name="t_order" alias="o" />
+ <simple-table start-index="167" stop-index="175" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="182" stop-index="195" name="t_order_item" alias="i" />
+ <simple-table start-index="182" stop-index="195"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="200" stop-index="220">
- <column-left-value name="user_id" start-index="200" stop-index="208">
- <owner name="o" start-index="200" stop-index="200" />
+ <column-left-value name="user_id" start-index="200"
+ stop-index="208">
+ <owner name="o" start-index="200" stop-index="200"/>
</column-left-value>
- <column-right-value name="user_id" start-index="212" stop-index="220">
- <owner name="i" start-index="212" stop-index="212" />
+ <column-right-value name="user_id" start-index="212"
+ stop-index="220">
+ <owner name="i" start-index="212" stop-index="212"/>
</column-right-value>
</predicate>
<predicate start-index="226" stop-index="248">
- <column-left-value name="order_id" start-index="226" stop-index="235">
- <owner name="o" start-index="226" stop-index="226" />
+ <column-left-value name="order_id" start-index="226"
+ stop-index="235">
+ <owner name="o" start-index="226" stop-index="226"/>
</column-left-value>
- <column-right-value name="order_id" start-index="239" stop-index="248">
- <owner name="i" start-index="239" stop-index="239" />
+ <column-right-value name="order_id" start-index="239"
+ stop-index="248">
+ <owner name="i" start-index="239" stop-index="239"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="250" stop-index="305" literal-stop-index="306">
- <and-predicate>
- <predicate start-index="256" stop-index="274">
- <column-left-value name="user_id" start-index="256" stop-index="264">
- <owner name="o" start-index="256" stop-index="256" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="270" stop-index="270" />
- <parameter-marker-expression value="2" start-index="273" stop-index="273" />
- <literal-expression value="1" start-index="270" stop-index="270" />
- <literal-expression value="2" start-index="273" stop-index="273" />
- </in-right-value>
- </predicate>
- <predicate start-index="280" stop-index="305" literal-stop-index="306">
- <column-left-value name="order_id" start-index="280" stop-index="289">
- <owner name="o" start-index="280" stop-index="280" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="299" stop-index="299" />
- <and-parameter-marker-expression value="4" start-index="305" stop-index="305" />
- <between-literal-expression value="9" start-index="299" stop-index="299" />
- <and-literal-expression value="10" start-index="305" stop-index="306" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="256" stop-index="305" literal-stop-index="306">
+ <left>
+ <in-expression start-index="256" stop-index="274">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="256" stop-index="264">
+ <owner name="o" start-index="256" stop-index="256" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="269" stop-index="274">
+ <items>
+ <literal-expression value="1" start-index="270" stop-index="270" />
+ <parameter-marker-expression value="1" start-index="270" stop-index="270" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="273" stop-index="273" />
+ <parameter-marker-expression value="2" start-index="273" stop-index="273" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="280" stop-index="305" literal-stop-index="306">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="280" stop-index="289">
+ <owner name="o" start-index="280" stop-index="280" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="299" stop-index="299" />
+ <parameter-marker-expression value="3" start-index="299" stop-index="299" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="305" stop-index="306" />
+ <parameter-marker-expression value="4" start-index="305" stop-index="305" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="item_id" start-index="316" stop-index="324" literal-start-index="317" literal-stop-index="325">
- <owner name="i" start-index="316" stop-index="316" literal-start-index="317" literal-stop-index="317" />
+ <column-item name="item_id" start-index="316" stop-index="324"
+ literal-start-index="317" literal-stop-index="325">
+ <owner name="i" start-index="316" stop-index="316"
+ literal-start-index="317" literal-stop-index="317"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="335" stop-index="356" literal-start-index="336" literal-stop-index="357">
- <and-predicate>
- <predicate start-index="341" stop-index="356" literal-start-index="342" literal-stop-index="357">
- <column-left-value start-index="341" stop-index="352" literal-start-index="342" literal-stop-index="353" name="rownum_">
- <owner start-index="341" stop-index="344" literal-start-index="342" literal-stop-index="345" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="356" stop-index="356" value="5" />
- <literal-expression start-index="357" stop-index="357" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="341" stop-index="356" literal-start-index="342" literal-stop-index="357">
+ <left>
+ <column name="rownum_" start-index="341" stop-index="352" literal-start-index="342" literal-stop-index="353">
+ <owner name="row_" start-index="341" stop-index="344" literal-start-index="342" literal-stop-index="345" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="357" stop-index="357" />
+ <parameter-marker-expression value="5" start-index="356" stop-index="356" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_percent_with_ties_and_group_by_and_order_by_and_parentheses" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_percent_with_ties_and_group_by_and_order_by_and_parentheses"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="178">
<top-projection alias="rownum_" start-index="22" stop-index="90">
- <top-value value="3" parameter-index="0" start-index="27" stop-index="27" />
+ <top-value value="3" parameter-index="0" start-index="27"
+ stop-index="27"/>
</top-projection>
<column-projection name="item_id" start-index="104" stop-index="112">
- <owner name="i" start-index="104" stop-index="104" />
+ <owner name="i" start-index="104" stop-index="104"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="115" stop-index="124">
- <owner name="o" start-index="115" stop-index="115" />
+ <column-projection name="order_id" alias="order_id" start-index="115"
+ stop-index="124">
+ <owner name="o" start-index="115" stop-index="115"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="139" stop-index="146">
- <owner name="o" start-index="139" stop-index="139" />
+ <column-projection name="status" alias="status" start-index="139"
+ stop-index="146">
+ <owner name="o" start-index="139" stop-index="139"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="159" stop-index="167">
- <owner name="o" start-index="159" stop-index="159" />
+ <column-projection name="user_id" alias="user_id" start-index="159"
+ stop-index="167">
+ <owner name="o" start-index="159" stop-index="159"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="185" stop-index="193" name="t_order" alias="o" />
+ <simple-table start-index="185" stop-index="193" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="200" stop-index="213" name="t_order_item" alias="i" />
+ <simple-table start-index="200" stop-index="213"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="218" stop-index="238">
- <column-left-value name="user_id" start-index="218" stop-index="226">
- <owner name="o" start-index="218" stop-index="218" />
+ <column-left-value name="user_id" start-index="218"
+ stop-index="226">
+ <owner name="o" start-index="218" stop-index="218"/>
</column-left-value>
- <column-right-value name="user_id" start-index="230" stop-index="238">
- <owner name="i" start-index="230" stop-index="230" />
+ <column-right-value name="user_id" start-index="230"
+ stop-index="238">
+ <owner name="i" start-index="230" stop-index="230"/>
</column-right-value>
</predicate>
<predicate start-index="244" stop-index="266">
- <column-left-value name="order_id" start-index="244" stop-index="253">
- <owner name="o" start-index="244" stop-index="244" />
+ <column-left-value name="order_id" start-index="244"
+ stop-index="253">
+ <owner name="o" start-index="244" stop-index="244"/>
</column-left-value>
- <column-right-value name="order_id" start-index="257" stop-index="266">
- <owner name="i" start-index="257" stop-index="257" />
+ <column-right-value name="order_id" start-index="257"
+ stop-index="266">
+ <owner name="i" start-index="257" stop-index="257"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="268" stop-index="323" literal-stop-index="324">
- <and-predicate>
- <predicate start-index="274" stop-index="292">
- <column-left-value name="user_id" start-index="274" stop-index="282">
- <owner name="o" start-index="274" stop-index="274" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="288" stop-index="288" />
- <parameter-marker-expression value="2" start-index="291" stop-index="291" />
- <literal-expression value="1" start-index="288" stop-index="288" />
- <literal-expression value="2" start-index="291" stop-index="291" />
- </in-right-value>
- </predicate>
- <predicate start-index="298" stop-index="323" literal-stop-index="324">
- <column-left-value name="order_id" start-index="298" stop-index="307">
- <owner name="o" start-index="298" stop-index="298" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="317" stop-index="317" />
- <and-parameter-marker-expression value="4" start-index="323" stop-index="323" />
- <between-literal-expression value="9" start-index="317" stop-index="317" />
- <and-literal-expression value="10" start-index="323" stop-index="324" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="274" stop-index="323" literal-stop-index="324">
+ <left>
+ <in-expression start-index="274" stop-index="292">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="274" stop-index="282">
+ <owner name="o" start-index="274" stop-index="274" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="287" stop-index="292">
+ <items>
+ <literal-expression value="1" start-index="288" stop-index="288" />
+ <parameter-marker-expression value="1" start-index="288" stop-index="288" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="291" stop-index="291" />
+ <parameter-marker-expression value="2" start-index="291" stop-index="291" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="298" stop-index="323" literal-stop-index="324">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="298" stop-index="307">
+ <owner name="o" start-index="298" stop-index="298" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="317" stop-index="317" />
+ <parameter-marker-expression value="3" start-index="317" stop-index="317" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="323" stop-index="324" />
+ <parameter-marker-expression value="4" start-index="323" stop-index="323" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="item_id" start-index="334" stop-index="342" literal-start-index="335" literal-stop-index="343">
- <owner name="i" start-index="334" stop-index="334" literal-start-index="335" literal-stop-index="335" />
+ <column-item name="item_id" start-index="334" stop-index="342"
+ literal-start-index="335" literal-stop-index="343">
+ <owner name="i" start-index="334" stop-index="334"
+ literal-start-index="335" literal-stop-index="335"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="353" stop-index="374" literal-start-index="354" literal-stop-index="375">
- <and-predicate>
- <predicate start-index="359" stop-index="374" literal-start-index="360" literal-stop-index="375">
- <column-left-value start-index="359" stop-index="370" literal-start-index="360" literal-stop-index="371" name="rownum_">
- <owner start-index="359" stop-index="362" literal-start-index="360" literal-stop-index="363" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="374" stop-index="374" value="5" />
- <literal-expression start-index="375" stop-index="375" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="359" stop-index="374" literal-start-index="360" literal-stop-index="375">
+ <left>
+ <column name="rownum_" start-index="359" stop-index="370" literal-start-index="360" literal-stop-index="371">
+ <owner name="row_" start-index="359" stop-index="362" literal-start-index="360" literal-stop-index="363" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="375" stop-index="375" />
+ <parameter-marker-expression value="5" start-index="374" stop-index="374" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_and_diff_group_by_and_order_by" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_and_diff_group_by_and_order_by"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="158">
<top-projection alias="rownum_" start-index="22" stop-index="70">
- <top-value value="3" parameter-index="0" start-index="26" stop-index="26" />
+ <top-value value="3" parameter-index="0" start-index="26"
+ stop-index="26"/>
</top-projection>
<column-projection name="item_id" start-index="84" stop-index="92">
- <owner name="i" start-index="84" stop-index="84" />
+ <owner name="i" start-index="84" stop-index="84"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="95" stop-index="104">
- <owner name="o" start-index="95" stop-index="95" />
+ <column-projection name="order_id" alias="order_id" start-index="95"
+ stop-index="104">
+ <owner name="o" start-index="95" stop-index="95"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="119" stop-index="126">
- <owner name="o" start-index="119" stop-index="119" />
+ <column-projection name="status" alias="status" start-index="119"
+ stop-index="126">
+ <owner name="o" start-index="119" stop-index="119"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="139" stop-index="147">
- <owner name="o" start-index="139" stop-index="139" />
+ <column-projection name="user_id" alias="user_id" start-index="139"
+ stop-index="147">
+ <owner name="o" start-index="139" stop-index="139"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="165" stop-index="173" name="t_order" alias="o" />
+ <simple-table start-index="165" stop-index="173" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="180" stop-index="193" name="t_order_item" alias="i" />
+ <simple-table start-index="180" stop-index="193"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="198" stop-index="218">
- <column-left-value name="user_id" start-index="198" stop-index="206">
- <owner name="o" start-index="198" stop-index="198" />
+ <column-left-value name="user_id" start-index="198"
+ stop-index="206">
+ <owner name="o" start-index="198" stop-index="198"/>
</column-left-value>
- <column-right-value name="user_id" start-index="210" stop-index="218">
- <owner name="i" start-index="210" stop-index="210" />
+ <column-right-value name="user_id" start-index="210"
+ stop-index="218">
+ <owner name="i" start-index="210" stop-index="210"/>
</column-right-value>
</predicate>
<predicate start-index="224" stop-index="246">
- <column-left-value name="order_id" start-index="224" stop-index="233">
- <owner name="o" start-index="224" stop-index="224" />
+ <column-left-value name="order_id" start-index="224"
+ stop-index="233">
+ <owner name="o" start-index="224" stop-index="224"/>
</column-left-value>
- <column-right-value name="order_id" start-index="237" stop-index="246">
- <owner name="i" start-index="237" stop-index="237" />
+ <column-right-value name="order_id" start-index="237"
+ stop-index="246">
+ <owner name="i" start-index="237" stop-index="237"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="248" stop-index="303" literal-stop-index="304">
- <and-predicate>
- <predicate start-index="254" stop-index="272">
- <column-left-value name="user_id" start-index="254" stop-index="262">
- <owner name="o" start-index="254" stop-index="254" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="268" stop-index="268" />
- <parameter-marker-expression value="2" start-index="271" stop-index="271" />
- <literal-expression value="1" start-index="268" stop-index="268" />
- <literal-expression value="2" start-index="271" stop-index="271" />
- </in-right-value>
- </predicate>
- <predicate start-index="278" stop-index="303" literal-stop-index="304">
- <column-left-value name="order_id" start-index="278" stop-index="287">
- <owner name="o" start-index="278" stop-index="278" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="297" stop-index="297" />
- <and-parameter-marker-expression value="4" start-index="303" stop-index="303" />
- <between-literal-expression value="9" start-index="297" stop-index="297" />
- <and-literal-expression value="10" start-index="303" stop-index="304" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="254" stop-index="303" literal-stop-index="304">
+ <left>
+ <in-expression start-index="254" stop-index="272">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="254" stop-index="262">
+ <owner name="o" start-index="254" stop-index="254" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="267" stop-index="272">
+ <items>
+ <literal-expression value="1" start-index="268" stop-index="268" />
+ <parameter-marker-expression value="1" start-index="268" stop-index="268" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="271" stop-index="271" />
+ <parameter-marker-expression value="2" start-index="271" stop-index="271" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="278" stop-index="303" literal-stop-index="304">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="278" stop-index="287">
+ <owner name="o" start-index="278" stop-index="278" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="297" stop-index="297" />
+ <parameter-marker-expression value="3" start-index="297" stop-index="297" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="303" stop-index="304" />
+ <parameter-marker-expression value="4" start-index="303" stop-index="303" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="user_id" start-index="314" stop-index="322" literal-start-index="315" literal-stop-index="323">
- <owner name="i" start-index="314" stop-index="314" literal-start-index="315" literal-stop-index="315" />
+ <column-item name="user_id" start-index="314" stop-index="322"
+ literal-start-index="315" literal-stop-index="323">
+ <owner name="i" start-index="314" stop-index="314"
+ literal-start-index="315" literal-stop-index="315"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="333" stop-index="354" literal-start-index="334" literal-stop-index="355">
- <and-predicate>
- <predicate start-index="339" stop-index="354" literal-start-index="340" literal-stop-index="355">
- <column-left-value start-index="339" stop-index="350" literal-start-index="340" literal-stop-index="351" name="rownum_">
- <owner start-index="339" stop-index="342" literal-start-index="340" literal-stop-index="343" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="354" stop-index="354" value="5" />
- <literal-expression start-index="355" stop-index="355" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="339" stop-index="354" literal-start-index="340" literal-stop-index="355">
+ <left>
+ <column name="rownum_" start-index="339" stop-index="350" literal-start-index="340" literal-stop-index="351">
+ <owner name="row_" start-index="339" stop-index="342" literal-start-index="340" literal-stop-index="343" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="355" stop-index="355" />
+ <parameter-marker-expression value="5" start-index="354" stop-index="354" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_percent_with_ties_and_diff_group_by_and_order_by" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_percent_with_ties_and_diff_group_by_and_order_by"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="176">
<top-projection alias="rownum_" start-index="22" stop-index="88">
- <top-value value="3" parameter-index="0" start-index="26" stop-index="26" />
+ <top-value value="3" parameter-index="0" start-index="26"
+ stop-index="26"/>
</top-projection>
<column-projection name="item_id" start-index="102" stop-index="110">
- <owner name="i" start-index="102" stop-index="102" />
+ <owner name="i" start-index="102" stop-index="102"/>
</column-projection>
- <column-projection name="order_id" alias="order_id" start-index="113" stop-index="122">
- <owner name="o" start-index="113" stop-index="113" />
+ <column-projection name="order_id" alias="order_id" start-index="113"
+ stop-index="122">
+ <owner name="o" start-index="113" stop-index="113"/>
</column-projection>
- <column-projection name="status" alias="status" start-index="137" stop-index="144">
- <owner name="o" start-index="137" stop-index="137" />
+ <column-projection name="status" alias="status" start-index="137"
+ stop-index="144">
+ <owner name="o" start-index="137" stop-index="137"/>
</column-projection>
- <column-projection name="user_id" alias="user_id" start-index="157" stop-index="165">
- <owner name="o" start-index="157" stop-index="157" />
+ <column-projection name="user_id" alias="user_id" start-index="157"
+ stop-index="165">
+ <owner name="o" start-index="157" stop-index="157"/>
</column-projection>
</projections>
<from>
<join-table>
<left>
- <simple-table start-index="183" stop-index="191" name="t_order" alias="o" />
+ <simple-table start-index="183" stop-index="191" name="t_order"
+ alias="o"/>
</left>
<right>
- <simple-table start-index="198" stop-index="211" name="t_order_item" alias="i" />
+ <simple-table start-index="198" stop-index="211"
+ name="t_order_item" alias="i"/>
</right>
<joinSpecification>
<and-predicate>
<predicate start-index="216" stop-index="236">
- <column-left-value name="user_id" start-index="216" stop-index="224">
- <owner name="o" start-index="216" stop-index="216" />
+ <column-left-value name="user_id" start-index="216"
+ stop-index="224">
+ <owner name="o" start-index="216" stop-index="216"/>
</column-left-value>
- <column-right-value name="user_id" start-index="228" stop-index="236">
- <owner name="i" start-index="228" stop-index="228" />
+ <column-right-value name="user_id" start-index="228"
+ stop-index="236">
+ <owner name="i" start-index="228" stop-index="228"/>
</column-right-value>
</predicate>
<predicate start-index="242" stop-index="264">
- <column-left-value name="order_id" start-index="242" stop-index="251">
- <owner name="o" start-index="242" stop-index="242" />
+ <column-left-value name="order_id" start-index="242"
+ stop-index="251">
+ <owner name="o" start-index="242" stop-index="242"/>
</column-left-value>
- <column-right-value name="order_id" start-index="255" stop-index="264">
- <owner name="i" start-index="255" stop-index="255" />
+ <column-right-value name="order_id" start-index="255"
+ stop-index="264">
+ <owner name="i" start-index="255" stop-index="255"/>
</column-right-value>
</predicate>
</and-predicate>
</joinSpecification>
</join-table>
</from>
<where start-index="266" stop-index="321" literal-stop-index="322">
- <and-predicate>
- <predicate start-index="272" stop-index="290">
- <column-left-value name="user_id" start-index="272" stop-index="280">
- <owner name="o" start-index="272" stop-index="272" />
- </column-left-value>
- <in-right-value>
- <parameter-marker-expression value="1" start-index="286" stop-index="286" />
- <parameter-marker-expression value="2" start-index="289" stop-index="289" />
- <literal-expression value="1" start-index="286" stop-index="286" />
- <literal-expression value="2" start-index="289" stop-index="289" />
- </in-right-value>
- </predicate>
- <predicate start-index="296" stop-index="321" literal-stop-index="322">
- <column-left-value name="order_id" start-index="296" stop-index="305">
- <owner name="o" start-index="296" stop-index="296" />
- </column-left-value>
- <between-right-value>
- <between-parameter-marker-expression value="3" start-index="315" stop-index="315" />
- <and-parameter-marker-expression value="4" start-index="321" stop-index="321" />
- <between-literal-expression value="9" start-index="315" stop-index="315" />
- <and-literal-expression value="10" start-index="321" stop-index="322" />
- </between-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="272" stop-index="321" literal-stop-index="322">
+ <left>
+ <in-expression start-index="272" stop-index="290">
+ <not>false</not>
+ <left>
+ <column name="user_id" start-index="272" stop-index="280">
+ <owner name="o" start-index="272" stop-index="272" />
+ </column>
+ </left>
+ <right>
+ <list-expression start-index="285" stop-index="290">
+ <items>
+ <literal-expression value="1" start-index="286" stop-index="286" />
+ <parameter-marker-expression value="1" start-index="286" stop-index="286" />
+ </items>
+ <items>
+ <literal-expression value="2" start-index="289" stop-index="289" />
+ <parameter-marker-expression value="2" start-index="289" stop-index="289" />
+ </items>
+ </list-expression>
+ </right>
+ </in-expression>
+ </left>
+ <operator>AND</operator>
+ <right>
+ <between-expression start-index="296" stop-index="321" literal-stop-index="322">
+ <not>false</not>
+ <left>
+ <column name="order_id" start-index="296" stop-index="305">
+ <owner name="o" start-index="296" stop-index="296" />
+ </column>
+ </left>
+ <between-expr>
+ <literal-expression value="9" start-index="315" stop-index="315" />
+ <parameter-marker-expression value="3" start-index="315" stop-index="315" />
+ </between-expr>
+ <and-expr>
+ <literal-expression value="10" start-index="321" stop-index="322" />
+ <parameter-marker-expression value="4" start-index="321" stop-index="321" />
+ </and-expr>
+ </between-expression>
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
<group-by>
- <column-item name="user_id" start-index="332" stop-index="340" literal-start-index="333" literal-stop-index="341">
- <owner name="i" start-index="332" stop-index="332" literal-start-index="333" literal-stop-index="333" />
+ <column-item name="user_id" start-index="332" stop-index="340"
+ literal-start-index="333" literal-stop-index="341">
+ <owner name="i" start-index="332" stop-index="332"
+ literal-start-index="333" literal-stop-index="333"/>
</column-item>
</group-by>
</select>
</subquery>
</subquery-table>
</from>
<where start-index="351" stop-index="372" literal-start-index="352" literal-stop-index="373">
- <and-predicate>
- <predicate start-index="357" stop-index="372" literal-start-index="358" literal-stop-index="373">
- <column-left-value start-index="357" stop-index="368" literal-start-index="358" literal-stop-index="369" name="rownum_">
- <owner start-index="357" stop-index="360" literal-start-index="358" literal-stop-index="361" name="row_" />
- </column-left-value>
- <operator type=">" />
- <compare-right-value>
- <parameter-marker-expression start-index="372" stop-index="372" value="5" />
- <literal-expression start-index="373" stop-index="373" value="6" />
- </compare-right-value>
- </predicate>
- </and-predicate>
+ <expr>
+ <binary-operation-expression start-index="357" stop-index="372" literal-start-index="358" literal-stop-index="373">
+ <left>
+ <column name="rownum_" start-index="357" stop-index="368" literal-start-index="358" literal-stop-index="369">
+ <owner name="row_" start-index="357" stop-index="360" literal-start-index="358" literal-stop-index="361" />
+ </column>
+ </left>
+ <operator>></operator>
+ <right>
+ <literal-expression value="6" start-index="373" stop-index="373" />
+ <parameter-marker-expression value="5" start-index="372" stop-index="372" />
+ </right>
+ </binary-operation-expression>
+ </expr>
</where>
</select>
- <select sql-case-id="select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses" parameters="3, 1, 2, 9, 10, 6">
+ <select sql-case-id="select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses"
+ parameters="3, 1, 2, 9, 10, 6">
<projections start-index="7" stop-index="7">
- <shorthand-projection start-index="7" stop-index="7" />
+ <shorthand-projection start-index="7" stop-index="7"/>
</projections>
<from>
<subquery-table alias="row_">
<subquery>
<select>
<projections start-index="22" stop-index="160">
<top-projection alias="rownum_" start-index="22" stop-index="72">
- <top-value value="3" parameter-index="0" start-index="27" stop-index="27" />
+ <top-value value="3" parameter-index="0" start-index="27"
+ stop-index="27"/>
Review comment:
@lwtdev Like this, is it better to merge them into one line?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org