Aleksandr Efimov created IMPALA-15697:
-----------------------------------------
Summary: Calcite rejects unquoted RESULT, RETURN and USER
identifiers
Key: IMPALA-15697
URL: https://issues.apache.org/jira/browse/IMPALA-15697
Project: IMPALA
Issue Type: Bug
Components: Frontend
Reporter: Aleksandr Efimov
Assignee: Aleksandr Efimov
The original planner accepts unquoted RESULT, RETURN and USER as identifiers.
The Calcite parser rejects RESULT and RETURN as column names and aliases, and
USER as an alias or qualified column name. Quoting the names works.
Examples accepted by the original planner but rejected by Calcite:
{code:sql}
SELECT 1 AS result;
SELECT 1 AS return;
SELECT 1 AS user;
SELECT t.user FROM (SELECT 1 AS `user`) t;
{code}
Calcite should accept these identifier forms while preserving USER() as a
function.
Reproduced on master 234bd0001e33.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
