You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by as...@apache.org on 2023/11/29 10:58:45 UTC

(doris) branch master updated: [fix](regression)fix parquet data page v2 unstable case (#27753)

This is an automated email from the ASF dual-hosted git repository.

ashingau pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 573f0eaad92 [fix](regression)fix parquet data page v2 unstable case (#27753)
573f0eaad92 is described below

commit 573f0eaad92fc54500650ccee1219543b64e07d1
Author: daidai <20...@qq.com>
AuthorDate: Wed Nov 29 18:58:37 2023 +0800

    [fix](regression)fix parquet data page v2 unstable case (#27753)
---
 .../tvf/test_s3_tvf_parquet_compress.out           | 120 ++++++++++----------
 .../tvf/test_s3_tvf_parquet_compress.groovy        | 124 ++++++++++-----------
 2 files changed, 122 insertions(+), 122 deletions(-)

diff --git a/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out b/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
index bdabe4f2b73..3e0cbc3dad9 100644
--- a/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
+++ b/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
@@ -6,16 +6,16 @@
 -- !gzip_3 --
 
 -- !gzip_4 --
-1564	325	10	143864319215	1.0850098E7	1.8213909835504765E10	false	WNimzJ	FzUmkpokth	rvUeXZDSroGMbmvdAPTWNRwXV	2025-11-05	2023-12-28T05:47:37	44980.17
-1668	491	7	117571775364	9.9940696E7	9.701980510428255E9	false	hICAsLLERWs	PLyzxBOqLx	iAczHecIGIkwPDVzmSDYNIIyo	2024-04-22	2023-12-12T20:16:37	51522.04
-2398	287	1	50023210093	3.3281682E7	1.2771441084116616E9	false	GSxpvBtDs	uYZxmPFnrD	mNnMYQfzuNksmZCDEGMOPJWIo	2021-11-25	2023-12-09T15:39:37	125314.51
-5103	203	5	147767173537	3.2217082E7	1.1398368094759958E10	true	DPAJeMetPhaGcLf	kCQHOseqxM	yFIubHohRHbNtLdTiNQyJLzpX	2024-08-19	2023-12-22T21:16:37	184070.99
-6192	8	4	143947090532	5.5333332E7	1.4477460789058594E10	false	NUSfncaPiVPOWoWy	yiOZtVUmxn	hgFZMFnahwWauiTUDRGcrbHjm	2026-08-10	2023-12-01T10:19:37	86351.44
-6226	75	7	64107996632	2.043812E7	4.68241706778275E9	true	YDJUttKPsJPknJgPCCsQ	OichDrHpbR	JYbDuynhpVcSMMiwklJiHswdS	2027-05-27	2023-12-27T09:59:37	63291.69
-7177	242	10	79143578402	2.1207298E7	3.493073001162331E9	false	IoXxoANRdLzi	JHGiUNthsU	hCmzdYYcmlyEUmUtjKiKpOkHS	2022-03-24	2023-12-13T03:07:37	112661.56
-862	263	1	39973050004	1.9387052E7	4.176116841836267E9	false	lXnSrcNHfgYzHURCw	cMjrYqCetO	XjHjiVpwZskvmqBrRkgcLMTFO	2024-04-30	2023-12-11T04:57:37	5197.78
-9525	387	9	25195785817	5.8421788E7	1.4225957898379774E10	true	XHGfSkbzrK	ENCcNrCbNp	svCnWJvgSCrxXhBJDzqYXfSot	2028-07-24	2023-12-18T12:43:37	139546.08
-9945	163	10	141900020369	3.2400444E7	1.554696451316843E10	true	AlzTfwn	WpLULspqZK	FRufswEdXHiJslGvsBzqppFAb	2024-08-03	2023-12-14T19:02:37	161665.49
+185	193	53	56605217928	5.451878E7	1.9952208284243374E10	false	ylOkeCpMZmsAdfMZKU	SLWxRpdBGB	iqGOSxAYdFcGicLkovFewsIsp	2031-06-05	2023-12-09T04:40:37	94603.01
+295	417	20	148276324771	4.7573584E7	1.606954292368833E10	false	McFVbRNqw	GWLZYJnSAm	JRdtgaVkQFpuQfeShCtmsKQVs	2033-10-21	2023-12-13T14:23:37	103618.10
+352	272	50	132842035948	3.9088484E7	1.4114080886312649E10	false	YStkfSPLEW	ZjhIqBBkqF	VZTwrLVdgfWkfprNXhGgclQKg	2024-05-28	2023-12-24T01:05:37	153759.13
+361	410	73	80944806602	4.0352936E7	1.2128315118429937E10	false	OX	tnYxueTSNX	AYQmNmBAaLGzTfLifPwEQQftT	2020-11-22	2023-12-14T06:01:37	129452.40
+415	215	22	65540407472	3625543.2	1.0412365247547463E9	false	OAfCmDFdnjHq	SSQXXGOcvi	ClHKPGmpfmtJNrapLLvkddEtt	2027-03-27	2023-12-01T06:56:37	152754.22
+49	78	54	26445927221	5.1698004E7	1.4099392773994835E10	false	cRIntlcdDaGWbSGEbaFB	gxwUYJirCB	waWtBfdOtbKMXKaKpbGYEhqFN	2033-08-11	2023-12-15T18:45:37	83181.72
+490	103	54	119509966565	2.4116646E7	1.9869840205733356E10	true	dRqNdTPkzDAbqqmzn	uSrGbvtVdi	QJOncduXQYNfwoMaNDKSnyhcg	2029-07-02	2023-12-25T12:03:37	67311.03
+626	457	47	72797784919	4.8966996E7	2.565888388726609E9	true	uT	aKNykzWDJs	nHrOUfGgcFnnYcKhJbxLhCLIl	2029-02-03	2023-11-29T13:04:37	174501.34
+717	122	27	59784778057	3.564988E7	1.1160980469798027E10	false	odeCVHNGbZUGRl	TVjEIrOOMu	OsRMnfURWsiKKFrQtjyUXmQQn	2020-07-15	2023-12-14T16:51:37	196108.06
+745	325	20	78752727055	1.5183382E7	1.4748467499527681E10	true	RhpEbfrQGGxLL	dYqOOUfWfh	NQQSFeDTyPKGaphBPcUGwlRhm	2021-08-15	2023-12-02T21:28:37	93769.74
 
 -- !gzip_5 --
 
@@ -26,16 +26,16 @@
 -- !lz42_3 --
 
 -- !lz42_4 --
-123	413	41	31256173112	2538895.0	1.210256462227462E10	false	FIYhbaoeYKzioDcSIz	vAREVcDTxz	NaKatTOFKKfeYovtAWbqluYUx	2025-01-09	2023-12-08T05:21:35	555.68
-1542	143	46	108520036928	5.1077408E7	2.0487181788492233E10	false	zdVnykLiePDoSj	pYmTnloWbn	vlTDesIFoKSXWQJmeyErnfwFK	2030-08-08	2023-12-10T00:48:35	148.54
-2266	433	15	105873219227	4.8684736E7	5.265299058631221E9	false	apY	EWkXLOcGmD	DHRGKmaGJWuwwlGIOvclnByns	2033-01-01	2023-12-02T09:51:35	50.23
-2819	271	28	81725301437	9.4405816E7	9.82620901000283E9	true	zebrXdGTGMxroIJo	rQcxNXPrFr	KYvVTfcDEpcmVaQXNZjrJiqvY	2026-11-06	2023-12-06T14:59:35	1384.35
-3268	165	1	142401321962	5.5133996E7	2.5486781033954887E9	false	nCUvMFaXKfKT	gQcpCbLvQL	rRbshNHLVMQfzwQtsZtfaEYHY	2021-02-22	2023-12-06T15:51:35	1327.90
-3926	200	13	30050982563	7862024.5	1.7841214369751728E10	true	zHMdgMgWrRUmRUYip	wgZSJxVesm	LNSmWNNfFPXivwLRNwLnlRCzn	2023-04-09	2023-12-19T09:43:35	409.24
-4203	374	60	122945496780	8.3296E7	1.764882208561375E10	false	RmXtfizgsUDyoCE	CYIzLVHYvD	AEIiIKOATksgORAVpcdSFPBJH	2034-05-31	2023-12-03T17:46:35	326.42
-6529	439	29	73416430566	3.3359424E7	1.949241511173809E10	true	myzr	WtZMVXtpun	pfvgwYcdPwNyqeNjKqphtdXyU	2026-03-31	2023-12-05T20:43:35	872.26
-7888	252	12	144084724700	3.2299228E7	1.8406068854886074E10	false	nbVmBNsQuFTmCrpR	kXNeJxUWsF	aYyEfoELUAQFRlfXJbRrbpcsW	2027-12-02	2023-12-08T01:58:35	714.86
-8850	286	68	31796762044	5.2957636E7	9.745578729562857E9	true	FtClyHG	LLkLmyPxXG	sGGgIBVklPCiupCfQfHNyLiHn	2033-07-05	2023-12-18T11:17:35	1117.50
+12	25	23	37690551367	1739118.0	1.5796150955205643E10	false	CRYGKFUJbGBIe	hzxdvVhixg	dKsFlyxrgmWgUPubvFMiEVAMw	2025-09-25	2023-11-30T09:03:35	191265.80
+13	101	46	114744069847	9.9938768E7	1.4837020807992098E10	false	gfCNYXL	ZbPnzJwYeK	jCbLcczVZCXQLIrWzKLSrzCdP	2021-02-09	2023-12-15T23:15:35	64827.72
+2	185	42	149520919149	3.4833664E7	1.1822608934606503E10	false	IcdmGgK	cEfdjzUnlR	POxVvslyyYrPzvqMnPdIyWsYc	2024-05-12	2023-12-15T17:47:35	142341.23
+26	32	38	60671962182	7531824.5	1.4733848060344421E10	true	KOYetyhzellUqvUVqN	dikJqNhnFx	ndvjDRNIMrJHIvSldXaEvFXLT	2021-09-09	2023-12-10T20:05:35	193323.54
+34	327	13	77750585316	5.2026716E7	1.3565608513727581E10	false	wNPvbSoifnwLtHTqoEi	YZjfEkKIGV	FmUQtlZsMnbGcotsabDCuZzCv	2031-11-30	2023-12-13T19:25:35	66427.85
+34	471	26	135806034349	8076124.0	1.0066063806334663E10	false	rKYxkXtBaGerDm	GVJmQKDnEG	GhZmOjSBgagfERePNKqrfRPZP	2033-02-27	2023-12-09T01:50:35	108043.94
+39	353	62	132230399602	6.4890496E7	1.4364807353729563E10	true	VndnuqCCaOtRKUKWopUp	VlPHqQRqYm	wMidbmfhIEojjzjwECenSMHGs	2027-02-15	2023-12-21T10:23:35	183030.50
+45	26	68	53752579002	8.9017168E7	1.9340340329838943E10	true	OINGDCPkvdhkdmcS	YkepCHrjOr	SZYiGERTakzzzMMKpNQdhqLOc	2030-09-21	2023-12-12T20:08:35	130910.41
+53	72	65	146006164519	6.6903E7	2.0507334388700092E10	false	TPJuvqCXK	qSHjDEfYui	lOZFyOETtUFghsoMcckCdEMcf	2024-06-23	2023-12-13T14:40:35	165043.20
+55	347	32	75539160521	1353359.8	1.2653349834209116E10	false	zkaBxLzoya	bsAfSUONxQ	bdTgPzPbidbAlEaYYKgTckHYn	2030-06-14	2023-11-29T19:10:35	188584.20
 
 -- !no_null_none_1 --
 
@@ -88,16 +88,16 @@
 -- !no_null_snappy_3 --
 
 -- !no_null_snappy_4 --
-1735	271	9	60346027512	7.1809408E7	1.1542596070194454E8	true	PQhXcQjEVEcvB	GNTURsqQPR	uxoVrWvvQpRdURLefjWPqcuym	2031-07-13	2023-12-28T09:29:39	48192.71
-2580	50	58	69249672497	6.85824E7	8.513882709782144E7	false	vVnpuJWDJh	qLonevGdLz	wndtBVgAzlHyCSoEoScfQziYf	2024-12-30	2023-12-10T07:01:39	197543.36
-3763	436	31	107071953533	5.33427E7	9.534465359291871E7	false	QFWLOoIYXgLRug	KLBTuyZUlR	fZIFxGHUYQRikplSkQjZlsqCF	2025-05-30	2023-12-13T00:50:39	26625.70
-5462	472	21	104973629214	9.6762848E7	2.185684504798187E7	false	kwkYBLTUsKDw	OkUwAMMFya	cMhuewGhSxHeoJLQXULzrlCms	2034-06-02	2023-12-02T22:41:39	63617.65
-5474	426	12	42722162752	3.2170124E7	8.804404064844951E7	false	cpq	zscIVsMewJ	ORxiIkBaPyHTMHxlNyfmjChon	2025-08-27	2023-12-21T03:33:39	181825.24
-5857	368	52	40930392551	6.1337756E7	1.023509329427285E8	true	UDzC	PTMXXZsvyE	EMbfwFEmQIbMkfrPKiDVYeHOA	2021-09-19	2023-12-14T15:06:39	43382.62
-6335	247	23	75599898342	9.260008E7	2.7036205338388097E7	true	yEThqFnRPj	EJwgAOLnsm	iLoukKsngncSxxqacAFHnVIqi	2028-09-16	2023-12-09T05:07:39	156419.99
-670	15	14	98662225199	9.1477744E7	6.88714186315456E7	false	DuufJxCIGmoVHSLWP	LuqwUtKFDW	RyCajswEVhOXYIOupVDmJUfqh	2025-12-02	2023-12-22T13:21:39	120131.69
-7733	141	1	52671352949	7.4806392E7	1.110764780477845E7	false	QVmPZWSLpRNPWyD	wuvRYvaFqt	xdvwMENBnAipsOZOBDVgRbLmu	2024-06-03	2023-12-27T17:23:39	118699.19
-9405	409	21	107351298418	1.9931788E7	5.6723663780093096E7	true	ADRhycfiHBGBtvlJeVcb	NUeaftoSmT	HioPrElDQXvaGJJKaBJzOgQxV	2031-04-01	2023-12-24T10:27:39	62226.72
+1	154	47	56558270788	5.4536948E7	1.3217071820869438E10	false	XfvMcpmTrBwVVUFBTfv	UpvjnTPFYK	VCsoIshvMNTdAKzAmrpopbBnR	2025-07-30	2023-12-04T09:05:39	130077.82
+21	279	45	100090340220	5.3739808E7	1.6962735429451965E10	true	vau	YstuEEpUYl	BqDxtlDptzwYLnFbBsHBSyVEj	2031-12-05	2023-12-01T07:26:39	158763.22
+22	147	37	38451482962	5.7348188E7	6.709969882160862E9	false	UsMqGSrPdhvPv	YKKcbDNgAY	XuineFLOuEKDopqiOrRRWFkON	2031-01-08	2023-12-06T01:52:39	62344.33
+26	314	66	48416066859	5.075556E7	1.2613108635303028E10	true	HzZTVwGWlDzZ	lKrSRRzJEk	eLMsGzGoiLirCeHtUkBFTJTJy	2033-03-30	2023-11-28T20:01:39	61085.83
+35	41	6	74116293939	9.5409224E7	3.0375883609755764E9	true	iHalWMyJKwcCcnXIZc	oRmnkittIB	qOoLzOpilUqAOvQBOyYlPoiIr	2034-03-02	2023-12-12T09:21:39	18991.90
+35	96	33	129564598321	5.8018556E7	1.7037885810063845E10	true	gjVoXOHOQndHncvaFQC	WgMShQxLQL	VvyPxLnaEZeOemJbosqSkSvEl	2021-01-31	2023-12-19T08:06:39	152296.20
+36	256	59	34966299569	9.0360968E7	1.6050368291434975E10	false	cxDqSdYXQXcUgizXbq	mQsNaawIJP	pbjcFsDoRAzvmMNphXQoBtmzb	2031-10-27	2023-12-25T21:18:39	140767.55
+4	417	21	32611494638	5.462062E7	2.392456171662606E9	true	JPMliq	ouZEKYBjoH	GNsUsuuGbynVCwJeexZdaQnCl	2027-10-06	2023-12-18T11:43:39	121553.06
+43	179	36	147307082013	3.8981628E7	2.0026077534463943E10	true	JPBDURDCLAbeKg	lurvLFZwae	aVuYHsksMZhapxxdmyfFcDSgd	2020-04-08	2023-12-16T08:12:39	60879.14
+46	281	4	81012784171	5.5589576E7	1.9537200475225827E8	true	LTKJwkcwNdKRfpUxxe	aSgtpzTLKj	ynECHVHsichYRKumIUELddPOl	2031-11-10	2023-12-18T02:30:39	137501.43
 
 -- !none2_1 --
 
@@ -106,16 +106,16 @@
 -- !none2_3 --
 
 -- !none2_4 --
-2900	341	25	10088150880	5.875234E7	1.9284854951681435E10	false	MPqcsUwkAhLhIxW	YLKXNemlov	yqpLcuiwpSwnLpVjFAYvSfNTi	2022-01-07	2023-12-01T21:40:04	190184.28
-4487	495	13	10316747093	1.8574004E7	1.7523820634890663E10	false	kjYchCMTsJoauXDU	NhsQKtYfMa	ljEeEquWuPKYLxlCQCSmyoJBn	2024-12-02	2023-12-08T07:25:04	22883.65
-5013	407	62	10169303340	8.2304232E7	1.3872229599628126E10	true	QCrLjklhO	NnbYgnqDeO	kDVRVqrCjovqAxQrsHGspLJmQ	2020-10-22	2023-12-26T19:59:04	86383.93
-5482	371	36	10287245865	3.3911876E7	9.899660468716501E9	true	Ofy	RYuzpCqRIc	nmoJWtBbOWhSciXIqEkLEtTFS	2022-03-19	2023-12-07T06:53:04	12159.62
-6944	307	35	10118760839	4.9430636E7	8.928666056824632E8	false	ApHXeJos	icTrKTCPxK	RZvXnTYnrYuljysldIRmAcMSC	2023-03-30	2023-12-13T05:17:04	176750.16
-805	425	34	10087075925	3.3842428E7	9.340510350959852E9	false	MFeTfBOFrxtpI	adpglhhSaH	ogFqttOhPHKxDhrPYmQYiHfAu	2033-10-16	2023-12-04T10:43:04	40377.50
-8347	72	45	10263415754	1.7299256E7	1.3399835950398888E8	true	qXGHpJcAvL	czwVIPKiKo	ButfIhNLWrlcBFIoKqHNlgZdN	2022-11-05	2023-12-21T10:56:04	11735.63
-8768	143	35	10146208549	7.8137584E7	8.967516129741959E9	true	CyppoJFFmpNoNxnx	bmlKHaErTd	mWKfQzFZCiAPsJsAKLwWqpEeI	2026-04-05	2023-12-26T19:22:04	165288.57
-9165	340	4	10163157832	3100085.0	2.185136235034098E10	false	yelYDBtfnlnJV	QVlHPpYVQc	DufhLfGcUVjQXtiYZmEjiQrrn	2021-04-07	2023-12-05T22:31:04	185971.87
-9761	110	4	10133304479	3.2209318E7	6.632848353229889E9	false	dUtCFGnLMWbtEg	IMJlPtaOJp	tBDIlqGuEzzXEyVgkYASycvEd	2020-03-05	2023-12-24T15:25:04	79100.17
+10	133	23	110735234104	4.1348184E7	6.724669852415883E9	true	qylrxSiSgrKu	fXIxvHGluy	eklOsykJrnQGIRLaIEelHwdzm	2024-03-02	2023-12-22T05:49:04	176211.72
+11	394	66	99624300897	2.274807E7	4.963466594895596E9	true	mVdYGIMifFUBHNatRyM	KRqNQRaSDg	dylbZDzYyzsqShMkWFpDAYSCU	2021-04-05	2023-12-19T18:30:04	147684.86
+12	477	37	63993096030	5.7643764E7	2.0866619972258877E10	false	wNKtMCuCVaDcwu	WVFlxBfRpW	kwpESPDNaofDFMnOviauLBAIl	2026-12-09	2023-12-08T23:50:04	140885.38
+12	52	50	13187171725	4.328852E7	1.439178560256354E9	false	GfUoPlFQvfNaLdk	HFpbCrThUT	JjjCcBGUUMpkyXRbjrhSYpfSx	2030-06-14	2023-12-26T18:02:04	88542.26
+15	499	46	41312302840	5.216176E7	1.9019488905673557E10	true	tahGGPipseDsw	bHtFJxGJmZ	wQyXJUELxYRbgjbHaVIrUQCks	2029-09-19	2023-11-30T21:09:04	26654.48
+4	160	11	119904143312	6.7974712E7	1.866353471070769E10	true	GNJyKlQlBoDlvy	agZHVaqlIU	SYZxyOTcjCDfaHSksJaoDYxIA	2034-05-15	2023-12-04T18:43:04	130407.15
+41	394	40	49490189808	1.2031474E7	3.1199659364367003E9	false	GLUtKxYhrX	aPyQlkqHsn	KhpRXlHRPHvCbmlRWrpKwYuuX	2024-02-11	2023-12-01T19:02:04	83410.50
+45	439	31	67121611959	3.5429484E7	7.620345797982114E9	false	uhSD	qHGFMshLLp	rONGaSIkJJQPlFBfhBsEwcqMe	2022-02-02	2023-12-04T19:43:04	936.05
+47	290	34	19180961481	2.3980818E7	8.905338300548578E9	false	JynKEvLPvFHGKvyDVv	mScFpzPIrA	BMLACiTfOubXNgJAiVUfhvtVt	2024-06-21	2023-12-16T15:41:04	49807.06
+9	92	36	145734369838	2.6161538E7	1.7063014826469292E10	false	yjeyyDOEgViRwbRVArt	yGxosmUWEC	tqLZwzBiPPltSdbpVChwkWNRF	2025-06-22	2023-12-05T21:26:04	146649.97
 
 -- !none2_5 --
 
@@ -126,16 +126,16 @@
 -- !zstd2_3 --
 
 -- !zstd2_4 --
-1312	340	14	147176897373	6.3653556E7	1.7178218821412378E10	false	eXMf	SJpBpVYWbs	nvxKEbmWqTJFIhCeRHUvRKiGZ	2024-03-02	2023-12-11T18:07:09	123613.01
-2433	340	32	134681184365	1.7680632E7	1.7563484635199E10	false	DhFjIB	npUzPUDfiY	ZrQEgsknIVNRuXbsCtrZxGFSc	2026-03-18	2023-12-22T00:58:09	35433.79
-2491	104	36	112577913121	1834077.0	1.893395865292783E10	false	tglGVhSAklagcHqAGTv	DaAXlKbnfW	AwSQlUAYmxhdISjFjTnZmDTrx	2020-02-29	2023-12-06T20:17:09	29655.53
-3820	157	11	24723365393	2.0236874E7	5.997382284492535E9	false	hhFUUD	XYXpXoWRon	BFrNYOBeYeNxChfVKlfSxFulM	2032-07-15	2023-11-28T14:33:09	64603.31
-5055	336	55	26887547526	6.9563584E7	5.760953396099434E9	false	HMrzLVqDTDZOrTAvny	uqYYmEBWQQ	ZbCUzMghvzBOjdJUutdqppVoD	2034-05-16	2023-12-21T23:56:09	111103.27
-5137	106	43	47754302132	4.8185832E7	1.1526454048268053E10	false	NxOuXWyGyg	kzQtEEToOb	qlNYVnGdYSsrpJzJHrURqzjPg	2027-10-08	2023-12-21T15:41:09	99731.29
-5224	132	41	112455524629	3.3051536E7	9.941947060306278E9	false	nIgnvryfvRbar	ciRFZTrdUT	gnQYthtqWZUhgPHOEGEAuwJlA	2026-03-09	2023-12-09T06:56:09	84164.06
-5793	296	10	52907730760	9.5646328E7	1.1200586288381305E9	false	KxKBVpworG	DiWOJelnFx	xvkUQpaLHqEoXCvpRVgLhCTUu	2034-12-05	2023-12-10T22:23:09	30967.64
-8884	65	74	85010558965	6.6290416E7	1.2063704499794256E10	false	pMPAXZGzVknskKmIlDl	QlGlscSWGY	iqgGtUWNjyliThgZLticgzxqs	2030-12-01	2023-12-04T17:57:09	124538.85
-973	272	63	28184649837	2.170711E7	4.759095368836494E9	false	FGwKfBVzugJ	NHAvnpmlfq	hMglZrwBcMfSXiFLTFVlxjdnD	2024-12-09	2023-12-01T10:29:09	61038.36
+25	108	31	149098682156	4.8272672E7	5.930003546336057E9	true	dAtUCcFxXKk	sQIGXEgYNT	ZPbhiaUnywWcJErUhjWJlTuja	2028-02-17	2023-12-05T13:00:09	104331.10
+25	217	18	114185433037	7.6510376E7	1.0861182565773449E10	false	Dfnwto	wPnPnVkuVc	OxCVhlSZORwnIvoBTUzyZayLF	2019-03-26	2023-12-23T05:47:09	64693.45
+58	331	36	59407318513	1.4188228E7	1.0117605147311861E10	false	kflDCVAYbcs	ipNFhPgRKv	rMRGLlJXRXUnZesnAQboIFmaA	2021-08-17	2023-12-17T15:08:09	183820.26
+65	147	38	21817494173	6070327.5	1.5818161359746944E10	true	RFtD	BsehDZuGNw	QBIDYmMhQvghksPLjTDkXdEvu	2033-08-20	2023-12-17T21:12:09	54614.36
+7	12	47	71342719085	4613431.5	1.3705618365178734E10	true	XenTgJvpZFFiriibVE	oxAlQKcypL	iFNqxDRELyNOWhWEgvhDOUwBs	2033-04-11	2023-12-16T17:33:09	161342.39
+79	95	64	90406816348	8.6113624E7	9.057061555897038E9	true	TuEKTQzaZecgnk	CnTjiGIdvo	KjxJGDlSdpTntCnGgHQWjYeMK	2034-04-14	2023-12-16T18:59:09	176973.77
+81	128	73	25218454317	9.3758232E7	4.90567313620045E9	true	scj	KRJIgLpBZg	xygkYhTRmAmVhXUxSnaseltsb	2028-10-25	2023-11-29T00:41:09	164248.11
+83	52	67	122533885998	3.7610484E7	9.136770151694872E9	true	rzKkvolDCKDKhf	MyDYVefDpx	edPSYNkjtKXmAvqLLLvfhiBzV	2028-09-02	2023-12-20T07:25:09	58108.15
+87	272	39	127196423938	2.3952176E7	7.701823624333466E9	false	xvVAbRaqWwGKmr	OJakVHUwPp	ejlHDXfcoftCkWVyDRsgYmmwi	2030-01-12	2023-12-21T02:11:09	151881.70
+99	252	8	99743310755	5003965.5	1.7335544354242287E10	true	SrXh	oLATQNrFUt	wWrkNwanllbGArJbLtkBtaRRw	2020-12-31	2023-12-16T02:24:09	94944.45
 
 -- !lz4_1 --
 
@@ -160,16 +160,16 @@
 -- !no_null_zstd_4 --
 
 -- !no_null_zstd_5 --
-383	293	51	33044558645	326028.1	2.189678010941299E9	false	kVmBt	EkkVZYfRZD	qCGmOIYzYPxgjqwsygiQuHprk	2020-01-02	2023-12-02T18:56:54	131227.87
-4243	276	48	62445263394	496504.66	1.8498306610117477E10	true	SVzhcQpuPkG	wyOnICYTPN	cwVFEkMXkTftsqiLdVEkWAhLz	2023-12-31	2023-12-11T22:53:54	187918.56
-4840	61	54	26240668018	6438.2705	1.0309399295602386E10	true	zQinQW	TolZiTvbGZ	LivmxkZAvdQKUbIivXtyukcwb	2034-12-29	2023-12-06T00:37:54	5674.70
-5590	139	44	50838994101	422656.72	9.947330937061028E9	false	OZjBLJUcJNIQ	zAddUBuikL	SqnZTmbFrLKJcExUkouadwDZG	2029-12-15	2023-12-23T16:48:54	191558.13
-56	92	48	85501469933	371303.5	1.5374355252136162E10	false	gTFiSJNIIVCUQBmgaqEw	PEyDSWWZSr	IUmVtPmsOzUgGVyBENBEfRAuz	2026-06-02	2023-12-27T06:49:54	76821.40
-8405	166	66	74722925142	415562.88	2.0266805279476093E10	true	XHaglMHPkqEpIyrEoW	PNdFzeFWmU	PvlViKZNwkmhxJYhZEIAABGTM	2029-10-19	2023-12-16T22:38:54	139384.88
-8588	124	57	112514759844	352363.44	8.66651024813605E9	true	PzMOcqHjZSTrT	vTMntQPtzn	WCJZkzWXzyZEqzexQGWVldXGr	2031-03-16	2023-12-27T05:55:54	17153.37
-897	225	67	79324747270	246958.16	1.782671640884806E10	true	WEBxgxcg	VKppIKbyoT	jnzGJxHnxybhJAqGDrwsruRwg	2029-11-18	2023-11-30T12:55:54	5301.50
-9378	239	37	101475897296	597503.9	7.616898174341047E9	false	jBMZF	mOWgZRkuJE	SztNODvhaKzpFYGDpAUwanUgz	2034-04-18	2023-12-23T15:06:54	176903.62
-9960	216	63	16070096189	376901.34	1.195508798637962E10	false	LLOnSN	eGDMZgazSV	hpIzhEgnKeiXEoytKKDIMwmwB	2029-07-15	2023-12-03T14:54:54	180721.58
+15	248	15	21558482213	6487986.5	1.0939869723964705E9	true	RJTQHTtGIHlKVlzk	FcbxoaqqpI	WJucDRirckTPgbZLjsEKplAWn	2024-08-13	2023-11-30T01:25:54	34141.57
+25	83	72	149711605439	6.2890304E7	7.440117092023224E9	false	hjXuMtPQ	VZqPglUMPk	HbNzdUJAHaizFkXxNEYBYPYCf	2019-11-18	2023-12-12T03:05:54	86166.27
+28	462	50	99515493604	1.0113E8	1.5197217619216759E10	true	VaRiy	RUZwanoIXS	wGJmjlsrtktJGzGTvtRleomHv	2020-09-28	2023-12-20T03:23:54	160536.09
+35	72	32	15905879451	8.3402976E7	2.174744968486151E10	false	zkd	dQkISTxetN	gpbemtjhvejdkPDXyDjjrWXrG	2028-02-21	2023-12-21T17:19:54	181969.97
+39	104	67	102858005915	3883196.2	7.698795111611849E9	false	oANcFYcWwftK	riOYGAuzYa	jBrKXHbKuRgqJQUyiorbcVmEc	2028-09-17	2023-12-05T03:11:54	58245.11
+41	102	53	81432267997	8.3292832E7	1.832442879595766E10	false	qtwQtWGokDPkkCzfO	nwrNOwzvSF	qXNCoYVdIEoEdVhMXUsUoXBWf	2024-12-31	2023-12-08T16:26:54	143405.87
+43	66	31	103368561997	4.2050856E7	1.7742240298212337E10	false	WxcDOdxJl	kXpBppqAlP	sSltbkkDZdIRDSzHOxJgsMtOl	2029-04-15	2023-12-20T01:49:54	84059.39
+47	442	43	113416931027	7.6058776E7	4.766215418628829E9	false	CFdWIVEcmp	TUBoxBcSfR	wnbIuqmKRHfZJWzzvmpEnwDic	2033-01-08	2023-11-29T07:52:54	82430.94
+8	181	34	95477376121	7.5397792E7	1.6273298833350899E10	false	vkgWftEsKYXEliikl	TNwWzMduUG	AImvOcOGQjanpfPhWQzNcEfds	2024-04-25	2023-12-28T10:11:54	66374.37
+9	388	37	141886807584	9965839.0	4.2909144426083784E9	true	DIvqtxxgyUr	SrTKPJUfzO	YPfKKFCOPSMQeePQvFCACzeSG	2025-11-22	2023-12-02T22:55:54	189986.54
 
 -- !no_null_zstd_6 --
 
diff --git a/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy b/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
index 66ad6118a10..e8ca08811f0 100644
--- a/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
@@ -35,7 +35,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint > 607 and col_string = 'CyGmiNdrY' order by col_bigint , col_string limit 10 ;
+                )where col_bigint > 607 and col_string = 'CyGmiNdrY' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip_2 """
     select * from 
@@ -45,7 +45,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint > 752 and  col_float = 0.3 order by col_bigint , col_float limit 10 ;
+                )where col_bigint > 752 and  col_float = 0.3 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip_3 """
     select * from 
@@ -55,7 +55,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'TaOCwaPcNfGeNxMqi' and col_boolean = 680 and col_int = 1953 order by col_char , col_boolean , col_int limit 10 ;
+                )where col_char = 'TaOCwaPcNfGeNxMqi' and col_boolean = 680 and col_int = 1953 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip_4 """
     select * from 
@@ -65,7 +65,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_tinyint < 1423 order by col_tinyint limit 10 ;
+                )where col_tinyint < 1423 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip_5 """
     select * from 
@@ -75,7 +75,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float = 2.5 order by col_float limit 10 ;
+                )where  col_float = 2.5 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz42_1 """
     select * from 
@@ -85,7 +85,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal = 0.8 order by col_decimal limit 10 ;
+                )where  col_decimal = 0.8 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz42_2 """
     select * from 
