1. [FAILURE] test_sql_cases.TestSQLCases.test_agg_state_table_with_all_functions Element counts were not equal: Diff is 20927 characters long. Set self.maxDiff to None to see it. : sql result not match: - [SQL]: select k1, array_agg_distinct_merge(v0),array_agg_distinct_merge(v1),array_agg_distinct_merge(v2),array_agg_distinct_merge(v3),array_agg_distinct_merge(v4),array_agg_distinct_merge(v5),array_agg_distinct_merge(v6),array_agg_distinct_merge(v7),array_agg_distinct_merge(v8),array_agg_distinct_merge(v9),array_agg_distinct_merge(v10),array_agg_distinct_merge(v11),array_agg_distinct_merge(v12),array_agg_distinct_merge(v13),percentile_approx_merge(v14),percentile_approx_merge(v15),covar_pop_merge(v16),covar_pop_merge(v17),covar_pop_merge(v18),covar_pop_merge(v19),covar_pop_merge(v20),covar_pop_merge(v21),covar_pop_merge(v22),covar_pop_merge(v23),count_merge(v24),count_merge(v25),count_merge(v26),count_merge(v27),count_merge(v28),count_merge(v29),count_merge(v30),count_merge(v31),count_merge(v32),count_merge(v33),count_merge(v34),count_merge(v35),count_merge(v36),count_merge(v37),count_merge(v38),count_merge(v39),count_merge(v40),count_merge(v41),count_merge(v42),array_unique_agg_merge(v43),array_unique_agg_merge(v44),array_unique_agg_merge(v45),array_unique_agg_merge(v46),array_unique_agg_merge(v47),array_unique_agg_merge(v48),array_unique_agg_merge(v49),array_unique_agg_merge(v50),array_unique_agg_merge(v51),array_unique_agg_merge(v52),array_unique_agg_merge(v53),array_unique_agg_merge(v54),array_unique_agg_merge(v55),array_unique_agg_merge(v56),array_unique_agg_merge(v57),percentile_disc_merge(v58),percentile_disc_merge(v59),percentile_disc_merge(v60),percentile_disc_merge(v61),percentile_disc_merge(v62),percentile_disc_merge(v63),percentile_disc_merge(v64),percentile_disc_merge(v65),percentile_disc_merge(v66),percentile_disc_merge(v67),percentile_disc_merge(v68),percentile_disc_merge(v69),percentile_disc_merge(v70),percentile_disc_merge(v71),multi_distinct_count_merge(v72),multi_distinct_count_merge(v73),multi_distinct_count_merge(v74),multi_distinct_count_merge(v75),multi_distinct_count_merge(v76),multi_distinct_count_merge(v77),multi_distinct_count_merge(v78),multi_distinct_count_merge(v79),multi_distinct_count_merge(v80),multi_distinct_count_merge(v81),multi_distinct_count_merge(v82),multi_distinct_count_merge(v83),multi_distinct_count_merge(v84),multi_distinct_count_merge(v85),array_agg_merge(v86),stddev_samp_merge(v87),stddev_samp_merge(v88),stddev_samp_merge(v89),stddev_samp_merge(v90),stddev_samp_merge(v91),stddev_samp_merge(v92),stddev_samp_merge(v93),stddev_samp_merge(v94),mann_whitney_u_test_merge(v95),mann_whitney_u_test_merge(v96),mann_whitney_u_test_merge(v97),max_merge(v98),max_merge(v99),max_merge(v100),max_merge(v101),max_merge(v102),max_merge(v103),max_merge(v104),max_merge(v105),max_merge(v106),max_merge(v107),max_merge(v108),max_merge(v109),max_merge(v110),max_merge(v111),ds_hll_count_distinct_merge(v112),ds_hll_count_distinct_merge(v113),ds_hll_count_distinct_merge(v114),ds_hll_count_distinct_merge(v115),ds_hll_count_distinct_merge(v116),ds_hll_count_distinct_merge(v117),ds_hll_count_distinct_merge(v118),ds_hll_count_distinct_merge(v119),ds_hll_count_distinct_merge(v120),ds_hll_count_distinct_merge(v121),ds_hll_count_distinct_merge(v122),ds_hll_count_distinct_merge(v123),ds_hll_count_distinct_merge(v124),ds_hll_count_distinct_merge(v125),ds_hll_count_distinct_merge(v126),ds_hll_count_distinct_merge(v127),ds_hll_count_distinct_merge(v128),ds_hll_count_distinct_merge(v129),ds_hll_count_distinct_merge(v130),ds_hll_count_distinct_merge(v131),ds_hll_count_distinct_merge(v132),ds_hll_count_distinct_merge(v133),ds_hll_count_distinct_merge(v134),ds_hll_count_distinct_merge(v135),ds_hll_count_distinct_merge(v136),ds_hll_count_distinct_merge(v137),ds_hll_count_distinct_merge(v138),ds_hll_count_distinct_merge(v139),ds_hll_count_distinct_merge(v140),ds_hll_count_distinct_merge(v141),ds_hll_count_distinct_merge(v142),ds_hll_count_distinct_merge(v143),ds_hll_count_distinct_merge(v144),ds_hll_count_distinct_merge(v145),ds_hll_count_distinct_merge(v146),ds_hll_count_distinct_merge(v147),ds_hll_count_distinct_merge(v148),ds_hll_count_distinct_merge(v149),ds_hll_count_distinct_merge(v150),ds_hll_count_distinct_merge(v151),ds_hll_count_distinct_merge(v152),ds_hll_count_distinct_merge(v153),ndv_merge(v154),ndv_merge(v155),ndv_merge(v156),ndv_merge(v157),ndv_merge(v158),ndv_merge(v159),ndv_merge(v160),ndv_merge(v161),ndv_merge(v162),ndv_merge(v163),ndv_merge(v164),ndv_merge(v165),ndv_merge(v166),ndv_merge(v167),stddev_merge(v168),stddev_merge(v169),stddev_merge(v170),stddev_merge(v171),stddev_merge(v172),stddev_merge(v173),stddev_merge(v174),stddev_merge(v175),covar_samp_merge(v176),covar_samp_merge(v177),covar_samp_merge(v178),covar_samp_merge(v179),covar_samp_merge(v180),covar_samp_merge(v181),covar_samp_merge(v182),covar_samp_merge(v183),bitmap_agg_merge(v184),bitmap_agg_merge(v185),bitmap_agg_merge(v186),bitmap_agg_merge(v187),bitmap_agg_merge(v188),bitmap_agg_merge(v189),std_merge(v190),std_merge(v191),std_merge(v192),std_merge(v193),std_merge(v194),std_merge(v195),std_merge(v196),std_merge(v197),sum_merge(v198),sum_merge(v199),sum_merge(v200),sum_merge(v201),sum_merge(v202),sum_merge(v203),sum_merge(v204),sum_merge(v205),sum_merge(v206),sum_merge(v207),approx_count_distinct_merge(v208),approx_count_distinct_merge(v209),approx_count_distinct_merge(v210),approx_count_distinct_merge(v211),approx_count_distinct_merge(v212),approx_count_distinct_merge(v213),approx_count_distinct_merge(v214),approx_count_distinct_merge(v215),approx_count_distinct_merge(v216),approx_count_distinct_merge(v217),approx_count_distinct_merge(v218),approx_count_distinct_merge(v219),approx_count_distinct_merge(v220),approx_count_distinct_merge(v221),min_merge(v222),min_merge(v223),min_merge(v224),min_merge(v225),min_merge(v226),min_merge(v227),min_merge(v228),min_merge(v229),min_merge(v230),min_merge(v231),min_merge(v232),min_merge(v233),min_merge(v234),min_merge(v235),retention_merge(v236),max_by_merge(v237),max_by_merge(v238),max_by_merge(v239),max_by_merge(v240),max_by_merge(v241),max_by_merge(v242),max_by_merge(v243),max_by_merge(v244),max_by_merge(v245),max_by_merge(v246),max_by_merge(v247),max_by_merge(v248),max_by_merge(v249),max_by_merge(v250),max_by_merge(v251),max_by_merge(v252),max_by_merge(v253),max_by_merge(v254),max_by_merge(v255),max_by_merge(v256),max_by_merge(v257),max_by_merge(v258),max_by_merge(v259),max_by_merge(v260),max_by_merge(v261),max_by_merge(v262),max_by_merge(v263),max_by_merge(v264),max_by_merge(v265),max_by_merge(v266),max_by_merge(v267),max_by_merge(v268),max_by_merge(v269),max_by_merge(v270),max_by_merge(v271),max_by_merge(v272),max_by_merge(v273),max_by_merge(v274),max_by_merge(v275),max_by_merge(v276),max_by_merge(v277),max_by_merge(v278),max_by_merge(v279),max_by_merge(v280),max_by_merge(v281),max_by_merge(v282),max_by_merge(v283),max_by_merge(v284),max_by_merge(v285),max_by_merge(v286),max_by_merge(v287),max_by_merge(v288),max_by_merge(v289),max_by_merge(v290),max_by_merge(v291),max_by_merge(v292),max_by_merge(v293),max_by_merge(v294),max_by_merge(v295),max_by_merge(v296),max_by_merge(v297),max_by_merge(v298),max_by_merge(v299),max_by_merge(v300),max_by_merge(v301),max_by_merge(v302),max_by_merge(v303),max_by_merge(v304),max_by_merge(v305),max_by_merge(v306),max_by_merge(v307),max_by_merge(v308),max_by_merge(v309),max_by_merge(v310),max_by_merge(v311),max_by_merge(v312),max_by_merge(v313),max_by_merge(v314),max_by_merge(v315),max_by_merge(v316),max_by_merge(v317),max_by_merge(v318),max_by_merge(v319),max_by_merge(v320),max_by_merge(v321),max_by_merge(v322),max_by_merge(v323),max_by_merge(v324),max_by_merge(v325),max_by_merge(v326),max_by_merge(v327),max_by_merge(v328),max_by_merge(v329),max_by_merge(v330),max_by_merge(v331),max_by_merge(v332),max_by_merge(v333),max_by_merge(v334),max_by_merge(v335),max_by_merge(v336),max_by_merge(v337),max_by_merge(v338),max_by_merge(v339),max_by_merge(v340),max_by_merge(v341),max_by_merge(v342),max_by_merge(v343),max_by_merge(v344),max_by_merge(v345),max_by_merge(v346),max_by_merge(v347),max_by_merge(v348),max_by_merge(v349),max_by_merge(v350),max_by_merge(v351),max_by_merge(v352),max_by_merge(v353),max_by_merge(v354),max_by_merge(v355),max_by_merge(v356),max_by_merge(v357),max_by_merge(v358),max_by_merge(v359),max_by_merge(v360),max_by_merge(v361),max_by_merge(v362),max_by_merge(v363),max_by_merge(v364),max_by_merge(v365),max_by_merge(v366),max_by_merge(v367),max_by_merge(v368),max_by_merge(v369),max_by_merge(v370),max_by_merge(v371),max_by_merge(v372),max_by_merge(v373),max_by_merge(v374),max_by_merge(v375),max_by_merge(v376),max_by_merge(v377),max_by_merge(v378),max_by_merge(v379),max_by_merge(v380),max_by_merge(v381),max_by_merge(v382),max_by_merge(v383),max_by_merge(v384),max_by_merge(v385),max_by_merge(v386),max_by_merge(v387),max_by_merge(v388),max_by_merge(v389),max_by_merge(v390),max_by_merge(v391),max_by_merge(v392),max_by_merge(v393),max_by_merge(v394),max_by_merge(v395),max_by_merge(v396),max_by_merge(v397),max_by_merge(v398),max_by_merge(v399),max_by_merge(v400),max_by_merge(v401),max_by_merge(v402),max_by_merge(v403),max_by_merge(v404),max_by_merge(v405),max_by_merge(v406),max_by_merge(v407),max_by_merge(v408),max_by_merge(v409),max_by_merge(v410),max_by_merge(v411),max_by_merge(v412),max_by_merge(v413),max_by_merge(v414),max_by_merge(v415),max_by_merge(v416),max_by_merge(v417),max_by_merge(v418),max_by_merge(v419),max_by_merge(v420),max_by_merge(v421),max_by_merge(v422),max_by_merge(v423),max_by_merge(v424),max_by_merge(v425),max_by_merge(v426),max_by_merge(v427),max_by_merge(v428),max_by_merge(v429),max_by_merge(v430),max_by_merge(v431),max_by_merge(v432),max_by_merge(v433),max_by_merge(v434),max_by_merge(v435),max_by_merge(v436),max_by_merge(v437),max_by_merge(v438),max_by_merge(v439),max_by_merge(v440),max_by_merge(v441),max_by_merge(v442),max_by_merge(v443),max_by_merge(v444),max_by_merge(v445),max_by_merge(v446),min_by_merge(v447),min_by_merge(v448),min_by_merge(v449),min_by_merge(v450),min_by_merge(v451),min_by_merge(v452),min_by_merge(v453),min_by_merge(v454),min_by_merge(v455),min_by_merge(v456),min_by_merge(v457),min_by_merge(v458),min_by_merge(v459),min_by_merge(v460),min_by_merge(v461),min_by_merge(v462),min_by_merge(v463),min_by_merge(v464),min_by_merge(v465),min_by_merge(v466),min_by_merge(v467),min_by_merge(v468),min_by_merge(v469),min_by_merge(v470),min_by_merge(v471),min_by_merge(v472),min_by_merge(v473),min_by_merge(v474),min_by_merge(v475),min_by_merge(v476),min_by_merge(v477),min_by_merge(v478),min_by_merge(v479),min_by_merge(v480),min_by_merge(v481),min_by_merge(v482),min_by_merge(v483),min_by_merge(v484),min_by_merge(v485),min_by_merge(v486),min_by_merge(v487),min_by_merge(v488),min_by_merge(v489),min_by_merge(v490),min_by_merge(v491),min_by_merge(v492),min_by_merge(v493),min_by_merge(v494),min_by_merge(v495),min_by_merge(v496),min_by_merge(v497),min_by_merge(v498),min_by_merge(v499),min_by_merge(v500),min_by_merge(v501),min_by_merge(v502),min_by_merge(v503),min_by_merge(v504),min_by_merge(v505),min_by_merge(v506),min_by_merge(v507),min_by_merge(v508),min_by_merge(v509),min_by_merge(v510),min_by_merge(v511),min_by_merge(v512),min_by_merge(v513),min_by_merge(v514),min_by_merge(v515),min_by_merge(v516),min_by_merge(v517),min_by_merge(v518),min_by_merge(v519),min_by_merge(v520),min_by_merge(v521),min_by_merge(v522),min_by_merge(v523),min_by_merge(v524),min_by_merge(v525),min_by_merge(v526),min_by_merge(v527),min_by_merge(v528),min_by_merge(v529),min_by_merge(v530),min_by_merge(v531),min_by_merge(v532),min_by_merge(v533),min_by_merge(v534),min_by_merge(v535),min_by_merge(v536),min_by_merge(v537),min_by_merge(v538),min_by_merge(v539),min_by_merge(v540),min_by_merge(v541),min_by_merge(v542),min_by_merge(v543),min_by_merge(v544),min_by_merge(v545),min_by_merge(v546),min_by_merge(v547),min_by_merge(v548),min_by_merge(v549),min_by_merge(v550),min_by_merge(v551),min_by_merge(v552),min_by_merge(v553),min_by_merge(v554),min_by_merge(v555),min_by_merge(v556),min_by_merge(v557),min_by_merge(v558),min_by_merge(v559),min_by_merge(v560),min_by_merge(v561),min_by_merge(v562),min_by_merge(v563),min_by_merge(v564),min_by_merge(v565),min_by_merge(v566),min_by_merge(v567),min_by_merge(v568),min_by_merge(v569),min_by_merge(v570),min_by_merge(v571),min_by_merge(v572),min_by_merge(v573),min_by_merge(v574),min_by_merge(v575),min_by_merge(v576),min_by_merge(v577),min_by_merge(v578),min_by_merge(v579),min_by_merge(v580),min_by_merge(v581),min_by_merge(v582),min_by_merge(v583),min_by_merge(v584),min_by_merge(v585),min_by_merge(v586),min_by_merge(v587),min_by_merge(v588),min_by_merge(v589),min_by_merge(v590),min_by_merge(v591),min_by_merge(v592),min_by_merge(v593),min_by_merge(v594),min_by_merge(v595),min_by_merge(v596),min_by_merge(v597),min_by_merge(v598),min_by_merge(v599),min_by_merge(v600),min_by_merge(v601),min_by_merge(v602),min_by_merge(v603),min_by_merge(v604),min_by_merge(v605),min_by_merge(v606),min_by_merge(v607),min_by_merge(v608),min_by_merge(v609),min_by_merge(v610),min_by_merge(v611),min_by_merge(v612),min_by_merge(v613),min_by_merge(v614),min_by_merge(v615),min_by_merge(v616),min_by_merge(v617),min_by_merge(v618),min_by_merge(v619),min_by_merge(v620),min_by_merge(v621),min_by_merge(v622),min_by_merge(v623),min_by_merge(v624),min_by_merge(v625),min_by_merge(v626),min_by_merge(v627),min_by_merge(v628),min_by_merge(v629),min_by_merge(v630),min_by_merge(v631),min_by_merge(v632),min_by_merge(v633),min_by_merge(v634),min_by_merge(v635),min_by_merge(v636),min_by_merge(v637),min_by_merge(v638),min_by_merge(v639),min_by_merge(v640),min_by_merge(v641),min_by_merge(v642),min_by_merge(v643),min_by_merge(v644),min_by_merge(v645),min_by_merge(v646),min_by_merge(v647),min_by_merge(v648),min_by_merge(v649),min_by_merge(v650),min_by_merge(v651),min_by_merge(v652),min_by_merge(v653),min_by_merge(v654),min_by_merge(v655),min_by_merge(v656),variance_pop_merge(v657),variance_pop_merge(v658),variance_pop_merge(v659),variance_pop_merge(v660),variance_pop_merge(v661),variance_pop_merge(v662),variance_pop_merge(v663),variance_pop_merge(v664),avg_merge(v665),avg_merge(v666),avg_merge(v667),avg_merge(v668),avg_merge(v669),avg_merge(v670),avg_merge(v671),avg_merge(v672),avg_merge(v673),avg_merge(v674),any_value_merge(v675),any_value_merge(v676),any_value_merge(v677),any_value_merge(v678),any_value_merge(v679),any_value_merge(v680),any_value_merge(v681),any_value_merge(v682),any_value_merge(v683),any_value_merge(v684),any_value_merge(v685),any_value_merge(v686),any_value_merge(v687),any_value_merge(v688),any_value_merge(v689),any_value_merge(v690),any_value_merge(v691),any_value_merge(v692),any_value_merge(v693),var_pop_merge(v694),var_pop_merge(v695),var_pop_merge(v696),var_pop_merge(v697),var_pop_merge(v698),var_pop_merge(v699),var_pop_merge(v700),var_pop_merge(v701),stddev_pop_merge(v702),stddev_pop_merge(v703),stddev_pop_merge(v704),stddev_pop_merge(v705),stddev_pop_merge(v706),stddev_pop_merge(v707),stddev_pop_merge(v708),stddev_pop_merge(v709),variance_samp_merge(v710),variance_samp_merge(v711),variance_samp_merge(v712),variance_samp_merge(v713),variance_samp_merge(v714),variance_samp_merge(v715),variance_samp_merge(v716),variance_samp_merge(v717),percentile_cont_merge(v718),percentile_cont_merge(v719),percentile_cont_merge(v720),corr_merge(v721),corr_merge(v722),corr_merge(v723),corr_merge(v724),corr_merge(v725),corr_merge(v726),corr_merge(v727),corr_merge(v728),multi_distinct_sum_merge(v729),multi_distinct_sum_merge(v730),multi_distinct_sum_merge(v731),multi_distinct_sum_merge(v732),multi_distinct_sum_merge(v733),multi_distinct_sum_merge(v734),multi_distinct_sum_merge(v735),multi_distinct_sum_merge(v736),multi_distinct_sum_merge(v737),multi_distinct_sum_merge(v738),multi_distinct_sum_merge(v739),var_samp_merge(v740),var_samp_merge(v741),var_samp_merge(v742),var_samp_merge(v743),var_samp_merge(v744),var_samp_merge(v745),var_samp_merge(v746),var_samp_merge(v747),bitmap_union_int_merge(v748),bitmap_union_int_merge(v749),bitmap_union_int_merge(v750),bitmap_union_int_merge(v751),variance_merge(v752),variance_merge(v753),variance_merge(v754),variance_merge(v755),variance_merge(v756),variance_merge(v757),variance_merge(v758),variance_merge(v759) from test_agg_state_table group by k1; - [exp]: ['2024-01-01\t[0,1,null]\t[127,null]\t[32000,32100,null]\t[2147483647,2047483647,null]\t[9223372036854775807,9023372036854775807,null]\t[100141183460469231731687303715884105727,170141183460469231731687303715884105727,null]\t[12345.6789,123450.6789,null]\t[123450.67,12345.67,null]\t[123.46,1230.46,null]\t[123.46,1230.46,null]\t[123.46,1230.46,null]\t["a","ExampleCharData",null]\t["2024-01-01","2024-01-02",null]\t["2024-01-01 12:34:56","2024-01-01 13:34:56",null]\t12345.6787109375\t12345.6787109375\t2743182450.0\t2743182546.445313\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.0\t8.888888888888888e+33\t1.0888888888888889e+75\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t[0,1,null]\t[-1,1,127,null]\t[-100,32767,100,null]\t[-100000,100000,2147483647,null]\t[-10000000000,10000000000,9223372036854775807,null]\t[12345678901234567890,-12345678901234567890,170141183460469231731687303715884105727,null]\t[1.23,4.56,7.89,null]\t[7.89,1.23,4.56,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t["abc","def","ghi",null]\t["2024-01-01","2024-01-02",null]\t["2024-01-01 12:34:56","2024-01-02 12:34:56",null]\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t123.46\t123.46\t123.46\tExampleCharData\t2024-01-02\t2024-01-01 12:34:56\t12345.6789\t12345.67\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t["ExampleVarcharData","ExampleVarcharData","ExampleVarcharData",null]\t64146.50165831337\t64146.502785950615\t0.5773502691896257\t0.0\t57.735026918962575\t57735026.918962575\t1.1547005383792514e+17\t4.04145188432738e+37\t[2, 0.15729920705028522]\t[2, 0.9830525732376554]\t[2, 0.15729920705028522]\t1\t127\t32100\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-02\t2024-01-01 13:34:56\t2\t2\t2\t1\t1\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t1\t1\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t52375.399282487575\t52375.400203199526\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.079103164\t9.428090415820634e+16\t3.299831645537222e+37\t4114773675.0\t4114773819.6679697\t0.3333333333333333\t0.0\t3333.333333333333\t3333333333333333.0\t1.333333333333333e+34\t1.6333333333333332e+75\tNone\tNone\tNone\tNone\tNone\tNone\t52375.399282487575\t52375.400203199526\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.079103164\t9.428090415820634e+16\t3.299831645537222e+37\t148142.0367\t148142.01171875\t254\t96100\t6342450941\t9023372036854775805\t100141183460469231731687303715884105725\t1477.38\t1477.38\t1477.38\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t0\t127\t32000\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-01\t2024-01-01 12:34:56\t[1,0,1]\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t2743182450.0\t2743182546.445313\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.0\t8.888888888888888e+33\t1.0888888888888889e+75\t49380.6789\t49380.670572916664\t127.0\t32033.333333333332\t2114150313.6666667\t9.156705370188109e+18\t1.468078501271359e+38\t492.46000000\t492.46000000\t492.46000000\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t[10000000000,-10000000000,9223372036854775807]\t{"key1":"value1","key2":"value2"}\t{"col1":null}\t{"key": "value"}\tMyVarbinaryData\t2743182450.0\t2743182546.445313\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.0\t8.888888888888888e+33\t1.0888888888888889e+75\t52375.399282487575\t52375.400203199526\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.079103164\t9.428090415820634e+16\t3.299831645537222e+37\t4114773675.0\t4114773819.6679697\t0.3333333333333333\t0.0\t3333.333333333333\t3333333333333333.0\t1.333333333333333e+34\t1.6333333333333332e+75\t2024-01-02\t2024-01-01 12:34:56\t12345.6789\t0.9999999999999999\t1.0000000000000002\t1.0\tnan\t1.0\t0.9999999999999998\t1.0000000000000002\t1.0\t135796.3578\t135796.341796875\t1\t127\t64100\t4194967294\t-200000000000000002\t-70000000000000000000000000000000000002\t1353.92\t1353.92\t1353.92\t4114773675.0\t4114773819.6679697\t0.3333333333333333\t0.0\t3333.333333333333\t3333333333333333.0\t1.333333333333333e+34\t1.6333333333333332e+75\t1\t2\t2\t2\t2743182450.0\t2743182546.445313\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.0\t8.888888888888888e+33\t1.0888888888888889e+75'] - [act]: ['2024-01-01\t[0,1,null]\t[127,null]\t[32000,32100,null]\t[2147483647,2047483647,null]\t[9223372036854775807,9023372036854775807,null]\t[100141183460469231731687303715884105727,170141183460469231731687303715884105727,null]\t[12345.6789,123450.6789,null]\t[123450.67,12345.67,null]\t[123.46,1230.46,null]\t[123.46,1230.46,null]\t[123.46,1230.46,null]\t["a","ExampleCharData",null]\t["2024-01-01","2024-01-02",null]\t["2024-01-01 12:34:56","2024-01-01 13:34:56",null]\t12345.6787109375\t12345.6787109375\t2743182450.0\t2743182546.4453135\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.2\t8.888888888888889e+33\t1.0888888888888889e+75\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t4\t[0,1,null]\t[-1,1,127,null]\t[-100,32767,100,null]\t[-100000,100000,2147483647,null]\t[-10000000000,10000000000,9223372036854775807,null]\t[12345678901234567890,-12345678901234567890,170141183460469231731687303715884105727,null]\t[1.23,4.56,7.89,null]\t[7.89,1.23,4.56,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t[1.23,2.35,3.46,null]\t["abc","def","ghi",null]\t["2024-01-01","2024-01-02",null]\t["2024-01-01 12:34:56","2024-01-02 12:34:56",null]\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t123.46\t123.46\t123.46\tExampleCharData\t2024-01-02\t2024-01-01 12:34:56\t12345.6789\t12345.67\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t["ExampleVarcharData","ExampleVarcharData","ExampleVarcharData",null]\t64146.50165831337\t64146.502785950615\t0.5773502691896257\t0.0\t57.735026918962575\t57735026.918962575\t1.1547005383792515e+17\t4.0414518843273805e+37\t[2, 0.15729920705028522]\t[2, 0.9830525732376554]\t[2, 0.15729920705028522]\t1\t127\t32100\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-02\t2024-01-01 13:34:56\t2\t2\t2\t1\t1\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t1\t1\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t52375.399282487575\t52375.40020319953\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.07910317\t9.428090415820634e+16\t3.299831645537222e+37\t4114773675.0\t4114773819.66797\t0.3333333333333333\t0.0\t3333.3333333333335\t3333333333333333.5\t1.3333333333333333e+34\t1.6333333333333334e+75\tNone\tNone\tNone\tNone\tNone\tNone\t52375.399282487575\t52375.40020319953\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.07910317\t9.428090415820634e+16\t3.299831645537222e+37\t148142.0367\t148142.01171875\t254\t96100\t6342450941\t9023372036854775805\t100141183460469231731687303715884105725\t1477.38\t1477.38\t1477.38\t2\t1\t2\t2\t2\t2\t2\t2\t2\t2\t2\t1\t2\t2\t0\t127\t32000\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-01\t2024-01-01 12:34:56\t[1,0,1]\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t0\tNone\t32100\t2047483647\t9023372036854775807\t100141183460469231731687303715884105727\t123450.6789\t123450.67\t1230.46\t1230.46\t1230.46\tExampleVarcharData\t2024-01-01\t2024-01-01 13:34:56\t{"key": "value"}\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t{"key": "value"}\t2743182450.0\t2743182546.4453135\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.2\t8.888888888888889e+33\t1.0888888888888889e+75\t49380.6789\t49380.670572916664\t127.0\t32033.333333333332\t2114150313.6666667\t9.156705370188109e+18\t1.468078501271359e+38\t492.46000000\t492.46000000\t492.46000000\t1\t127\t32000\t2147483647\t9223372036854775807\t170141183460469231731687303715884105727\t12345.6789\t12345.67\t123.46\t123.46\t123.46\tExampleVarcharData\t2024-01-02\t2024-01-01 12:34:56\t[10000000000,-10000000000,9223372036854775807]\t{"key1":"value1","key2":"value2"}\t{"col1":null}\t{"key": "value"}\tMyVarbinaryData\t2743182450.0\t2743182546.4453135\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.2\t8.888888888888889e+33\t1.0888888888888889e+75\t52375.399282487575\t52375.40020319953\t0.4714045207910317\t0.0\t47.14045207910317\t47140452.07910317\t9.428090415820634e+16\t3.299831645537222e+37\t4114773675.0\t4114773819.66797\t0.3333333333333333\t0.0\t3333.3333333333335\t3333333333333333.5\t1.3333333333333333e+34\t1.6333333333333334e+75\t2024-01-02\t2024-01-01 12:34:56\t12345.6789\t0.9999999999999999\t1.0\t1.0\tnan\t0.9999999999999998\t1.0\t0.9999999999999998\t0.9999999999999999\t135796.3578\t135796.341796875\t1\t127\t64100\t4194967294\t-200000000000000002\t-70000000000000000000000000000000000002\t1353.92\t1353.92\t1353.92\t4114773675.0\t4114773819.66797\t0.3333333333333333\t0.0\t3333.3333333333335\t3333333333333333.5\t1.3333333333333333e+34\t1.6333333333333334e+75\t1\t2\t2\t2\t2743182450.0\t2743182546.4453135\t0.2222222222222222\t0.0\t2222.222222222222\t2222222222222222.2\t8.888888888888889e+33\t1.0888888888888889e+75'] --- 2. [FAILURE] test_sql_cases.TestSQLCases.test_approx_top_k_with_partition '' != [] : sql result not match: expected empty but got ([]) 3. [FAILURE] test_sql_cases.TestSQLCases.test_async_mv Element counts were not equal: First has 1, Second has 0: '1\t3' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from tva; - [exp]: ['1\t3'] - [act]: [''] --- 4. [FAILURE] test_sql_cases.TestSQLCases.test_case_when Element counts were not equal: First has 1, Second has 0: "E: (1064, 'Getting analyzing error. Detail message: Expression CaseWhen too complex, limit: 10000. Please simplify your expression or increase Config.max_scalar_operator_flat_children..')" First has 0, Second has 1: '' : sql result not match: - [SQL]: SELECT *, CASE WHEN `handling_department_2` LIKE '%Ganzhou Transfer Yard%' THEN REPLACE(`handling_department_2`, 'Ganzhou Transfer Yard', 'Ganzhou Transfer Yard Loading/Unloading Team 1') WHEN `handling_department_2` LIKE '%Guangzhou Fanlong Distribution Station Loading/Unloading Team 1%' THEN REPLACE(`handling_department_2`, 'Guangzhou Fanlong Distribution Station Loading/Unloading Team 1', 'Guangzhou Fanlong Distribution Station Loading/Unloading Team') WHEN `handling_department_2` LIKE '%Jingzhou Transfer Yard Loading/Unloading Department%' THEN REPLACE(`handling_department_2`, 'Jingzhou Transfer Yard Loading/Unloading Department', 'Jingzhou Transfer Yard Loading/Unloading Team') WHEN `handling_department_2` LIKE '%Tangshan Loading/Unloading Team 1%' THEN REPLACE(`handling_department_2`, 'Tangshan Loading/Unloading Team 1', 'Tangshan Loading/Unloading Team') WHEN `handling_department_2` LIKE '%Zhexi Hub Center%' THEN REPLACE(`handling_department_2`, 'Zhexi Hub Center', 'Hangzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Shanghai Hub Center%' THEN REPLACE(`handling_department_2`, 'Shanghai Hub Center', 'Shanghai Transfer Yard') WHEN `handling_department_2` LIKE '%Shunde Hub Center%' THEN REPLACE(`handling_department_2`, 'Shunde Hub Center', 'Shunde Transfer Yard') WHEN `handling_department_2` LIKE '%Sunan Hub Center%' THEN REPLACE(`handling_department_2`, 'Sunan Hub Center', 'Suzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Tianjin Hub Center%' THEN REPLACE(`handling_department_2`, 'Tianjin Hub Center', 'Tianjin Transfer Yard') WHEN `handling_department_2` LIKE '%Wuhan Hub Center%' THEN REPLACE(`handling_department_2`, 'Wuhan Hub Center', 'Wuhan Transfer Yard') WHEN `handling_department_2` LIKE '%Northwest Hub Center%' THEN REPLACE(`handling_department_2`, 'Northwest Hub Center', 'Xi\'an Transfer Yard') WHEN `handling_department_2` LIKE '%Zhengzhou Hub Center%' THEN REPLACE(`handling_department_2`, 'Zhengzhou Hub Center', 'Zhengzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Changzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Changzhou Transfer Center', 'Changzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Chaoshan Transfer Center%' THEN REPLACE(`handling_department_2`, 'Chaoshan Transfer Center', 'Chaoshan Transfer Yard') WHEN `handling_department_2` LIKE '%Fangshan Transfer Center%' THEN REPLACE(`handling_department_2`, 'Fangshan Transfer Center', 'Fangshan Transfer Yard') WHEN `handling_department_2` LIKE '%Fuzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Fuzhou Transfer Center', 'Fuzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Guiyang Transfer Center%' THEN REPLACE(`handling_department_2`, 'Guiyang Transfer Center', 'Guiyang Transfer Yard') WHEN `handling_department_2` LIKE '%Harbin Transfer Center%' THEN REPLACE(`handling_department_2`, 'Harbin Transfer Center', 'Harbin Transfer Yard') WHEN `handling_department_2` LIKE '%Huaian Transfer Center%' THEN REPLACE(`handling_department_2`, 'Huaian Transfer Center', 'Huaian Transfer Yard') WHEN `handling_department_2` LIKE '%Jinhua Transfer Center%' THEN REPLACE(`handling_department_2`, 'Jinhua Transfer Center', 'Jinhua Transfer Yard') WHEN `handling_department_2` LIKE '%Kunming Transfer Center%' THEN REPLACE(`handling_department_2`, 'Kunming Transfer Center', 'Kunming Transfer Yard') WHEN `handling_department_2` LIKE '%Lanzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Lanzhou Transfer Center', 'Lanzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Luohe Transfer Center%' THEN REPLACE(`handling_department_2`, 'Luohe Transfer Center', 'Luohe Transfer Yard') WHEN `handling_department_2` LIKE '%Nanchang Transfer Center%' THEN REPLACE(`handling_department_2`, 'Nanchang Transfer Center', 'Nanchang Transfer Yard') WHEN `handling_department_2` LIKE '%Nanjing Transfer Center%' THEN REPLACE(`handling_department_2`, 'Nanjing Transfer Center', 'Nanjing Transfer Yard') WHEN `handling_department_2` LIKE '%Nanning Transfer Center%' THEN REPLACE(`handling_department_2`, 'Nanning Transfer Center', 'Nanning Transfer Yard') WHEN `handling_department_2` LIKE '%Nantong Transfer Center%' THEN REPLACE(`handling_department_2`, 'Nantong Transfer Center', 'Nantong Transfer Yard') WHEN `handling_department_2` LIKE '%Pudong Transfer Center%' THEN REPLACE(`handling_department_2`, 'Pudong Transfer Center', 'Pudong Transfer Yard') WHEN `handling_department_2` LIKE '%Quanzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Quanzhou Transfer Center', 'Quanzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Xiamen Transfer Center%' THEN REPLACE(`handling_department_2`, 'Xiamen Transfer Center', 'Xiamen Transfer Yard') WHEN `handling_department_2` LIKE '%Shenyang Transfer Center%' THEN REPLACE(`handling_department_2`, 'Shenyang Transfer Center', 'Shenyang Transfer Yard') WHEN `handling_department_2` LIKE '%Taiyuan Transfer Center%' THEN REPLACE(`handling_department_2`, 'Taiyuan Transfer Center', 'Taiyuan Transfer Yard') WHEN `handling_department_2` LIKE '%Wenzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Wenzhou Transfer Center', 'Wenzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Wuhu Transfer Center%' THEN REPLACE(`handling_department_2`, 'Wuhu Transfer Center', 'Wuhu Transfer Yard') WHEN `handling_department_2` LIKE '%Xuzhou Shaji Transfer Center%' THEN REPLACE(`handling_department_2`, 'Xuzhou Shaji Transfer Center', 'Xuzhou Shaji Transfer Yard') WHEN `handling_department_2` LIKE '%Xuzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Xuzhou Transfer Center', 'Xuzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Yantai Transfer Center%' THEN REPLACE(`handling_department_2`, 'Yantai Transfer Center', 'Yantai Transfer Yard') WHEN `handling_department_2` LIKE '%Yangzhou Transfer Center%' THEN REPLACE(`handling_department_2`, 'Yangzhou Transfer Center', 'Yangzhou Transfer Yard') WHEN `handling_department_2` LIKE '%Changchun Transfer Center%' THEN REPLACE(`handling_department_2`, 'Changchun Transfer Center', 'Changchun Transfer Yard') WHEN `handling_department_2` LIKE '%Chongqing Baihe Transfer Center%' THEN REPLACE(`handling_department_2`, 'Chongqing Baihe Transfer Center', 'Chongqing Baihe Transfer Yard') ELSE `handling_department_2` END AS `handling_department_3` FROM ( SELECT *, CASE WHEN `handling_department` LIKE '%Ganzhou Transfer Yard%' THEN REPLACE(`handling_department`, 'Ganzhou Transfer Yard', 'Ganzhou Transfer Yard Loading/Unloading Team 1') WHEN `handling_department` LIKE '%Guangzhou Fanlong Distribution Station Loading/Unloading Team 1%' THEN REPLACE(`handling_department`, 'Guangzhou Fanlong Distribution Station Loading/Unloading Team 1', 'Guangzhou Fanlong Distribution Station Loading/Unloading Team') WHEN `handling_department` LIKE '%Jingzhou Transfer Yard Loading/Unloading Department%' THEN REPLACE(`handling_department`, 'Jingzhou Transfer Yard Loading/Unloading Department', 'Jingzhou Transfer Yard Loading/Unloading Team') WHEN `handling_department` LIKE '%Tangshan Loading/Unloading Team 1%' THEN REPLACE(`handling_department`, 'Tangshan Loading/Unloading Team 1', 'Tangshan Loading/Unloading Team') WHEN `handling_department` LIKE '%Zhexi Hub Center%' THEN REPLACE(`handling_department`, 'Zhexi Hub Center', 'Hangzhou Transfer Yard') WHEN `handling_department` LIKE '%Shanghai Hub Center%' THEN REPLACE(`handling_department`, 'Shanghai Hub Center', 'Shanghai Transfer Yard') WHEN `handling_department` LIKE '%Shunde Hub Center%' THEN REPLACE(`handling_department`, 'Shunde Hub Center', 'Shunde Transfer Yard') WHEN `handling_department` LIKE '%Sunan Hub Center%' THEN REPLACE(`handling_department`, 'Sunan Hub Center', 'Suzhou Transfer Yard') WHEN `handling_department` LIKE '%Tianjin Hub Center%' THEN REPLACE(`handling_department`, 'Tianjin Hub Center', 'Tianjin Transfer Yard') WHEN `handling_department` LIKE '%Wuhan Hub Center%' THEN REPLACE(`handling_department`, 'Wuhan Hub Center', 'Wuhan Transfer Yard') WHEN `handling_department` LIKE '%Northwest Hub Center%' THEN REPLACE(`handling_department`, 'Northwest Hub Center', 'Xi\'an Transfer Yard') WHEN `handling_department` LIKE '%Zhengzhou Hub Center%' THEN REPLACE(`handling_department`, 'Zhengzhou Hub Center', 'Zhengzhou Transfer Yard') WHEN `handling_department` LIKE '%Changzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Changzhou Transfer Center', 'Changzhou Transfer Yard') WHEN `handling_department` LIKE '%Chaoshan Transfer Center%' THEN REPLACE(`handling_department`, 'Chaoshan Transfer Center', 'Chaoshan Transfer Yard') WHEN `handling_department` LIKE '%Fangshan Transfer Center%' THEN REPLACE(`handling_department`, 'Fangshan Transfer Center', 'Fangshan Transfer Yard') WHEN `handling_department` LIKE '%Fuzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Fuzhou Transfer Center', 'Fuzhou Transfer Yard') WHEN `handling_department` LIKE '%Guiyang Transfer Center%' THEN REPLACE(`handling_department`, 'Guiyang Transfer Center', 'Guiyang Transfer Yard') WHEN `handling_department` LIKE '%Harbin Transfer Center%' THEN REPLACE(`handling_department`, 'Harbin Transfer Center', 'Harbin Transfer Yard') WHEN `handling_department` LIKE '%Huaian Transfer Center%' THEN REPLACE(`handling_department`, 'Huaian Transfer Center', 'Huaian Transfer Yard') WHEN `handling_department` LIKE '%Jinhua Transfer Center%' THEN REPLACE(`handling_department`, 'Jinhua Transfer Center', 'Jinhua Transfer Yard') WHEN `handling_department` LIKE '%Kunming Transfer Center%' THEN REPLACE(`handling_department`, 'Kunming Transfer Center', 'Kunming Transfer Yard') WHEN `handling_department` LIKE '%Lanzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Lanzhou Transfer Center', 'Lanzhou Transfer Yard') WHEN `handling_department` LIKE '%Luohe Transfer Center%' THEN REPLACE(`handling_department`, 'Luohe Transfer Center', 'Luohe Transfer Yard') WHEN `handling_department` LIKE '%Nanchang Transfer Center%' THEN REPLACE(`handling_department`, 'Nanchang Transfer Center', 'Nanchang Transfer Yard') WHEN `handling_department` LIKE '%Nanjing Transfer Center%' THEN REPLACE(`handling_department`, 'Nanjing Transfer Center', 'Nanjing Transfer Yard') WHEN `handling_department` LIKE '%Nanning Transfer Center%' THEN REPLACE(`handling_department`, 'Nanning Transfer Center', 'Nanning Transfer Yard') WHEN `handling_department` LIKE '%Nantong Transfer Center%' THEN REPLACE(`handling_department`, 'Nantong Transfer Center', 'Nantong Transfer Yard') WHEN `handling_department` LIKE '%Pudong Transfer Center%' THEN REPLACE(`handling_department`, 'Pudong Transfer Center', 'Pudong Transfer Yard') WHEN `handling_department` LIKE '%Quanzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Quanzhou Transfer Center', 'Quanzhou Transfer Yard') WHEN `handling_department` LIKE '%Xiamen Transfer Center%' THEN REPLACE(`handling_department`, 'Xiamen Transfer Center', 'Xiamen Transfer Yard') WHEN `handling_department` LIKE '%Shenyang Transfer Center%' THEN REPLACE(`handling_department`, 'Shenyang Transfer Center', 'Shenyang Transfer Yard') WHEN `handling_department` LIKE '%Taiyuan Transfer Center%' THEN REPLACE(`handling_department`, 'Taiyuan Transfer Center', 'Taiyuan Transfer Yard') WHEN `handling_department` LIKE '%Wenzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Wenzhou Transfer Center', 'Wenzhou Transfer Yard') WHEN `handling_department` LIKE '%Wuhu Transfer Center%' THEN REPLACE(`handling_department`, 'Wuhu Transfer Center', 'Wuhu Transfer Yard') WHEN `handling_department` LIKE '%Xuzhou Shaji Transfer Center%' THEN REPLACE(`handling_department`, 'Xuzhou Shaji Transfer Center', 'Xuzhou Shaji Transfer Yard') WHEN `handling_department` LIKE '%Xuzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Xuzhou Transfer Center', 'Xuzhou Transfer Yard') WHEN `handling_department` LIKE '%Yantai Transfer Center%' THEN REPLACE(`handling_department`, 'Yantai Transfer Center', 'Yantai Transfer Yard') WHEN `handling_department` LIKE '%Yangzhou Transfer Center%' THEN REPLACE(`handling_department`, 'Yangzhou Transfer Center', 'Yangzhou Transfer Yard') WHEN `handling_department` LIKE '%Changchun Transfer Center%' THEN REPLACE(`handling_department`, 'Changchun Transfer Center', 'Changchun Transfer Yard') WHEN `handling_department` LIKE '%Chongqing Baihe Transfer Center%' THEN REPLACE(`handling_department`, 'Chongqing Baihe Transfer Center', 'Chongqing Baihe Transfer Yard') ELSE `handling_department` END AS `handling_department_2` FROM ( SELECT CAST(`handling_department` AS STRING) AS `handling_department` FROM ( SELECT handed_dept_name AS `handling_department` FROM ads_opt_t_goods_odd_important_kd_di ) dataset_table ) table_1 ) table_2; - [exp]: ["E: (1064, 'Getting analyzing error. Detail message: Expression CaseWhen too complex, limit: 10000. Please simplify your expression or increase Config.max_scalar_operator_flat_children..')"] - [act]: [''] --- 5. [FAILURE] test_sql_cases.TestSQLCases.test_ctas_from_normal_table Element counts were not equal: First has 1, Second has 0: ' `c3` date NULL COMMENT ""' First has 0, Second has 1: ' `c3` date NULL COMMENT "",' First has 0, Second has 1: ' `__generated_partition_column_0` varchar(1048576) NULL AS from_unixtime(c1) COMMENT ""' : sql result not match: - [SQL]: show create table multi_level_expr_par_tbl_1; - [exp]: ['multi_level_expr_par_tbl_1\tCREATE TABLE `multi_level_expr_par_tbl_1` (', ' `c1` bigint(20) NOT NULL COMMENT "",', ' `c2` varchar(65533) NULL COMMENT "",', ' `c3` date NULL COMMENT ""', ') ENGINE=OLAP ', 'PRIMARY KEY(`c1`)', 'PARTITION BY (`__generated_partition_column_0`)', 'DISTRIBUTED BY HASH(`c1`) BUCKETS 3 ', 'PROPERTIES (', '"compression" = "LZ4",', '"enable_persistent_index" = "true",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');'] - [act]: ['multi_level_expr_par_tbl_1\tCREATE TABLE `multi_level_expr_par_tbl_1` (', ' `c1` bigint(20) NOT NULL COMMENT "",', ' `c2` varchar(65533) NULL COMMENT "",', ' `c3` date NULL COMMENT "",', ' `__generated_partition_column_0` varchar(1048576) NULL AS from_unixtime(c1) COMMENT ""', ') ENGINE=OLAP ', 'PRIMARY KEY(`c1`)', 'PARTITION BY (`__generated_partition_column_0`)', 'DISTRIBUTED BY HASH(`c1`) BUCKETS 3 ', 'PROPERTIES (', '"compression" = "LZ4",', '"enable_persistent_index" = "true",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');'] --- 6. [FAILURE] test_sql_cases.TestSQLCases.test_cte_in_where_subquery Element counts were not equal: First has 1, Second has 0: '1' First has 1, Second has 0: '2' First has 1, Second has 0: '3' First has 0, Second has 1: 'E: (1064, "Getting syntax error at line 2, column 64. Detail message: Unexpected input \'ALL\', the most similar input is {a legal identifier}.")' : sql result not match: - [SQL]: WITH a1 AS (SELECT v1 FROM t_cte_0) SELECT v1 FROM t_cte_0 WHERE v1 IN (SELECT v1 FROM a1) ORDER BY ALL; - [exp]: ['1', '2', '3'] - [act]: ['E: (1064, "Getting syntax error at line 2, column 64. Detail message: Unexpected input \'ALL\', the most similar input is {a legal identifier}.")'] --- 7. [ERROR] test_sql_cases.TestSQLCases.test_join_feedback 'result' 8. [FAILURE] test_sql_cases.TestSQLCases.test_non_dup_random 'Getting analyzing error from line 1, column 45 to line 1, column 75. Detail message: PRIMARY KEY cannot use random distribution.' not found in "E: (1064, 'Getting analyzing error from line 1, column 45 to line 1, column 75. Detail message: PRIMARY KEY must use hash distribution.')" 9. [FAILURE] test_sql_cases.TestSQLCases.test_query_after_compact Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 10. [FAILURE] test_sql_cases.TestSQLCases.test_query_after_compact_pk Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 11. [FAILURE] test_sql_cases.TestSQLCases.test_query_by_timestamp Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 12. [FAILURE] test_sql_cases.TestSQLCases.test_query_by_timestamp_pk Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 13. [FAILURE] test_sql_cases.TestSQLCases.test_query_by_timestamp_schema_change Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 14. [FAILURE] test_sql_cases.TestSQLCases.test_query_by_timestamp_schema_change_pk Element counts were not equal: First has 1, Second has 0: '1' First has 0, Second has 1: '' : sql result not match: - [SQL]: select * from t before '${t1[1]}'; - [exp]: ['1'] - [act]: [''] --- 15. [FAILURE] test_sql_cases.TestSQLCases.test_regexp '' != ['bCd', 'xCe'] : sql result not match: expected empty but got (['bCd', 'xCe']) 16. [FAILURE] test_sql_cases.TestSQLCases.test_regexp_count_invalid Element counts were not equal: First has 1, Second has 0: 'abc123def456\t[0-9\tNone' First has 1, Second has 0: 'repetition test\t?invalid\tNone' First has 1, Second has 0: 'test string\t(unclosed\tNone' First has 1, Second has 0: 'valid test\tvalid\t1' First has 0, Second has 1: "E: (1064, 'Getting analyzing error from line 1, column 19 to line 1, column 42. Detail message: No matching function with signature: regexp_count(varchar(65533), varchar(65533)).')" : sql result not match: - [SQL]: select str, regex, regexp_count(str, regex) from tsc_invalid order by str, regex; - [exp]: ['abc123def456\t[0-9\tNone', 'repetition test\t?invalid\tNone', 'test string\t(unclosed\tNone', 'valid test\tvalid\t1'] - [act]: ["E: (1064, 'Getting analyzing error from line 1, column 19 to line 1, column 42. Detail message: No matching function with signature: regexp_count(varchar(65533), varchar(65533)).')"] --- 17. [FAILURE] test_sql_cases.TestSQLCases.test_runtime_filter_partial_exceed True is not false : sql result not match: actual with E(E: (1193, "Unknown system variable 'semi_join_deduplicat_mode', the most similar variables are {'spill_enable_direct_io', 'join_implementation_mode_v2', 'historical_nodes_min_update_interval'}"))