[
https://issues.apache.org/jira/browse/ASTERIXDB-2669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Till Westmann updated ASTERIXDB-2669:
-------------------------------------
Fix Version/s: 0.9.8
(was: 0.9.7)
> Hyracks exception from OBJECT_REMOVE_FIELDS subquery
> ----------------------------------------------------
>
> Key: ASTERIXDB-2669
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2669
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: *DB - AsterixDB, FUN - Functions, RT - Runtime, SQL -
> Translator SQL++
> Affects Versions: 0.9.4.1
> Reporter: Michael J. Carey
> Assignee: Dmitry Lychagin
> Priority: Major
> Fix For: 0.9.8
>
>
> This query does not work:
> SELECT VALUE t FROM (SELECT VALUE OBJECT_REMOVE_FIELDS(t, ["message"]) FROM
> GleambookMessages t) t WHERE t.messageId >= 3;
> It gives a semi-nasty-looking error message:
> org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression
> cannot be cast to
> org.apache.hyracks.algebricks.core.algebra.expressions.VariableReferenceExpression
> [ClassCastException]
> This variant of the query (with type-casting before the comparison) works:
> SELECT VALUE t FROM (SELECT VALUE OBJECT_REMOVE_FIELDS(t, ["message"]) FROM
> GleambookMessages t) t WHERE int(t.messageId) >= 3;
> Seems like this is a bug related to the compiler not knowing what to expect
> following the application of OBJECT_REMOVE_FIELDS - but it seems like it
> should indeed work as long as the data is okay (all numbers) at runtime. In
> the event of "bad" data for the comparison at runtime, it seems like it
> should still work without an error, but should yield a bad comparison warning.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
