[GitHub] [incubator-shardingsphere] zjcnb removed a comment on issue #4781: Add start-index and stop-index assertion for LiteralExpressionSegment

[GitBox <gi...@apache.org>]

zjcnb removed a comment on issue #4781: Add start-index and stop-index assertion for LiteralExpressionSegment
URL: https://github.com/apache/incubator-shardingsphere/issues/4781#issuecomment-604398511
 
 
   hi, i hava a question! 
   sql is :
   update t_order set status = 'update' where order_id = 1000 and user_id = 10
   
   xml is: 
   ` <update sql-case-id="update_without_parameters">
           <table name="t_order" start-index="7" stop-index="13" />
           <set start-index="15" stop-index="35">
               <assignment start-index="19" stop-index="35" literal-start-index="28">
                   <column name="status" start-index="19" stop-index="24" literal-stop-index="35"/>
                   <assignment-value>
                       <literal-expression value="update" />
                   </assignment-value>
               </assignment>
           </set>
           <where start-index="37" stop-index="74" literal-start-index="54" literal-stop-index="74">
               <and-predicate>
                   <predicate start-index="43" stop-index="57">
                       <column-left-value name="order_id" start-index="43" stop-index="50" literal-start-index="54" literal-stop-index="57"/>
                       <operator type="=" />
                       <compare-right-value>
                           <literal-expression value="1000" />
                       </compare-right-value>
                   </predicate>
                   <predicate start-index="63" stop-index="74">
                       <column-left-value name="user_id" start-index="63" stop-index="69" literal-start-index="73" literal-stop-index="74"/>
                       <operator type="=" />
                       <compare-right-value>
                           <literal-expression value="10" />
                       </compare-right-value>
                   </predicate>
               </and-predicate>
           </where>
       </update>`
   
   What's wrong? Can you correct that?

----------------------------------------------------------------
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


With regards,
Apache Git Services