@@ -95,7 +95,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'MVAhYjsZf' and  col_decimal < 2.3 and  col_float = 2.7 order by col_char , col_decimal , col_float limit 10 ;
+                )where col_char = 'MVAhYjsZf' and  col_decimal < 2.3 and  col_float = 2.7 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz42_3 """
     select * from 
@@ -105,7 +105,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_tinyint < 32 and col_char = 'Ja' order by col_tinyint , col_char limit 10 ;
+                )where col_tinyint < 32 and col_char = 'Ja' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz42_4 """
     select * from 
@@ -115,7 +115,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal > 1.6 order by col_decimal limit 10 ;
+                )where  col_decimal > 1.6 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_none_1 """
     select * from 
@@ -125,7 +125,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_varchar = 'gLmEXgvqlm' and col_smallint < 1271 order by col_varchar , col_smallint limit 10 ;
+                )where col_varchar = 'gLmEXgvqlm' and col_smallint < 1271 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_none_2 """
     select * from 
@@ -135,7 +135,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_tinyint > 1288 order by col_tinyint limit 10 ;
+                )where col_tinyint > 1288 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_none_3 """
     select * from 
@@ -145,7 +145,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_string = 'jTFdDLHZK' and year(col_date)=2016 order by col_string , col_date limit 10 ;
+                )where col_string = 'jTFdDLHZK' and year(col_date)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_none_4 """
     select * from 
