From notifications-return-155210-archive-asf-public=cust-asf.ponee.io@asterixdb.apache.org Fri Apr 10 01:36:08 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id CC123180634 for ; Fri, 10 Apr 2020 03:36:06 +0200 (CEST) Received: (qmail 83266 invoked by uid 500); 10 Apr 2020 01:36:05 -0000 Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list notifications@asterixdb.apache.org Received: (qmail 83255 invoked by uid 99); 10 Apr 2020 01:36:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2020 01:36:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 1F3141A40AD for ; Fri, 10 Apr 2020 01:36:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -112.189 X-Spam-Level: X-Spam-Status: No, score=-112.189 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, KAM_DMARC_STATUS=0.01, RCVD_IN_DNSWL_HI=-5, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 7QojgJ8MYhAU for ; Fri, 10 Apr 2020 01:36:04 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=207.244.88.153; helo=mail.apache.org; envelope-from=jira@apache.org; receiver= Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with SMTP id CC47DBB8F6 for ; Fri, 10 Apr 2020 01:36:03 +0000 (UTC) Received: (qmail 82680 invoked by uid 99); 10 Apr 2020 01:36:02 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2020 01:36:02 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 7C641E30B6 for ; Fri, 10 Apr 2020 01:36:01 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 425F6780477 for ; Fri, 10 Apr 2020 01:36:00 +0000 (UTC) Date: Fri, 10 Apr 2020 01:36:00 +0000 (UTC) From: "Dmitry Lychagin (Jira)" To: notifications@asterixdb.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (ASTERIXDB-2709) ST_UNION operator with select query inside does not work in the master branch MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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((