You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/01/19 03:53:19 UTC
[GitHub] [incubator-shardingsphere] succeo opened a new issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
succeo opened a new 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
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] succeo commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by 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-575994499
The problem is solved，thank you
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
terrymanu 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-575965461
What is your version?
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
terrymanu 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-575965456
> 执行时会出现标题显示的问题，希望能帮忙处理一下
Hi, for English only
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] succeo commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by 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-575964791
执行时会出现标题显示的问题，希望能帮忙处理一下
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] succeo edited a comment on issue #4016:
SQL syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] succeo commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by 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-575970471
sharding- jdbc version 3.0.0
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
kimmking 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-575971044
> sharding- jdbc version 3.0.0
can you try it with sharding-jdbc 4.0.0 ?
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] succeo closed issue #4016: SQL syntax
error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
succeo closed 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
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] succeo commented on issue #4016: SQL
syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by 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
[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #4016:
SQL syntax error, expected token is 'EQ', actual token is 'IDENTIFIER',
literals is 'contractsm0_'
Posted by GitBox <gi...@apache.org>.
SteNicholas 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-575981938
@succeo Could you please the latest version of sharding-jdbc? Your version is too old to hardly validate the problem you mentioned.
----------------------------------------------------------------
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