@@ -155,7 +155,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_timestamp)=2016 order by col_timestamp limit 10 ;
+                )where year(col_timestamp)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_none_5 """
     select * from 
@@ -165,7 +165,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'qHqL' order by col_char limit 10 ;
+                )where col_char = 'qHqL' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_1 """
     select * from 
@@ -175,7 +175,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float = 0.3 order by col_float limit 10 ;
+                )where  col_float = 0.3 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_2 """
     select * from 
@@ -185,7 +185,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint < 50 and  col_float < 1.6 order by col_bigint , col_float limit 10 ;
+                )where col_bigint < 50 and  col_float < 1.6 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_3 """
     select * from 
@@ -195,7 +195,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_boolean > 314 order by col_boolean limit 10 ;
+                )where col_boolean > 314 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_4 """
     select * from 
@@ -205,7 +205,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_boolean = 1240 and  col_decimal < 0.8 and  col_float < 1.4 order by col_boolean , col_decimal , col_float limit 10 ;
+                )where col_boolean = 1240 and  col_decimal < 0.8 and  col_float < 1.4 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_5 """
     select * from 
@@ -215,7 +215,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'doB' order by col_char limit 10 ;
+                )where col_char = 'doB' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none_6 """
     select * from 
@@ -225,7 +225,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_double = 2.4 and col_varchar = 'OlykmDCvDpdh' and col_boolean > 1449 order by col_double , col_varchar , col_boolean limit 10 ;
+                )where  col_double = 2.4 and col_varchar = 'OlykmDCvDpdh' and col_boolean > 1449 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy2_1 """
     select * from 
@@ -235,7 +235,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_timestamp)=2016 and col_boolean > 1011 and col_smallint < 780 order by col_timestamp , col_boolean , col_smallint limit 10 ;
+                )where year(col_timestamp)=2016 and col_boolean > 1011 and col_smallint < 780 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy2_2 """
     select * from 
@@ -245,7 +245,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal = 1.4 order by col_decimal limit 10 ;
+                )where  col_decimal = 1.4 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy2_3 """
     select * from 
@@ -255,7 +255,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float > 1.8 and  col_double < 2.0 order by col_float , col_double limit 10 ;
+                )where  col_float > 1.8 and  col_double < 2.0 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy2_4 """
     select * from 
@@ -265,7 +265,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_double = 1.0 and col_varchar = 'YpajmCZhNSTaHwOriViw' and col_char = 'Syavtn' order by col_double , col_varchar , col_char limit 10 ;
+                )where  col_double = 1.0 and col_varchar = 'YpajmCZhNSTaHwOriViw' and col_char = 'Syavtn' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip2_1 """
     select * from 
@@ -275,7 +275,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_int = 1795 and col_smallint > 1239 order by col_int , col_smallint limit 10 ;
+                )where col_int = 1795 and col_smallint > 1239 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip2_2 """
     select * from 
@@ -285,7 +285,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_int = 1812 and col_bigint < 1976 and  col_float < 2.2 order by col_int , col_bigint , col_float limit 10 ;
+                )where col_int = 1812 and col_bigint < 1976 and  col_float < 2.2 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip2_3 """
     select * from 
