SQL syntax error, expected token is 'EQ', actual token is 'IDENTIFIER', literals is 'contractsm0_'

[ghost]

No description provided.

[ghost]

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;

[ghost]

执行时会出现标题显示的问题，希望能帮忙处理一下

[terrymanu]

执行时会出现标题显示的问题，希望能帮忙处理一下

Hi, for English only

[terrymanu]

What is your version?

[ghost]

sharding- jdbc version 3.0.0

[kimmking]

sharding- jdbc version 3.0.0

can you try it with sharding-jdbc 4.0.0 ?

[SteNicholas]

@succeo Could you please the latest version of sharding-jdbc? Your version is too old to hardly validate the problem you mentioned.

[ghost]

The problem is solved，thank you