Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TableNotExistsException: Table or view *** does not exist #30860

Open
shijie-328931589 opened this issue Apr 12, 2024 · 2 comments
Open

TableNotExistsException: Table or view *** does not exist #30860

shijie-328931589 opened this issue Apr 12, 2024 · 2 comments

Comments

@shijie-328931589
Copy link

Which version of ShardingSphere did you use?

5.4.1

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-JDBC

Expected behavior

When loading postgresql database schema,SchemaMetaDataLoader should load TABLE、VIEW、SYSTEM TABLE、SYSTEM TABLE、SYSTEM VIEW and PARTITION TABLE

Actual behavior

SchemaMetaDataLoader not load PARTITION TABLE,when do query from pg PARTITION TABLE, will appear org.apache.shardingsphere.infra.exception.TableNotExistsException

Reason analyze (If you can)

when load database tables, SchemaMetaDataLoader should add PARTITION TABLE.

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).

@shijie-328931589 shijie-328931589 changed the title ShardingSphere-JDBC 5.4.1 can not load postgresql partition table ShardingSphere-JDBC 5.4.1 can not load postgresql partitioned table Apr 12, 2024
@shijie-328931589 shijie-328931589 changed the title ShardingSphere-JDBC 5.4.1 can not load postgresql partitioned table TableNotExistsException: Table or view *** does not exist Apr 15, 2024
@strongduanmu
Copy link
Member

strongduanmu commented May 9, 2024

@shijie-328931589 Can you give an example to describe the problem about partition table? I'm sorry, I'm not familiar with PostgreSQL partitioned tables and would like to learn more information.

Copy link

github-actions bot commented Jun 8, 2024

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

@github-actions github-actions bot added the stale label Jun 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants