succeo edited a comment 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: us...@infra.apache.org With regards, Apache Git Services