You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "liangpengzhou (via GitHub)" <gi...@apache.org> on 2025/05/08 13:36:07 UTC
[I] stuck in many union statement [shardingsphere]
liangpengzhou opened a new issue, #35344:
URL: https://github.com/apache/shardingsphere/issues/35344
## Bug Report
,When there are many unions in SQL, and each union has three table join
I have a sql
`SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table1 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table1 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table3 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table3 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table2 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table2 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
KepSharedBody DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
KepSharedBody DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table4 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table4 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table5 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table5 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table6 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table6 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table7 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table7 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table8 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table8 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table9 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table9 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table10 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table10 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table11 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table11 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table12 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table12 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table13 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table13 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table14 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table14 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table15 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table15 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table16 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table16 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table17 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table17 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table18 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table18 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
KepItem DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
KepItem DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table19 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table19 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table20 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table20 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table21 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table21 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table22 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table22 DC0,
link2 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( ( DC1.bfs913817 = DC0.bfsitrInfo ) AND ( DC0.latestitrInfo = ? ) ) ) UNION ALL
SELECT
DC0.cn9592,
DC0.fs9592,
DC2.cn9592,
DC2.fs9592
FROM
table23 DC0,
link1 DC1,
folder2 DC2
WHERE
( ( DC2.fs9592 = ? ) )
AND ( ( DC1.fs913917 = DC2.fs9592 ) AND ( DC1.fs913817 = DC0.fs9592 ) )`
.the sql has many union,and the code is **stuck** by shardingsphere
the stack is
at java.lang.Object.hashCode(Native Method)
at java.util.concurrent.ConcurrentHashMap.get(ConcurrentHashMap.java:936)
at java.util.concurrent.ConcurrentHashMap.containsKey(ConcurrentHashMap.java:964)
at org.apache.shardingsphere.infra.database.core.type.DatabaseTypeRegistry.<init>(DatabaseTypeRegistry.java:44)
at org.apache.shardingsphere.infra.binder.context.segment.table.TablesContext.findDatabaseName(TablesContext.java:103)
at org.apache.shardingsphere.infra.binder.context.segment.table.TablesContext.<init>(TablesContext.java:93)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:123)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.createSubqueryContexts(SelectStatementContext.java:193)
at org.apache.shardingsphere.infra.binder.context.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:122)
at org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContextFactory.getDMLStatementContext(SQLStatementContextFactory.java:147)
at org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContextFactory.newInstance(SQLStatementContextFactory.java:131)
at org.apache.shardingsphere.infra.binder.engine.SQLBindEngine.bind(SQLBindEngine.java:54)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:146)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:117)
at org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:111)
<img width="1229" alt="Image" src="https://github.com/user-attachments/assets/8d2c7c60-fba9-480b-8266-b026600fc416" />
can you help me solve the problem?
--
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
Re: [I] stuck in many union statement [shardingsphere]
Posted by "liangpengzhou (via GitHub)" <gi...@apache.org>.
liangpengzhou commented on issue #35344:
URL: https://github.com/apache/shardingsphere/issues/35344#issuecomment-2865272110
> Hi [@liangpengzhou](https://github.com/liangpengzhou), please try the latest version, I think this bug has been solved.
latest version 5.5.2 works well,GREAT!
wo use version 5.5.1 in last year November，at that time 5.5.1 is latest.
**thanks very much!**
--
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] stuck in many union statement [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #35344:
URL: https://github.com/apache/shardingsphere/issues/35344#issuecomment-2864724726
Hi @liangpengzhou, please try the latest version, I think this bug has been solved.
--
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] stuck in many union statement [shardingsphere]
Posted by "liangpengzhou (via GitHub)" <gi...@apache.org>.
liangpengzhou commented on issue #35344:
URL: https://github.com/apache/shardingsphere/issues/35344#issuecomment-2864898462
> Hi [@liangpengzhou](https://github.com/liangpengzhou), please try the latest version, I think this bug has been solved.
my sharding version is 5.5.1,now i am try latest version 5.5.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
Re: [I] stuck in many union statement [shardingsphere]
Posted by "liangpengzhou (via GitHub)" <gi...@apache.org>.
liangpengzhou closed issue #35344: stuck in many union statement
URL: https://github.com/apache/shardingsphere/issues/35344
--
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