Piotr Bojko created CALCITE-2208: ------------------------------------ Summary: MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user Key: CALCITE-2208 URL: https://issues.apache.org/jira/browse/CALCITE-2208 Project: Calcite Issue Type: New Feature Components: core Affects Versions: 1.15.0, 1.16.0 Reporter: Piotr Bojko Assignee: Julian Hyde
MaterializedViewTable.MATERIALIZATION_CONNECTION used for validating views uses ORACLE lex by default. Calcite expands the view sql to uppercase so when schemas used in such view sql are used are declared in lowercase - Calcite does not find needed objects to resolve and validate the view sql. It does really not work even when end user creates connection with lex=oracle, but uses uppercase for the names of its tables. It would be best when MaterializedViewTable.MATERIALIZATION_CONNECTION would be replaced by connection of an end user or dynamically created connection with passed lex from end user connection. Quick and dirty solution is to create MaterializedViewTable.MATERIALIZATION_CONNECTION with caseSensitive=false; -- This message was sent by Atlassian JIRA (v7.6.3#76005)