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

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

    [ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16391266#comment-16391266 ] 

Piotr Bojko commented on CALCITE-2208:
--------------------------------------

I am planning to add the mentioned workaround when working on CALCITE-2194 - disabling case sensitivity on MaterializedViewTable.MATERIALIZATION_CONNECTION

> 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: Bug
>          Components: core
>    Affects Versions: 1.15.0, 1.16.0
>            Reporter: Piotr Bojko
>            Assignee: Julian Hyde
>            Priority: Major
>
> 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)