Rajeshbabu Chintaguntla created PHOENIX-3647:
------------------------------------------------
Summary: Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite
Key: PHOENIX-3647
URL: https://issues.apache.org/jira/browse/PHOENIX-3647
Project: Phoenix
Issue Type: Sub-task
Reporter: Rajeshbabu Chintaguntla
Assignee: Rajeshbabu Chintaguntla
{noformat}
testIndexOnViewWithChildView(org.apache.phoenix.compile.QueryCompilerTest)
Time elapsed: 0.07 sec <<< ERROR!
java.sql.SQLException:
Error while executing SQL "CREATE VIEW PLATFORM_ENTITY.GLOBAL_VIEW (
INT1 BIGINT NOT NULL,
DOUBLE1 DECIMAL(12, 3),
IS_BOOLEAN BOOLEAN,
TEXT1 VARCHAR,
CONSTRAINT PKVIEW PRIMARY KEY
(
INT1
)
)
AS SELECT * FROM PLATFORM_ENTITY.GLOBAL_TABLE WHERE KEY_PREFIX = '123'": parse
failed: Encountered ", CONSTRAINT" at line 5, column 18.
Was expecting one of:
")" ...
"," <IDENTIFIER> ...
"," <QUOTED_IDENTIFIER> ...
"," <BACK_QUOTED_IDENTIFIER> ...
"," <BRACKET_QUOTED_IDENTIFIER> ...
"," <UNICODE_QUOTED_IDENTIFIER> ...
"NOT" ...
"NULL" ...
"PRIMARY" ...
"ASC" ...
"DESC" ...
"ROW_TIMESTAMP" ...
"(" ...
"ARRAY" ...
"[" ...
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)