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