[
https://issues.apache.org/jira/browse/PHOENIX-6365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17279714#comment-17279714
]
Istvan Toth commented on PHOENIX-6365:
--------------------------------------
{noformat}
CREATE TABLE IF NOT EXISTS GRAMMAR_TABLE (ID INTEGER PRIMARY KEY,unsig_id
UNSIGNED_INT,big_id BIGINT,unsig_long_id UNSIGNED_LONG,tiny_id
TINYINT,unsig_tiny_id UNSIGNED_TINYINT,small_id SMALLINT,unsig_small_id
UNSIGNED_SMALLINT,float_id FLOAT,unsig_float_id UNSIGNED_FLOAT,double_id
DOUBLE,unsig_double_id UNSIGNED_DOUBLE,decimal_id DECIMAL,boolean_id
BOOLEAN,time_id TIME,date_id DATE,timestamp_id TIMESTAMP,unsig_time_id
UNSIGNED_TIME,unsig_date_id UNSIGNED_DATE,unsig_timestamp_id
UNSIGNED_TIMESTAMP,varchar_id VARCHAR (30),char_id CHAR (30),binary_id BINARY
(100),varbinary_id VARBINARY (100),array_id VARCHAR[]);
CREATE TABLE IF NOT EXISTS SECONDARY_GRAMMAR_TABLE (SEC_ID INTEGER PRIMARY
KEY,sec_unsig_id UNSIGNED_INT,sec_big_id BIGINT,sec_usnig_long_id
UNSIGNED_LONG,sec_tiny_id TINYINT,sec_unsig_tiny_id
UNSIGNED_TINYINT,sec_small_id SMALLINT,sec_unsig_small_id
UNSIGNED_SMALLINT,sec_float_id FLOAT,sec_unsig_float_id
UNSIGNED_FLOAT,sec_double_id DOUBLE,sec_unsig_double_id
UNSIGNED_DOUBLE,sec_decimal_id DECIMAL,sec_boolean_id BOOLEAN,sec_time_id
TIME,sec_date_id DATE,sec_timestamp_id TIMESTAMP,sec_unsig_time_id
UNSIGNED_TIME,sec_unsig_date_id UNSIGNED_DATE,sec_unsig_timestamp_id
UNSIGNED_TIMESTAMP,sec_varchar_id VARCHAR (30),sec_char_id CHAR
(30),sec_binary_id BINARY (100),sec_varbinary_id VARBINARY (100),sec_array_id
VARCHAR[]);
CREATE LOCAL INDEX GRAMMAR_TABLE_LOCAL_INDEX ON GRAMMAR_TABLE (unsig_small_id);
CREATE LOCAL INDEX SECONDARY_GRAMMAR_TABLE_LOCAL_INDEX ON
SECONDARY_GRAMMAR_TABLE (sec_unsig_small_id);
SELECT
A.ID,
B.SEC_UNSIG_ID,
C.TINY_ID,
D.TIME_ID,
E.SEC_TIME_ID,
F.SEC_BOOLEAN_ID,
G.VARBINARY_ID,
H.SEC_UNSIG_ID,
I.UNSIG_TIMESTAMP_ID,
I.UNSIG_SMALL_ID
FROM
GRAMMAR_TABLE AS A
INNER JOIN
SECONDARY_GRAMMAR_TABLE AS B
ON A.ID = B.SEC_ID
LEFT OUTER JOIN
GRAMMAR_TABLE AS C
ON B.SEC_BIG_ID = C.BIG_ID
LEFT OUTER JOIN
GRAMMAR_TABLE AS D
ON C.TINY_ID = D.TINY_ID
INNER JOIN
SECONDARY_GRAMMAR_TABLE AS E
ON D.TIME_ID = E.SEC_TIME_ID
INNER JOIN
SECONDARY_GRAMMAR_TABLE AS F
ON D.BOOLEAN_ID = F.SEC_BOOLEAN_ID
RIGHT OUTER JOIN
GRAMMAR_TABLE AS G
ON F.SEC_VARBINARY_ID = G.VARBINARY_ID
RIGHT OUTER JOIN
SECONDARY_GRAMMAR_TABLE AS H
ON H.SEC_UNSIG_ID = G.UNSIG_ID
INNER JOIN
GRAMMAR_TABLE AS I
ON I.UNSIG_TIMESTAMP_ID = E.SEC_UNSIG_TIMESTAMP_ID
INNER JOIN
GRAMMAR_TABLE AS J
ON J.UNSIG_SMALL_ID = F.SEC_UNSIG_SMALL_ID
WHERE
A.ID IS NOT NULL
AND I.UNSIG_TIMESTAMP_ID IS NOT NULL
AND I.UNSIG_SMALL_ID IS NOT NULL
ORDER BY
A.ID DESC;
{noformat}
> Bogus AmbiguousTableException in query with aliases on local indexed tables
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-6365
> URL: https://issues.apache.org/jira/browse/PHOENIX-6365
> Project: Phoenix
> Issue Type: Task
> Components: core
> Affects Versions: 5.1.0
> Reporter: Istvan Toth
> Priority: Major
>
> Certain queries with aliases on tbales with local indexes throw
> AmbiguousTableException
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
