Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Precedence of the operator '[...]' is too low. When the below query is executed
select _MAP['R_REGIONKEY'] + _MAP['R_REGIONKEY'] from "region.parquet";
Optiq throws the following error: Cannot apply '+' to arguments of type '<ANY> + <(VARCHAR, ANY) MAP>'. Supported form(s): '<NUMERIC> + <NUMERIC>
It seems to not resolve the second Map type to SqlTypeFamily 'ANY' instead treats it like a map. Using () around the expression like in the below query fixes the problem.
select _MAP['R_REGIONKEY'] + (_MAP['R_REGIONKEY']) from "region.parquet";
---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/76
Created by: mehant
Labels:
Created at: Mon Nov 04 08:50:12 CET 2013
State: closed