[GitHub] [incubator-shardingsphere] succeo commented on issue #4016: SQL syntax error, expected token is 'EQ', actual token is 'IDENTIFIER', literals is 'contractsm0_'

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

succeo commented on issue #4016: SQL syntax error, expected token is 'EQ', actual token is 'IDENTIFIER', literals is 'contractsm0_'
URL: https://github.com/apache/incubator-shardingsphere/issues/4016#issuecomment-575964713
 
 
   ```select taker.createdAt as takerCreatedAt,
          taker.userId,
          maker.price as makerPrice,
          maker.quantity as makerQuantity,
          maker.fee + taker.fee as sysFee
   from t_order taker left join t_order maker
                      on taker.orderId = maker.counterOrderId
                       and taker.counterOrderId = maker.orderId
   where
   
         taker.type = 'TAKER'
         and taker.createdAt between 1579104000000 and 1579251131120
         and maker.createdAt between 1579104000000 and 1579251131120
   order by taker.orderId asc,taker.counterOrderId asc limit 1000;```

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