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/12/24 09:58:14 UTC

[GitHub] [shardingsphere] HoltYin opened a new issue #8754: sql can't parse ":="

HoltYin opened a new issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754


   **version:**
   5.0.0-alpha
   **project:**
   shardingsphere-jdbc-core-spring-boot-starter
   **sql:**
   INSERT INTO test ( id, test, count )
   VALUES
   	( 13, 1, 2 ) 
   	ON DUPLICATE KEY UPDATE 
   	id =
   IF
   	( @update_condition := ( count < VALUES ( count ) ), VALUES ( id ), id ),
   	test =
   IF
   	( @update_condition, VALUES ( test ), test ),
   	count =
   IF
   	( @update_condition, VALUES ( count ), count )
   
   **exception:**
   line 1:106 no viable alternative at input 'IF(@update_condition:'
   ![image](https://user-images.githubusercontent.com/25241944/103080281-79b10f00-4610-11eb-86b5-736ea4d5f5ac.png)
   **Reason analyze:**
   maybe can't parse ":=",i try it without":" like  @update_condition = ( count < VALUES ( count ) ),it worked
   


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

[GitHub] [shardingsphere] tristaZero edited a comment on issue #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754#issuecomment-751634776


   @HoltYin Thanks for the feedback.
   @jingshanglu Is there any progress?


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

[GitHub] [shardingsphere] jingshanglu commented on issue #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754#issuecomment-750866868


   @HoltYin It is a bug, i'll check 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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754#issuecomment-927689039


   This sql has been supported in the master branch, you can try it. 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.

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 #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754


   


-- 
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 #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754#issuecomment-751634776


   @HoltYin Thanks for the feedback.
   @jingshanglu Is they any progress?


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

[GitHub] [shardingsphere] tuichenchuxin commented on issue #8754: sql can't parse ":="

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #8754:
URL: https://github.com/apache/shardingsphere/issues/8754#issuecomment-927684057


   I found this sql already supported on branch master.


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