[jira] [Comment Edited] (ASTERIXDB-2709) ST_UNION operator with select query inside does not work in the master branch

["Dmitry Lychagin (Jira)" <ji...@apache.org>]

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

Dmitry Lychagin edited comment on ASTERIXDB-2709 at 4/10/20, 1:35 AM:
----------------------------------------------------------------------

The patch to fix function registration is available at 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/5704 

With that patch the following query will work
{noformat}
strict_st_union((SELECT VALUE gbu FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu));
{noformat}

SQL aggregate rewriting is still broken, so the following query won't yet work:
{noformat}
FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu
SELECT st_union(gbu) as agg_value
{noformat}
In order to fix this query we need a "sql-*" runtime for this function



was (Author: dlychagin-cb):
The patch to fix function registration is available at 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/5704 

With that patch the following query will work
{{noformat}}
strict_st_union((SELECT VALUE gbu FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu));
{{noformat}}

SQL aggregate rewriting is still broken, so the following query won't yet work:
{{noformat}}
FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu
SELECT st_union(gbu) as agg_value
{{noformat}}
In order to fix this query we need a "sql-*" runtime for this function


> ST_UNION operator with select query inside does not work in the master branch
> -----------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2709
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2709
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: FUN - Functions
>            Reporter: Mehnaz Tabassum Mahin
>            Priority: Major
>
> The "ST_UNION((<select geometry from dataset>))" statement is not working in the master branch, but it works for the last release (version 0.9.4.1).
> The error I get in the master branch is as follows:
> ASX1079: Compilation error: st_union is a SQL-92 aggregate function. The SQL++ core aggregate function array_st-union could potentially express the intent. (in line 1, at column 1) [CompilationException]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)