[jira] [Created] (PHOENIX-2619) Boolean expression has no impact in ON clause

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-2619:
-------------------------------------

             Summary: Boolean expression has no impact in ON clause
                 Key: PHOENIX-2619
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2619
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
            Reporter: James Taylor
            Assignee: Maryann Xue


Related to PHOENIX-2618 (and not sure if it's as general as expressed in the subject), the following query worked:

{code}
UPSERT INTO SYSTEM.CATALOG(TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,IMMUTABLE_ROWS)
SELECT A.TENANT_ID,A.TABLE_SCHEM,B.COLUMN_FAMILY, NULL, NULL, TRUE
FROM SYSTEM.CATALOG A JOIN SYSTEM.CATALOG B ON (
 A.TENANT_ID = B.TENANT_ID AND 
 A.TABLE_SCHEM = B.TABLE_SCHEM AND
 A.TABLE_NAME = B.TABLE_NAME AND
 A.COLUMN_NAME = B.COLUMN_NAME AND
 B.LINK_TYPE = 1
)
WHERE A.COLUMN_FAMILY IS NULL AND
 B.COLUMN_FAMILY IS NOT NULL AND
 A.IMMUTABLE_ROWS = TRUE
{code}

While the query below raised no exception, but didn't filter on the A.IMMUTABLE_ROWS expression:
{code}
UPSERT INTO SYSTEM.CATALOG(TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,IMMUTABLE_ROWS)
SELECT A.TENANT_ID,A.TABLE_SCHEM,B.COLUMN_FAMILY, NULL, NULL, TRUE
FROM SYSTEM.CATALOG A JOIN SYSTEM.CATALOG B ON (
 A.TENANT_ID = B.TENANT_ID AND 
 A.TABLE_SCHEM = B.TABLE_SCHEM AND
 A.TABLE_NAME = B.TABLE_NAME AND
 A.COLUMN_NAME = B.COLUMN_NAME AND
 B.LINK_TYPE = 1 AND
A.IMMUTABLE_ROWS
)
WHERE A.COLUMN_FAMILY IS NULL AND
 B.COLUMN_FAMILY IS NOT NULL
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)