wuwen5 commented on issue #29463:
URL:
https://github.com/apache/shardingsphere/issues/29463#issuecomment-2069661249
I think this is a case sensitive issue with table names.
> TableNotExistsException: Table or view system_sd_demo does not exist.
> CREATE TABLE "SYSTEM_SD_DEMO_0"
In the exception log, it is lowercase, while in the `DDL` statement, it is
uppercase.
This SQL can be used to confirm case sensitive configurations
`SELECT *
FROM nls_database_parameters
WHERE parameter IN ('NLS_SORT', 'NLS_COMP');`
`SELECT OWNER AS TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, NULLABLE, DATA_TYPE,
COLUMN_ID, HIDDEN_COLUMN , IDENTITY_COLUMN, COLLATION
FROM ALL_TAB_COLS WHERE
TABLE_NAME in ('system_sd_demo_0' )
ORDER BY COLUMN_ID
`
--
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]