@@ -295,7 +295,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float > 1.4 and col_tinyint > 1799 and  col_decimal > 0.3 order by col_float , col_tinyint , col_decimal limit 10 ;
+                )where  col_float > 1.4 and col_tinyint > 1799 and  col_decimal > 0.3 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_gzip2_4 """
     select * from 
@@ -305,7 +305,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_timestamp)=2016 and col_bigint > 1938 order by col_timestamp , col_bigint limit 10 ;
+                )where year(col_timestamp)=2016 and col_bigint > 1938 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_gzip_1 """
     select * from 
@@ -315,7 +315,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint = 1426 and col_varchar = 'NcXlcfnRpO' order by col_bigint , col_varchar limit 10 ;
+                )where col_bigint = 1426 and col_varchar = 'NcXlcfnRpO' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_gzip_2 """
     select * from 
@@ -325,7 +325,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float = 1.8 and col_string = 'khbrpZBfNbFP' order by col_float , col_string limit 10 ;
+                )where  col_float = 1.8 and col_string = 'khbrpZBfNbFP' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_gzip_3 """
     select * from 
@@ -335,7 +335,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_double < 0.3 and  col_float < 0.3 and col_bigint < 1642 order by col_double , col_float , col_bigint limit 10 ;
+                )where  col_double < 0.3 and  col_float < 0.3 and col_bigint < 1642 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_snappy_1 """
     select * from 
@@ -345,7 +345,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_varchar = 'DdYENcTybQV' and col_boolean < 1004 order by col_varchar , col_boolean limit 10 ;
+                )where col_varchar = 'DdYENcTybQV' and col_boolean < 1004 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_snappy_2 """
     select * from 
