tristaZero opened a new issue #10271: URL: https://github.com/apache/shardingsphere/issues/10271
As you know, ShardingSphere defines [DistSQL](https://shardingsphere.apache.org/document/current/cn/features/dist-sql/) for distributed metadata queries. There is an issue that `SHOW xxx` DistSQL has conflicts with PostgreSQL standard SQL syntax. ### How to reproduce? - Start Proxy using PostgreSQL - Execute DistSQL `show REPLICA_QUERY rule from schem_name` ### Expected and actual results **Expected** `ShardingSphereSQLParserEngine` return `ShowRuleStatement`. **Actual** `ShardingSphereSQLParserEngine` return `PostgreSQLShowStatement`. ### Some hints for solution - Please check the definition of `show` in `shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DALStatement.g4` is aligned with PostgreSQL or not - Consider working on its definition to avoid the visitor entering into `show colId` branch **Note** I am unsure these hints can help us fix this conflict, but it is worth more investigation since this method is the cheapest for pushing the development of the DistSQL feature. If you have any progress, please contact me. -- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
