Skip to content

Commit 56a7338

Browse files
authored
fix SMARTBI cases & Decimalv3 (apache#174)
some SMARTBI cases will fail in fuzzy test. The result is because of the lack of `order by` after we added the scanner pooling. fix it. btw, fixed the legacy part of https://github.com/selectdb/usercases/pull/173 # Checklist * 内部Jira: * 修复PR: * master: * 1.2-lts: * 1.2-lts: * Doris-master: * [ ] 已修复 * [ ] 未修复 * [ ] 无问题 * Doris-1.2-lts: * [ ] 已修复 * [ ] 未修复 * [ ] 无问题 * Doris-1.1-lts: * [ ] 已修复 * [ ] 未修复 * [ ] 无问题
1 parent 0bd0e46 commit 56a7338

3 files changed

Lines changed: 478 additions & 478 deletions

File tree

‎regression-test/data/usercases/Decimalv3/sql/q01.out‎

Lines changed: 106 additions & 106 deletions
Original file line numberDiff line numberDiff line change
@@ -3,140 +3,140 @@
33
610782
44

55
-- !q01_2 --
6-
28390531014.22 28407338644.98 28373319379.42 28390715366.17 1933280.43725411 84866544723.33235013452655334015
6+
28390531014.22 28407338644.98 28373319379.42 28390715366.17 1933280.437254110 84866544723.332365895
77

88
-- !q01_3 --
9-
69000.00 69000.00 68799.99 69000.00 398.56594808 13967923.00514023600000000000
9+
69000.00 69000.00 68799.99 69000.00 398.565948080 13967923.005140236
1010

1111
-- !q01_4 --
12-
28093.81 28397.52 27734.00 28073.03 0E-8 0E-20
12+
28093.81 28397.52 27734.00 28073.03 0E-9 0E-9
1313

1414
-- !q01_5 --
15-
46482.2653 46509.7835 46454.0857 46482.5672 3.16525443 138947.35719672870211389096
15+
46482.2653 46509.7835 46454.0857 46482.5672 3.165254439 138947.357196728
1616

1717
-- !q01_6 --
18-
12879070142.85 12884731560.12 12873137162.19 12879117591.44 423406.49238726 20896321999.17029646416762622010
18+
12879070142.85 12884731560.12 12873137162.19 12879117591.44 423406.492387260 20896321999.170302400
1919

2020
-- !q01_7 --
21-
69000.00 69000.00 68799.99 69000.00 289.91769178 12917149.39511968000000000000
21+
69000.00 69000.00 68799.99 69000.00 289.917691780 12917149.395119680
2222

2323
-- !q01_8 --
24-
33043.00 33127.25 32950.72 33043.07 0E-8 0E-20
24+
33043.00 33127.25 32950.72 33043.07 0E-9 0E-9
2525

2626
-- !q01_9 --
27-
49371.2006 49392.9033 49348.4568 49371.3825 1.62310529 80104.89070531659062710408
27+
49371.2006 49392.9033 49348.4568 49371.3825 1.623105290 80104.890705316
2828

2929
-- !q01_10 --
30-
2021-1 1542437627.78 1544224228.94 1540580311.16 1542443273.44 457459.96820690 15730314417.89447807784261400000
31-
2021-10 2574371062.25 2575503859.90 2573217077.52 2574407481.91 79184.40996612 4600588196.69934630529598300000
32-
2021-11 2621350389.91 2622492903.99 2620161586.25 2621344770.59 72200.80293287 4353866199.77330437332234296010
33-
2021-12 2208838511.44 2209802624.13 2207782498.31 2208823152.45 71896.37902730 3546480164.56595901577985500000
34-
2021-2 1857799491.75 1859430961.49 1856134668.51 1857822141.53 240350.58332404 11055992861.79459449421714900000
35-
2021-3 2439024153.29 2440611143.72 2437445905.58 2439077981.76 157899.39519804 8606400481.08894365124634500000
36-
2021-4 2467619085.84 2469018171.00 2466224415.41 2467641607.84 139623.60228363 7863358962.80563349499760200000
37-
2021-5 2096861942.90 2098890853.66 2094902838.04 2096865925.37 209751.84938526 9222900498.95323297594447400000
38-
2021-6 1545287333.63 1546377970.47 1544166646.08 1545283112.57 144223.40019357 5105046610.97725689250188800000
39-
2021-7 1528425457.80 1529125377.92 1527703496.60 1528450258.66 79968.04941590 2780579371.74941157764812550005
40-
2021-8 2033958660.36 2034881244.66 2032976860.08 2033966372.51 80596.17351049 3605586028.19014403496072962000
41-
2021-9 1990012147.75 1990919973.09 1989060269.50 1990019192.62 69842.36002367 3182418235.42212666689913500000
42-
2022-1 1837399419.56 1838197566.19 1836547472.90 1837400035.66 71877.26241652 2865616165.74894122993604456000
43-
2022-2 1637497388.09 1638208737.61 1636772067.67 1637521688.67 57983.83108439 2329080047.90855118587462570000
44-
2022-3 9648341.87 9653028.21 9643265.81 9648370.59 422.37028541 18316479.76042615805964000000
30+
2021-1 1542437627.78 1544224228.94 1540580311.16 1542443273.44 457459.968206900 15730314417.894479406
31+
2021-10 2574371062.25 2575503859.90 2573217077.52 2574407481.91 79184.409966120 4600588196.699347509
32+
2021-11 2621350389.91 2622492903.99 2620161586.25 2621344770.59 72200.802932870 4353866199.773305541
33+
2021-12 2208838511.44 2209802624.13 2207782498.31 2208823152.45 71896.379027300 3546480164.565959961
34+
2021-2 1857799491.75 1859430961.49 1856134668.51 1857822141.53 240350.583324040 11055992861.794595704
35+
2021-3 2439024153.29 2440611143.72 2437445905.58 2439077981.76 157899.395198040 8606400481.088945033
36+
2021-4 2467619085.84 2469018171.00 2466224415.41 2467641607.84 139623.602283630 7863358962.805634739
37+
2021-5 2096861942.90 2098890853.66 2094902838.04 2096865925.37 209751.849385260 9222900498.953234361
38+
2021-6 1545287333.63 1546377970.47 1544166646.08 1545283112.57 144223.400193570 5105046610.977258087
39+
2021-7 1528425457.80 1529125377.92 1527703496.60 1528450258.66 79968.049415900 2780579371.749412598
40+
2021-8 2033958660.36 2034881244.66 2032976860.08 2033966372.51 80596.173510490 3605586028.190145096
41+
2021-9 1990012147.75 1990919973.09 1989060269.50 1990019192.62 69842.360023670 3182418235.422127502
42+
2022-1 1837399419.56 1838197566.19 1836547472.90 1837400035.66 71877.262416520 2865616165.748942223
43+
2022-2 1637497388.09 1638208737.61 1636772067.67 1637521688.67 57983.831084390 2329080047.908551974
44+
2022-3 9648341.87 9653028.21 9643265.81 9648370.59 422.370285410 18316479.760426161
4545

4646
-- !q01_11 --
47-
2021-1 41951.79 42000.00 41905.03 41969.31 398.56594808 13967923.00514023600000000000
48-
2021-10 66966.29 67016.50 66897.57 66952.80 212.38778798 11772497.92076829600000000000
49-
2021-11 69000.00 69000.00 68799.99 69000.00 148.66734969 9086841.28773169000000000000
50-
2021-12 59090.05 59099.64 59017.30 59090.05 289.91769178 12917149.39511968000000000000
51-
2021-2 58345.54 58354.14 58326.56 58354.14 248.50451742 11357922.35709397000000000000
52-
2021-3 61763.56 61781.83 61673.55 61781.80 164.42557013 9149914.66445741000000000000
53-
2021-4 64842.86 64895.22 64731.25 64859.30 190.70323237 9676282.01045380000000000000
54-
2021-5 59595.03 59603.00 59554.30 59589.90 378.47288922 13783062.53868815100000000000
55-
2021-6 41330.64 41341.57 41260.63 41320.50 359.70323577 10764763.19920927800000000000
56-
2021-7 42274.79 42411.32 42201.23 42278.67 222.39767734 8762466.26321922600000000000
57-
2021-8 50497.95 50562.11 50491.37 50507.34 169.93580509 6460145.31701541900000000000
58-
2021-9 52916.79 52956.47 52905.54 52905.54 145.77585523 6863127.26422840000000000000
59-
2022-1 47960.24 47989.00 47922.41 47984.82 197.49380037 6649227.19567117100000000000
60-
2022-2 45783.31 45850.00 45658.69 45748.34 229.67229297 8013130.79507044900000000000
61-
2022-3 43621.64 43750.00 43602.50 43602.50 41.15933902 1787117.50898549960000000000
47+
2021-1 41951.79 42000.00 41905.03 41969.31 398.565948080 13967923.005140236
48+
2021-10 66966.29 67016.50 66897.57 66952.80 212.387787980 11772497.920768296
49+
2021-11 69000.00 69000.00 68799.99 69000.00 148.667349690 9086841.287731690
50+
2021-12 59090.05 59099.64 59017.30 59090.05 289.917691780 12917149.395119680
51+
2021-2 58345.54 58354.14 58326.56 58354.14 248.504517420 11357922.357093970
52+
2021-3 61763.56 61781.83 61673.55 61781.80 164.425570130 9149914.664457410
53+
2021-4 64842.86 64895.22 64731.25 64859.30 190.703232370 9676282.010453800
54+
2021-5 59595.03 59603.00 59554.30 59589.90 378.472889220 13783062.538688151
55+
2021-6 41330.64 41341.57 41260.63 41320.50 359.703235770 10764763.199209278
56+
2021-7 42274.79 42411.32 42201.23 42278.67 222.397677340 8762466.263219226
57+
2021-8 50497.95 50562.11 50491.37 50507.34 169.935805090 6460145.317015419
58+
2021-9 52916.79 52956.47 52905.54 52905.54 145.775855230 6863127.264228400
59+
2022-1 47960.24 47989.00 47922.41 47984.82 197.493800370 6649227.195671171
60+
2022-2 45783.31 45850.00 45658.69 45748.34 229.672292970 8013130.795070449
61+
2022-3 43621.64 43750.00 43602.50 43602.50 41.159339020 1787117.508985500
6262

6363
-- !q01_12 --
64-
2021-1 28093.81 28397.52 27734.00 28073.03 0E-8 0E-20
65-
2021-10 43292.11 43326.84 43291.07 43298.56 0E-8 0E-20
66-
2021-11 53527.59 53620.96 53308.93 53531.00 0E-8 0E-20
67-
2021-12 42603.22 44953.41 41967.50 42431.05 0E-8 0E-20
68-
2021-2 32386.48 32410.05 32333.01 32396.31 0E-8 0E-20
69-
2021-3 45030.00 45056.98 45020.25 45048.59 0E-8 0E-20
70-
2021-4 47061.80 47284.00 47004.20 47091.34 0E-8 0E-20
71-
2021-5 30500.01 31339.99 30066.00 30500.00 0E-8 0E-20
72-
2021-6 28900.30 28920.00 28600.00 28839.68 0E-8 0E-20
73-
2021-7 29301.00 29409.00 29296.39 29317.73 0E-8 0E-20
74-
2021-8 37418.88 37493.98 37300.00 37419.40 0E-8 0E-20
75-
2021-9 39669.24 39973.83 39573.21 39708.53 0E-8 0E-20
76-
2022-1 33043.00 33127.25 32950.72 33043.07 0E-8 0E-20
77-
2022-2 34348.67 34406.14 34324.05 34354.28 0E-8 0E-20
78-
2022-3 42918.62 42939.95 42870.04 42920.46 0E-8 0E-20
64+
2021-1 28093.81 28397.52 27734.00 28073.03 0E-9 0E-9
65+
2021-10 43292.11 43326.84 43291.07 43298.56 0E-9 0E-9
66+
2021-11 53527.59 53620.96 53308.93 53531.00 0E-9 0E-9
67+
2021-12 42603.22 44953.41 41967.50 42431.05 0E-9 0E-9
68+
2021-2 32386.48 32410.05 32333.01 32396.31 0E-9 0E-9
69+
2021-3 45030.00 45056.98 45020.25 45048.59 0E-9 0E-9
70+
2021-4 47061.80 47284.00 47004.20 47091.34 0E-9 0E-9
71+
2021-5 30500.01 31339.99 30066.00 30500.00 0E-9 0E-9
72+
2021-6 28900.30 28920.00 28600.00 28839.68 0E-9 0E-9
73+
2021-7 29301.00 29409.00 29296.39 29317.73 0E-9 0E-9
74+
2021-8 37418.88 37493.98 37300.00 37419.40 0E-9 0E-9
75+
2021-9 39669.24 39973.83 39573.21 39708.53 0E-9 0E-9
76+
2022-1 33043.00 33127.25 32950.72 33043.07 0E-9 0E-9
77+
2022-2 34348.67 34406.14 34324.05 34354.28 0E-9 0E-9
78+
2022-3 42918.62 42939.95 42870.04 42920.46 0E-9 0E-9
7979

8080
-- !q01_13 --
81-
2021-1 34553.5882 34593.6116 34511.9808 34553.7147 10.24798871 352389.48941272156808715728
82-
2021-10 57669.6026 57694.9789 57643.7517 57670.4185 1.77384430 103059.77143143696920465911
83-
2021-11 60679.4071 60705.8542 60651.8885 60679.2770 1.67131488 100783.93980956723086394312
84-
2021-12 49481.1494 49502.7469 49457.4932 49480.8053 1.61058196 79446.24024565320375850929
85-
2021-2 46076.3762 46116.8393 46035.0860 46076.9380 5.96107597 274206.17216752466503514754
86-
2021-3 54637.6378 54673.1887 54602.2828 54638.8436 3.53717283 192795.70970181325383616364
87-
2021-4 57120.8121 57153.1984 57088.5281 57121.3335 3.23202783 182022.19821309336793975930
88-
2021-5 46972.7137 47018.1642 46928.8270 46972.8029 4.69874214 206606.19397296668852922208
89-
2021-6 35770.5401 35795.7863 35744.5982 35770.4424 3.33850463 118172.37525410316880791407
90-
2021-7 34238.9215 34254.6007 34222.7485 34239.4771 1.79139895 62288.96442090975756380209
91-
2021-8 45563.5900 45584.2572 45541.5963 45563.7628 1.80546983 80770.29633042437354302709
92-
2021-9 46065.0960 46086.1104 46043.0617 46065.2590 1.61672129 73667.08878291959877081331
93-
2022-1 41160.3812 41178.2608 41141.2964 41160.3950 1.61015372 64193.91052304975873512644
94-
2022-2 40612.5344 40630.1770 40594.5453 40613.1371 1.43809104 57764.88214058906710998575
95-
2022-3 43266.1070 43287.1220 43243.3444 43266.2358 1.89403715 82136.68054002761461721973
81+
2021-1 34553.5882 34593.6116 34511.9808 34553.7147 10.247988714 352389.489412721
82+
2021-10 57669.6026 57694.9789 57643.7517 57670.4185 1.773844309 103059.771431436
83+
2021-11 60679.4071 60705.8542 60651.8885 60679.2770 1.671314882 100783.939809567
84+
2021-12 49481.1494 49502.7469 49457.4932 49480.8053 1.610581967 79446.240245653
85+
2021-2 46076.3762 46116.8393 46035.0860 46076.9380 5.961075975 274206.172167524
86+
2021-3 54637.6378 54673.1887 54602.2828 54638.8436 3.537172831 192795.709701813
87+
2021-4 57120.8121 57153.1984 57088.5281 57121.3335 3.232027830 182022.198213093
88+
2021-5 46972.7137 47018.1642 46928.8270 46972.8029 4.698742145 206606.193972966
89+
2021-6 35770.5401 35795.7863 35744.5982 35770.4424 3.338504634 118172.375254103
90+
2021-7 34238.9215 34254.6007 34222.7485 34239.4771 1.791398956 62288.964420909
91+
2021-8 45563.5900 45584.2572 45541.5963 45563.7628 1.805469836 80770.296330424
92+
2021-9 46065.0960 46086.1104 46043.0617 46065.2590 1.616721296 73667.088782919
93+
2022-1 41160.3812 41178.2608 41141.2964 41160.3950 1.610153727 64193.910523049
94+
2022-2 40612.5344 40630.1770 40594.5453 40613.1371 1.438091048 57764.882140589
95+
2022-3 43266.1070 43287.1220 43243.3444 43266.2358 1.894037154 82136.680540027
9696

9797
-- !q01_14 --
98-
2021-1 1542437627.78 1544224228.94 1540580311.16 1542443273.44 457459.96820690 15730314417.89447807784261400000
99-
2021-2 1857799491.75 1859430961.49 1856134668.51 1857822141.53 240350.58332404 11055992861.79459449421714900000
100-
2021-3 2439024153.29 2440611143.72 2437445905.58 2439077981.76 157899.39519804 8606400481.08894365124634500000
101-
2021-4 2467619085.84 2469018171.00 2466224415.41 2467641607.84 139623.60228363 7863358962.80563349499760200000
102-
2021-5 2096861942.90 2098890853.66 2094902838.04 2096865925.37 209751.84938526 9222900498.95323297594447400000
103-
2021-6 1545287333.63 1546377970.47 1544166646.08 1545283112.57 144223.40019357 5105046610.97725689250188800000
98+
2021-1 1542437627.78 1544224228.94 1540580311.16 1542443273.44 457459.968206900 15730314417.894479406
99+
2021-2 1857799491.75 1859430961.49 1856134668.51 1857822141.53 240350.583324040 11055992861.794595704
100+
2021-3 2439024153.29 2440611143.72 2437445905.58 2439077981.76 157899.395198040 8606400481.088945033
101+
2021-4 2467619085.84 2469018171.00 2466224415.41 2467641607.84 139623.602283630 7863358962.805634739
102+
2021-5 2096861942.90 2098890853.66 2094902838.04 2096865925.37 209751.849385260 9222900498.953234361
103+
2021-6 1545287333.63 1546377970.47 1544166646.08 1545283112.57 144223.400193570 5105046610.977258087
104104

105105
-- !q01_15 --
106-
2021-1 41951.79 42000.00 41905.03 41969.31 398.56594808 13967923.00514023600000000000
107-
2021-10 66966.29 67016.50 66897.57 66952.80 212.38778798 11772497.92076829600000000000
108-
2021-11 69000.00 69000.00 68799.99 69000.00 148.66734969 9086841.28773169000000000000
109-
2021-12 59090.05 59099.64 59017.30 59090.05 289.91769178 12917149.39511968000000000000
110-
2021-2 58345.54 58354.14 58326.56 58354.14 248.50451742 11357922.35709397000000000000
111-
2021-3 61763.56 61781.83 61673.55 61781.80 164.42557013 9149914.66445741000000000000
112-
2021-4 64842.86 64895.22 64731.25 64859.30 190.70323237 9676282.01045380000000000000
113-
2021-5 59595.03 59603.00 59554.30 59589.90 378.47288922 13783062.53868815100000000000
114-
2021-6 41330.64 41341.57 41260.63 41320.50 359.70323577 10764763.19920927800000000000
115-
2021-7 42274.79 42411.32 42201.23 42278.67 222.39767734 8762466.26321922600000000000
116-
2022-2 45783.31 45850.00 45658.69 45748.34 229.67229297 8013130.79507044900000000000
106+
2021-1 41951.79 42000.00 41905.03 41969.31 398.565948080 13967923.005140236
107+
2021-10 66966.29 67016.50 66897.57 66952.80 212.387787980 11772497.920768296
108+
2021-11 69000.00 69000.00 68799.99 69000.00 148.667349690 9086841.287731690
109+
2021-12 59090.05 59099.64 59017.30 59090.05 289.917691780 12917149.395119680
110+
2021-2 58345.54 58354.14 58326.56 58354.14 248.504517420 11357922.357093970
111+
2021-3 61763.56 61781.83 61673.55 61781.80 164.425570130 9149914.664457410
112+
2021-4 64842.86 64895.22 64731.25 64859.30 190.703232370 9676282.010453800
113+
2021-5 59595.03 59603.00 59554.30 59589.90 378.472889220 13783062.538688151
114+
2021-6 41330.64 41341.57 41260.63 41320.50 359.703235770 10764763.199209278
115+
2021-7 42274.79 42411.32 42201.23 42278.67 222.397677340 8762466.263219226
116+
2022-2 45783.31 45850.00 45658.69 45748.34 229.672292970 8013130.795070449
117117

118118
-- !q01_16 --
119-
2021-1 28093.81 28397.52 27734.00 28073.03 0E-8 0E-20
120-
2021-10 43292.11 43326.84 43291.07 43298.56 0E-8 0E-20
121-
2021-11 53527.59 53620.96 53308.93 53531.00 0E-8 0E-20
122-
2021-12 42603.22 44953.41 41967.50 42431.05 0E-8 0E-20
123-
2021-2 32386.48 32410.05 32333.01 32396.31 0E-8 0E-20
124-
2021-3 45030.00 45056.98 45020.25 45048.59 0E-8 0E-20
125-
2021-4 47061.80 47284.00 47004.20 47091.34 0E-8 0E-20
126-
2021-5 30500.01 31339.99 30066.00 30500.00 0E-8 0E-20
127-
2021-6 28900.30 28920.00 28600.00 28839.68 0E-8 0E-20
128-
2021-7 29301.00 29409.00 29296.39 29317.73 0E-8 0E-20
129-
2021-8 37418.88 37493.98 37300.00 37419.40 0E-8 0E-20
130-
2021-9 39669.24 39973.83 39573.21 39708.53 0E-8 0E-20
131-
2022-1 33043.00 33127.25 32950.72 33043.07 0E-8 0E-20
132-
2022-2 34348.67 34406.14 34324.05 34354.28 0E-8 0E-20
133-
2022-3 42918.62 42939.95 42870.04 42920.46 0E-8 0E-20
119+
2021-1 28093.81 28397.52 27734.00 28073.03 0E-9 0E-9
120+
2021-10 43292.11 43326.84 43291.07 43298.56 0E-9 0E-9
121+
2021-11 53527.59 53620.96 53308.93 53531.00 0E-9 0E-9
122+
2021-12 42603.22 44953.41 41967.50 42431.05 0E-9 0E-9
123+
2021-2 32386.48 32410.05 32333.01 32396.31 0E-9 0E-9
124+
2021-3 45030.00 45056.98 45020.25 45048.59 0E-9 0E-9
125+
2021-4 47061.80 47284.00 47004.20 47091.34 0E-9 0E-9
126+
2021-5 30500.01 31339.99 30066.00 30500.00 0E-9 0E-9
127+
2021-6 28900.30 28920.00 28600.00 28839.68 0E-9 0E-9
128+
2021-7 29301.00 29409.00 29296.39 29317.73 0E-9 0E-9
129+
2021-8 37418.88 37493.98 37300.00 37419.40 0E-9 0E-9
130+
2021-9 39669.24 39973.83 39573.21 39708.53 0E-9 0E-9
131+
2022-1 33043.00 33127.25 32950.72 33043.07 0E-9 0E-9
132+
2022-2 34348.67 34406.14 34324.05 34354.28 0E-9 0E-9
133+
2022-3 42918.62 42939.95 42870.04 42920.46 0E-9 0E-9
134134

135135
-- !q01_17 --
136-
2021-1 34553.5882 34593.6116 34511.9808 34553.7147 10.24798871 352389.48941272156808715728
137-
2021-2 46076.3762 46116.8393 46035.0860 46076.9380 5.96107597 274206.17216752466503514754
138-
2021-3 54637.6378 54673.1887 54602.2828 54638.8436 3.53717283 192795.70970181325383616364
139-
2021-4 57120.8121 57153.1984 57088.5281 57121.3335 3.23202783 182022.19821309336793975930
140-
2021-5 46972.7137 47018.1642 46928.8270 46972.8029 4.69874214 206606.19397296668852922208
141-
2021-6 35770.5401 35795.7863 35744.5982 35770.4424 3.33850463 118172.37525410316880791407
136+
2021-1 34553.5882 34593.6116 34511.9808 34553.7147 10.247988714 352389.489412721
137+
2021-2 46076.3762 46116.8393 46035.0860 46076.9380 5.961075975 274206.172167524
138+
2021-3 54637.6378 54673.1887 54602.2828 54638.8436 3.537172831 192795.709701813
139+
2021-4 57120.8121 57153.1984 57088.5281 57121.3335 3.232027830 182022.198213093
140+
2021-5 46972.7137 47018.1642 46928.8270 46972.8029 4.698742145 206606.193972966
141+
2021-6 35770.5401 35795.7863 35744.5982 35770.4424 3.338504634 118172.375254103
142142

0 commit comments

Comments
 (0)