@@ -355,7 +355,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'bcuSohgIFYKTMVv' and year(col_date)=2016 order by col_char , col_date limit 10 ;
+                )where col_char = 'bcuSohgIFYKTMVv' and year(col_date)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_snappy_3 """
     select * from 
@@ -365,7 +365,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_tinyint = 693 and col_varchar = 'qHnjmUWAaKcpAn' and year(col_timestamp)=2016 order by col_tinyint , col_varchar , col_timestamp limit 10 ;
+                )where col_tinyint = 693 and col_varchar = 'qHnjmUWAaKcpAn' and year(col_timestamp)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_snappy_4 """
     select * from 
@@ -375,7 +375,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_double > 2.3 order by col_double limit 10 ;
+                )where  col_double > 2.3 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none2_1 """
     select * from 
@@ -385,7 +385,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal < 0.2 order by col_decimal limit 10 ;
+                )where  col_decimal < 0.2 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none2_2 """
     select * from 
@@ -395,7 +395,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_boolean > 1693 and col_varchar = 'YowzLFscqYmYB' and col_char = 'CJ' order by col_boolean , col_varchar , col_char limit 10 ;
+                )where col_boolean > 1693 and col_varchar = 'YowzLFscqYmYB' and col_char = 'CJ' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none2_3 """
     select * from 
@@ -405,7 +405,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'WGSpFnLYSPVTlyl' and year(col_date)=2016 and col_string = 'fmhUKNb' order by col_char , col_date , col_string limit 10 ;
+                )where col_char = 'WGSpFnLYSPVTlyl' and year(col_date)=2016 and col_string = 'fmhUKNb' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none2_4 """
     select * from 
