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 2021/09/11 10:15:52 UTC
[GitHub] [shardingsphere] 448700174 opened a new issue #12370: Is last_value a reserved words
448700174 opened a new issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370
SELECT COUNT(distinct elder_id)
FROM elder_change
WHERE category IN ( 0, 1 ) and tenant_id = ?
AND last_value not in ( ? , ? , ? , ? , ? , ? , ? , ? )
AND current_value in ( ? , ? , ? , ? , ? , ? , ? , ? )
This simple SQL can not parse.The error message is:You have an error in your SQL syntax
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] 448700174 commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
448700174 commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917791088
It's 5.0.0-beta
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917592123
Hi @448700174 Thanks for your feedback. I am curious which release you tested? I suppose 5.0.0-beta supports it.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-918664474
Welcome @ThanoshanMV, i will assign this issue to 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-920527520
@ThanoshanMV Hey, Glad to see you after GSoC. ;-)
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-918745713
> Hi @RaigorJiang, I'll try to fix it.
Thank you @ThanoshanMV .
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] 448700174 edited a comment on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
448700174 edited a comment on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917381631
When I change the last_value to my_last_value it parse success.
So I changed it as `last_value` then It works.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ThanoshanMV commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
ThanoshanMV commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-918499924
Hi @RaigorJiang, I'll try to fix it.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917382915
MySQL has a function called `last_value`, which may conflict in parsing.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917792789
> Hi @448700174 Thanks for your feedback. I am curious which release you tested? I suppose 5.0.0-beta supports it.
I tested with the parser of the mstaer branch, but it still doesn’t support.
> SELECT COUNT(distinct elder_id)
> FROM elder_change
> WHERE category IN ( 0, 1 ) and tenant_id = ?
> AND last_value not in ( ? , ? , ? , ? , ? , ? , ? , ? )
> AND current_value in ( ? , ? , ? , ? , ? , ? , ? , ? )
>
> This simple SQL can not parse.The error message is:You have an error in your SQL syntax
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] 448700174 commented on issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
448700174 commented on issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370#issuecomment-917381631
When I change the last_value to my_last_value it parse success.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #12370: Is last_value a reserved words
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #12370:
URL: https://github.com/apache/shardingsphere/issues/12370
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org