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 2022/01/13 06:41:47 UTC
[GitHub] [shardingsphere] carlyin0801 opened a new issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
carlyin0801 opened a new issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731
Hello, why can't version 5.0.0 support SQL batch insert or update?
--
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] hipopular removed a comment on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
hipopular removed a comment on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1022967689
Insert statement does not support sharding table routing to multiple data nodes.\n### The error may exist
The error occur
red while setting parameters\n### SQL: insert into `mer_batch_321566` ( UID, CINEMA_UID, CINEMA_NAME, MER_UID, SKU_UID, SKU_CODE, UNIT_UID, UNIT_NAME, LEVEL, DEL_FLAG, CREATE_TIME, TENANT_ID ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '32
1566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '
321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
'321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' )
--
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] carlyin0801 commented on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
carlyin0801 commented on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1011880660
such as:
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" )
VALUES
( 1, 10, NULL, '2021-12-19 13:38:35', 'xxx'),
( 2, 11, NULL, '2021-12-19 15:05:13', 'xxx'),
( 3, 12, NULL, '2021-12-19 15:05:13', 'xxx'),
( 4, 13, NULL, '2021-12-19 15:05:13', 'xxx');
--
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] terrymanu commented on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1042902617
Closed because of no response for long time.
--
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] carlyin0801 edited a comment on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
carlyin0801 edited a comment on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1011880660
such as:
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" )
VALUES
( 1, 10, NULL, '2021-12-19 13:38:35', 'xxx'),
( 2, 11, NULL, '2021-12-19 15:05:13', 'xxx'),
( 3, 12, NULL, '2021-12-19 15:05:13', 'xxx'),
( 4, 13, NULL, '2021-12-19 15:05:13', 'xxx');
Version 5.0.0 does not currently support this method.
--
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] hipopular commented on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
hipopular commented on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1022967689
Insert statement does not support sharding table routing to multiple data nodes.\n### The error may exist
The error occur
red while setting parameters\n### SQL: insert into `mer_batch_321566` ( UID, CINEMA_UID, CINEMA_NAME, MER_UID, SKU_UID, SKU_CODE, UNIT_UID, UNIT_NAME, LEVEL, DEL_FLAG, CREATE_TIME, TENANT_ID ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '32
1566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '
321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
'321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '321566' )
--
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 #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1011861003
@carlyin0801 Can you explain this issue in detail?
--
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 #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1011909520
@carlyin0801 If you have any problem, you can submit a issue according to the bug template.
--
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 edited a comment on issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
strongduanmu edited a comment on issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731#issuecomment-1011909520
@carlyin0801 If you have any problem, you can submit an issue according to the bug template.
--
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] terrymanu closed issue #14731: Hello, why can't version 5.0.0 support SQL batch insert or update?
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #14731:
URL: https://github.com/apache/shardingsphere/issues/14731
--
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