phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kadir OZDEMIR (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-5064) TenantId is not set for the parent on PARENT_TABLE links
Date Thu, 06 Dec 2018 00:33:00 GMT

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

Kadir OZDEMIR edited comment on PHOENIX-5064 at 12/6/18 12:33 AM:
------------------------------------------------------------------

[~gjacoby]

String childParentLinkQuery = "SELECT " +
 TENANT_ID + ", " +
 TABLE_SCHEM + ", " +
 TABLE_NAME + ", " +
 COLUMN_NAME + " AS PARENT_VIEW_TENANT_ID, " +
 COLUMN_FAMILY + " AS PARENT_VIEW_FULL_NAME " +
 " FROM " + SYSTEM_CATALOG_NAME +
 " WHERE "+ LINK_TYPE + " = " +
 PTable.LinkType.PARENT_TABLE.getSerializedValue();


was (Author: kozdemir):
String childParentLinkQuery = "SELECT " +
 TENANT_ID + ", " +
 TABLE_SCHEM + ", " +
 TABLE_NAME + ", " +
 COLUMN_NAME + " AS PARENT_VIEW_TENANT_ID, " +
 COLUMN_FAMILY + " AS PARENT_VIEW_FULL_NAME " +
 " FROM " + SYSTEM_CATALOG_NAME +
 " WHERE "+ LINK_TYPE + " = " +
 PTable.LinkType.PARENT_TABLE.getSerializedValue();

> TenantId is not set for the parent on PARENT_TABLE links
> --------------------------------------------------------
>
>                 Key: PHOENIX-5064
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5064
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0
>            Reporter: Kadir OZDEMIR
>            Assignee: Kadir OZDEMIR
>            Priority: Minor
>
> The queries on the child-parent links (the PARENT_TABLE links) returns "NULL" tenant
id for the parent views where the tenant id is not supposed to be "NULL".  Either the tenant
id of the parent is not set for child-parent links, or the query has a bug and returns the
wrong value. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message