[GitHub] zhengwangColder opened a new issue #1890: Left Join not support < sign. Detail Exception: SQL syntax error, expected token is 'EQ', actual token is 'LT', literals is '<'

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

zhengwangColder opened a new issue #1890: Left Join not support < sign. Detail Exception: SQL syntax error, expected token is 'EQ', actual token is 'LT', literals is '<'
URL: https://github.com/apache/incubator-shardingsphere/issues/1890
 
 
   Deatil SQL follow:
   SELECT m1.* FROM phone_tag m1
   LEFT JOIN phone_tag m2 ON m1.telephone = m2.telephone AND m1.updatetime < m2.updatetime
   WHERE m1.telephone in
   (
   
   #{item}
   
   ) 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:
users@infra.apache.org


With regards,
Apache Git Services