From issues-return-120495-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Jun 2 09:23: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-he-de.apache.org (mxout1-he-de.apache.org [95.216.194.37]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id 1FA56180638 for ; Wed, 2 Jun 2021 11:23:04 +0200 (CEST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-he-de.apache.org (ASF Mail Server at mxout1-he-de.apache.org) with SMTP id A6A3D6164B for ; Wed, 2 Jun 2021 09:23:02 +0000 (UTC) Received: (qmail 47632 invoked by uid 500); 2 Jun 2021 09:23:01 -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 47618 invoked by uid 99); 2 Jun 2021 09:23:01 -0000 Received: from mailrelay1-he-de.apache.org (HELO mailrelay1-he-de.apache.org) (116.203.21.61) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jun 2021 09:23:01 +0000 Received: from jira2-he-de.apache.org (unknown [IPv6:2a01:4f8:242:1f49::2]) by mailrelay1-he-de.apache.org (ASF Mail Server at mailrelay1-he-de.apache.org) with ESMTPS id 5A1B03EA55 for ; Wed, 2 Jun 2021 09:23: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 202A9C807FF for ; Wed, 2 Jun 2021 09:23:00 +0000 (UTC) Date: Wed, 2 Jun 2021 09:23:00 +0000 (UTC) From: "Alexander Belyak (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (IGNITE-14813) Use statistics with not null where clauses MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Alexander Belyak created IGNITE-14813: ----------------------------------------- Summary: Use statistics with not null where clauses Key: IGNITE-14813 URL: https://issues.apache.org/jira/browse/IGNITE-14813 Project: Ignite Issue Type: Improvement Components: sql Reporter: Alexander Belyak Now we can use null counter only with "is null" where clauses, but we should use it with "not null" too. In queries like: select * from employee where birth_date IS NOT NULL -- This message was sent by Atlassian Jira (v8.3.4#803005)