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/07/07 07:18:44 UTC

[GitHub] [shardingsphere] ChuckPerry opened a new issue #6289: insert into select is unsupport

ChuckPerry opened a new issue #6289:
URL: https://github.com/apache/shardingsphere/issues/6289


   ## Bug Report
   
   ### versions:
   shardingproxy version: 4.1.1
   mysql: 5.7.21
   
   ### replay example:
   `mysql>  create table test_t1(id int primary key auto_increment,name varchar(20));`
   `mysql>  insert into test_t1 values(1,1);`
   case 1:
   `mysql> mysql> insert into test_t1(`name`) select t.`name` from test_t1 t;`
   `ERROR 10002 (C1000): 2Unknown exception: [null]`
   case 2:
   `mysql> insert into test_t1(`name`) select '1' as name from test_t1;`
   `ERROR 10002 (C1000): 2Unknown exception: [null]`
   case 3:
   `mysql> insert into test_t1 select 1,'1' ;`
   `ERROR 10002 (C1000): 2Unknown exception: [null]`


----------------------------------------------------------------
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 #6289: insert into select is unsupport

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


   @ChuckPerry The insert select statement and replace select statement have not been implemented yet, and I will try to support 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] ChuckPerry commented on issue #6289: insert into select is unsupport

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


   OK，thx for your reply


----------------------------------------------------------------
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 closed issue #6289: insert into select is unsupport

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


   


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