Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTImL-004cG6-H9 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Jan 2025 10:50:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tTImK-00EGIc-C2 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Jan 2025 10:50:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTImK-00EGIR-2R for pgsql-bugs@lists.postgresql.org; Thu, 02 Jan 2025 10:50:11 +0000 Received: from mail-pj1-x1043.google.com ([2607:f8b0:4864:20::1043]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tTImI-001heR-0w for pgsql-bugs@lists.postgresql.org; Thu, 02 Jan 2025 10:50:10 +0000 Received: by mail-pj1-x1043.google.com with SMTP id 98e67ed59e1d1-2ef28f07dbaso12066476a91.2 for ; Thu, 02 Jan 2025 02:50:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735815009; x=1736419809; darn=lists.postgresql.org; h=mime-version:subject:references:in-reply-to:message-id:to:from:date :from:to:cc:subject:date:message-id:reply-to; bh=NJdlB3tTipMdlWJFbm3MrF/UUsqVhViEN9HM7TCrwiI=; b=R4GmmH8nc65xoAzHr+rig0G3bSkgQWke8lh3UAc2D8mKxvTh0YEn5rLNrIItr6mifb WtYehpwkimOC+lQU4XiYsW6JGmAtp+bnUNWCcMBu0lkz9C5mG0A1tq5m7wfyeDKHnQ8g F5pB1AkuAbAqotzy0tLHsU5BdJW7WddGixbRlt7zcafiCKA0OMUuVOniDFbpkGuSAJPc Raxn56Mq0ZaSz5PigcxNZMaJqHmrDhfp1aGqMEeBUkOESFr7CQuzyICq3eciVwZJBjkc NAVx8y/vWn+OW9Kz6QtMomhw2UFbSZv+hC/8lOjqIqd1n/bFY2SfiTMLwjx+yrndSWWT k1mQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735815009; x=1736419809; h=mime-version:subject:references:in-reply-to:message-id:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=NJdlB3tTipMdlWJFbm3MrF/UUsqVhViEN9HM7TCrwiI=; b=YnSvLFxCcKFVmKqLeRZZq2xUwecZ59ZAwXTX1TSd+61dRF2q+y3nu0JhnTM0EB+Lhi bhkWOcZ5IqyV3WBzds86fvXmsWgllsT0PwJrPoKIr+xOlXYxrMPRfacKt8y45vdkqjS4 aMp3mmOxsDXM3tb+9NKhTuYFPc/BmYnY12klrLFGrukLZNYyGIxguqh0V+zbkBwXlNXI SDnxGHgpO+dvN+CVVuvilPhvZyuk6iLRJlJZaYrJgPL8jmtQYeISxZPAgR0t7DWU3DPL UzOfikYaGL4hxLbh+I69CGzrHyFWGzhGOrS2iN8lgT58P+83Hc9nNud8uV6n0tYElh7k PRIA== X-Gm-Message-State: AOJu0YyYojDrlw0i0mZmzwycrQcXj0uiXpYpwbM4bq0Fh5+niveoNjh8 ztsCdT/J8Wtit4VRJXzmUGah8bc1fEXm3y5D0xtNLvabHJXWiKVGL5iOBDwS29vBnQ== X-Gm-Gg: ASbGnctKl7g3m2rww5CJ9kKnu9foDeV0RHGtTZCQZZg8fsuvow483o4dDWUj51bOlNw EZUINR6eK2U8cAhjRFJTsPp1d8hDshtcSrhrhOxEAN/Akh7HgCHTkMjJr4NeTcn7mQgRhUSZXfI J+vw3snmAaAcN96G1wV1VhzxAHQxBoQHrdRpsx5ymepC6Ni5Vun/PR8hNmTtLORqStUS6zt5JTj BwL/WLrh/eHeOwnAHmwlIRJhwvyXPt0jZceICdb68VVoLfOcTvp/tD8tovuiFU= X-Google-Smtp-Source: AGHT+IEiD4WXyWf+LV14fwP57PIuYKAyl0pGITwOH17VYtOQjNegGaLFUX/7qAadDMDazpt+UY7voQ== X-Received: by 2002:a17:90b:5202:b0:2ee:ed1c:e451 with SMTP id 98e67ed59e1d1-2f452e1cc7emr74001647a91.15.1735815008854; Thu, 02 Jan 2025 02:50:08 -0800 (PST) Received: from localhashdata ([2406:da18:9e5:1501:d46d:d5ba:41bc:311f]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2f2ed52dfecsm27911770a91.4.2025.01.02.02.50.07 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 02 Jan 2025 02:50:08 -0800 (PST) Date: Thu, 2 Jan 2025 18:49:26 +0800 From: Zhang Mingli To: pgsql-bugs , =?utf-8?Q?=E8=B0=AD=E5=BF=A0=E6=B6=9B?= Message-ID: In-Reply-To: References: Subject: Re: Incorrect sort result caused by ROLLUP and WHERE operation X-Readdle-Message-ID: c7363f1d-dcc3-4003-bd18-4f80af5be3d7@Spark MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="67766f3b_5ac7e52f_ca4f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --67766f3b_5ac7e52f_ca4f Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Zhang Mingli www.hashdata.xyz Do you mean order of null value (column a) =C2=A0is wrong=3F Use=C2=A0NULLS =46IRST/LAST to order null values. On Jan 2, 2025 at 18:19 +0800, =E8=B0=AD=E5=BF=A0=E6=B6=9B , wrote: > > Case: > create table t1(a int, b int); > insert into t1 values(1,1),(1,2); > select a,b,sum(10) as s from t1 where a =3D 1 group by rollup(a,b) orde= r by a, s desc; --67766f3b_5ac7e52f_ca4f Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi,


Zhang Mingli
www.hashdata.xyz

Do you mean order of null value (colu= mn a) &=23160;is wrong=3F
Use&=23160;NULLS =46IRST/LAST to order null values.
On Jan 2, 2025 at 18:19 +0800, =E8=B0= =AD=E5=BF=A0=E6=B6=9B <zhongtao.tan=40seaboxdata.com>, wrote:
=

Case:
crea= te table t1(a int, b int);<= /span>
inse= rt into t1 values(1,1),(1,2);
sele= ct a,b,sum(10) as s from t1 where a =3D 1 group by rollup(a,b) order by a= , s desc;
--67766f3b_5ac7e52f_ca4f--