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

James Taylor reopened PHOENIX-1682:
-----------------------------------

Did you run the unit tests before submitting your patch, [~ivanweiss]? Looks 
like we're getting the following failure. Would you mind submitting a patch for 
this?
{code}
FAILURE! - in org.apache.phoenix.end2end.QueryMoreIT
testQueryMore1(org.apache.phoenix.end2end.QueryMoreIT)  Time elapsed: 3.45 sec  
<<< ERROR!
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table 
undefined. tableName="HISTORY_TABLE_00Dxxxxxtenant1"
        at 
org.apache.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:241)
        at 
org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:313)
        at 
org.apache.phoenix.util.PhoenixRuntime.encodeValues(PhoenixRuntime.java:839)
        at 
org.apache.phoenix.end2end.QueryMoreIT.getRecordsOutofCursorTable(QueryMoreIT.java:268)
        at 
org.apache.phoenix.end2end.QueryMoreIT.testQueryMore(QueryMoreIT.java:142)
        at 
org.apache.phoenix.end2end.QueryMoreIT.testQueryMore1(QueryMoreIT.java:50)

testQueryMore4(org.apache.phoenix.end2end.QueryMoreIT)  Time elapsed: 0.38 sec  
<<< ERROR!
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table 
undefined. tableName="HISTORY_TABLE_00Dxxxxxtenant1"
        at 
org.apache.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:241)
        at 
org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:313)
        at 
org.apache.phoenix.util.PhoenixRuntime.encodeValues(PhoenixRuntime.java:839)
        at 
org.apache.phoenix.end2end.QueryMoreIT.getRecordsOutofCursorTable(QueryMoreIT.java:268)
        at 
org.apache.phoenix.end2end.QueryMoreIT.testQueryMore(QueryMoreIT.java:142)
        at 
org.apache.phoenix.end2end.QueryMoreIT.testQueryMore4(QueryMoreIT.java:68)
{code}

[~samarthjain] - will this impact the query more in production, or would these 
generated table names not require normalization?

> PhoenixRuntime.getTable() does not work with case-sensitive table names
> -----------------------------------------------------------------------
>
>                 Key: PHOENIX-1682
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1682
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.2.0
>            Reporter: Eli Levine
>            Assignee: Ivan Weiss
>              Labels: Newbie
>             Fix For: 5.0.0, 4.4.0, 4.3.2
>
>
> 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
(v6.3.4#6332)

Reply via email to