@@ -415,7 +415,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint > 1841 order by col_bigint limit 10 ;
+                )where col_bigint > 1841 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_none2_5 """
     select * from 
@@ -425,7 +425,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_date)=2016 order by col_date limit 10 ;
+                )where year(col_date)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_zstd2_1 """
     select * from 
@@ -435,7 +435,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_timestamp)=2016 and col_smallint = 130 order by col_timestamp , col_smallint limit 10 ;
+                )where year(col_timestamp)=2016 and col_smallint = 130 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_zstd2_2 """
     select * from 
@@ -445,7 +445,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal > 2.0 and col_tinyint = 1662 and col_bigint < 1224 order by col_decimal , col_tinyint , col_bigint limit 10 ;
+                )where  col_decimal > 2.0 and col_tinyint = 1662 and col_bigint < 1224 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_zstd2_3 """
     select * from 
@@ -455,7 +455,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_smallint > 615 and col_int > 1410 order by col_smallint , col_int limit 10 ;
+                )where col_smallint > 615 and col_int > 1410 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_zstd2_4 """
     select * from 
@@ -465,7 +465,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_boolean < 128 order by col_boolean limit 10 ;
+                )where col_boolean < 128 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz4_1 """
     select * from 
@@ -475,7 +475,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_varchar = 'qirvWjuTAgAPrzjlcU' and  col_float < 0.9 order by col_varchar , col_float limit 10 ;
+                )where col_varchar = 'qirvWjuTAgAPrzjlcU' and  col_float < 0.9 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz4_2 """
     select * from 
@@ -485,7 +485,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'YNT' and col_string = 'iLZNgqK' order by col_char , col_string limit 10 ;
+                )where col_char = 'YNT' and col_string = 'iLZNgqK' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_lz4_3 """
     select * from 
