The SQL of querying table name is:
SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='XSTORACLE' ORDER BY TABLE_NAME ASC;
If the database has a table named ALL_TABLES，an error will be reported.
What did you expect to happen?
The SQL of querying table name is:
SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='XSTORACLE' ORDER BY TABLE_NAME ASC;
How can we reproduce it (as minimally and precisely as possible)?
If the database has a table named ALL_TABLES，an error will be reported.
sl01388797
commented
10 months ago
ODC version
ODC 4.2.2
OB version
Any version of OceanBase.
What happened?
The SQL of querying table name is: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='XSTORACLE' ORDER BY TABLE_NAME ASC; If the database has a table named ALL_TABLES，an error will be reported.
What did you expect to happen?
The SQL of querying table name is: SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='XSTORACLE' ORDER BY TABLE_NAME ASC;
How can we reproduce it (as minimally and precisely as possible)?
If the database has a table named ALL_TABLES，an error will be reported.
Anything else we need to know?
No response
Cloud
No response