[jira] [Resolved] (PHOENIX-6004) Metadata operations cannot filter on case-sensitive names

["Istvan Toth (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-6004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Istvan Toth resolved PHOENIX-6004.
----------------------------------
    Resolution: Invalid

This is not a bug.

The metadata operations ARE case sensitive.

They do not handle the double quote escaping that I proposed in this patch, but since they are case sensitive by default, it is not necessary.

> Metadata operations cannot filter on case-sensitive names
> ---------------------------------------------------------
>
>                 Key: PHOENIX-6004
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6004
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 5.1.0, 4.16.0
>            Reporter: Istvan Toth
>            Assignee: Richard Antal
>            Priority: Major
>
> The MetaData operations cannot filter on case-sensitive table, schema, column, or catalog names.
> Looks like at least QueryUtil.getTablesStmt() misses the logic to detect and handle the case-sensitive names 
> expected behaviour:
> {code:java}
> meta.getTables(null, null, "\"CamelCase\"", null){code}
> should find the table "CamelCase", instead of "CAMELCASE"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)