[jira] [Updated] (PHOENIX-7391) PhoenixRuntime.generateColumnInfo does not filter tenant_id column

["rejeb ben rejeb (Jira)" <ji...@apache.org>]

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

rejeb ben rejeb updated PHOENIX-7391:
-------------------------------------
    Summary: PhoenixRuntime.generateColumnInfo does not filter tenant_id column  (was: PhoenixRuntime.generateColumnInfo does not discard tenant_id column)

> PhoenixRuntime.generateColumnInfo does not filter tenant_id column
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-7391
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7391
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>            Reporter: rejeb ben rejeb
>            Assignee: rejeb ben rejeb
>            Priority: Minor
>
> Given multitenant table:
> {code:java}
> CREATE TABLE MULTITENANT_TABLE (TENANT_ID VARCHAR NOT NULL, GLOBAL_COL1 VARCHAR, GLOBAL_COL2 VARCHAR CONSTRAINT pk PRIMARY KEY (TENANT_ID, GLOBAL_COL1)) MULTI_TENANT=true{code}
>  
> Create View with tenantId= "MyTenantId":
> {code:java}
> CREATE VIEW IF NOT EXISTS TENANT_VIEW(TENANT_ONLY_COL VARCHAR) AS SELECT * FROM MULTITENANT_TEST_TABLE {code}
> When call:
> {code:java}
> Properties props = new Properties();
> props.setProperty(PhoenixRuntime.TENANT_ID_ATTRIB, "MyTenantId");
> Connection conn = DriverManager.getConnection(getUrl(), props);
> List<String> result = PhoenixRuntime.generateColumnInfo(tsconn,"TENANT_VIEW",null).stream()
> .map(ColumnInfo::getDisplayName).collect(Collectors.toList());{code}
> Expected result is: GLOBAL_COL1,GLOBAL_COL2,TENANT_ONLY_COL
> Actual: TENANT_ID, GLOBAL_COL1,GLOBAL_COL2,TENANT_ONLY_COL
>  
> When I looked at method implementation I foud out that salted column is ignored when getting columns info but not the tenantId column:
> {code:java}
> <line 5612> int offset = (table.getBucketNum() == null ? 0 : 1); {code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)