Re: [I] Not compatible to Oracle12C [shardingsphere]

["wuwen5 (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org