From issues-return-121156-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Thu Jun 17 09:39:23 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 183B8180658 for ; Thu, 17 Jun 2021 11:39:23 +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 2096A61EC0 for ; Thu, 17 Jun 2021 09:39:20 +0000 (UTC) Received: (qmail 72012 invoked by uid 500); 17 Jun 2021 09:39: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 71906 invoked by uid 99); 17 Jun 2021 09:39: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; Thu, 17 Jun 2021 09:39: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 37F2C3E8AA for ; Thu, 17 Jun 2021 09:39: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 0A54AC81590 for ; Thu, 17 Jun 2021 09:39:00 +0000 (UTC) Date: Thu, 17 Jun 2021 09:39:00 +0000 (UTC) From: "Aleksey Plekhanov (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (IGNITE-14849) Calcite engine. Support '%' operator as alias for 'mod' function MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/IGNITE-14849?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D17= 364809#comment-17364809 ]=20 Aleksey Plekhanov commented on IGNITE-14849: -------------------------------------------- [~zstan]=C2=A0thanks for the review! Merged to sql-calcite branch. > Calcite engine. Support '%' operator as alias for 'mod' function > ---------------------------------------------------------------- > > Key: IGNITE-14849 > URL: https://issues.apache.org/jira/browse/IGNITE-14849 > Project: Ignite > Issue Type: Improvement > Reporter: Aleksey Plekhanov > Assignee: Aleksey Plekhanov > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > Currently, the H2-based SQL engine supports both {{a % b}} and {{mod(a, b= )}} syntax for the modulo operation. But calcite-based engine supports only= {{mod(a, b)}} syntax. Support for {{%}} operator should be added to minimi= ze compatibility issues.=C2=A0 > Affected tests: > {{src/test/sql/aggregate/group/test_group_by.test}} > And many other. -- This message was sent by Atlassian Jira (v8.3.4#803005)