[jira] [Created] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

["Piotr Bojko (JIRA)" <ji...@apache.org>]

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)