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)
