From issues-return-121521-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Fri Jun 25 07:18:04 2021 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org [3.227.148.255]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id DEC1F180181 for ; Fri, 25 Jun 2021 09:18:03 +0200 (CEST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-ec2-va.apache.org (ASF Mail Server at mxout1-ec2-va.apache.org) with SMTP id 2929D3F710 for ; Fri, 25 Jun 2021 07:18:03 +0000 (UTC) Received: (qmail 63771 invoked by uid 500); 25 Jun 2021 07:18:02 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 63743 invoked by uid 99); 25 Jun 2021 07:18:01 -0000 Received: from ec2-52-204-25-47.compute-1.amazonaws.com (HELO mailrelay1-ec2-va.apache.org) (52.204.25.47) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jun 2021 07:18:01 +0000 Received: from jira2-he-de.apache.org (jira2-he-de.apache.org [168.119.33.54]) by mailrelay1-ec2-va.apache.org (ASF Mail Server at mailrelay1-ec2-va.apache.org) with ESMTPS id E26043E9B2 for ; Fri, 25 Jun 2021 07:18:00 +0000 (UTC) Received: from jira2-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira2-he-de.apache.org (ASF Mail Server at jira2-he-de.apache.org) with ESMTP id 1C2BAC806C8 for ; Fri, 25 Jun 2021 07:18:00 +0000 (UTC) Date: Fri, 25 Jun 2021 07:18:00 +0000 (UTC) From: "Aleksey Plekhanov (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (IGNITE-14721) Calcite. SOME with subquery consume huge time. 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/IGNITE-14721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov reassigned IGNITE-14721: ------------------------------------------ Assignee: Aleksey Plekhanov > Calcite. SOME with subquery consume huge time. > ---------------------------------------------- > > Key: IGNITE-14721 > URL: https://issues.apache.org/jira/browse/IGNITE-14721 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Stanilovsky Evgeny > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite, calcite2-required, calcite3-required > > Table of 7 rows and further request : > {noformat} > SELECT name FROM Orders o WHERE name <= SOME (SELECT name FROM Orders o) > {noformat} > consume 1 min 21 sec for now. -- This message was sent by Atlassian Jira (v8.3.4#803005)