@@ -495,7 +495,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_date)=2016 and col_tinyint > 1491 and col_int > 342 order by col_date , col_tinyint , col_int limit 10 ;
+                )where year(col_date)=2016 and col_tinyint > 1491 and col_int > 342 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_lz4_1 """
     select * from 
@@ -505,7 +505,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_decimal > 2.5 and year(col_timestamp)=2016 order by col_decimal , col_timestamp limit 10 ;
+                )where  col_decimal > 2.5 and year(col_timestamp)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_lz4_2 """
     select * from 
@@ -515,7 +515,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_date)=2016 and col_int > 166 order by col_date , col_int limit 10 ;
+                )where year(col_date)=2016 and col_int > 166 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_lz4_3 """
     select * from 
@@ -525,7 +525,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'YN' and col_string = 'XBnUNfbPCijQSaxwKLh' order by col_char , col_string limit 10 ;
+                )where col_char = 'YN' and col_string = 'XBnUNfbPCijQSaxwKLh' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_lz4_4 """
     select * from 
@@ -535,7 +535,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_boolean = 27 and col_string = 'VYDMZZ' and year(col_date)=2016 order by col_boolean , col_string , col_date limit 10 ;
+                )where col_boolean = 27 and col_string = 'VYDMZZ' and year(col_date)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_1 """
     select * from 
@@ -545,7 +545,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_int = 1361 order by col_int limit 10 ;
+                )where col_int = 1361 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_2 """
     select * from 
@@ -555,7 +555,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint = 516 and col_varchar = 'rxqicLIhJEykBOEmr' and col_char = 'sioJZDxWfjFkTsO' order by col_bigint , col_varchar , col_char limit 10 ;
+                )where col_bigint = 516 and col_varchar = 'rxqicLIhJEykBOEmr' and col_char = 'sioJZDxWfjFkTsO' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_3 """
     select * from 
@@ -565,7 +565,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where year(col_timestamp)=2016 and col_char = 'NSKJPkGHUSXVDD' order by col_timestamp , col_char limit 10 ;
+                )where year(col_timestamp)=2016 and col_char = 'NSKJPkGHUSXVDD' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_4 """
     select * from 
@@ -575,7 +575,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint < 886 and year(col_timestamp)=2016 order by col_bigint , col_timestamp limit 10 ;
+                )where col_bigint < 886 and year(col_timestamp)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_5 """
     select * from 
@@ -585,7 +585,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float > 0.5 order by col_float limit 10 ;
+                )where  col_float > 0.5 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_no_null_zstd_6 """
     select * from 
@@ -595,7 +595,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_char = 'VyUYzxhFtq' and col_varchar = 'OJfigYX' and col_string = 'EzFjFJEWXuOdG' order by col_char , col_varchar , col_string limit 10 ;
+                )where col_char = 'VyUYzxhFtq' and col_varchar = 'OJfigYX' and col_string = 'EzFjFJEWXuOdG' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy_1 """
     select * from 
@@ -605,7 +605,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float = 1.0 and year(col_timestamp)=2016 and col_boolean < 1328 order by col_float , col_timestamp , col_boolean limit 10 ;
+                )where  col_float = 1.0 and year(col_timestamp)=2016 and col_boolean < 1328 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy_2 """
     select * from 
@@ -615,7 +615,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where  col_float < 1.8 and year(col_date)=2016 order by col_float , col_date limit 10 ;
+                )where  col_float < 1.8 and year(col_date)=2016 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy_3 """
     select * from 
@@ -625,7 +625,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_bigint = 949 order by col_bigint limit 10 ;
+                )where col_bigint = 949 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy_4 """
     select * from 
@@ -635,7 +635,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_string = 'rq' and col_varchar = 'pinxLaVk' and  col_decimal < 2.3 order by col_string , col_varchar , col_decimal limit 10 ;
+                )where col_string = 'rq' and col_varchar = 'pinxLaVk' and  col_decimal < 2.3 order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
     order_qt_snappy_5 """
     select * from 
@@ -645,7 +645,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
                 "s3.secret_key" = "${sk}",     
                 "REGION" = "${region}",    
                 "FORMAT" = "parquet"
-                )where col_tinyint > 628 and col_varchar = 'xQWHzZPhLlCM' order by col_tinyint , col_varchar limit 10 ;
+                )where col_tinyint > 628 and col_varchar = 'xQWHzZPhLlCM' order by col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp limit 10;
     """
 
 }
\ No newline at end of file


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org