phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivan Weiss (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-1682) PhoenixRuntime.getTable() does not work with case-sensitive table names
Date Wed, 15 Apr 2015 22:44:58 GMT


Ivan Weiss commented on PHOENIX-1682:

[~giacomotaylor] I was told to ask you about the proper way to deal with various Schema/Table/Case
Sensitive situations. Currently we are normalizing and stripping the quotes off of case sensitive
table names but we normalize when there is a leading schema name

Please tell me which of these is valid, invalid or needs correction:
TableName becomes TABLENAME
"TableName" becomes TableName
SchemaName.TableName becomes SCHEMANAME & TABLENAME
SchemaName."TableName" becomes SCHEMANAME & TableName
"SchemaName"."TableName" becomes SchemaName & TableName
"Schema.Name"."TableName" becomes Schema.Name & TableName

> PhoenixRuntime.getTable() does not work with case-sensitive table names
> -----------------------------------------------------------------------
>                 Key: PHOENIX-1682
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.2.0
>            Reporter: Eli Levine
>            Assignee: Ivan Weiss
>              Labels: Newbie
> PhoenixRuntime.getTable(conn, name) assumes _name_ is a single component because it calls
SchemaUtil.normalizeIdentifier(name) on the whole thing, without breaking up _name_ into table
name and schema name components. In cases where a table is case sensitive (created with _schemaName."tableName"_)
this will result in getTable not finding the table.

This message was sent by Atlassian JIRA

View raw message