You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "zhouxinhai (via GitHub)" <gi...@apache.org> on 2024/09/06 06:40:30 UTC
[I] 5.5.0 version,oracle Federation mode failed [shardingsphere]
zhouxinhai opened a new issue, #32802:
URL: https://github.com/apache/shardingsphere/issues/32802
I use 5.5.0 version,run in Federation mode。
sql is simple: "SELECT count(1) FROM USER_INFO A1, USER_COMPANY B1 where A1.USER_ID = B1.USER_ID and A1.USER_ID = 10001000"
If database is mysql, run success. But if database is oracle run failed
```
14:39:15.725 [main] INFO ShardingSphere-SQL - Logic SQL: SELECT * FROM `logic_db`.`USER_INFO` WHERE CAST(`USER_ID` AS SIGNED) = 10001000
14:39:15.725 [main] INFO ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT * FROM `USER_INFO` WHERE CAST(`USER_ID` AS SIGNED) = 10001000
14:39:15.728 [main] INFO ShardingSphere-SQL - Logic SQL: SELECT * FROM `logic_db`.`USER_COMPANY` WHERE CAST(`USER_ID` AS SIGNED) = 10001000
14:39:15.728 [main] INFO ShardingSphere-SQL - Actual SQL: ds_1 ::: SELECT * FROM `USER_COMPANY` WHERE CAST(`USER_ID` AS SIGNED) = 10001000
Exception in thread "main" java.sql.SQLException: SQL federation does not support SQL 'SELECT count(1) FROM USER_INFO A1, USER_COMPANY B1 where A1.USER_ID = B1.USER_ID and A1.USER_ID = 10001000'.
at org.apache.shardingsphere.infra.exception.core.external.sql.ShardingSphereSQLException.toSQLException(ShardingSphereSQLException.java:76)
at org.apache.shardingsphere.infra.exception.dialect.SQLExceptionTransformEngine.toSQLException(SQLExceptionTransformEngine.java:54)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeQuery(ShardingSpherePreparedStatement.java:253)
at indi.zhouxh.main.singleTest(main.java:109)
at indi.zhouxh.main.main(main.java:28)
```
shardingsphere.yml:
```
sqlFederation:
sqlFederationEnabled: true
allQueryUseSQLFederation: false
executionPlanCache:
initialCapacity: 2000
maximumSize: 65535
```
--
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] 5.5.0 version,oracle Federation mode failed [shardingsphere]
Posted by "zhouxinhai (via GitHub)" <gi...@apache.org>.
zhouxinhai commented on issue #32802:
URL: https://github.com/apache/shardingsphere/issues/32802#issuecomment-2334972576
> Yes, SQL Federation just support MySQL, PostgreSQL and openGauss. Other databases are not yet compatible.
In the future, is there any plan to support Oracle? Which version will be supported?
--
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] 5.5.0 version,oracle Federation mode failed [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #32802:
URL: https://github.com/apache/shardingsphere/issues/32802#issuecomment-2372268647
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
Re: [I] 5.5.0 version,oracle Federation mode failed [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #32802: 5.5.0 version,oracle Federation mode failed
URL: https://github.com/apache/shardingsphere/issues/32802
--
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] 5.5.0 version,oracle Federation mode failed [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #32802:
URL: https://github.com/apache/shardingsphere/issues/32802#issuecomment-2333826259
Yes, SQL Federation just support MySQL, PostgreSQL and openGauss. Other databases are not yet compatible.
--
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] 5.5.0 version,oracle Federation mode failed [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #32802:
URL: https://github.com/apache/shardingsphere/issues/32802#issuecomment-2339856040
There is no plan to support Oracle yet. Open source MySQL and PostgreSQL are given higher priority. If you are interested, you are welcome to participate in the development of SQL Federation.
--
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