-
Notifications
You must be signed in to change notification settings - Fork 6.8k
Closed
Description
When using SINGLE Table config,Add support for partition tables in Postgresql
1.ShardingSphere Version:5.5.1

2.postgresql version: 11.22

3.SQL is : “SELECT * FROM SYS_LOG” AND Exception Occur "Table or view 'SYS_LOG' does not exist“

4.config.yaml - SINGLE Table config

5.Cause Analysis:
(1)The table "SYS_LOG" is PARTITIONED TABLE

(2)ShardingSphereTable not contain PARTITIONED TABLES

(3)SchemaMetaDataLoader just load type in (TABLE_TYPE, VIEW_TYPE, SYSTEM_TABLE_TYPE, SYSTEM_VIEW_TYPE)


6.Suggested solution:SchemaMetaDataLoader Add ”PARTITIONED TABLE“ Type
postgresql PARTITIONED TABLE
