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/10/10 06:42:44 UTC
[GitHub] [shardingsphere] Crackersssss opened a new issue, #13574: Are subqueries not allowed in the "value" in the "insert" statement?
Crackersssss opened a new issue, #13574:
URL: https://github.com/apache/shardingsphere/issues/13574
version：
master
config：
``` yaml
schemaName: zeus
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/zeustest_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_1:
url: jdbc:mysql://127.0.0.1:3306/zeustest_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: pcloud
password: pcloud
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
cloud_node_service:
actualDataNodes: ds_${0..1}.cloud_node_service
cloud_service:
actualDataNodes: ds_${0..1}.cloud_service
bindingTables:
- cloud_node_service,cloud_service
defaultDatabaseStrategy:
standard:
shardingColumn: service_uuid
shardingAlgorithmName: database_inline_service
defaultTableStrategy:
none:
shardingAlgorithms:
database_inline_service:
type: HASH_MOD
props:
sharding-count: 2
```
error:
``` sql
mysql> insert into cloud_node_service (node_id,service_uuid,version,version_time,metadata) values('teststr',(select service_uuid from cloud_service wher
e app_name ='powercloud' and service_name = 'vesta_server-basHostProductService'),'1.0',localtimestamp(0),'testtest') ON DUPLICATE KEY UPDATE version_ti
me = VALUES(version_time);
ERROR 1997 (C1997): Runtime exception: [org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.subquery.SubqueryExpressionSegment cannot be ca
st to org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.simple.LiteralExpressionSegment]
```
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] carlors commented on issue #13574: Are subqueries not allowed in the "value" in the "insert" statement?
Posted by GitBox <gi...@apache.org>.
carlors commented on issue #13574:
URL: https://github.com/apache/shardingsphere/issues/13574#issuecomment-1338864112
> @CrackerSuperior Thank you for your feedback, this statement is not supported now. We will consider supporting the execution of this statement in next version.
hello，请问这个问题在哪个版本修复了呢？目前我用的shardingsphere-proxy 5.1.2版本依然遇到这个问题。
--
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] github-actions[bot] closed issue #13574: Are subqueries not allowed in the "value" in the "insert" statement?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #13574: Are subqueries not allowed in the "value" in the "insert" statement?
URL: https://github.com/apache/shardingsphere/issues/13574
--
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] github-actions[bot] commented on issue #13574: Are subqueries not allowed in the "value" in the "insert" statement?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #13574:
URL: https://github.com/apache/shardingsphere/issues/13574#issuecomment-1272350688
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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
Re: [I] Are subqueries not allowed in the "value" in the "insert" statement? [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #13574:
URL: https://github.com/apache/shardingsphere/issues/13574#issuecomment-2026022671
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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