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:32:12 UTC
[GitHub] [shardingsphere] huangconghe opened a new issue, #20632: Does sharding JDBC support insert into select
huangconghe opened a new issue, #20632:
URL: https://github.com/apache/shardingsphere/issues/20632
Does sharding JDBC support insert into select？
Not through my custom sharding-Algorithm, such as actual-data-nodes: ds0.order_$->{['tr','fs']}_$->{0..9},
Actual stored table is order_tr_0,do not throw exception.
--
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] github-actions[bot] closed issue #20632: Does sharding JDBC support insert into select
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20632: Does sharding JDBC support insert into select
URL: https://github.com/apache/shardingsphere/issues/20632
--
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 #20632: Does sharding JDBC support insert into select
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20632:
URL: https://github.com/apache/shardingsphere/issues/20632#issuecomment-1230089754
Now, ShardingSphere can support insert into select for binding tables and single tables, you can try the latest version.
--
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] huangconghe closed issue #20632: Does sharding JDBC support insert into select
Posted by GitBox <gi...@apache.org>.
huangconghe closed issue #20632: Does sharding JDBC support insert into select
URL: https://github.com/apache/shardingsphere/issues/20632
--
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 #20632: Does sharding JDBC support insert into select
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20632:
URL: https://github.com/apache/shardingsphere/issues/20632#issuecomment-1272348682
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] Does sharding JDBC support insert into select [shardingsphere]
Posted by "taku-hua (via GitHub)" <gi...@apache.org>.
taku-hua commented on issue #20632:
URL: https://github.com/apache/shardingsphere/issues/20632#issuecomment-1899862984
actually it don't support, i use 4.1.1 。
the sql is like below
```sql
insert into tabel1 (id, name) select id,'#{name}' from tableB
```
and it throw a nullpointerException from tree.visit(this) in
```java
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser
@Override
public <T> T accept(ParseTreeVisitor<? extends T> visitor) {
if ( visitor instanceof MySQLStatementVisitor ) return ((MySQLStatementVisitor<? extends T>)visitor).visitInsert(this);
else return visitor.visitChildren(this);
}
```
--
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