naah69 commented on issue #32189: URL: https://github.com/apache/shardingsphere/issues/32189#issuecomment-2259554093
> * CTE for MySQL is actually supported via SQL Federation at https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-federation/ . But for a wider range of databases, this actually requires Calcite 1.36 which adds `recursive with` parsing support. That is https://issues.apache.org/jira/browse/CALCITE-129 . But due to the merge of [[CALCITE-6006] RelToSqlConverter loses charset information calcite#3429](https://github.com/apache/calcite/pull/3429) , ShardingSphere is not compatible with Calcite 1.36, which is reflected in CI [Updates Calcite to 1.36.0 to further support the `WITH RECURSIVE` keyword #29229](https://github.com/apache/shardingsphere/pull/29229).MySQL 的 CTE 实际上是通过 SQL Federation 支持的，网址为https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-federation/ 。但对于更广泛的数据库，这实际上需要 Calcite 1.36，它添加了`re cursive with`解析支持。那是https://issues.apache.org/jira/browse/CALCITE-129 。但由于合并 [[CALCITE-6006] RelToSqlConverter loses charset information calcite#3429](https://github.com/apache/calcite/pull/3429) ，ShardingSphere不兼容Calcite 1.36，体现在CI中 [Updates Calcite to 1.36.0 to further support the `WITH RECURSIVE` keyword #29229](https://github.com/apache/shardingsphere/pull/29229) 。 > * Feel free to raise your PR to fix it. sorry，I leaved out some infomation. In my case，we use postgresql and `WITH`,it also throwed exception that is about `Table or view 'xxx' does not exist` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
