Control: retitle -1 clickhouse: rounding issue in unit tests. Also, on arm64, 00047_stored_aggregates_complex fails:
Buildlog excerpt (unmangled) from: https://buildd.debian.org/status/fetch.php?pkg=clickhouse&arch=arm64&ver=18.16.1%2Bds-7.3%7Eexp2&stamp=1667169496&raw=0 8: b"--- /<<PKGBUILDDIR>>/dbms/tests/queries/0_stateless/00047_stored_aggregates_complex.reference 2018-12-20 16:38:50.000000000 +0000 +++ /tmp/clickhouse.test..IyGS7/tmp/0_stateless/00047_stored_aggregates_complex.stdout 2022-10-30 20:07:43.809291574 +0000 @@ -3,37 +3,37 @@ 2014-06-01 0 2 245 24.5 7 20 21 [24.5,28.1] ['20','21','22','23','24','25','26','27','28','29'] 2014-06-01 0 3 345 34.5 7 30 35 [34.5,38.1] ['30','31','32','33','34','35','36','37','38','39'] 2014-06-01 0 4 445 44.5 7 40 42 [44.5,48.1] ['40','41','42','43','44','45','46','47','48','49'] -2014-06-01 0 5 545 54.5 7 50 56 [54.5,58.099999999999994] ['50','51','52','53','54','55','56','57','58','59'] +2014-06-01 0 5 545 54.5 7 50 56 [54.5,58.1] ['50','51','52','53','54','55','56','57','58','59'] 2014-06-01 0 6 645 64.5 7 60 63 [64.5,68.1] ['60','61','62','63','64','65','66','67','68','69'] -2014-06-01 0 7 745 74.5 7 70 70 [74.5,78.10000000000001] ['70','71','72','73','74','75','76','77','78','79'] +2014-06-01 0 7 745 74.5 7 70 70 [74.5,78.1] ['70','71','72','73','74','75','76','77','78','79'] 2014-06-01 0 8 845 84.5 7 80 84 [84.5,88.1] ['80','81','82','83','84','85','86','87','88','89'] 2014-06-01 0 9 945 94.5 7 90 91 [94.5,98.1] ['90','91','92','93','94','95','96','97','98','99'] -2014-06-01 1 10 1045 104.5 7 100 105 [104.5,108.10000000000001] ['100','101','102','103','104','105','106','107','108','109'] -2014-06-01 1 11 1145 114.5 7 110 112 [114.5,118.10000000000001] ['110','111','112','113','114','115','116','117','118','119'] +2014-06-01 1 10 1045 104.5 7 100 105 [104.5,108.1] ['100','101','102','103','104','105','106','107','108','109'] +2014-06-01 1 11 1145 114.5 7 110 112 [114.5,118.1] ['110','111','112','113','114','115','116','117','118','119'] 2014-06-01 1 12 1245 124.5 7 120 126 [124.5,128.1] ['120','121','122','123','124','125','126','127','128','129'] 2014-06-01 1 13 1345 134.5 7 130 133 [134.5,138.1] ['130','131','132','133','134','135','136','137','138','139'] 2014-06-01 1 14 1445 144.5 7 140 140 [144.5,148.1] ['140','141','142','143','144','145','146','147','148','149'] 2014-06-01 1 15 1545 154.5 7 150 154 [154.5,158.1] ['150','151','152','153','154','155','156','157','158','159'] 2014-06-01 1 16 1645 164.5 7 160 161 [164.5,168.1] ['160','161','162','163','164','165','166','167','168','169'] -2014-06-01 1 17 1745 174.5 7 170 175 [174.5,178.10000000000002] ['170','171','172','173','174','175','176','177','178','179'] -2014-06-01 1 18 1845 184.5 7 180 182 [184.5,188.10000000000002] ['180','181','182','183','184','185','186','187','188','189'] +2014-06-01 1 17 1745 174.5 7 170 175 [174.5,178.1] ['170','171','172','173','174','175','176','177','178','179'] +2014-06-01 1 18 1845 184.5 7 180 182 [184.5,188.1] ['180','181','182','183','184','185','186','187','188','189'] 2014-06-01 1 19 1945 194.5 7 190 196 [194.5,198.1] ['190','191','192','193','194','195','196','197','198','199'] 2014-06-01 2 20 2045 204.5 7 200 203 [204.5,208.1] ['200','201','202','203','204','205','206','207','208','209'] 2014-06-01 2 21 2145 214.5 7 210 210 [214.5,218.1] ['210','211','212','213','214','215','216','217','218','219'] 2014-06-01 2 22 2245 224.5 7 220 224 [224.5,228.1] ['220','221','222','223','224','225','226','227','228','229'] 2014-06-01 2 23 2345 234.5 7 230 231 [234.5,238.1] ['230','231','232','233','234','235','236','237','238','239'] -2014-06-01 2 24 2445 244.5 7 240 245 [244.5,248.10000000000002] ['240','241','242','243','244','245','246','247','248','249'] +2014-06-01 2 24 2445 244.5 7 240 245 [244.5,248.1] ['240','241','242','243','244','245','246','247','248','249'] 2014-06-01 2 25 2545 254.5 7 250 252 [254.5,258.1] ['250','251','252','253','254','255','256','257','258','259'] 2014-06-01 2 26 2645 264.5 7 260 266 [264.5,268.1] ['260','261','262','263','264','265','266','267','268','269'] 2014-06-01 2 27 2745 274.5 7 270 273 [274.5,278.1] ['270','271','272','273','274','275','276','277','278','279'] 2014-06-01 2 28 2845 284.5 7 280 280 [284.5,288.1] ['280','281','282','283','284','285','286','287','288','289'] 2014-06-01 2 29 2945 294.5 7 290 294 [294.5,298.1] ['290','291','292','293','294','295','296','297','298','299'] 2014-06-01 3 30 3045 304.5 7 300 301 [304.5,308.1] ['300','301','302','303','304','305','306','307','308','309'] -2014-06-01 3 31 3145 314.5 7 310 315 [314.5,318.09999999999997] ['310','311','312','313','314','315','316','317','318','319'] -2014-06-01 3 32 3245 324.5 7 320 322 [324.5,328.09999999999997] ['320','321','322','323','324','325','326','327','328','329'] -2014-06-01 3 33 3345 334.5 7 330 336 [334.5,338.09999999999997] ['330','331','332','333','334','335','336','337','338','339'] -2014-06-01 3 34 3445 344.5 7 340 343 [344.5,348.09999999999997] ['340','341','342','343','344','345','346','347','348','349'] -2014-06-01 3 35 3545 354.5 7 350 350 [354.5,358.09999999999997] ['350','351','352','353','354','355','356','357','358','359'] +2014-06-01 3 31 3145 314.5 7 310 315 [314.5,318.1] ['310','311','312','313','314','315','316','317','318','319'] +2014-06-01 3 32 3245 324.5 7 320 322 [324.5,328.1] ['320','321','322','323','324','325','326','327','328','329'] +2014-06-01 3 33 3345 334.5 7 330 336 [334.5,338.1] ['330','331','332','333','334','335','336','337','338','339'] +2014-06-01 3 34 3445 344.5 7 340 343 [344.5,348.1] ['340','341','342','343','344','345','346','347','348','349'] +2014-06-01 3 35 3545 354.5 7 350 350 [354.5,358.1] ['350','351','352','353','354','355','356','357','358','359'] 2014-06-01 3 36 3645 364.5 7 360 364 [364.5,368.1] ['360','361','362','363','364','365','366','367','368','369'] 2014-06-01 3 37 3745 374.5 7 370 371 [374.5,378.1] ['370','371','372','373','374','375','376','377','378','379'] 2014-06-01 3 38 3845 384.5 7 380 385 [384.5,388.1] ['380','381','382','383','384','385','386','387','388','389'] @@ -45,19 +45,19 @@ 2014-06-01 4 44 4445 444.5 7 440 441 [444.5,448.1] ['440','441','442','443','444','445','446','447','448','449'] 2014-06-01 4 45 4545 454.5 7 450 455 [454.5,458.1] ['450','451','452','453','454','455','456','457','458','459'] 2014-06-01 4 46 4645 464.5 7 460 462 [464.5,468.1] ['460','461','462','463','464','465','466','467','468','469'] -2014-06-01 4 47 4745 474.5 7 470 476 [474.5,478.09999999999997] ['470','471','472','473','474','475','476','477','478','479'] -2014-06-01 4 48 4845 484.5 7 480 483 [484.5,488.09999999999997] ['480','481','482','483','484','485','486','487','488','489'] -2014-06-01 4 49 4945 494.5 7 490 490 [494.5,498.09999999999997] ['490','491','492','493','494','495','496','497','498','499'] -2014-06-01 5 50 5045 504.5 7 500 504 [504.5,508.09999999999997] ['500','501','502','503','504','505','506','507','508','509'] +2014-06-01 4 47 4745 474.5 7 470 476 [474.5,478.1] ['470','471','472','473','474','475','476','477','478','479'] +2014-06-01 4 48 4845 484.5 7 480 483 [484.5,488.1] ['480','481','482','483','484','485','486','487','488','489'] +2014-06-01 4 49 4945 494.5 7 490 490 [494.5,498.1] ['490','491','492','493','494','495','496','497','498','499'] +2014-06-01 5 50 5045 504.5 7 500 504 [504.5,508.1] ['500','501','502','503','504','505','506','507','508','509'] 2014-06-01 5 51 5145 514.5 7 510 511 [514.5,518.1] ['510','511','512','513','514','515','516','517','518','519'] 2014-06-01 5 52 5245 524.5 7 520 525 [524.5,528.1] ['520','521','522','523','524','525','526','527','528','529'] 2014-06-01 5 53 5345 534.5 7 530 532 [534.5,538.1] ['530','531','532','533','534','535','536','537','538','539'] 2014-06-01 5 54 5445 544.5 7 540 546 [544.5,548.1] ['540','541','542','543','544','545','546','547','548','549'] 2014-06-01 5 55 5545 554.5 7 550 553 [554.5,558.1] ['550','551','552','553','554','555','556','557','558','559'] 2014-06-01 5 56 5645 564.5 7 560 560 [564.5,568.1] ['560','561','562','563','564','565','566','567','568','569'] -2014-06-01 5 57 5745 574.5 7 570 574 [574.5,578.0999999999999] ['570','571','572','573','574','575','576','577','578','579'] -2014-06-01 5 58 5845 584.5 7 580 581 [584.5,588.0999999999999] ['580','581','582','583','584','585','586','587','588','589'] -2014-06-01 5 59 5945 594.5 7 590 595 [594.5,598.0999999999999] ['590','591','592','593','594','595','596','597','598','599'] +2014-06-01 5 57 5745 574.5 7 570 574 [574.5,578.1] ['570','571','572','573','574','575','576','577','578','579'] +2014-06-01 5 58 5845 584.5 7 580 581 [584.5,588.1] ['580','581','582','583','584','585','586','587','588','589'] +2014-06-01 5 59 5945 594.5 7 590 595 [594.5,598.1] ['590','591','592','593','594','595','596','597','598','599'] 2014-06-01 6 60 6045 604.5 7 600 602 [604.5,608.1] ['600','601','602','603','604','605','606','607','608','609'] 2014-06-01 6 61 6145 614.5 7 610 616 [614.5,618.1] ['610','611','612','613','614','615','616','617','618','619'] 2014-06-01 6 62 6245 624.5 7 620 623 [624.5,628.1] ['620','621','622','623','624','625','626','627','628','629'] @@ -82,15 +82,15 @@ 2014-06-01 8 81 8145 814.5 7 810 812 [814.5,818.1] ['810','811','812','813','814','815','816','817','818','819'] 2014-06-01 8 82 8245 824.5 7 820 826 [824.5,828.1] ['820','821','822','823','824','825','826','827','828','829'] 2014-06-01 8 83 8345 834.5 7 830 833 [834.5,838.1] ['830','831','832','833','834','835','836','837','838','839'] -2014-06-01 8 84 8445 844.5 7 840 840 [844.5,848.0999999999999] ['840','841','842','843','844','845','846','847','848','849'] -2014-06-01 8 85 8545 854.5 7 850 854 [854.5,858.0999999999999] ['850','851','852','853','854','855','856','857','858','859'] -2014-06-01 8 86 8645 864.5 7 860 861 [864.5,868.0999999999999] ['860','861','862','863','864','865','866','867','868','869'] -2014-06-01 8 87 8745 874.5 7 870 875 [874.5,878.0999999999999] ['870','871','872','873','874','875','876','877','878','879'] -2014-06-01 8 88 8845 884.5 7 880 882 [884.5,888.0999999999999] ['880','881','882','883','884','885','886','887','888','889'] -2014-06-01 8 89 8945 894.5 7 890 896 [894.5,898.0999999999999] ['890','891','892','893','894','895','896','897','898','899'] -2014-06-01 9 90 9045 904.5 7 900 903 [904.5,908.0999999999999] ['900','901','902','903','904','905','906','907','908','909'] -2014-06-01 9 91 9145 914.5 7 910 910 [914.5,918.0999999999999] ['910','911','912','913','914','915','916','917','918','919'] -2014-06-01 9 92 9245 924.5 7 920 924 [924.5,928.0999999999999] ['920','921','922','923','924','925','926','927','928','929'] +2014-06-01 8 84 8445 844.5 7 840 840 [844.5,848.1] ['840','841','842','843','844','845','846','847','848','849'] +2014-06-01 8 85 8545 854.5 7 850 854 [854.5,858.1] ['850','851','852','853','854','855','856','857','858','859'] +2014-06-01 8 86 8645 864.5 7 860 861 [864.5,868.1] ['860','861','862','863','864','865','866','867','868','869'] +2014-06-01 8 87 8745 874.5 7 870 875 [874.5,878.1] ['870','871','872','873','874','875','876','877','878','879'] +2014-06-01 8 88 8845 884.5 7 880 882 [884.5,888.1] ['880','881','882','883','884','885','886','887','888','889'] +2014-06-01 8 89 8945 894.5 7 890 896 [894.5,898.1] ['890','891','892','893','894','895','896','897','898','899'] +2014-06-01 9 90 9045 904.5 7 900 903 [904.5,908.1] ['900','901','902','903','904','905','906','907','908','909'] +2014-06-01 9 91 9145 914.5 7 910 910 [914.5,918.1] ['910','911','912','913','914','915','916','917','918','919'] +2014-06-01 9 92 9245 924.5 7 920 924 [924.5,928.1] ['920','921','922','923','924','925','926','927','928','929'] 2014-06-01 9 93 9345 934.5 7 930 931 [934.5,938.1] ['930','931','932','933','934','935','936','937','938','939'] 2014-06-01 9 94 9445 944.5 7 940 945 [944.5,948.1] ['940','941','942','943','944','945','946','947','948','949'] 2014-06-01 9 95 9545 954.5 7 950 952 [954.5,958.1] ['950','951','952','953','954','955','956','957','958','959'] @@ -99,7 +99,7 @@ 2014-06-01 9 98 9845 984.5 7 980 980 [984.5,988.1] ['980','981','982','983','984','985','986','987','988','989'] 2014-06-01 9 99 9945 994.5 7 990 994 [994.5,998.1] ['990','991','992','993','994','995','996','997','998','999'] 2014-06- 01 0 4950 49.5 7 0 0 [49.5,89.10000000000001] ['0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99'] -2014-06- 01 1 14950 149.5 7 100 105 [149.5,189.1] ['100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199'] +2014-06- 01 1 14950 149.5 7 100 105 [149.5,189.10000000000002] ['100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199'] 2014-06- 01 2 24950 249.5 7 200 203 [249.5,289.1] ['200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299'] 2014-06- 01 3 34950 349.5 7 300 301 [349.5,389.1] ['300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399'] 2014-06- 01 4 44950 449.5 7 400 406 [449.5,489.1] ['400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499'] "
