You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/03/05 21:30:00 UTC

[jira] [Commented] (ASTERIXDB-2524) Illegal state error with ratio_to_report()

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16784927#comment-16784927 ] 

ASF subversion and git services commented on ASTERIXDB-2524:
------------------------------------------------------------

Commit eabb9163ffbfba600376efb9c6a0646caae50d99 in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=eabb916 ]

[ASTERIXDB-2524][COMP] Fix name resolution for ratio_to_report()

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Fixes illegal state error when using ratio_to_report()
  caused by incorrect identifier resolution for this function

Change-Id: I604ff1ee340fe58250500b2ff459f9b46433a269
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3244
Sonar-Qube: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> Illegal state error with ratio_to_report()
> ------------------------------------------
>
>                 Key: ASTERIXDB-2524
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2524
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Minor
>
> FROM (
>   FROM range(1, 2) x, range(1, 2) y SELECT x, y
> ) t
> SELECT x, y,
>   round_half_to_even(ratio_to_report(x) over (partition by y), 2) as `ratio_to_report`
> ORDER BY y, x;
> Throws ASX1038: Illegal state



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)