twosoy opened a new issue, #34329: URL: https://github.com/apache/shardingsphere/issues/34329
## When using SINGLE Table config，Add support for partition tables in Postgresql ## 1.ShardingSphere Version：5.5.1 <img width="474" alt="image" src="https://github.com/user-attachments/assets/7d67e3fe-aaf0-4993-b662-1db517e5aee1"; /> ## 2.postgresql version: 11.22 <img width="485" alt="image" src="https://github.com/user-attachments/assets/c9d7e570-7165-4261-a2d4-28b7fb0a94e0"; /> ## 3.SQL is : “SELECT * FROM SYS_LOG” AND Exception Occur "Table or view 'SYS_LOG' does not exist“ <img width="1014" alt="image" src="https://github.com/user-attachments/assets/f8c02a33-003f-4e87-b43e-d8efa915b392"; /> ## 4.config.yaml - SINGLE Table config <img width="687" alt="image" src="https://github.com/user-attachments/assets/350c8b4e-fcc2-48bd-8fc0-e1dac05b57ae"; /> ## 5.Cause Analysis： ### （1）The table "SYS_LOG" is PARTITIONED TABLE <img width="1067" alt="image" src="https://github.com/user-attachments/assets/97e51928-5221-4ee2-a4f7-27935a95cfe8"; /> ### （2）**ShardingSphereTable** not contain **PARTITIONED TABLES** <img width="1344" alt="image" src="https://github.com/user-attachments/assets/a1622c56-d879-43f7-93aa-4e7341817cca"; /> ### （3）**SchemaMetaDataLoader** just load type in (TABLE_TYPE, VIEW_TYPE, SYSTEM_TABLE_TYPE, SYSTEM_VIEW_TYPE) <img width="1526" alt="image" src="https://github.com/user-attachments/assets/00e0df30-7a32-4b60-a86a-43a4f84ed541"; /> <img width="834" alt="image" src="https://github.com/user-attachments/assets/34c7e4cb-f401-478c-9751-3d95679d3483"; /> ## 6.Suggested solution：SchemaMetaDataLoader Add ”PARTITIONED TABLE“ Type postgresql PARTITIONED TABLE <img width="1572" alt="image" src="https://github.com/user-attachments/assets/b4659527-ca9c-4995-b589-0fe4ae6bbe95"; /> -- 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]
