[GitHub] zhengwangColder opened a new issue #1886: Left Join不支持<符号 SQL syntax error, expected token is 'EQ', actual token is 'LT', literals is '<'.

[GitBox]

zhengwangColder opened a new issue #1886: Left Join不支持<符号 SQL syntax error, 
expected token is 'EQ', actual token is 'LT', literals is '<'.
URL: https://github.com/apache/incubator-shardingsphere/issues/1886
 
 
   SQL如下
   SELECT m1.* FROM phone_tag m1
           LEFT JOIN phone_tag m2 ON m1.telephone = m2.telephone AND 
m1.updatetime &lt; m2.updatetime
           WHERE m1.telephone in
           (
           <foreach item="item" collection="telephones" index="index" 
separator=",">
               #{item}
           </foreach>
           ) AND m2.id is NULL AND m1.isactive = 1;

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services