Consider supporting PostgreSQL/openGauss search path feature

[strongduanmu]

Feature Request

Is your feature request related to a problem?

No.

Describe the feature you would like.

After issue #14004 is completed, ShardingSphere has supported SQL such as CREATE SCHEMA, ALTER SCHEMA and DROP SCHEMA, and allows users to specify schema modifiers when executing SQL, such as:

SELECT * FROM test.t_order;

This SQL will query the data of the t_order table from the test schema.

In order to improve the experience of using PostgreSQL/openGauss schema, we need to support the search_path parameter. Through the SET SEARCH_PATH TO test, public; statement, users can dynamically switch the schema without going through schema.t_order. For more detail about search_path, we can refer this doc——https://www.postgresql.org/docs/14/ddl-schemas.html#DDL-SCHEMAS-PATH.

[zhaojinchao95]

@strongduanmu Hi,i want to do this. Can you assign me? Thx

[strongduanmu]

@zjcnb Of course. We can consider implementing the global search path first by adding a configuration.

[zhaojinchao95]

Hi, i am sort out what needs to be done. @FlyingZC Can you do it with me?

• [ ] Add search path configuation for server.yaml props
• [ ] Refactor metadata structure
• [ ] Check all schemas are consistent
• [ ] Set search path to jdbc url
• [ ] Refactor get schema logic
• [ ] Clear up session search path

[FlyingZC]

Hi, i am sort out what needs to be done. @FlyingZC Can you do it with me?

• [ ] Add search path configuation for server.yaml props
• [ ] Refactor metadata structure
• [ ] Check all schemas are consistent
• [ ] Set search path to jdbc url
• [ ] Refactor get schema logic
• [ ] Clear up session search path

Ok,I'd like to try that.

[github-actions[bot]]

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.

[strongduanmu]

This issue is currently low priority, so I will remove milestone.

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.