This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 d1e7edabd8d [fix](Nereids) decimalv2 and int/date bit arithmetic need
cast to bigint (#32311)
d1e7edabd8d is described below
commit d1e7edabd8d742321b519587021658ab8ac67c27
Author: morrySnow <[email protected]>
AuthorDate: Wed Mar 20 18:20:34 2024 +0800
[fix](Nereids) decimalv2 and int/date bit arithmetic need cast to bigint
(#32311)
---
.../doris/nereids/util/TypeCoercionUtils.java | 12 +-
regression-test/data/nereids_arith_p0/decimal.out | 2400 ++++++++++----------
regression-test/data/nereids_arith_p0/integer.out | 776 +++----
.../suites/nereids_arith_p0/load.groovy | 6 +-
4 files changed, 1598 insertions(+), 1596 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/util/TypeCoercionUtils.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/util/TypeCoercionUtils.java
index e2b183cde4a..758bb03a043 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/util/TypeCoercionUtils.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/util/TypeCoercionUtils.java
@@ -798,12 +798,6 @@ public class TypeCoercionUtils {
commonType = DoubleType.INSTANCE;
}
- // we treat decimalv2 vs dicimalv3, largeint or bigint as decimalv3
way.
- if ((t1.isDecimalV3Type() || t1.isBigIntType() || t1.isLargeIntType())
&& t2.isDecimalV2Type()
- || t1.isDecimalV2Type() && (t2.isDecimalV3Type() ||
t2.isBigIntType() || t2.isLargeIntType())) {
- return processDecimalV3BinaryArithmetic(binaryArithmetic, left,
right);
- }
-
if (t1.isDecimalV2Type() || t2.isDecimalV2Type()) {
// to be consistent with old planner
// see findCommonType() method in ArithmeticExpr.java
@@ -832,6 +826,12 @@ public class TypeCoercionUtils {
return binaryArithmetic;
}
+ // we treat decimalv2 vs dicimalv3, largeint or bigint as decimalv3
way.
+ if ((t1.isDecimalV3Type() || t1.isBigIntType() || t1.isLargeIntType())
&& t2.isDecimalV2Type()
+ || t1.isDecimalV2Type() && (t2.isDecimalV3Type() ||
t2.isBigIntType() || t2.isLargeIntType())) {
+ return processDecimalV3BinaryArithmetic(binaryArithmetic, left,
right);
+ }
+
// if double as common type, all arithmetic should cast both side to
double
if (isArithmetic && commonType.isDoubleType()) {
return castChildren(binaryArithmetic, left, right, commonType);
diff --git a/regression-test/data/nereids_arith_p0/decimal.out
b/regression-test/data/nereids_arith_p0/decimal.out
index 8fac14d37d2..7b0e2bc82b2 100644
--- a/regression-test/data/nereids_arith_p0/decimal.out
+++ b/regression-test/data/nereids_arith_p0/decimal.out
@@ -1538,109 +1538,109 @@
-- !sql_test_Float_DecimalV2_0 --
\N \N \N
-1 24.495000001490116 -24.294999998509883
-2 34.684000002980234 -34.28399999701977
-3 49.05600001192093 -48.45599998807907
-4 69.34300000596046 -68.54299999403953
-5 97.994 -96.994
-6 138.47400002384185 -137.27399997615814
-7 195.67999998807906 -194.28000001192092
-8 276.5410000119209 -274.94099998807906
-9 390.8549999761581 -389.05500002384184
-10 552.479 -550.479
-11 781.0080000238419 -778.8079999761582
-12 1104.1570000476838 -1101.7569999523164
-13 24.495000001490116 -24.294999998509883
-14 34.684000002980234 -34.28399999701977
-15 49.05600001192093 -48.45599998807907
-16 69.34300000596046 -68.54299999403953
-17 97.994 -96.994
-18 138.47400002384185 -137.27399997615814
-19 195.67999998807906 -194.28000001192092
-20 276.5410000119209 -274.94099998807906
-21 390.8549999761581 -389.05500002384184
-22 552.479 -550.479
-23 781.0080000238419 -778.8079999761582
-24 1104.1570000476838 -1101.7569999523164
+1 24.495000000 -24.295000000
+2 34.684000000 -34.284000000
+3 49.056000000 -48.456000000
+4 69.343000000 -68.543000000
+5 97.994000000 -96.994000000
+6 138.474000000 -137.274000000
+7 195.680000000 -194.280000000
+8 276.541000000 -274.941000000
+9 390.855000000 -389.055000000
+10 552.479000000 -550.479000000
+11 781.008000000 -778.808000000
+12 1104.157000000 -1101.757000000
+13 24.495000000 -24.295000000
+14 34.684000000 -34.284000000
+15 49.056000000 -48.456000000
+16 69.343000000 -68.543000000
+17 97.994000000 -96.994000000
+18 138.474000000 -137.274000000
+19 195.680000000 -194.280000000
+20 276.541000000 -274.941000000
+21 390.855000000 -389.055000000
+22 552.479000000 -550.479000000
+23 781.008000000 -778.808000000
+24 1104.157000000 -1101.757000000
-- !sql_test_Float_DecimalV2_notn_0 --
-1 24.495000001490116 -24.294999998509883
-2 34.684000002980234 -34.28399999701977
-3 49.05600001192093 -48.45599998807907
-4 69.34300000596046 -68.54299999403953
-5 97.994 -96.994
-6 138.47400002384185 -137.27399997615814
-7 195.67999998807906 -194.28000001192092
-8 276.5410000119209 -274.94099998807906
-9 390.8549999761581 -389.05500002384184
-10 552.479 -550.479
-11 781.0080000238419 -778.8079999761582
-12 1104.1570000476838 -1101.7569999523164
-13 24.495000001490116 -24.294999998509883
-14 34.684000002980234 -34.28399999701977
-15 49.05600001192093 -48.45599998807907
-16 69.34300000596046 -68.54299999403953
-17 97.994 -96.994
-18 138.47400002384185 -137.27399997615814
-19 195.67999998807906 -194.28000001192092
-20 276.5410000119209 -274.94099998807906
-21 390.8549999761581 -389.05500002384184
-22 552.479 -550.479
-23 781.0080000238419 -778.8079999761582
-24 1104.1570000476838 -1101.7569999523164
+1 24.495000000 -24.295000000
+2 34.684000000 -34.284000000
+3 49.056000000 -48.456000000
+4 69.343000000 -68.543000000
+5 97.994000000 -96.994000000
+6 138.474000000 -137.274000000
+7 195.680000000 -194.280000000
+8 276.541000000 -274.941000000
+9 390.855000000 -389.055000000
+10 552.479000000 -550.479000000
+11 781.008000000 -778.808000000
+12 1104.157000000 -1101.757000000
+13 24.495000000 -24.295000000
+14 34.684000000 -34.284000000
+15 49.056000000 -48.456000000
+16 69.343000000 -68.543000000
+17 97.994000000 -96.994000000
+18 138.474000000 -137.274000000
+19 195.680000000 -194.280000000
+20 276.541000000 -274.941000000
+21 390.855000000 -389.055000000
+22 552.479000000 -550.479000000
+23 781.008000000 -778.808000000
+24 1104.157000000 -1101.757000000
-- !sql_test_Float_DecimalV2_1 --
\N \N \N \N
-1 2.4395000363513826 0.0040992007169549545 0.10000000149011612
-2 6.896800102770329 0.005799791293940153 0.20000000298023224
-3 14.626800581216813 0.0061530890951047865 0.30000001192092896
-4 27.577200410932303 0.005801894404949951 0.4000000059604645
-5 48.747 0.005128520729480788 0.5
-6 82.72440328717231 0.004351799642005439 0.6000000238418579
-7 136.48599767565727 0.0035901117451998723 0.699999988079071
-8 220.59280328708886 0.0029012733395502627 0.800000011920929
-9 350.95949070274827 0.002307958549468893 0.8999999761581421
-10 551.479 0.0018133056743774468 1.0
-11 857.8988185944557 0.0014104227983837297 1.100000023841858
-12 1323.5484525930883 0.0010879844342832183 1.2000000476837158
-13 2.4395000363513826 0.0040992007169549545 0.10000000149011612
-14 6.896800102770329 0.005799791293940153 0.20000000298023224
-15 14.626800581216813 0.0061530890951047865 0.30000001192092896
-16 27.577200410932303 0.005801894404949951 0.4000000059604645
-17 48.747 0.005128520729480788 0.5
-18 82.72440328717231 0.004351799642005439 0.6000000238418579
-19 136.48599767565727 0.0035901117451998723 0.699999988079071
-20 220.59280328708886 0.0029012733395502627 0.800000011920929
-21 350.95949070274827 0.002307958549468893 0.8999999761581421
-22 551.479 0.0018133056743774468 1.0
-23 857.8988185944557 0.0014104227983837297 1.100000023841858
-24 1323.5484525930883 0.0010879844342832183 1.2000000476837158
+1 2.439500000 0.0040992007169549545 0.100000000
+2 6.896800000 0.005799791293940153 0.200000000
+3 14.626800000 0.0061530890951047865 0.300000000
+4 27.577200000 0.005801894404949951 0.400000000
+5 48.747000000 0.005128520729480788 0.500000000
+6 82.724400000 0.004351799642005439 0.600000000
+7 136.486000000 0.0035901117451998723 0.700000000
+8 220.592800000 0.0029012733395502627 0.800000000
+9 350.959500000 0.002307958549468893 0.900000000
+10 551.479000000 0.0018133056743774468 1.000000000
+11 857.898800000 0.0014104227983837297 1.100000000
+12 1323.548400000 0.0010879844342832183 1.200000000
+13 2.439500000 0.0040992007169549545 0.100000000
+14 6.896800000 0.005799791293940153 0.200000000
+15 14.626800000 0.0061530890951047865 0.300000000
+16 27.577200000 0.005801894404949951 0.400000000
+17 48.747000000 0.005128520729480788 0.500000000
+18 82.724400000 0.004351799642005439 0.600000000
+19 136.486000000 0.0035901117451998723 0.700000000
+20 220.592800000 0.0029012733395502627 0.800000000
+21 350.959500000 0.002307958549468893 0.900000000
+22 551.479000000 0.0018133056743774468 1.000000000
+23 857.898800000 0.0014104227983837297 1.100000000
+24 1323.548400000 0.0010879844342832183 1.200000000
-- !sql_test_Float_DecimalV2_notn_1 --
-1 2.4395000363513826 0.0040992007169549545 0.10000000149011612
-2 6.896800102770329 0.005799791293940153 0.20000000298023224
-3 14.626800581216813 0.0061530890951047865 0.30000001192092896
-4 27.577200410932303 0.005801894404949951 0.4000000059604645
-5 48.747 0.005128520729480788 0.5
-6 82.72440328717231 0.004351799642005439 0.6000000238418579
-7 136.48599767565727 0.0035901117451998723 0.699999988079071
-8 220.59280328708886 0.0029012733395502627 0.800000011920929
-9 350.95949070274827 0.002307958549468893 0.8999999761581421
-10 551.479 0.0018133056743774468 1.0
-11 857.8988185944557 0.0014104227983837297 1.100000023841858
-12 1323.5484525930883 0.0010879844342832183 1.2000000476837158
-13 2.4395000363513826 0.0040992007169549545 0.10000000149011612
-14 6.896800102770329 0.005799791293940153 0.20000000298023224
-15 14.626800581216813 0.0061530890951047865 0.30000001192092896
-16 27.577200410932303 0.005801894404949951 0.4000000059604645
-17 48.747 0.005128520729480788 0.5
-18 82.72440328717231 0.004351799642005439 0.6000000238418579
-19 136.48599767565727 0.0035901117451998723 0.699999988079071
-20 220.59280328708886 0.0029012733395502627 0.800000011920929
-21 350.95949070274827 0.002307958549468893 0.8999999761581421
-22 551.479 0.0018133056743774468 1.0
-23 857.8988185944557 0.0014104227983837297 1.100000023841858
-24 1323.5484525930883 0.0010879844342832183 1.2000000476837158
+1 2.439500000 0.0040992007169549545 0.100000000
+2 6.896800000 0.005799791293940153 0.200000000
+3 14.626800000 0.0061530890951047865 0.300000000
+4 27.577200000 0.005801894404949951 0.400000000
+5 48.747000000 0.005128520729480788 0.500000000
+6 82.724400000 0.004351799642005439 0.600000000
+7 136.486000000 0.0035901117451998723 0.700000000
+8 220.592800000 0.0029012733395502627 0.800000000
+9 350.959500000 0.002307958549468893 0.900000000
+10 551.479000000 0.0018133056743774468 1.000000000
+11 857.898800000 0.0014104227983837297 1.100000000
+12 1323.548400000 0.0010879844342832183 1.200000000
+13 2.439500000 0.0040992007169549545 0.100000000
+14 6.896800000 0.005799791293940153 0.200000000
+15 14.626800000 0.0061530890951047865 0.300000000
+16 27.577200000 0.005801894404949951 0.400000000
+17 48.747000000 0.005128520729480788 0.500000000
+18 82.724400000 0.004351799642005439 0.600000000
+19 136.486000000 0.0035901117451998723 0.700000000
+20 220.592800000 0.0029012733395502627 0.800000000
+21 350.959500000 0.002307958549468893 0.900000000
+22 551.479000000 0.0018133056743774468 1.000000000
+23 857.898800000 0.0014104227983837297 1.100000000
+24 1323.548400000 0.0010879844342832183 1.200000000
-- !sql_test_Float_DecimalV2_2 --
\N \N
@@ -5301,109 +5301,109 @@
-- !sql_test_Double_DecimalV2_0 --
\N \N \N
-1 24.9194 -23.8706
-2 35.2256 -33.7424
-3 49.7928 -47.7192
-4 70.3921 -67.4939
-5 99.525 -95.463
-6 140.7288 -135.01919999999998
-7 199.0018 -190.95819999999998
-8 281.4155 -270.06649999999996
-9 397.96909999999997 -381.9409
-10 562.8038 -540.1542000000001
-11 795.9166 -763.8994
-12 1125.5910000000001 -1080.323
-13 24.9194 -23.8706
-14 35.2256 -33.7424
-15 49.7928 -47.7192
-16 70.3921 -67.4939
-17 99.525 -95.463
-18 140.7288 -135.01919999999998
-19 199.0018 -190.95819999999998
-20 281.4155 -270.06649999999996
-21 397.96909999999997 -381.9409
-22 562.8038 -540.1542000000001
-23 795.9166 -763.8994
-24 1125.5910000000001 -1080.323
+1 24.919400000 -23.870600000
+2 35.225600000 -33.742400000
+3 49.792800000 -47.719200000
+4 70.392100000 -67.493900000
+5 99.525000000 -95.463000000
+6 140.728800000 -135.019200000
+7 199.001800000 -190.958200000
+8 281.415500000 -270.066500000
+9 397.969100000 -381.940900000
+10 562.803800000 -540.154200000
+11 795.916600000 -763.899400000
+12 1125.591000000 -1080.323000000
+13 24.919400000 -23.870600000
+14 35.225600000 -33.742400000
+15 49.792800000 -47.719200000
+16 70.392100000 -67.493900000
+17 99.525000000 -95.463000000
+18 140.728800000 -135.019200000
+19 199.001800000 -190.958200000
+20 281.415500000 -270.066500000
+21 397.969100000 -381.940900000
+22 562.803800000 -540.154200000
+23 795.916600000 -763.899400000
+24 1125.591000000 -1080.323000000
-- !sql_test_Double_DecimalV2_notn_0 --
-1 24.9194 -23.8706
-2 35.2256 -33.7424
-3 49.7928 -47.7192
-4 70.3921 -67.4939
-5 99.525 -95.463
-6 140.7288 -135.01919999999998
-7 199.0018 -190.95819999999998
-8 281.4155 -270.06649999999996
-9 397.96909999999997 -381.9409
-10 562.8038 -540.1542000000001
-11 795.9166 -763.8994
-12 1125.5910000000001 -1080.323
-13 24.9194 -23.8706
-14 35.2256 -33.7424
-15 49.7928 -47.7192
-16 70.3921 -67.4939
-17 99.525 -95.463
-18 140.7288 -135.01919999999998
-19 199.0018 -190.95819999999998
-20 281.4155 -270.06649999999996
-21 397.96909999999997 -381.9409
-22 562.8038 -540.1542000000001
-23 795.9166 -763.8994
-24 1125.5910000000001 -1080.323
+1 24.919400000 -23.870600000
+2 35.225600000 -33.742400000
+3 49.792800000 -47.719200000
+4 70.392100000 -67.493900000
+5 99.525000000 -95.463000000
+6 140.728800000 -135.019200000
+7 199.001800000 -190.958200000
+8 281.415500000 -270.066500000
+9 397.969100000 -381.940900000
+10 562.803800000 -540.154200000
+11 795.916600000 -763.899400000
+12 1125.591000000 -1080.323000000
+13 24.919400000 -23.870600000
+14 35.225600000 -33.742400000
+15 49.792800000 -47.719200000
+16 70.392100000 -67.493900000
+17 99.525000000 -95.463000000
+18 140.728800000 -135.019200000
+19 199.001800000 -190.958200000
+20 281.415500000 -270.066500000
+21 397.969100000 -381.940900000
+22 562.803800000 -540.154200000
+23 795.916600000 -763.899400000
+24 1125.591000000 -1080.323000000
-- !sql_test_Double_DecimalV2_1 --
\N \N \N \N
-1 12.792738 0.021496208239393317 0.5244
-2 25.573334400000004 0.02150562579747129 0.7416
-3 50.5502208 0.021265075067683978 1.0368
-4 99.9053013 0.02101881264232772 1.4491
-5 198.01031400000002 0.020832051203150966 2.031
-6 393.60269519999997 0.020705861873884852 2.8548
-7 784.1705639999999 0.02062673094676377 4.0218
-8 1564.6923044999999 0.02057909414994506 5.6745
-9 3125.1383654999995 0.020551345668089905 8.0141
-10 6245.3893792 0.020535324101189707 11.3248
-11 12485.2352088 0.020526267200746757 16.0086
-12 24964.328738000004 0.02052119892253279 22.634
-13 12.792738 0.021496208239393317 0.5244
-14 25.573334400000004 0.02150562579747129 0.7416
-15 50.5502208 0.021265075067683978 1.0368
-16 99.9053013 0.02101881264232772 1.4491
-17 198.01031400000002 0.020832051203150966 2.031
-18 393.60269519999997 0.020705861873884852 2.8548
-19 784.1705639999999 0.02062673094676377 4.0218
-20 1564.6923044999999 0.02057909414994506 5.6745
-21 3125.1383654999995 0.020551345668089905 8.0141
-22 6245.3893792 0.020535324101189707 11.3248
-23 12485.2352088 0.020526267200746757 16.0086
-24 24964.328738000004 0.02052119892253279 22.634
+1 12.792738000 0.021496208239393317 0.524400000
+2 25.573334400 0.02150562579747129 0.741600000
+3 50.550220800 0.021265075067683978 1.036800000
+4 99.905301300 0.02101881264232772 1.449100000
+5 198.010314000 0.020832051203150966 2.031000000
+6 393.602695200 0.020705861873884852 2.854800000
+7 784.170564000 0.02062673094676377 4.021800000
+8 1564.692304500 0.02057909414994506 5.674500000
+9 3125.138365500 0.020551345668089905 8.014100000
+10 6245.389379200 0.020535324101189707 11.324800000
+11 12485.235208800 0.020526267200746757 16.008600000
+12 24964.328738000 0.02052119892253279 22.634000000
+13 12.792738000 0.021496208239393317 0.524400000
+14 25.573334400 0.02150562579747129 0.741600000
+15 50.550220800 0.021265075067683978 1.036800000
+16 99.905301300 0.02101881264232772 1.449100000
+17 198.010314000 0.020832051203150966 2.031000000
+18 393.602695200 0.020705861873884852 2.854800000
+19 784.170564000 0.02062673094676377 4.021800000
+20 1564.692304500 0.02057909414994506 5.674500000
+21 3125.138365500 0.020551345668089905 8.014100000
+22 6245.389379200 0.020535324101189707 11.324800000
+23 12485.235208800 0.020526267200746757 16.008600000
+24 24964.328738000 0.02052119892253279 22.634000000
-- !sql_test_Double_DecimalV2_notn_1 --
-1 12.792738 0.021496208239393317 0.5244
-2 25.573334400000004 0.02150562579747129 0.7416
-3 50.5502208 0.021265075067683978 1.0368
-4 99.9053013 0.02101881264232772 1.4491
-5 198.01031400000002 0.020832051203150966 2.031
-6 393.60269519999997 0.020705861873884852 2.8548
-7 784.1705639999999 0.02062673094676377 4.0218
-8 1564.6923044999999 0.02057909414994506 5.6745
-9 3125.1383654999995 0.020551345668089905 8.0141
-10 6245.3893792 0.020535324101189707 11.3248
-11 12485.2352088 0.020526267200746757 16.0086
-12 24964.328738000004 0.02052119892253279 22.634
-13 12.792738 0.021496208239393317 0.5244
-14 25.573334400000004 0.02150562579747129 0.7416
-15 50.5502208 0.021265075067683978 1.0368
-16 99.9053013 0.02101881264232772 1.4491
-17 198.01031400000002 0.020832051203150966 2.031
-18 393.60269519999997 0.020705861873884852 2.8548
-19 784.1705639999999 0.02062673094676377 4.0218
-20 1564.6923044999999 0.02057909414994506 5.6745
-21 3125.1383654999995 0.020551345668089905 8.0141
-22 6245.3893792 0.020535324101189707 11.3248
-23 12485.2352088 0.020526267200746757 16.0086
-24 24964.328738000004 0.02052119892253279 22.634
+1 12.792738000 0.021496208239393317 0.524400000
+2 25.573334400 0.02150562579747129 0.741600000
+3 50.550220800 0.021265075067683978 1.036800000
+4 99.905301300 0.02101881264232772 1.449100000
+5 198.010314000 0.020832051203150966 2.031000000
+6 393.602695200 0.020705861873884852 2.854800000
+7 784.170564000 0.02062673094676377 4.021800000
+8 1564.692304500 0.02057909414994506 5.674500000
+9 3125.138365500 0.020551345668089905 8.014100000
+10 6245.389379200 0.020535324101189707 11.324800000
+11 12485.235208800 0.020526267200746757 16.008600000
+12 24964.328738000 0.02052119892253279 22.634000000
+13 12.792738000 0.021496208239393317 0.524400000
+14 25.573334400 0.02150562579747129 0.741600000
+15 50.550220800 0.021265075067683978 1.036800000
+16 99.905301300 0.02101881264232772 1.449100000
+17 198.010314000 0.020832051203150966 2.031000000
+18 393.602695200 0.020705861873884852 2.854800000
+19 784.170564000 0.02062673094676377 4.021800000
+20 1564.692304500 0.02057909414994506 5.674500000
+21 3125.138365500 0.020551345668089905 8.014100000
+22 6245.389379200 0.020535324101189707 11.324800000
+23 12485.235208800 0.020526267200746757 16.008600000
+24 24964.328738000 0.02052119892253279 22.634000000
-- !sql_test_Double_DecimalV2_2 --
\N \N
@@ -7845,109 +7845,109 @@
-- !sql_test_DecimalV2_TinyInt_0 --
\N \N \N
-1 25.395 23.395
-2 36.484 32.484
-3 51.756 45.756
-4 72.943 64.943
-5 102.494 92.494
-6 143.874 131.874
-7 201.980 187.980
-8 283.741 267.741
-9 398.955 380.955
-10 561.479 541.479
-11 790.908 768.908
-12 1114.957 1090.957
-13 25.395 23.395
-14 36.484 32.484
-15 51.756 45.756
-16 72.943 64.943
-17 102.494 92.494
-18 143.874 131.874
-19 201.980 187.980
-20 283.741 267.741
-21 398.955 380.955
-22 561.479 541.479
-23 790.908 768.908
-24 1114.957 1090.957
+1 25.395000000 23.395000000
+2 36.484000000 32.484000000
+3 51.756000000 45.756000000
+4 72.943000000 64.943000000
+5 102.494000000 92.494000000
+6 143.874000000 131.874000000
+7 201.980000000 187.980000000
+8 283.741000000 267.741000000
+9 398.955000000 380.955000000
+10 561.479000000 541.479000000
+11 790.908000000 768.908000000
+12 1114.957000000 1090.957000000
+13 25.395000000 23.395000000
+14 36.484000000 32.484000000
+15 51.756000000 45.756000000
+16 72.943000000 64.943000000
+17 102.494000000 92.494000000
+18 143.874000000 131.874000000
+19 201.980000000 187.980000000
+20 283.741000000 267.741000000
+21 398.955000000 380.955000000
+22 561.479000000 541.479000000
+23 790.908000000 768.908000000
+24 1114.957000000 1090.957000000
-- !sql_test_DecimalV2_TinyInt_notn_0 --
-1 25.395 23.395
-2 36.484 32.484
-3 51.756 45.756
-4 72.943 64.943
-5 102.494 92.494
-6 143.874 131.874
-7 201.980 187.980
-8 283.741 267.741
-9 398.955 380.955
-10 561.479 541.479
-11 790.908 768.908
-12 1114.957 1090.957
-13 25.395 23.395
-14 36.484 32.484
-15 51.756 45.756
-16 72.943 64.943
-17 102.494 92.494
-18 143.874 131.874
-19 201.980 187.980
-20 283.741 267.741
-21 398.955 380.955
-22 561.479 541.479
-23 790.908 768.908
-24 1114.957 1090.957
+1 25.395000000 23.395000000
+2 36.484000000 32.484000000
+3 51.756000000 45.756000000
+4 72.943000000 64.943000000
+5 102.494000000 92.494000000
+6 143.874000000 131.874000000
+7 201.980000000 187.980000000
+8 283.741000000 267.741000000
+9 398.955000000 380.955000000
+10 561.479000000 541.479000000
+11 790.908000000 768.908000000
+12 1114.957000000 1090.957000000
+13 25.395000000 23.395000000
+14 36.484000000 32.484000000
+15 51.756000000 45.756000000
+16 72.943000000 64.943000000
+17 102.494000000 92.494000000
+18 143.874000000 131.874000000
+19 201.980000000 187.980000000
+20 283.741000000 267.741000000
+21 398.955000000 380.955000000
+22 561.479000000 541.479000000
+23 790.908000000 768.908000000
+24 1114.957000000 1090.957000000
-- !sql_test_DecimalV2_TinyInt_1 --
\N \N \N \N
-1 24.395 24.3950000 0.395
-2 68.968 17.2420000 0.484
-3 146.268 16.2520000 0.756
-4 275.772 17.2357500 0.943
-5 487.470 19.4988000 2.494
-6 827.244 22.9790000 5.874
-7 1364.860 27.8542857 5.980
-8 2205.928 34.4676250 3.741
-9 3509.595 43.3283333 2.955
-10 5514.790 55.1479000 1.479
-11 8578.988 70.9007272 9.908
-12 13235.484 91.9130833 10.957
-13 24.395 24.3950000 0.395
-14 68.968 17.2420000 0.484
-15 146.268 16.2520000 0.756
-16 275.772 17.2357500 0.943
-17 487.470 19.4988000 2.494
-18 827.244 22.9790000 5.874
-19 1364.860 27.8542857 5.980
-20 2205.928 34.4676250 3.741
-21 3509.595 43.3283333 2.955
-22 5514.790 55.1479000 1.479
-23 8578.988 70.9007272 9.908
-24 13235.484 91.9130833 10.957
+1 24.395000000 24.395000000 0.395000000
+2 68.968000000 17.242000000 0.484000000
+3 146.268000000 16.252000000 0.756000000
+4 275.772000000 17.235750000 0.943000000
+5 487.470000000 19.498800000 2.494000000
+6 827.244000000 22.979000000 5.874000000
+7 1364.860000000 27.854285714 5.980000000
+8 2205.928000000 34.467625000 3.741000000
+9 3509.595000000 43.328333333 2.955000000
+10 5514.790000000 55.147900000 1.479000000
+11 8578.988000000 70.900727273 9.908000000
+12 13235.484000000 91.913083333 10.957000000
+13 24.395000000 24.395000000 0.395000000
+14 68.968000000 17.242000000 0.484000000
+15 146.268000000 16.252000000 0.756000000
+16 275.772000000 17.235750000 0.943000000
+17 487.470000000 19.498800000 2.494000000
+18 827.244000000 22.979000000 5.874000000
+19 1364.860000000 27.854285714 5.980000000
+20 2205.928000000 34.467625000 3.741000000
+21 3509.595000000 43.328333333 2.955000000
+22 5514.790000000 55.147900000 1.479000000
+23 8578.988000000 70.900727273 9.908000000
+24 13235.484000000 91.913083333 10.957000000
-- !sql_test_DecimalV2_TinyInt_notn_1 --
-1 24.395 24.3950000 0.395
-2 68.968 17.2420000 0.484
-3 146.268 16.2520000 0.756
-4 275.772 17.2357500 0.943
-5 487.470 19.4988000 2.494
-6 827.244 22.9790000 5.874
-7 1364.860 27.8542857 5.980
-8 2205.928 34.4676250 3.741
-9 3509.595 43.3283333 2.955
-10 5514.790 55.1479000 1.479
-11 8578.988 70.9007272 9.908
-12 13235.484 91.9130833 10.957
-13 24.395 24.3950000 0.395
-14 68.968 17.2420000 0.484
-15 146.268 16.2520000 0.756
-16 275.772 17.2357500 0.943
-17 487.470 19.4988000 2.494
-18 827.244 22.9790000 5.874
-19 1364.860 27.8542857 5.980
-20 2205.928 34.4676250 3.741
-21 3509.595 43.3283333 2.955
-22 5514.790 55.1479000 1.479
-23 8578.988 70.9007272 9.908
-24 13235.484 91.9130833 10.957
+1 24.395000000 24.395000000 0.395000000
+2 68.968000000 17.242000000 0.484000000
+3 146.268000000 16.252000000 0.756000000
+4 275.772000000 17.235750000 0.943000000
+5 487.470000000 19.498800000 2.494000000
+6 827.244000000 22.979000000 5.874000000
+7 1364.860000000 27.854285714 5.980000000
+8 2205.928000000 34.467625000 3.741000000
+9 3509.595000000 43.328333333 2.955000000
+10 5514.790000000 55.147900000 1.479000000
+11 8578.988000000 70.900727273 9.908000000
+12 13235.484000000 91.913083333 10.957000000
+13 24.395000000 24.395000000 0.395000000
+14 68.968000000 17.242000000 0.484000000
+15 146.268000000 16.252000000 0.756000000
+16 275.772000000 17.235750000 0.943000000
+17 487.470000000 19.498800000 2.494000000
+18 827.244000000 22.979000000 5.874000000
+19 1364.860000000 27.854285714 5.980000000
+20 2205.928000000 34.467625000 3.741000000
+21 3509.595000000 43.328333333 2.955000000
+22 5514.790000000 55.147900000 1.479000000
+23 8578.988000000 70.900727273 9.908000000
+24 13235.484000000 91.913083333 10.957000000
-- !sql_test_DecimalV2_TinyInt_2 --
\N \N
@@ -8057,109 +8057,109 @@
-- !sql_test_DecimalV2_SmallInt_0 --
\N \N \N
-1 34.395 14.395
-2 54.484 14.484
-3 88.756 8.756
-4 148.943 -11.057
-5 257.494 -62.506
-6 457.874 -182.126
-7 834.980 -445.020
-8 1555.741 -1004.259
-9 2949.955 -2170.045
-10 5671.479 -4568.521
-11 11019.908 -9460.092
-12 21582.957 -19377.043
-13 34.395 14.395
-14 54.484 14.484
-15 88.756 8.756
-16 148.943 -11.057
-17 257.494 -62.506
-18 457.874 -182.126
-19 834.980 -445.020
-20 1555.741 -1004.259
-21 2949.955 -2170.045
-22 5671.479 -4568.521
-23 11019.908 -9460.092
-24 21582.957 -19377.043
+1 34.395000000 14.395000000
+2 54.484000000 14.484000000
+3 88.756000000 8.756000000
+4 148.943000000 -11.057000000
+5 257.494000000 -62.506000000
+6 457.874000000 -182.126000000
+7 834.980000000 -445.020000000
+8 1555.741000000 -1004.259000000
+9 2949.955000000 -2170.045000000
+10 5671.479000000 -4568.521000000
+11 11019.908000000 -9460.092000000
+12 21582.957000000 -19377.043000000
+13 34.395000000 14.395000000
+14 54.484000000 14.484000000
+15 88.756000000 8.756000000
+16 148.943000000 -11.057000000
+17 257.494000000 -62.506000000
+18 457.874000000 -182.126000000
+19 834.980000000 -445.020000000
+20 1555.741000000 -1004.259000000
+21 2949.955000000 -2170.045000000
+22 5671.479000000 -4568.521000000
+23 11019.908000000 -9460.092000000
+24 21582.957000000 -19377.043000000
-- !sql_test_DecimalV2_SmallInt_notn_0 --
-1 34.395 14.395
-2 54.484 14.484
-3 88.756 8.756
-4 148.943 -11.057
-5 257.494 -62.506
-6 457.874 -182.126
-7 834.980 -445.020
-8 1555.741 -1004.259
-9 2949.955 -2170.045
-10 5671.479 -4568.521
-11 11019.908 -9460.092
-12 21582.957 -19377.043
-13 34.395 14.395
-14 54.484 14.484
-15 88.756 8.756
-16 148.943 -11.057
-17 257.494 -62.506
-18 457.874 -182.126
-19 834.980 -445.020
-20 1555.741 -1004.259
-21 2949.955 -2170.045
-22 5671.479 -4568.521
-23 11019.908 -9460.092
-24 21582.957 -19377.043
+1 34.395000000 14.395000000
+2 54.484000000 14.484000000
+3 88.756000000 8.756000000
+4 148.943000000 -11.057000000
+5 257.494000000 -62.506000000
+6 457.874000000 -182.126000000
+7 834.980000000 -445.020000000
+8 1555.741000000 -1004.259000000
+9 2949.955000000 -2170.045000000
+10 5671.479000000 -4568.521000000
+11 11019.908000000 -9460.092000000
+12 21582.957000000 -19377.043000000
+13 34.395000000 14.395000000
+14 54.484000000 14.484000000
+15 88.756000000 8.756000000
+16 148.943000000 -11.057000000
+17 257.494000000 -62.506000000
+18 457.874000000 -182.126000000
+19 834.980000000 -445.020000000
+20 1555.741000000 -1004.259000000
+21 2949.955000000 -2170.045000000
+22 5671.479000000 -4568.521000000
+23 11019.908000000 -9460.092000000
+24 21582.957000000 -19377.043000000
-- !sql_test_DecimalV2_SmallInt_1 --
\N \N \N \N
-1 243.950 2.4395000 4.395
-2 689.680 1.7242000 14.484
-3 1950.240 1.2189000 8.756
-4 5515.440 0.8617875 68.943
-5 15599.040 0.6093375 97.494
-6 44119.680 0.4308562 137.874
-7 124787.200 0.3046562 194.980
-8 352948.480 0.2154226 275.741
-9 998284.800 0.1523261 389.955
-10 2823572.480 0.1077107 551.479
-11 7986257.920 0.0761628 779.908
-12 22588559.360 0.0538553 1102.957
-13 243.950 2.4395000 4.395
-14 689.680 1.7242000 14.484
-15 1950.240 1.2189000 8.756
-16 5515.440 0.8617875 68.943
-17 15599.040 0.6093375 97.494
-18 44119.680 0.4308562 137.874
-19 124787.200 0.3046562 194.980
-20 352948.480 0.2154226 275.741
-21 998284.800 0.1523261 389.955
-22 2823572.480 0.1077107 551.479
-23 7986257.920 0.0761628 779.908
-24 22588559.360 0.0538553 1102.957
+1 243.950000000 2.439500000 4.395000000
+2 689.680000000 1.724200000 14.484000000
+3 1950.240000000 1.218900000 8.756000000
+4 5515.440000000 0.861787500 68.943000000
+5 15599.040000000 0.609337500 97.494000000
+6 44119.680000000 0.430856250 137.874000000
+7 124787.200000000 0.304656250 194.980000000
+8 352948.480000000 0.215422656 275.741000000
+9 998284.800000000 0.152326172 389.955000000
+10 2823572.480000000 0.107710742 551.479000000
+11 7986257.920000000 0.076162891 779.908000000
+12 22588559.360000000 0.053855322 1102.957000000
+13 243.950000000 2.439500000 4.395000000
+14 689.680000000 1.724200000 14.484000000
+15 1950.240000000 1.218900000 8.756000000
+16 5515.440000000 0.861787500 68.943000000
+17 15599.040000000 0.609337500 97.494000000
+18 44119.680000000 0.430856250 137.874000000
+19 124787.200000000 0.304656250 194.980000000
+20 352948.480000000 0.215422656 275.741000000
+21 998284.800000000 0.152326172 389.955000000
+22 2823572.480000000 0.107710742 551.479000000
+23 7986257.920000000 0.076162891 779.908000000
+24 22588559.360000000 0.053855322 1102.957000000
-- !sql_test_DecimalV2_SmallInt_notn_1 --
-1 243.950 2.4395000 4.395
-2 689.680 1.7242000 14.484
-3 1950.240 1.2189000 8.756
-4 5515.440 0.8617875 68.943
-5 15599.040 0.6093375 97.494
-6 44119.680 0.4308562 137.874
-7 124787.200 0.3046562 194.980
-8 352948.480 0.2154226 275.741
-9 998284.800 0.1523261 389.955
-10 2823572.480 0.1077107 551.479
-11 7986257.920 0.0761628 779.908
-12 22588559.360 0.0538553 1102.957
-13 243.950 2.4395000 4.395
-14 689.680 1.7242000 14.484
-15 1950.240 1.2189000 8.756
-16 5515.440 0.8617875 68.943
-17 15599.040 0.6093375 97.494
-18 44119.680 0.4308562 137.874
-19 124787.200 0.3046562 194.980
-20 352948.480 0.2154226 275.741
-21 998284.800 0.1523261 389.955
-22 2823572.480 0.1077107 551.479
-23 7986257.920 0.0761628 779.908
-24 22588559.360 0.0538553 1102.957
+1 243.950000000 2.439500000 4.395000000
+2 689.680000000 1.724200000 14.484000000
+3 1950.240000000 1.218900000 8.756000000
+4 5515.440000000 0.861787500 68.943000000
+5 15599.040000000 0.609337500 97.494000000
+6 44119.680000000 0.430856250 137.874000000
+7 124787.200000000 0.304656250 194.980000000
+8 352948.480000000 0.215422656 275.741000000
+9 998284.800000000 0.152326172 389.955000000
+10 2823572.480000000 0.107710742 551.479000000
+11 7986257.920000000 0.076162891 779.908000000
+12 22588559.360000000 0.053855322 1102.957000000
+13 243.950000000 2.439500000 4.395000000
+14 689.680000000 1.724200000 14.484000000
+15 1950.240000000 1.218900000 8.756000000
+16 5515.440000000 0.861787500 68.943000000
+17 15599.040000000 0.609337500 97.494000000
+18 44119.680000000 0.430856250 137.874000000
+19 124787.200000000 0.304656250 194.980000000
+20 352948.480000000 0.215422656 275.741000000
+21 998284.800000000 0.152326172 389.955000000
+22 2823572.480000000 0.107710742 551.479000000
+23 7986257.920000000 0.076162891 779.908000000
+24 22588559.360000000 0.053855322 1102.957000000
-- !sql_test_DecimalV2_SmallInt_2 --
\N \N
@@ -8269,109 +8269,109 @@
-- !sql_test_DecimalV2_Integer_0 --
\N \N \N
-1 23819.395 -23770.605
-2 47579.484 -47510.516
-3 95093.756 -94996.244
-4 190113.943 -189976.057
-5 380142.494 -379947.506
-6 760182.874 -759907.126
-7 1520239.980 -1519850.020
-8 3040320.741 -3039769.259
-9 6080434.955 -6079655.045
-10 12160596.479 -12159493.521
-11 24320824.908 -24319265.092
-12 48641147.957 -48638942.043
-13 23819.395 -23770.605
-14 47579.484 -47510.516
-15 95093.756 -94996.244
-16 190113.943 -189976.057
-17 380142.494 -379947.506
-18 760182.874 -759907.126
-19 1520239.980 -1519850.020
-20 3040320.741 -3039769.259
-21 6080434.955 -6079655.045
-22 12160596.479 -12159493.521
-23 24320824.908 -24319265.092
-24 48641147.957 -48638942.043
+1 23819.395000000 -23770.605000000
+2 47579.484000000 -47510.516000000
+3 95093.756000000 -94996.244000000
+4 190113.943000000 -189976.057000000
+5 380142.494000000 -379947.506000000
+6 760182.874000000 -759907.126000000
+7 1520239.980000000 -1519850.020000000
+8 3040320.741000000 -3039769.259000000
+9 6080434.955000000 -6079655.045000000
+10 12160596.479000000 -12159493.521000000
+11 24320824.908000000 -24319265.092000000
+12 48641147.957000000 -48638942.043000000
+13 23819.395000000 -23770.605000000
+14 47579.484000000 -47510.516000000
+15 95093.756000000 -94996.244000000
+16 190113.943000000 -189976.057000000
+17 380142.494000000 -379947.506000000
+18 760182.874000000 -759907.126000000
+19 1520239.980000000 -1519850.020000000
+20 3040320.741000000 -3039769.259000000
+21 6080434.955000000 -6079655.045000000
+22 12160596.479000000 -12159493.521000000
+23 24320824.908000000 -24319265.092000000
+24 48641147.957000000 -48638942.043000000
-- !sql_test_DecimalV2_Integer_notn_0 --
-1 23819.395 -23770.605
-2 47579.484 -47510.516
-3 95093.756 -94996.244
-4 190113.943 -189976.057
-5 380142.494 -379947.506
-6 760182.874 -759907.126
-7 1520239.980 -1519850.020
-8 3040320.741 -3039769.259
-9 6080434.955 -6079655.045
-10 12160596.479 -12159493.521
-11 24320824.908 -24319265.092
-12 48641147.957 -48638942.043
-13 23819.395 -23770.605
-14 47579.484 -47510.516
-15 95093.756 -94996.244
-16 190113.943 -189976.057
-17 380142.494 -379947.506
-18 760182.874 -759907.126
-19 1520239.980 -1519850.020
-20 3040320.741 -3039769.259
-21 6080434.955 -6079655.045
-22 12160596.479 -12159493.521
-23 24320824.908 -24319265.092
-24 48641147.957 -48638942.043
+1 23819.395000000 -23770.605000000
+2 47579.484000000 -47510.516000000
+3 95093.756000000 -94996.244000000
+4 190113.943000000 -189976.057000000
+5 380142.494000000 -379947.506000000
+6 760182.874000000 -759907.126000000
+7 1520239.980000000 -1519850.020000000
+8 3040320.741000000 -3039769.259000000
+9 6080434.955000000 -6079655.045000000
+10 12160596.479000000 -12159493.521000000
+11 24320824.908000000 -24319265.092000000
+12 48641147.957000000 -48638942.043000000
+13 23819.395000000 -23770.605000000
+14 47579.484000000 -47510.516000000
+15 95093.756000000 -94996.244000000
+16 190113.943000000 -189976.057000000
+17 380142.494000000 -379947.506000000
+18 760182.874000000 -759907.126000000
+19 1520239.980000000 -1519850.020000000
+20 3040320.741000000 -3039769.259000000
+21 6080434.955000000 -6079655.045000000
+22 12160596.479000000 -12159493.521000000
+23 24320824.908000000 -24319265.092000000
+24 48641147.957000000 -48638942.043000000
-- !sql_test_DecimalV2_Integer_1 --
\N \N \N \N
-1 580479.025 0.0010252 24.395
-2 1639541.780 0.0007252 34.484
-3 4634014.020 0.0005129 48.756
-4 13102272.435 0.0003627 68.943
-5 37052107.230 0.0002565 97.494
-6 104790444.330 0.0001814 137.874
-7 296378374.100 0.0001282 194.980
-8 838265048.345 0.0000907 275.741
-9 2370943947.975 0.0000641 389.955
-10 6706009456.555 0.0000453 551.479
-11 18967397655.860 0.0000320 779.908
-12 53647878113.065 0.0000226 1102.957
-13 580479.025 0.0010252 24.395
-14 1639541.780 0.0007252 34.484
-15 4634014.020 0.0005129 48.756
-16 13102272.435 0.0003627 68.943
-17 37052107.230 0.0002565 97.494
-18 104790444.330 0.0001814 137.874
-19 296378374.100 0.0001282 194.980
-20 838265048.345 0.0000907 275.741
-21 2370943947.975 0.0000641 389.955
-22 6706009456.555 0.0000453 551.479
-23 18967397655.860 0.0000320 779.908
-24 53647878113.065 0.0000226 1102.957
+1 580479.025000000 0.001025215 24.395000000
+2 1639541.780000000 0.000725292 34.484000000
+3 4634014.020000000 0.000512978 48.756000000
+4 13102272.435000000 0.000362772 68.943000000
+5 37052107.230000000 0.000256533 97.494000000
+6 104790444.330000000 0.000181402 137.874000000
+7 296378374.100000000 0.000128273 194.980000000
+8 838265048.345000000 0.000090703 275.741000000
+9 2370943947.975000000 0.000064137 389.955000000
+10 6706009456.555000000 0.000045352 551.479000000
+11 18967397655.860000000 0.000032069 779.908000000
+12 53647878113.065000000 0.000022676 1102.957000000
+13 580479.025000000 0.001025215 24.395000000
+14 1639541.780000000 0.000725292 34.484000000
+15 4634014.020000000 0.000512978 48.756000000
+16 13102272.435000000 0.000362772 68.943000000
+17 37052107.230000000 0.000256533 97.494000000
+18 104790444.330000000 0.000181402 137.874000000
+19 296378374.100000000 0.000128273 194.980000000
+20 838265048.345000000 0.000090703 275.741000000
+21 2370943947.975000000 0.000064137 389.955000000
+22 6706009456.555000000 0.000045352 551.479000000
+23 18967397655.860000000 0.000032069 779.908000000
+24 53647878113.065000000 0.000022676 1102.957000000
-- !sql_test_DecimalV2_Integer_notn_1 --
-1 580479.025 0.0010252 24.395
-2 1639541.780 0.0007252 34.484
-3 4634014.020 0.0005129 48.756
-4 13102272.435 0.0003627 68.943
-5 37052107.230 0.0002565 97.494
-6 104790444.330 0.0001814 137.874
-7 296378374.100 0.0001282 194.980
-8 838265048.345 0.0000907 275.741
-9 2370943947.975 0.0000641 389.955
-10 6706009456.555 0.0000453 551.479
-11 18967397655.860 0.0000320 779.908
-12 53647878113.065 0.0000226 1102.957
-13 580479.025 0.0010252 24.395
-14 1639541.780 0.0007252 34.484
-15 4634014.020 0.0005129 48.756
-16 13102272.435 0.0003627 68.943
-17 37052107.230 0.0002565 97.494
-18 104790444.330 0.0001814 137.874
-19 296378374.100 0.0001282 194.980
-20 838265048.345 0.0000907 275.741
-21 2370943947.975 0.0000641 389.955
-22 6706009456.555 0.0000453 551.479
-23 18967397655.860 0.0000320 779.908
-24 53647878113.065 0.0000226 1102.957
+1 580479.025000000 0.001025215 24.395000000
+2 1639541.780000000 0.000725292 34.484000000
+3 4634014.020000000 0.000512978 48.756000000
+4 13102272.435000000 0.000362772 68.943000000
+5 37052107.230000000 0.000256533 97.494000000
+6 104790444.330000000 0.000181402 137.874000000
+7 296378374.100000000 0.000128273 194.980000000
+8 838265048.345000000 0.000090703 275.741000000
+9 2370943947.975000000 0.000064137 389.955000000
+10 6706009456.555000000 0.000045352 551.479000000
+11 18967397655.860000000 0.000032069 779.908000000
+12 53647878113.065000000 0.000022676 1102.957000000
+13 580479.025000000 0.001025215 24.395000000
+14 1639541.780000000 0.000725292 34.484000000
+15 4634014.020000000 0.000512978 48.756000000
+16 13102272.435000000 0.000362772 68.943000000
+17 37052107.230000000 0.000256533 97.494000000
+18 104790444.330000000 0.000181402 137.874000000
+19 296378374.100000000 0.000128273 194.980000000
+20 838265048.345000000 0.000090703 275.741000000
+21 2370943947.975000000 0.000064137 389.955000000
+22 6706009456.555000000 0.000045352 551.479000000
+23 18967397655.860000000 0.000032069 779.908000000
+24 53647878113.065000000 0.000022676 1102.957000000
-- !sql_test_DecimalV2_Integer_2 --
\N \N
@@ -8693,56 +8693,56 @@
-- !sql_test_DecimalV2_LargeInt_0 --
\N \N \N
-1 1.07090669395E8 -1.07090620605E8
-2 2.13965679484E8 -2.13965610516E8
-3 4.27715693756E8 -4.27715596244E8
-4 8.55215713943E8 -8.55215576057E8
-5 1.710215742494E9 -1.710215547506E9
-6 3.420215782874E9 -3.420215507126E9
-7 6.84021583998E9 -6.84021545002E9
-8 1.3680215920741E10 -1.3680215369259E10
-9 2.7360216034955E10 -2.7360215255045E10
-10 5.4720216196479E10 -5.4720215093521E10
-11 1.09440216424908E11 -1.09440214865092E11
-12 2.18880216747957E11 -2.18880214542043E11
-13 1.07090669395E8 -1.07090620605E8
-14 2.13965679484E8 -2.13965610516E8
-15 4.27715693756E8 -4.27715596244E8
-16 8.55215713943E8 -8.55215576057E8
-17 1.710215742494E9 -1.710215547506E9
-18 3.420215782874E9 -3.420215507126E9
-19 6.84021583998E9 -6.84021545002E9
-20 1.3680215920741E10 -1.3680215369259E10
-21 2.7360216034955E10 -2.7360215255045E10
-22 5.4720216196479E10 -5.4720215093521E10
-23 1.09440216424908E11 -1.09440214865092E11
-24 2.18880216747957E11 -2.18880214542043E11
+1 107090669 -107090621
+2 213965679 -213965611
+3 427715694 -427715596
+4 855215714 -855215576
+5 1710215742 -1710215548
+6 3420215783 -3420215507
+7 6840215840 -6840215450
+8 13680215921 -13680215369
+9 27360216035 -27360215255
+10 54720216196 -54720215094
+11 109440216425 -109440214865
+12 218880216748 -218880214542
+13 107090669 -107090621
+14 213965679 -213965611
+15 427715694 -427715596
+16 855215714 -855215576
+17 1710215742 -1710215548
+18 3420215783 -3420215507
+19 6840215840 -6840215450
+20 13680215921 -13680215369
+21 27360216035 -27360215255
+22 54720216196 -54720215094
+23 109440216425 -109440214865
+24 218880216748 -218880214542
-- !sql_test_DecimalV2_LargeInt_notn_0 --
-1 1.07090669395E8 -1.07090620605E8
-2 2.13965679484E8 -2.13965610516E8
-3 4.27715693756E8 -4.27715596244E8
-4 8.55215713943E8 -8.55215576057E8
-5 1.710215742494E9 -1.710215547506E9
-6 3.420215782874E9 -3.420215507126E9
-7 6.84021583998E9 -6.84021545002E9
-8 1.3680215920741E10 -1.3680215369259E10
-9 2.7360216034955E10 -2.7360215255045E10
-10 5.4720216196479E10 -5.4720215093521E10
-11 1.09440216424908E11 -1.09440214865092E11
-12 2.18880216747957E11 -2.18880214542043E11
-13 1.07090669395E8 -1.07090620605E8
-14 2.13965679484E8 -2.13965610516E8
-15 4.27715693756E8 -4.27715596244E8
-16 8.55215713943E8 -8.55215576057E8
-17 1.710215742494E9 -1.710215547506E9
-18 3.420215782874E9 -3.420215507126E9
-19 6.84021583998E9 -6.84021545002E9
-20 1.3680215920741E10 -1.3680215369259E10
-21 2.7360216034955E10 -2.7360215255045E10
-22 5.4720216196479E10 -5.4720215093521E10
-23 1.09440216424908E11 -1.09440214865092E11
-24 2.18880216747957E11 -2.18880214542043E11
+1 107090669 -107090621
+2 213965679 -213965611
+3 427715694 -427715596
+4 855215714 -855215576
+5 1710215742 -1710215548
+6 3420215783 -3420215507
+7 6840215840 -6840215450
+8 13680215921 -13680215369
+9 27360216035 -27360215255
+10 54720216196 -54720215094
+11 109440216425 -109440214865
+12 218880216748 -218880214542
+13 107090669 -107090621
+14 213965679 -213965611
+15 427715694 -427715596
+16 855215714 -855215576
+17 1710215742 -1710215548
+18 3420215783 -3420215507
+19 6840215840 -6840215450
+20 13680215921 -13680215369
+21 27360216035 -27360215255
+22 54720216196 -54720215094
+23 109440216425 -109440214865
+24 218880216748 -218880214542
-- !sql_test_DecimalV2_LargeInt_2 --
\N \N
@@ -8852,109 +8852,109 @@
-- !sql_test_DecimalV2_Float_0 --
\N \N \N
-1 24.495000001490116 24.294999998509883
-2 34.684000002980234 34.28399999701977
-3 49.05600001192093 48.45599998807907
-4 69.34300000596046 68.54299999403953
-5 97.994 96.994
-6 138.47400002384185 137.27399997615814
-7 195.67999998807906 194.28000001192092
-8 276.5410000119209 274.94099998807906
-9 390.8549999761581 389.05500002384184
-10 552.479 550.479
-11 781.0080000238419 778.8079999761582
-12 1104.1570000476838 1101.7569999523164
-13 24.495000001490116 24.294999998509883
-14 34.684000002980234 34.28399999701977
-15 49.05600001192093 48.45599998807907
-16 69.34300000596046 68.54299999403953
-17 97.994 96.994
-18 138.47400002384185 137.27399997615814
-19 195.67999998807906 194.28000001192092
-20 276.5410000119209 274.94099998807906
-21 390.8549999761581 389.05500002384184
-22 552.479 550.479
-23 781.0080000238419 778.8079999761582
-24 1104.1570000476838 1101.7569999523164
+1 24.495000000 24.295000000
+2 34.684000000 34.284000000
+3 49.056000000 48.456000000
+4 69.343000000 68.543000000
+5 97.994000000 96.994000000
+6 138.474000000 137.274000000
+7 195.680000000 194.280000000
+8 276.541000000 274.941000000
+9 390.855000000 389.055000000
+10 552.479000000 550.479000000
+11 781.008000000 778.808000000
+12 1104.157000000 1101.757000000
+13 24.495000000 24.295000000
+14 34.684000000 34.284000000
+15 49.056000000 48.456000000
+16 69.343000000 68.543000000
+17 97.994000000 96.994000000
+18 138.474000000 137.274000000
+19 195.680000000 194.280000000
+20 276.541000000 274.941000000
+21 390.855000000 389.055000000
+22 552.479000000 550.479000000
+23 781.008000000 778.808000000
+24 1104.157000000 1101.757000000
-- !sql_test_DecimalV2_Float_notn_0 --
-1 24.495000001490116 24.294999998509883
-2 34.684000002980234 34.28399999701977
-3 49.05600001192093 48.45599998807907
-4 69.34300000596046 68.54299999403953
-5 97.994 96.994
-6 138.47400002384185 137.27399997615814
-7 195.67999998807906 194.28000001192092
-8 276.5410000119209 274.94099998807906
-9 390.8549999761581 389.05500002384184
-10 552.479 550.479
-11 781.0080000238419 778.8079999761582
-12 1104.1570000476838 1101.7569999523164
-13 24.495000001490116 24.294999998509883
-14 34.684000002980234 34.28399999701977
-15 49.05600001192093 48.45599998807907
-16 69.34300000596046 68.54299999403953
-17 97.994 96.994
-18 138.47400002384185 137.27399997615814
-19 195.67999998807906 194.28000001192092
-20 276.5410000119209 274.94099998807906
-21 390.8549999761581 389.05500002384184
-22 552.479 550.479
-23 781.0080000238419 778.8079999761582
-24 1104.1570000476838 1101.7569999523164
+1 24.495000000 24.295000000
+2 34.684000000 34.284000000
+3 49.056000000 48.456000000
+4 69.343000000 68.543000000
+5 97.994000000 96.994000000
+6 138.474000000 137.274000000
+7 195.680000000 194.280000000
+8 276.541000000 274.941000000
+9 390.855000000 389.055000000
+10 552.479000000 550.479000000
+11 781.008000000 778.808000000
+12 1104.157000000 1101.757000000
+13 24.495000000 24.295000000
+14 34.684000000 34.284000000
+15 49.056000000 48.456000000
+16 69.343000000 68.543000000
+17 97.994000000 96.994000000
+18 138.474000000 137.274000000
+19 195.680000000 194.280000000
+20 276.541000000 274.941000000
+21 390.855000000 389.055000000
+22 552.479000000 550.479000000
+23 781.008000000 778.808000000
+24 1104.157000000 1101.757000000
-- !sql_test_DecimalV2_Float_1 --
\N \N \N \N
-1 2.4395000363513826 243.9499963648618 0.09499963790178256
-2 6.896800102770329 172.41999743074183 0.0839994874000567
-3 14.626800581216813 162.51999354203568 0.1559980688095095
-4 27.577200410932303 172.35749743167315 0.1429989748001077
-5 48.747 194.988 0.4939999999999998
-6 82.72440328717231 229.78999086896613 0.4739945402145338
-7 136.48599767565727 278.5428618864138 0.3800033140182393
-8 220.59280328708886 344.67624486392367 0.5409958992004249
-9 350.95949070274827 433.2833448114221 0.2550103235244592
-10 551.479 551.479 0.47900000000004184
-11 857.8988185944557 709.0072573599543 0.00798309612275716
-12 1323.5484525930883 919.130796810357 0.15695617866526845
-13 2.4395000363513826 243.9499963648618 0.09499963790178256
-14 6.896800102770329 172.41999743074183 0.0839994874000567
-15 14.626800581216813 162.51999354203568 0.1559980688095095
-16 27.577200410932303 172.35749743167315 0.1429989748001077
-17 48.747 194.988 0.4939999999999998
-18 82.72440328717231 229.78999086896613 0.4739945402145338
-19 136.48599767565727 278.5428618864138 0.3800033140182393
-20 220.59280328708886 344.67624486392367 0.5409958992004249
-21 350.95949070274827 433.2833448114221 0.2550103235244592
-22 551.479 551.479 0.47900000000004184
-23 857.8988185944557 709.0072573599543 0.00798309612275716
-24 1323.5484525930883 919.130796810357 0.15695617866526845
+1 2.439500000 243.9499963648618 0.095000000
+2 6.896800000 172.41999743074183 0.084000000
+3 14.626800000 162.51999354203568 0.156000000
+4 27.577200000 172.35749743167315 0.143000000
+5 48.747000000 194.988 0.494000000
+6 82.724400000 229.78999086896613 0.474000000
+7 136.486000000 278.5428618864138 0.380000000
+8 220.592800000 344.67624486392367 0.541000000
+9 350.959500000 433.2833448114221 0.255000000
+10 551.479000000 551.479 0.479000000
+11 857.898800000 709.0072573599543 0.008000000
+12 1323.548400000 919.130796810357 0.157000000
+13 2.439500000 243.9499963648618 0.095000000
+14 6.896800000 172.41999743074183 0.084000000
+15 14.626800000 162.51999354203568 0.156000000
+16 27.577200000 172.35749743167315 0.143000000
+17 48.747000000 194.988 0.494000000
+18 82.724400000 229.78999086896613 0.474000000
+19 136.486000000 278.5428618864138 0.380000000
+20 220.592800000 344.67624486392367 0.541000000
+21 350.959500000 433.2833448114221 0.255000000
+22 551.479000000 551.479 0.479000000
+23 857.898800000 709.0072573599543 0.008000000
+24 1323.548400000 919.130796810357 0.157000000
-- !sql_test_DecimalV2_Float_notn_1 --
-1 2.4395000363513826 243.9499963648618 0.09499963790178256
-2 6.896800102770329 172.41999743074183 0.0839994874000567
-3 14.626800581216813 162.51999354203568 0.1559980688095095
-4 27.577200410932303 172.35749743167315 0.1429989748001077
-5 48.747 194.988 0.4939999999999998
-6 82.72440328717231 229.78999086896613 0.4739945402145338
-7 136.48599767565727 278.5428618864138 0.3800033140182393
-8 220.59280328708886 344.67624486392367 0.5409958992004249
-9 350.95949070274827 433.2833448114221 0.2550103235244592
-10 551.479 551.479 0.47900000000004184
-11 857.8988185944557 709.0072573599543 0.00798309612275716
-12 1323.5484525930883 919.130796810357 0.15695617866526845
-13 2.4395000363513826 243.9499963648618 0.09499963790178256
-14 6.896800102770329 172.41999743074183 0.0839994874000567
-15 14.626800581216813 162.51999354203568 0.1559980688095095
-16 27.577200410932303 172.35749743167315 0.1429989748001077
-17 48.747 194.988 0.4939999999999998
-18 82.72440328717231 229.78999086896613 0.4739945402145338
-19 136.48599767565727 278.5428618864138 0.3800033140182393
-20 220.59280328708886 344.67624486392367 0.5409958992004249
-21 350.95949070274827 433.2833448114221 0.2550103235244592
-22 551.479 551.479 0.47900000000004184
-23 857.8988185944557 709.0072573599543 0.00798309612275716
-24 1323.5484525930883 919.130796810357 0.15695617866526845
+1 2.439500000 243.9499963648618 0.095000000
+2 6.896800000 172.41999743074183 0.084000000
+3 14.626800000 162.51999354203568 0.156000000
+4 27.577200000 172.35749743167315 0.143000000
+5 48.747000000 194.988 0.494000000
+6 82.724400000 229.78999086896613 0.474000000
+7 136.486000000 278.5428618864138 0.380000000
+8 220.592800000 344.67624486392367 0.541000000
+9 350.959500000 433.2833448114221 0.255000000
+10 551.479000000 551.479 0.479000000
+11 857.898800000 709.0072573599543 0.008000000
+12 1323.548400000 919.130796810357 0.157000000
+13 2.439500000 243.9499963648618 0.095000000
+14 6.896800000 172.41999743074183 0.084000000
+15 14.626800000 162.51999354203568 0.156000000
+16 27.577200000 172.35749743167315 0.143000000
+17 48.747000000 194.988 0.494000000
+18 82.724400000 229.78999086896613 0.474000000
+19 136.486000000 278.5428618864138 0.380000000
+20 220.592800000 344.67624486392367 0.541000000
+21 350.959500000 433.2833448114221 0.255000000
+22 551.479000000 551.479 0.479000000
+23 857.898800000 709.0072573599543 0.008000000
+24 1323.548400000 919.130796810357 0.157000000
-- !sql_test_DecimalV2_Float_2 --
\N \N
@@ -9064,109 +9064,109 @@
-- !sql_test_DecimalV2_Double_0 --
\N \N \N
-1 24.9194 23.8706
-2 35.2256 33.7424
-3 49.7928 47.7192
-4 70.3921 67.4939
-5 99.525 95.463
-6 140.7288 135.01919999999998
-7 199.0018 190.95819999999998
-8 281.4155 270.06649999999996
-9 397.96909999999997 381.9409
-10 562.8038 540.1542000000001
-11 795.9166 763.8994
-12 1125.5910000000001 1080.323
-13 24.9194 23.8706
-14 35.2256 33.7424
-15 49.7928 47.7192
-16 70.3921 67.4939
-17 99.525 95.463
-18 140.7288 135.01919999999998
-19 199.0018 190.95819999999998
-20 281.4155 270.06649999999996
-21 397.96909999999997 381.9409
-22 562.8038 540.1542000000001
-23 795.9166 763.8994
-24 1125.5910000000001 1080.323
+1 24.919400000 23.870600000
+2 35.225600000 33.742400000
+3 49.792800000 47.719200000
+4 70.392100000 67.493900000
+5 99.525000000 95.463000000
+6 140.728800000 135.019200000
+7 199.001800000 190.958200000
+8 281.415500000 270.066500000
+9 397.969100000 381.940900000
+10 562.803800000 540.154200000
+11 795.916600000 763.899400000
+12 1125.591000000 1080.323000000
+13 24.919400000 23.870600000
+14 35.225600000 33.742400000
+15 49.792800000 47.719200000
+16 70.392100000 67.493900000
+17 99.525000000 95.463000000
+18 140.728800000 135.019200000
+19 199.001800000 190.958200000
+20 281.415500000 270.066500000
+21 397.969100000 381.940900000
+22 562.803800000 540.154200000
+23 795.916600000 763.899400000
+24 1125.591000000 1080.323000000
-- !sql_test_DecimalV2_Double_notn_0 --
-1 24.9194 23.8706
-2 35.2256 33.7424
-3 49.7928 47.7192
-4 70.3921 67.4939
-5 99.525 95.463
-6 140.7288 135.01919999999998
-7 199.0018 190.95819999999998
-8 281.4155 270.06649999999996
-9 397.96909999999997 381.9409
-10 562.8038 540.1542000000001
-11 795.9166 763.8994
-12 1125.5910000000001 1080.323
-13 24.9194 23.8706
-14 35.2256 33.7424
-15 49.7928 47.7192
-16 70.3921 67.4939
-17 99.525 95.463
-18 140.7288 135.01919999999998
-19 199.0018 190.95819999999998
-20 281.4155 270.06649999999996
-21 397.96909999999997 381.9409
-22 562.8038 540.1542000000001
-23 795.9166 763.8994
-24 1125.5910000000001 1080.323
+1 24.919400000 23.870600000
+2 35.225600000 33.742400000
+3 49.792800000 47.719200000
+4 70.392100000 67.493900000
+5 99.525000000 95.463000000
+6 140.728800000 135.019200000
+7 199.001800000 190.958200000
+8 281.415500000 270.066500000
+9 397.969100000 381.940900000
+10 562.803800000 540.154200000
+11 795.916600000 763.899400000
+12 1125.591000000 1080.323000000
+13 24.919400000 23.870600000
+14 35.225600000 33.742400000
+15 49.792800000 47.719200000
+16 70.392100000 67.493900000
+17 99.525000000 95.463000000
+18 140.728800000 135.019200000
+19 199.001800000 190.958200000
+20 281.415500000 270.066500000
+21 397.969100000 381.940900000
+22 562.803800000 540.154200000
+23 795.916600000 763.899400000
+24 1125.591000000 1080.323000000
-- !sql_test_DecimalV2_Double_1 --
\N \N \N \N
-1 12.792738 46.519832189168575 0.2726000000000006
-2 25.573334400000004 46.49946062567422 0.37040000000000006
-3 50.5502208 47.02546296296297 0.026400000000002866
-4 99.9053013 47.57642674763646 0.8352999999999953
-5 198.01031400000002 48.002954209748886 0.005999999999993122
-6 393.60269519999997 48.29550231189575 0.843599999999995
-7 784.1705639999999 48.48077975036053 1.9335999999999984
-8 1564.6923044999999 48.593003788880075 3.3649999999999807
-9 3125.1383654999995 48.65861419248575 5.278200000000027
-10 6245.3893792 48.69657742300085 7.888600000000054
-11 12485.2352088 48.718064040578184 11.495199999999954
-12 24964.328738000004 48.730096315277905 16.52500000000009
-13 12.792738 46.519832189168575 0.2726000000000006
-14 25.573334400000004 46.49946062567422 0.37040000000000006
-15 50.5502208 47.02546296296297 0.026400000000002866
-16 99.9053013 47.57642674763646 0.8352999999999953
-17 198.01031400000002 48.002954209748886 0.005999999999993122
-18 393.60269519999997 48.29550231189575 0.843599999999995
-19 784.1705639999999 48.48077975036053 1.9335999999999984
-20 1564.6923044999999 48.593003788880075 3.3649999999999807
-21 3125.1383654999995 48.65861419248575 5.278200000000027
-22 6245.3893792 48.69657742300085 7.888600000000054
-23 12485.2352088 48.718064040578184 11.495199999999954
-24 24964.328738000004 48.730096315277905 16.52500000000009
+1 12.792738000 46.519832189168575 0.272600000
+2 25.573334400 46.49946062567422 0.370400000
+3 50.550220800 47.02546296296297 0.026400000
+4 99.905301300 47.57642674763646 0.835300000
+5 198.010314000 48.002954209748886 0.006000000
+6 393.602695200 48.29550231189575 0.843600000
+7 784.170564000 48.48077975036053 1.933600000
+8 1564.692304500 48.593003788880075 3.365000000
+9 3125.138365500 48.65861419248575 5.278200000
+10 6245.389379200 48.69657742300085 7.888600000
+11 12485.235208800 48.718064040578184 11.495200000
+12 24964.328738000 48.730096315277905 16.525000000
+13 12.792738000 46.519832189168575 0.272600000
+14 25.573334400 46.49946062567422 0.370400000
+15 50.550220800 47.02546296296297 0.026400000
+16 99.905301300 47.57642674763646 0.835300000
+17 198.010314000 48.002954209748886 0.006000000
+18 393.602695200 48.29550231189575 0.843600000
+19 784.170564000 48.48077975036053 1.933600000
+20 1564.692304500 48.593003788880075 3.365000000
+21 3125.138365500 48.65861419248575 5.278200000
+22 6245.389379200 48.69657742300085 7.888600000
+23 12485.235208800 48.718064040578184 11.495200000
+24 24964.328738000 48.730096315277905 16.525000000
-- !sql_test_DecimalV2_Double_notn_1 --
-1 12.792738 46.519832189168575 0.2726000000000006
-2 25.573334400000004 46.49946062567422 0.37040000000000006
-3 50.5502208 47.02546296296297 0.026400000000002866
-4 99.9053013 47.57642674763646 0.8352999999999953
-5 198.01031400000002 48.002954209748886 0.005999999999993122
-6 393.60269519999997 48.29550231189575 0.843599999999995
-7 784.1705639999999 48.48077975036053 1.9335999999999984
-8 1564.6923044999999 48.593003788880075 3.3649999999999807
-9 3125.1383654999995 48.65861419248575 5.278200000000027
-10 6245.3893792 48.69657742300085 7.888600000000054
-11 12485.2352088 48.718064040578184 11.495199999999954
-12 24964.328738000004 48.730096315277905 16.52500000000009
-13 12.792738 46.519832189168575 0.2726000000000006
-14 25.573334400000004 46.49946062567422 0.37040000000000006
-15 50.5502208 47.02546296296297 0.026400000000002866
-16 99.9053013 47.57642674763646 0.8352999999999953
-17 198.01031400000002 48.002954209748886 0.005999999999993122
-18 393.60269519999997 48.29550231189575 0.843599999999995
-19 784.1705639999999 48.48077975036053 1.9335999999999984
-20 1564.6923044999999 48.593003788880075 3.3649999999999807
-21 3125.1383654999995 48.65861419248575 5.278200000000027
-22 6245.3893792 48.69657742300085 7.888600000000054
-23 12485.2352088 48.718064040578184 11.495199999999954
-24 24964.328738000004 48.730096315277905 16.52500000000009
+1 12.792738000 46.519832189168575 0.272600000
+2 25.573334400 46.49946062567422 0.370400000
+3 50.550220800 47.02546296296297 0.026400000
+4 99.905301300 47.57642674763646 0.835300000
+5 198.010314000 48.002954209748886 0.006000000
+6 393.602695200 48.29550231189575 0.843600000
+7 784.170564000 48.48077975036053 1.933600000
+8 1564.692304500 48.593003788880075 3.365000000
+9 3125.138365500 48.65861419248575 5.278200000
+10 6245.389379200 48.69657742300085 7.888600000
+11 12485.235208800 48.718064040578184 11.495200000
+12 24964.328738000 48.730096315277905 16.525000000
+13 12.792738000 46.519832189168575 0.272600000
+14 25.573334400 46.49946062567422 0.370400000
+15 50.550220800 47.02546296296297 0.026400000
+16 99.905301300 47.57642674763646 0.835300000
+17 198.010314000 48.002954209748886 0.006000000
+18 393.602695200 48.29550231189575 0.843600000
+19 784.170564000 48.48077975036053 1.933600000
+20 1564.692304500 48.593003788880075 3.365000000
+21 3125.138365500 48.65861419248575 5.278200000
+22 6245.389379200 48.69657742300085 7.888600000
+23 12485.235208800 48.718064040578184 11.495200000
+24 24964.328738000 48.730096315277905 16.525000000
-- !sql_test_DecimalV2_Double_2 --
\N \N
@@ -9276,109 +9276,109 @@
-- !sql_test_DecimalV2_DecimalV2_0 --
\N \N \N
-1 48.790 0.000
-2 68.968 0.000
-3 97.512 0.000
-4 137.886 0.000
-5 194.988 0.000
-6 275.748 0.000
-7 389.960 0.000
-8 551.482 0.000
-9 779.910 0.000
-10 1102.958 0.000
-11 1559.816 0.000
-12 2205.914 0.000
-13 48.790 0.000
-14 68.968 0.000
-15 97.512 0.000
-16 137.886 0.000
-17 194.988 0.000
-18 275.748 0.000
-19 389.960 0.000
-20 551.482 0.000
-21 779.910 0.000
-22 1102.958 0.000
-23 1559.816 0.000
-24 2205.914 0.000
+1 48.790000000 0E-9
+2 68.968000000 0E-9
+3 97.512000000 0E-9
+4 137.886000000 0E-9
+5 194.988000000 0E-9
+6 275.748000000 0E-9
+7 389.960000000 0E-9
+8 551.482000000 0E-9
+9 779.910000000 0E-9
+10 1102.958000000 0E-9
+11 1559.816000000 0E-9
+12 2205.914000000 0E-9
+13 48.790000000 0E-9
+14 68.968000000 0E-9
+15 97.512000000 0E-9
+16 137.886000000 0E-9
+17 194.988000000 0E-9
+18 275.748000000 0E-9
+19 389.960000000 0E-9
+20 551.482000000 0E-9
+21 779.910000000 0E-9
+22 1102.958000000 0E-9
+23 1559.816000000 0E-9
+24 2205.914000000 0E-9
-- !sql_test_DecimalV2_DecimalV2_notn_0 --
-1 48.790 0.000
-2 68.968 0.000
-3 97.512 0.000
-4 137.886 0.000
-5 194.988 0.000
-6 275.748 0.000
-7 389.960 0.000
-8 551.482 0.000
-9 779.910 0.000
-10 1102.958 0.000
-11 1559.816 0.000
-12 2205.914 0.000
-13 48.790 0.000
-14 68.968 0.000
-15 97.512 0.000
-16 137.886 0.000
-17 194.988 0.000
-18 275.748 0.000
-19 389.960 0.000
-20 551.482 0.000
-21 779.910 0.000
-22 1102.958 0.000
-23 1559.816 0.000
-24 2205.914 0.000
+1 48.790000000 0E-9
+2 68.968000000 0E-9
+3 97.512000000 0E-9
+4 137.886000000 0E-9
+5 194.988000000 0E-9
+6 275.748000000 0E-9
+7 389.960000000 0E-9
+8 551.482000000 0E-9
+9 779.910000000 0E-9
+10 1102.958000000 0E-9
+11 1559.816000000 0E-9
+12 2205.914000000 0E-9
+13 48.790000000 0E-9
+14 68.968000000 0E-9
+15 97.512000000 0E-9
+16 137.886000000 0E-9
+17 194.988000000 0E-9
+18 275.748000000 0E-9
+19 389.960000000 0E-9
+20 551.482000000 0E-9
+21 779.910000000 0E-9
+22 1102.958000000 0E-9
+23 1559.816000000 0E-9
+24 2205.914000000 0E-9
-- !sql_test_DecimalV2_DecimalV2_1 --
\N \N \N \N
-1 595.116025 1.0000000 0.000
-2 1189.146256 1.0000000 0.000
-3 2377.147536 1.0000000 0.000
-4 4753.137249 1.0000000 0.000
-5 9505.080036 1.0000000 0.000
-6 19009.239876 1.0000000 0.000
-7 38017.200400 1.0000000 0.000
-8 76033.099081 1.0000000 0.000
-9 152064.902025 1.0000000 0.000
-10 304129.087441 1.0000000 0.000
-11 608256.488464 1.0000000 0.000
-12 1216514.143849 1.0000000 0.000
-13 595.116025 1.0000000 0.000
-14 1189.146256 1.0000000 0.000
-15 2377.147536 1.0000000 0.000
-16 4753.137249 1.0000000 0.000
-17 9505.080036 1.0000000 0.000
-18 19009.239876 1.0000000 0.000
-19 38017.200400 1.0000000 0.000
-20 76033.099081 1.0000000 0.000
-21 152064.902025 1.0000000 0.000
-22 304129.087441 1.0000000 0.000
-23 608256.488464 1.0000000 0.000
-24 1216514.143849 1.0000000 0.000
+1 595.116025000 1.000000000 0E-9
+2 1189.146256000 1.000000000 0E-9
+3 2377.147536000 1.000000000 0E-9
+4 4753.137249000 1.000000000 0E-9
+5 9505.080036000 1.000000000 0E-9
+6 19009.239876000 1.000000000 0E-9
+7 38017.200400000 1.000000000 0E-9
+8 76033.099081000 1.000000000 0E-9
+9 152064.902025000 1.000000000 0E-9
+10 304129.087441000 1.000000000 0E-9
+11 608256.488464000 1.000000000 0E-9
+12 1216514.143849000 1.000000000 0E-9
+13 595.116025000 1.000000000 0E-9
+14 1189.146256000 1.000000000 0E-9
+15 2377.147536000 1.000000000 0E-9
+16 4753.137249000 1.000000000 0E-9
+17 9505.080036000 1.000000000 0E-9
+18 19009.239876000 1.000000000 0E-9
+19 38017.200400000 1.000000000 0E-9
+20 76033.099081000 1.000000000 0E-9
+21 152064.902025000 1.000000000 0E-9
+22 304129.087441000 1.000000000 0E-9
+23 608256.488464000 1.000000000 0E-9
+24 1216514.143849000 1.000000000 0E-9
-- !sql_test_DecimalV2_DecimalV2_notn_1 --
-1 595.116025 1.0000000 0.000
-2 1189.146256 1.0000000 0.000
-3 2377.147536 1.0000000 0.000
-4 4753.137249 1.0000000 0.000
-5 9505.080036 1.0000000 0.000
-6 19009.239876 1.0000000 0.000
-7 38017.200400 1.0000000 0.000
-8 76033.099081 1.0000000 0.000
-9 152064.902025 1.0000000 0.000
-10 304129.087441 1.0000000 0.000
-11 608256.488464 1.0000000 0.000
-12 1216514.143849 1.0000000 0.000
-13 595.116025 1.0000000 0.000
-14 1189.146256 1.0000000 0.000
-15 2377.147536 1.0000000 0.000
-16 4753.137249 1.0000000 0.000
-17 9505.080036 1.0000000 0.000
-18 19009.239876 1.0000000 0.000
-19 38017.200400 1.0000000 0.000
-20 76033.099081 1.0000000 0.000
-21 152064.902025 1.0000000 0.000
-22 304129.087441 1.0000000 0.000
-23 608256.488464 1.0000000 0.000
-24 1216514.143849 1.0000000 0.000
+1 595.116025000 1.000000000 0E-9
+2 1189.146256000 1.000000000 0E-9
+3 2377.147536000 1.000000000 0E-9
+4 4753.137249000 1.000000000 0E-9
+5 9505.080036000 1.000000000 0E-9
+6 19009.239876000 1.000000000 0E-9
+7 38017.200400000 1.000000000 0E-9
+8 76033.099081000 1.000000000 0E-9
+9 152064.902025000 1.000000000 0E-9
+10 304129.087441000 1.000000000 0E-9
+11 608256.488464000 1.000000000 0E-9
+12 1216514.143849000 1.000000000 0E-9
+13 595.116025000 1.000000000 0E-9
+14 1189.146256000 1.000000000 0E-9
+15 2377.147536000 1.000000000 0E-9
+16 4753.137249000 1.000000000 0E-9
+17 9505.080036000 1.000000000 0E-9
+18 19009.239876000 1.000000000 0E-9
+19 38017.200400000 1.000000000 0E-9
+20 76033.099081000 1.000000000 0E-9
+21 152064.902025000 1.000000000 0E-9
+22 304129.087441000 1.000000000 0E-9
+23 608256.488464000 1.000000000 0E-9
+24 1216514.143849000 1.000000000 0E-9
-- !sql_test_DecimalV2_DecimalV2_2 --
\N \N
@@ -9977,18 +9977,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 178.684 -129.89399999999998
-14 252.578 -183.60999999999999
-15 357.115 -259.60299999999995
-16 504.976 -367.09000000000003
-17 714.102 -519.1139999999999
-18 1009.863 -734.115
-19 1428.141 -1038.181
-20 2019.681 -1468.199
-21 2856.249 -2076.339
-22 4039.339 -2936.3810000000003
-23 5712.482 -4152.665999999999
-24 8078.667 -5872.753
+13 178.684000000 -129.894000000
+14 252.578000000 -183.610000000
+15 357.115000000 -259.603000000
+16 504.976000000 -367.090000000
+17 714.102000000 -519.114000000
+18 1009.863000000 -734.115000000
+19 1428.141000000 -1038.181000000
+20 2019.681000000 -1468.199000000
+21 2856.249000000 -2076.339000000
+22 4039.339000000 -2936.381000000
+23 5712.482000000 -4152.666000000
+24 8078.667000000 -5872.753000000
-- !sql_test_DecimalV2_Char_notn_0 --
1 \N \N
@@ -10003,18 +10003,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 178.684 -129.89399999999998
-14 252.578 -183.60999999999999
-15 357.115 -259.60299999999995
-16 504.976 -367.09000000000003
-17 714.102 -519.1139999999999
-18 1009.863 -734.115
-19 1428.141 -1038.181
-20 2019.681 -1468.199
-21 2856.249 -2076.339
-22 4039.339 -2936.3810000000003
-23 5712.482 -4152.665999999999
-24 8078.667 -5872.753
+13 178.684000000 -129.894000000
+14 252.578000000 -183.610000000
+15 357.115000000 -259.603000000
+16 504.976000000 -367.090000000
+17 714.102000000 -519.114000000
+18 1009.863000000 -734.115000000
+19 1428.141000000 -1038.181000000
+20 2019.681000000 -1468.199000000
+21 2856.249000000 -2076.339000000
+22 4039.339000000 -2936.381000000
+23 5712.482000000 -4152.666000000
+24 8078.667000000 -5872.753000000
-- !sql_test_DecimalV2_Char_1 --
\N \N \N \N
@@ -10030,18 +10030,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 3763.880155 0.1581123735327859 24.395
-14 7520.753496 0.15811530807816815 34.484
-15 15034.351404 0.158114405611641 48.756
-16 30061.423119 0.1581141794313733 68.943
-17 60115.580352 0.15811342052000624 97.494
-18 120224.611386 0.15811437988323246 137.874
-19 240441.73178 0.15811398511629868 194.98
-20 480875.75954 0.15811381125497437 275.741
-21 961743.6767699999 0.15811375286158097 389.955
-22 1923481.5449400002 0.1581138577809889 551.479
-23 3846953.9231919996 0.1581137961640312 779.908
-24 7693908.174470001 0.15811394108986757 1102.957
+13 3763.880155000 0.1581123735327859 24.395000000
+14 7520.753496000 0.15811530807816815 34.484000000
+15 15034.351404000 0.158114405611641 48.756000000
+16 30061.423119000 0.1581141794313733 68.943000000
+17 60115.580352000 0.15811342052000624 97.494000000
+18 120224.611386000 0.15811437988323246 137.874000000
+19 240441.731780000 0.15811398511629868 194.980000000
+20 480875.759540000 0.15811381125497437 275.741000000
+21 961743.676770000 0.15811375286158097 389.955000000
+22 1923481.544940000 0.1581138577809889 551.479000000
+23 3846953.923192000 0.1581137961640312 779.908000000
+24 7693908.174470000 0.15811394108986757 1102.957000000
-- !sql_test_DecimalV2_Char_notn_1 --
1 \N \N \N
@@ -10056,18 +10056,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 3763.880155 0.1581123735327859 24.395
-14 7520.753496 0.15811530807816815 34.484
-15 15034.351404 0.158114405611641 48.756
-16 30061.423119 0.1581141794313733 68.943
-17 60115.580352 0.15811342052000624 97.494
-18 120224.611386 0.15811437988323246 137.874
-19 240441.73178 0.15811398511629868 194.98
-20 480875.75954 0.15811381125497437 275.741
-21 961743.6767699999 0.15811375286158097 389.955
-22 1923481.5449400002 0.1581138577809889 551.479
-23 3846953.9231919996 0.1581137961640312 779.908
-24 7693908.174470001 0.15811394108986757 1102.957
+13 3763.880155000 0.1581123735327859 24.395000000
+14 7520.753496000 0.15811530807816815 34.484000000
+15 15034.351404000 0.158114405611641 48.756000000
+16 30061.423119000 0.1581141794313733 68.943000000
+17 60115.580352000 0.15811342052000624 97.494000000
+18 120224.611386000 0.15811437988323246 137.874000000
+19 240441.731780000 0.15811398511629868 194.980000000
+20 480875.759540000 0.15811381125497437 275.741000000
+21 961743.676770000 0.15811375286158097 389.955000000
+22 1923481.544940000 0.1581138577809889 551.479000000
+23 3846953.923192000 0.1581137961640312 779.908000000
+24 7693908.174470000 0.15811394108986757 1102.957000000
-- !sql_test_DecimalV2_Char_2 --
\N \N
@@ -10189,18 +10189,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 2343.516 -2294.726
-14 3312.566 -3243.598
-15 4683.497 -4585.985
-16 6622.631 -6484.745
-17 9365.224 -9170.235999999999
-18 13244.011 -12968.263
-19 18729.565 -18339.605
-20 26487.394999999997 -25935.913
-21 37458.686 -36678.776
-22 52974.478 -51871.520000000004
-23 74917.151 -73357.335
-24 105948.79999999999 -103742.886
+13 2343.516000000 -2294.726000000
+14 3312.566000000 -3243.598000000
+15 4683.497000000 -4585.985000000
+16 6622.631000000 -6484.745000000
+17 9365.224000000 -9170.236000000
+18 13244.011000000 -12968.263000000
+19 18729.565000000 -18339.605000000
+20 26487.395000000 -25935.913000000
+21 37458.686000000 -36678.776000000
+22 52974.478000000 -51871.520000000
+23 74917.151000000 -73357.335000000
+24 105948.800000000 -103742.886000000
-- !sql_test_DecimalV2_Varchar_notn_0 --
1 \N \N
@@ -10215,18 +10215,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 2343.516 -2294.726
-14 3312.566 -3243.598
-15 4683.497 -4585.985
-16 6622.631 -6484.745
-17 9365.224 -9170.235999999999
-18 13244.011 -12968.263
-19 18729.565 -18339.605
-20 26487.394999999997 -25935.913
-21 37458.686 -36678.776
-22 52974.478 -51871.520000000004
-23 74917.151 -73357.335
-24 105948.79999999999 -103742.886
+13 2343.516000000 -2294.726000000
+14 3312.566000000 -3243.598000000
+15 4683.497000000 -4585.985000000
+16 6622.631000000 -6484.745000000
+17 9365.224000000 -9170.236000000
+18 13244.011000000 -12968.263000000
+19 18729.565000000 -18339.605000000
+20 26487.395000000 -25935.913000000
+21 37458.686000000 -36678.776000000
+22 52974.478000000 -51871.520000000
+23 74917.151000000 -73357.335000000
+24 105948.800000000 -103742.886000000
-- !sql_test_DecimalV2_Varchar_1 --
\N \N \N \N
@@ -10242,18 +10242,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 56574.956795 0.01051907166551465 24.395
-14 113041.379688 0.010519566014517026 34.484
-15 225971.432196 0.010519681682320543 48.756
-16 451830.911784 0.010519725687277147 68.943
-17 903548.0686199999 0.010519728131915798 97.494
-18 1806995.532738 0.010519804577046614 137.874
-19 3613873.3833 0.01051979313267602 194.98
-20 7227627.685613999 0.01051978635152135 275.741
-21 1.4455136997104999E7 0.01051978283259818 389.955
-22 2.8910183065521006E7 0.010519791132132673 551.479
-23 5.7820228913644E7 0.010519786930841223 779.908
-24 1.15640456457751E8 0.010519797146368503 1102.957
+13 56574.956795000 0.01051907166551465 24.395000000
+14 113041.379688000 0.010519566014517026 34.484000000
+15 225971.432196000 0.010519681682320543 48.756000000
+16 451830.911784000 0.010519725687277147 68.943000000
+17 903548.068620000 0.010519728131915798 97.494000000
+18 1806995.532738000 0.010519804577046614 137.874000000
+19 3613873.383300000 0.01051979313267602 194.980000000
+20 7227627.685614000 0.01051978635152135 275.741000000
+21 14455136.997105000 0.01051978283259818 389.955000000
+22 28910183.065521000 0.010519791132132673 551.479000000
+23 57820228.913644000 0.010519786930841223 779.908000000
+24 115640456.457751000 0.010519797146368503 1102.957000000
-- !sql_test_DecimalV2_Varchar_notn_1 --
1 \N \N \N
@@ -10268,18 +10268,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 56574.956795 0.01051907166551465 24.395
-14 113041.379688 0.010519566014517026 34.484
-15 225971.432196 0.010519681682320543 48.756
-16 451830.911784 0.010519725687277147 68.943
-17 903548.0686199999 0.010519728131915798 97.494
-18 1806995.532738 0.010519804577046614 137.874
-19 3613873.3833 0.01051979313267602 194.98
-20 7227627.685613999 0.01051978635152135 275.741
-21 1.4455136997104999E7 0.01051978283259818 389.955
-22 2.8910183065521006E7 0.010519791132132673 551.479
-23 5.7820228913644E7 0.010519786930841223 779.908
-24 1.15640456457751E8 0.010519797146368503 1102.957
+13 56574.956795000 0.01051907166551465 24.395000000
+14 113041.379688000 0.010519566014517026 34.484000000
+15 225971.432196000 0.010519681682320543 48.756000000
+16 451830.911784000 0.010519725687277147 68.943000000
+17 903548.068620000 0.010519728131915798 97.494000000
+18 1806995.532738000 0.010519804577046614 137.874000000
+19 3613873.383300000 0.01051979313267602 194.980000000
+20 7227627.685614000 0.01051978635152135 275.741000000
+21 14455136.997105000 0.01051978283259818 389.955000000
+22 28910183.065521000 0.010519791132132673 551.479000000
+23 57820228.913644000 0.010519786930841223 779.908000000
+24 115640456.457751000 0.010519797146368503 1102.957000000
-- !sql_test_DecimalV2_Varchar_2 --
\N \N
@@ -10401,18 +10401,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 10628.412 -10579.622
-14 15023.277 -14954.309
-15 21240.769 -21143.256999999998
-16 30035.198 -29897.312
-17 42473.506 -42278.518000000004
-18 60064.716 -59788.96799999999
-19 84942.997 -84553.03700000001
-20 120126.59199999999 -119575.11
-21 169883.98599999998 -169104.076
-22 240251.764 -239148.806
-23 339766.967 -338207.151
-24 480502.81799999997 -478296.904
+13 10628.412000000 -10579.622000000
+14 15023.277000000 -14954.309000000
+15 21240.769000000 -21143.257000000
+16 30035.198000000 -29897.312000000
+17 42473.506000000 -42278.518000000
+18 60064.716000000 -59788.968000000
+19 84942.997000000 -84553.037000000
+20 120126.592000000 -119575.110000000
+21 169883.986000000 -169104.076000000
+22 240251.764000000 -239148.806000000
+23 339766.967000000 -338207.151000000
+24 480502.818000000 -478296.904000000
-- !sql_test_DecimalV2_String_notn_0 --
1 \N \N
@@ -10427,18 +10427,18 @@
10 \N \N
11 \N \N
12 \N \N
-13 10628.412 -10579.622
-14 15023.277 -14954.309
-15 21240.769 -21143.256999999998
-16 30035.198 -29897.312
-17 42473.506 -42278.518000000004
-18 60064.716 -59788.96799999999
-19 84942.997 -84553.03700000001
-20 120126.59199999999 -119575.11
-21 169883.98599999998 -169104.076
-22 240251.764 -239148.806
-23 339766.967 -338207.151
-24 480502.81799999997 -478296.904
+13 10628.412000000 -10579.622000000
+14 15023.277000000 -14954.309000000
+15 21240.769000000 -21143.257000000
+16 30035.198000000 -29897.312000000
+17 42473.506000000 -42278.518000000
+18 60064.716000000 -59788.968000000
+19 84942.997000000 -84553.037000000
+20 120126.592000000 -119575.110000000
+21 169883.986000000 -169104.076000000
+22 240251.764000000 -239148.806000000
+23 339766.967000000 -338207.151000000
+24 480502.818000000 -478296.904000000
-- !sql_test_DecimalV2_String_1 --
\N \N \N \N
@@ -10454,18 +10454,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 258684.99471499998 0.002300543275251256 24.395
-14 516873.537812 0.0023006522273007575 34.484
-15 1033237.7858279999 0.00230067809037301 48.756
-16 2065963.518465 0.0023006878904287503 68.943
-17 4131406.9139280003 0.0023006884177774914 97.494
-18 8262353.413907999 0.002300705249911217 137.874
-19 1.652416835466E7 0.0023007027999251 194.98
-20 3.3047793505590998E7 0.0023007012273947055 275.741
-21 6.609504485860499E7 0.0023007004889747415 389.955
-22 1.3218967347151501E8 0.0023007023124732625 551.479
-23 2.64378719210572E8 0.002300701396391654 779.908
-24 5.28757432488977E8 0.0023007036291151535 1102.957
+13 258684.994715000 0.002300543275251256 24.395000000
+14 516873.537812000 0.0023006522273007575 34.484000000
+15 1033237.785828000 0.00230067809037301 48.756000000
+16 2065963.518465000 0.0023006878904287503 68.943000000
+17 4131406.913928000 0.0023006884177774914 97.494000000
+18 8262353.413908000 0.002300705249911217 137.874000000
+19 16524168.354660000 0.0023007027999251 194.980000000
+20 33047793.505591000 0.0023007012273947055 275.741000000
+21 66095044.858605000 0.0023007004889747415 389.955000000
+22 132189673.471515000 0.0023007023124732625 551.479000000
+23 264378719.210572000 0.002300701396391654 779.908000000
+24 528757432.488977000 0.0023007036291151535 1102.957000000
-- !sql_test_DecimalV2_String_notn_1 --
1 \N \N \N
@@ -10480,18 +10480,18 @@
10 \N \N \N
11 \N \N \N
12 \N \N \N
-13 258684.99471499998 0.002300543275251256 24.395
-14 516873.537812 0.0023006522273007575 34.484
-15 1033237.7858279999 0.00230067809037301 48.756
-16 2065963.518465 0.0023006878904287503 68.943
-17 4131406.9139280003 0.0023006884177774914 97.494
-18 8262353.413907999 0.002300705249911217 137.874
-19 1.652416835466E7 0.0023007027999251 194.98
-20 3.3047793505590998E7 0.0023007012273947055 275.741
-21 6.609504485860499E7 0.0023007004889747415 389.955
-22 1.3218967347151501E8 0.0023007023124732625 551.479
-23 2.64378719210572E8 0.002300701396391654 779.908
-24 5.28757432488977E8 0.0023007036291151535 1102.957
+13 258684.994715000 0.002300543275251256 24.395000000
+14 516873.537812000 0.0023006522273007575 34.484000000
+15 1033237.785828000 0.00230067809037301 48.756000000
+16 2065963.518465000 0.0023006878904287503 68.943000000
+17 4131406.913928000 0.0023006884177774914 97.494000000
+18 8262353.413908000 0.002300705249911217 137.874000000
+19 16524168.354660000 0.0023007027999251 194.980000000
+20 33047793.505591000 0.0023007012273947055 275.741000000
+21 66095044.858605000 0.0023007004889747415 389.955000000
+22 132189673.471515000 0.0023007023124732625 551.479000000
+23 264378719.210572000 0.002300701396391654 779.908000000
+24 528757432.488977000 0.0023007036291151535 1102.957000000
-- !sql_test_DecimalV2_String_2 --
\N \N
@@ -11449,109 +11449,109 @@
-- !sql_test_DecimalV2_Boolean_0 --
\N \N \N
-1 24.395 24.395
-2 34.484 34.484
-3 48.756 48.756
-4 68.943 68.943
-5 97.494 97.494
-6 137.874 137.874
-7 194.980 194.980
-8 276.741 274.741
-9 390.955 388.955
-10 552.479 550.479
-11 780.908 778.908
-12 1103.957 1101.957
-13 24.395 24.395
-14 34.484 34.484
-15 48.756 48.756
-16 68.943 68.943
-17 97.494 97.494
-18 137.874 137.874
-19 194.980 194.980
-20 276.741 274.741
-21 390.955 388.955
-22 552.479 550.479
-23 780.908 778.908
-24 1103.957 1101.957
+1 24.395000000 24.395000000
+2 34.484000000 34.484000000
+3 48.756000000 48.756000000
+4 68.943000000 68.943000000
+5 97.494000000 97.494000000
+6 137.874000000 137.874000000
+7 194.980000000 194.980000000
+8 276.741000000 274.741000000
+9 390.955000000 388.955000000
+10 552.479000000 550.479000000
+11 780.908000000 778.908000000
+12 1103.957000000 1101.957000000
+13 24.395000000 24.395000000
+14 34.484000000 34.484000000
+15 48.756000000 48.756000000
+16 68.943000000 68.943000000
+17 97.494000000 97.494000000
+18 137.874000000 137.874000000
+19 194.980000000 194.980000000
+20 276.741000000 274.741000000
+21 390.955000000 388.955000000
+22 552.479000000 550.479000000
+23 780.908000000 778.908000000
+24 1103.957000000 1101.957000000
-- !sql_test_DecimalV2_Boolean_notn_0 --
-1 24.395 24.395
-2 34.484 34.484
-3 48.756 48.756
-4 68.943 68.943
-5 97.494 97.494
-6 137.874 137.874
-7 194.980 194.980
-8 276.741 274.741
-9 390.955 388.955
-10 552.479 550.479
-11 780.908 778.908
-12 1103.957 1101.957
-13 24.395 24.395
-14 34.484 34.484
-15 48.756 48.756
-16 68.943 68.943
-17 97.494 97.494
-18 137.874 137.874
-19 194.980 194.980
-20 276.741 274.741
-21 390.955 388.955
-22 552.479 550.479
-23 780.908 778.908
-24 1103.957 1101.957
+1 24.395000000 24.395000000
+2 34.484000000 34.484000000
+3 48.756000000 48.756000000
+4 68.943000000 68.943000000
+5 97.494000000 97.494000000
+6 137.874000000 137.874000000
+7 194.980000000 194.980000000
+8 276.741000000 274.741000000
+9 390.955000000 388.955000000
+10 552.479000000 550.479000000
+11 780.908000000 778.908000000
+12 1103.957000000 1101.957000000
+13 24.395000000 24.395000000
+14 34.484000000 34.484000000
+15 48.756000000 48.756000000
+16 68.943000000 68.943000000
+17 97.494000000 97.494000000
+18 137.874000000 137.874000000
+19 194.980000000 194.980000000
+20 276.741000000 274.741000000
+21 390.955000000 388.955000000
+22 552.479000000 550.479000000
+23 780.908000000 778.908000000
+24 1103.957000000 1101.957000000
-- !sql_test_DecimalV2_Boolean_1 --
\N \N \N \N
-1 0.000 \N \N
-2 0.000 \N \N
-3 0.000 \N \N
-4 0.000 \N \N
-5 0.000 \N \N
-6 0.000 \N \N
-7 0.000 \N \N
-8 275.741 275.7410000 0.741
-9 389.955 389.9550000 0.955
-10 551.479 551.4790000 0.479
-11 779.908 779.9080000 0.908
-12 1102.957 1102.9570000 0.957
-13 0.000 \N \N
-14 0.000 \N \N
-15 0.000 \N \N
-16 0.000 \N \N
-17 0.000 \N \N
-18 0.000 \N \N
-19 0.000 \N \N
-20 275.741 275.7410000 0.741
-21 389.955 389.9550000 0.955
-22 551.479 551.4790000 0.479
-23 779.908 779.9080000 0.908
-24 1102.957 1102.9570000 0.957
+1 0E-9 \N \N
+2 0E-9 \N \N
+3 0E-9 \N \N
+4 0E-9 \N \N
+5 0E-9 \N \N
+6 0E-9 \N \N
+7 0E-9 \N \N
+8 275.741000000 275.741000000 0.741000000
+9 389.955000000 389.955000000 0.955000000
+10 551.479000000 551.479000000 0.479000000
+11 779.908000000 779.908000000 0.908000000
+12 1102.957000000 1102.957000000 0.957000000
+13 0E-9 \N \N
+14 0E-9 \N \N
+15 0E-9 \N \N
+16 0E-9 \N \N
+17 0E-9 \N \N
+18 0E-9 \N \N
+19 0E-9 \N \N
+20 275.741000000 275.741000000 0.741000000
+21 389.955000000 389.955000000 0.955000000
+22 551.479000000 551.479000000 0.479000000
+23 779.908000000 779.908000000 0.908000000
+24 1102.957000000 1102.957000000 0.957000000
-- !sql_test_DecimalV2_Boolean_notn_1 --
-1 0.000 \N \N
-2 0.000 \N \N
-3 0.000 \N \N
-4 0.000 \N \N
-5 0.000 \N \N
-6 0.000 \N \N
-7 0.000 \N \N
-8 275.741 275.7410000 0.741
-9 389.955 389.9550000 0.955
-10 551.479 551.4790000 0.479
-11 779.908 779.9080000 0.908
-12 1102.957 1102.9570000 0.957
-13 0.000 \N \N
-14 0.000 \N \N
-15 0.000 \N \N
-16 0.000 \N \N
-17 0.000 \N \N
-18 0.000 \N \N
-19 0.000 \N \N
-20 275.741 275.7410000 0.741
-21 389.955 389.9550000 0.955
-22 551.479 551.4790000 0.479
-23 779.908 779.9080000 0.908
-24 1102.957 1102.9570000 0.957
+1 0E-9 \N \N
+2 0E-9 \N \N
+3 0E-9 \N \N
+4 0E-9 \N \N
+5 0E-9 \N \N
+6 0E-9 \N \N
+7 0E-9 \N \N
+8 275.741000000 275.741000000 0.741000000
+9 389.955000000 389.955000000 0.955000000
+10 551.479000000 551.479000000 0.479000000
+11 779.908000000 779.908000000 0.908000000
+12 1102.957000000 1102.957000000 0.957000000
+13 0E-9 \N \N
+14 0E-9 \N \N
+15 0E-9 \N \N
+16 0E-9 \N \N
+17 0E-9 \N \N
+18 0E-9 \N \N
+19 0E-9 \N \N
+20 275.741000000 275.741000000 0.741000000
+21 389.955000000 389.955000000 0.955000000
+22 551.479000000 551.479000000 0.479000000
+23 779.908000000 779.908000000 0.908000000
+24 1102.957000000 1102.957000000 0.957000000
-- !sql_test_DecimalV2_Boolean_2 --
\N \N
@@ -12297,56 +12297,56 @@
-- !sql_test_Decimal32V3_LargeInt_0 --
\N \N \N
-1 1.07090657012E8 -1.07090632988E8
-2 2.13965668123E8 -2.13965621877E8
-3 4.27715679234E8 -4.27715610766E8
-4 8.55215690345E8 -8.55215599655E8
-5 1.710215701456E9 -1.710215588544E9
-6 3.420215712567E9 -3.420215577433E9
-7 6.840215723678E9 -6.840215566322E9
-8 1.3680215734789E10 -1.3680215555211E10
-9 2.73602157459E10 -2.73602155441E10
-10 5.4720215757011E10 -5.4720215532989E10
-11 1.09440215768122E11 -1.09440215521878E11
-12 2.18880215779233E11 -2.18880215510767E11
-13 1.07090790344E8 -1.07090499656E8
-14 2.13965801455E8 -2.13965488545E8
-15 4.27715812566E8 -4.27715477434E8
-16 8.55215823677E8 -8.55215466323E8
-17 1.710215834788E9 -1.710215455212E9
-18 3.420215845899E9 -3.420215444101E9
-19 6.84021585701E9 -6.84021543299E9
-20 1.3680215868121E10 -1.3680215421879E10
-21 2.7360215879232E10 -2.7360215410768E10
-22 5.4720215890343E10 -5.4720215399657E10
-23 1.09440215901454E11 -1.09440215388546E11
-24 2.18880215912565E11 -2.18880215377435E11
+1 107090657 -107090633
+2 213965668 -213965622
+3 427715679 -427715611
+4 855215690 -855215600
+5 1710215701 -1710215589
+6 3420215713 -3420215577
+7 6840215724 -6840215566
+8 13680215735 -13680215555
+9 27360215746 -27360215544
+10 54720215757 -54720215533
+11 109440215768 -109440215522
+12 218880215779 -218880215511
+13 107090790 -107090500
+14 213965801 -213965489
+15 427715813 -427715477
+16 855215824 -855215466
+17 1710215835 -1710215455
+18 3420215846 -3420215444
+19 6840215857 -6840215433
+20 13680215868 -13680215422
+21 27360215879 -27360215411
+22 54720215890 -54720215400
+23 109440215901 -109440215389
+24 218880215913 -218880215377
-- !sql_test_Decimal32V3_LargeInt_notn_0 --
-1 1.07090657012E8 -1.07090632988E8
-2 2.13965668123E8 -2.13965621877E8
-3 4.27715679234E8 -4.27715610766E8
-4 8.55215690345E8 -8.55215599655E8
-5 1.710215701456E9 -1.710215588544E9
-6 3.420215712567E9 -3.420215577433E9
-7 6.840215723678E9 -6.840215566322E9
-8 1.3680215734789E10 -1.3680215555211E10
-9 2.73602157459E10 -2.73602155441E10
-10 5.4720215757011E10 -5.4720215532989E10
-11 1.09440215768122E11 -1.09440215521878E11
-12 2.18880215779233E11 -2.18880215510767E11
-13 1.07090790344E8 -1.07090499656E8
-14 2.13965801455E8 -2.13965488545E8
-15 4.27715812566E8 -4.27715477434E8
-16 8.55215823677E8 -8.55215466323E8
-17 1.710215834788E9 -1.710215455212E9
-18 3.420215845899E9 -3.420215444101E9
-19 6.84021585701E9 -6.84021543299E9
-20 1.3680215868121E10 -1.3680215421879E10
-21 2.7360215879232E10 -2.7360215410768E10
-22 5.4720215890343E10 -5.4720215399657E10
-23 1.09440215901454E11 -1.09440215388546E11
-24 2.18880215912565E11 -2.18880215377435E11
+1 107090657 -107090633
+2 213965668 -213965622
+3 427715679 -427715611
+4 855215690 -855215600
+5 1710215701 -1710215589
+6 3420215713 -3420215577
+7 6840215724 -6840215566
+8 13680215735 -13680215555
+9 27360215746 -27360215544
+10 54720215757 -54720215533
+11 109440215768 -109440215522
+12 218880215779 -218880215511
+13 107090790 -107090500
+14 213965801 -213965489
+15 427715813 -427715477
+16 855215824 -855215466
+17 1710215835 -1710215455
+18 3420215846 -3420215444
+19 6840215857 -6840215433
+20 13680215868 -13680215422
+21 27360215879 -27360215411
+22 54720215890 -54720215400
+23 109440215901 -109440215389
+24 218880215913 -218880215377
-- !sql_test_Decimal32V3_LargeInt_2 --
\N \N
@@ -15530,56 +15530,56 @@
-- !sql_test_Decimal64V3_LargeInt_0 --
\N \N \N
-1 1.0709187901234E8 -1.0708941098766E8
-2 2.1396799012345E8 -2.1396329987655E8
-3 4.2771910123456E8 -4.2771218876544E8
-4 8.5522021234567E8 -8.5521107765433E8
-5 1.71022132345678E9 -1.71020996654322E9
-6 3.42022243456789E9 -3.42020885543211E9
-7 6.840223545679E9 -6.840207744321E9
-8 1.368022465679011E10 -1.368020663320989E10
-9 2.736022576790122E10 -2.736020552209878E10
-10 5.472022687901233E10 -5.472020441098767E10
-11 1.0944022799012344E11 -1.0944020329987656E11
-12 2.1888022910123456E11 -2.1888020218876544E11
-13 1.0710521234566E8 -1.0707607765434E8
-14 2.1398132345677E8 -2.1394996654323E8
-15 4.2773243456788E8 -4.2769885543212E8
-16 8.5523354567899E8 -8.5519774432101E8
-17 1.7102346567901E9 -1.7101966332099E9
-18 3.42023576790121E9 -3.42019552209879E9
-19 6.84023687901232E9 -6.84019441098768E9
-20 1.368023799012343E10 -1.368019329987657E10
-21 2.736023910123454E10 -2.736019218876546E10
-22 5.472024021234565E10 -5.472019107765435E10
-23 1.0944024132345676E11 -1.0944018996654324E11
-24 2.1888024243456787E11 -2.1888018885543213E11
+1 107091879 -107089411
+2 213967990 -213963300
+3 427719101 -427712189
+4 855220212 -855211078
+5 1710221323 -1710209967
+6 3420222435 -3420208855
+7 6840223546 -6840207744
+8 13680224657 -13680206633
+9 27360225768 -27360205522
+10 54720226879 -54720204411
+11 109440227990 -109440203300
+12 218880229101 -218880202189
+13 107105212 -107076078
+14 213981323 -213949967
+15 427732435 -427698855
+16 855233546 -855197744
+17 1710234657 -1710196633
+18 3420235768 -3420195522
+19 6840236879 -6840194411
+20 13680237990 -13680193300
+21 27360239101 -27360192189
+22 54720240212 -54720191078
+23 109440241323 -109440189967
+24 218880242435 -218880188855
-- !sql_test_Decimal64V3_LargeInt_notn_0 --
-1 1.0709187901234E8 -1.0708941098766E8
-2 2.1396799012345E8 -2.1396329987655E8
-3 4.2771910123456E8 -4.2771218876544E8
-4 8.5522021234567E8 -8.5521107765433E8
-5 1.71022132345678E9 -1.71020996654322E9
-6 3.42022243456789E9 -3.42020885543211E9
-7 6.840223545679E9 -6.840207744321E9
-8 1.368022465679011E10 -1.368020663320989E10
-9 2.736022576790122E10 -2.736020552209878E10
-10 5.472022687901233E10 -5.472020441098767E10
-11 1.0944022799012344E11 -1.0944020329987656E11
-12 2.1888022910123456E11 -2.1888020218876544E11
-13 1.0710521234566E8 -1.0707607765434E8
-14 2.1398132345677E8 -2.1394996654323E8
-15 4.2773243456788E8 -4.2769885543212E8
-16 8.5523354567899E8 -8.5519774432101E8
-17 1.7102346567901E9 -1.7101966332099E9
-18 3.42023576790121E9 -3.42019552209879E9
-19 6.84023687901232E9 -6.84019441098768E9
-20 1.368023799012343E10 -1.368019329987657E10
-21 2.736023910123454E10 -2.736019218876546E10
-22 5.472024021234565E10 -5.472019107765435E10
-23 1.0944024132345676E11 -1.0944018996654324E11
-24 2.1888024243456787E11 -2.1888018885543213E11
+1 107091879 -107089411
+2 213967990 -213963300
+3 427719101 -427712189
+4 855220212 -855211078
+5 1710221323 -1710209967
+6 3420222435 -3420208855
+7 6840223546 -6840207744
+8 13680224657 -13680206633
+9 27360225768 -27360205522
+10 54720226879 -54720204411
+11 109440227990 -109440203300
+12 218880229101 -218880202189
+13 107105212 -107076078
+14 213981323 -213949967
+15 427732435 -427698855
+16 855233546 -855197744
+17 1710234657 -1710196633
+18 3420235768 -3420195522
+19 6840236879 -6840194411
+20 13680237990 -13680193300
+21 27360239101 -27360192189
+22 54720240212 -54720191078
+23 109440241323 -109440189967
+24 218880242435 -218880188855
-- !sql_test_Decimal64V3_LargeInt_2 --
\N \N
@@ -18763,56 +18763,56 @@
-- !sql_test_Decimal128V3_LargeInt_0 --
\N \N \N
-1 1.19436323012345E8 -9.4744966987655E7
-2 2.37422434123456E8 -1.90508855876544E8
-3 4.62283545234567E8 -3.93147744765433E8
-4 9.00894656345678E8 -8.09536633654322E8
-5 1.767005767456789E9 -1.653425522543211E9
-6 3.4881168785679E9 -3.3523144114321E9
-7 6.919227989679011E9 -6.761203300320989E9
-8 1.3770339100790121E10 -1.3590092189209879E10
-9 2.7461450211901234E10 -2.7258981078098766E10
-10 5.4832561323012344E10 -5.4607869966987656E10
-11 1.0956367243412346E11 -1.0931675885587654E11
-12 2.1901478354523456E11 -2.1874564774476544E11
-13 2.52769656345677E8 3.858836634567699E7
-14 3.70755767456788E8 -5.7175522543212E7
-15 5.95616878567899E8 -2.59814411432101E8
-16 1.03422798967901E9 -6.7620330032099E8
-17 1.900339100790121E9 -1.520092189209879E9
-18 3.621450211901232E9 -3.218981078098768E9
-19 7.052561323012343E9 -6.627869966987657E9
-20 1.3903672434123453E10 -1.3456758855876547E10
-21 2.7594783545234566E10 -2.7125647744765434E10
-22 5.496589465634567E10 -5.447453663365433E10
-23 1.0969700576745679E11 -1.0918342552254321E11
-24 2.191481168785679E11 -2.186123144114321E11
+1 119436323 -94744967
+2 237422434 -190508856
+3 462283545 -393147745
+4 900894656 -809536634
+5 1767005767 -1653425523
+6 3488116879 -3352314411
+7 6919227990 -6761203300
+8 13770339101 -13590092189
+9 27461450212 -27258981078
+10 54832561323 -54607869967
+11 109563672434 -109316758856
+12 219014783545 -218745647745
+13 252769656 38588366
+14 370755767 -57175523
+15 595616879 -259814411
+16 1034227990 -676203300
+17 1900339101 -1520092189
+18 3621450212 -3218981078
+19 7052561323 -6627869967
+20 13903672434 -13456758856
+21 27594783545 -27125647745
+22 54965894656 -54474536634
+23 109697005767 -109183425523
+24 219148116879 -218612314411
-- !sql_test_Decimal128V3_LargeInt_notn_0 --
-1 1.19436323012345E8 -9.4744966987655E7
-2 2.37422434123456E8 -1.90508855876544E8
-3 4.62283545234567E8 -3.93147744765433E8
-4 9.00894656345678E8 -8.09536633654322E8
-5 1.767005767456789E9 -1.653425522543211E9
-6 3.4881168785679E9 -3.3523144114321E9
-7 6.919227989679011E9 -6.761203300320989E9
-8 1.3770339100790121E10 -1.3590092189209879E10
-9 2.7461450211901234E10 -2.7258981078098766E10
-10 5.4832561323012344E10 -5.4607869966987656E10
-11 1.0956367243412346E11 -1.0931675885587654E11
-12 2.1901478354523456E11 -2.1874564774476544E11
-13 2.52769656345677E8 3.858836634567699E7
-14 3.70755767456788E8 -5.7175522543212E7
-15 5.95616878567899E8 -2.59814411432101E8
-16 1.03422798967901E9 -6.7620330032099E8
-17 1.900339100790121E9 -1.520092189209879E9
-18 3.621450211901232E9 -3.218981078098768E9
-19 7.052561323012343E9 -6.627869966987657E9
-20 1.3903672434123453E10 -1.3456758855876547E10
-21 2.7594783545234566E10 -2.7125647744765434E10
-22 5.496589465634567E10 -5.447453663365433E10
-23 1.0969700576745679E11 -1.0918342552254321E11
-24 2.191481168785679E11 -2.186123144114321E11
+1 119436323 -94744967
+2 237422434 -190508856
+3 462283545 -393147745
+4 900894656 -809536634
+5 1767005767 -1653425523
+6 3488116879 -3352314411
+7 6919227990 -6761203300
+8 13770339101 -13590092189
+9 27461450212 -27258981078
+10 54832561323 -54607869967
+11 109563672434 -109316758856
+12 219014783545 -218745647745
+13 252769656 38588366
+14 370755767 -57175523
+15 595616879 -259814411
+16 1034227990 -676203300
+17 1900339101 -1520092189
+18 3621450212 -3218981078
+19 7052561323 -6627869967
+20 13903672434 -13456758856
+21 27594783545 -27125647745
+22 54965894656 -54474536634
+23 109697005767 -109183425523
+24 219148116879 -218612314411
-- !sql_test_Decimal128V3_LargeInt_2 --
\N \N
diff --git a/regression-test/data/nereids_arith_p0/integer.out
b/regression-test/data/nereids_arith_p0/integer.out
index d2e1904fd65..0ece765e0e7 100644
--- a/regression-test/data/nereids_arith_p0/integer.out
+++ b/regression-test/data/nereids_arith_p0/integer.out
@@ -1334,7 +1334,7 @@
6 0.0 0.0 0.0
7 0.0 0.0 0.0
8 0.800000011920929 1.2499999813735487 0.19999999
-9 0.8999999761581421 1.1111111405455043 0.10000002
+9 0.8999999761581421 1.1111111405455043 0.100000024
10 1.0 1.0 0.0
11 1.100000023841858 0.9090908893868948 1.0
12 1.2000000476837158 0.8333333002196431 1.0
@@ -1346,7 +1346,7 @@
18 0.0 0.0 0.0
19 0.0 0.0 0.0
20 0.800000011920929 1.2499999813735487 0.19999999
-21 0.8999999761581421 1.1111111405455043 0.10000002
+21 0.8999999761581421 1.1111111405455043 0.100000024
22 1.0 1.0 0.0
23 1.100000023841858 0.9090908893868948 1.0
24 1.2000000476837158 0.8333333002196431 1.0
@@ -1360,7 +1360,7 @@
6 0.0 0.0 0.0
7 0.0 0.0 0.0
8 0.800000011920929 1.2499999813735487 0.19999999
-9 0.8999999761581421 1.1111111405455043 0.10000002
+9 0.8999999761581421 1.1111111405455043 0.100000024
10 1.0 1.0 0.0
11 1.100000023841858 0.9090908893868948 1.0
12 1.2000000476837158 0.8333333002196431 1.0
@@ -1372,7 +1372,7 @@
18 0.0 0.0 0.0
19 0.0 0.0 0.0
20 0.800000011920929 1.2499999813735487 0.19999999
-21 0.8999999761581421 1.1111111405455043 0.10000002
+21 0.8999999761581421 1.1111111405455043 0.100000024
22 1.0 1.0 0.0
23 1.100000023841858 0.9090908893868948 1.0
24 1.2000000476837158 0.8333333002196431 1.0
@@ -1697,109 +1697,109 @@
-- !sql_test_Boolean_DecimalV2_0 --
\N \N \N
-1 24.395 -24.395
-2 34.484 -34.484
-3 48.756 -48.756
-4 68.943 -68.943
-5 97.494 -97.494
-6 137.874 -137.874
-7 194.980 -194.980
-8 276.741 -274.741
-9 390.955 -388.955
-10 552.479 -550.479
-11 780.908 -778.908
-12 1103.957 -1101.957
-13 24.395 -24.395
-14 34.484 -34.484
-15 48.756 -48.756
-16 68.943 -68.943
-17 97.494 -97.494
-18 137.874 -137.874
-19 194.980 -194.980
-20 276.741 -274.741
-21 390.955 -388.955
-22 552.479 -550.479
-23 780.908 -778.908
-24 1103.957 -1101.957
+1 24.395000000 -24.395000000
+2 34.484000000 -34.484000000
+3 48.756000000 -48.756000000
+4 68.943000000 -68.943000000
+5 97.494000000 -97.494000000
+6 137.874000000 -137.874000000
+7 194.980000000 -194.980000000
+8 276.741000000 -274.741000000
+9 390.955000000 -388.955000000
+10 552.479000000 -550.479000000
+11 780.908000000 -778.908000000
+12 1103.957000000 -1101.957000000
+13 24.395000000 -24.395000000
+14 34.484000000 -34.484000000
+15 48.756000000 -48.756000000
+16 68.943000000 -68.943000000
+17 97.494000000 -97.494000000
+18 137.874000000 -137.874000000
+19 194.980000000 -194.980000000
+20 276.741000000 -274.741000000
+21 390.955000000 -388.955000000
+22 552.479000000 -550.479000000
+23 780.908000000 -778.908000000
+24 1103.957000000 -1101.957000000
-- !sql_test_Boolean_DecimalV2_notn_0 --
-1 24.395 -24.395
-2 34.484 -34.484
-3 48.756 -48.756
-4 68.943 -68.943
-5 97.494 -97.494
-6 137.874 -137.874
-7 194.980 -194.980
-8 276.741 -274.741
-9 390.955 -388.955
-10 552.479 -550.479
-11 780.908 -778.908
-12 1103.957 -1101.957
-13 24.395 -24.395
-14 34.484 -34.484
-15 48.756 -48.756
-16 68.943 -68.943
-17 97.494 -97.494
-18 137.874 -137.874
-19 194.980 -194.980
-20 276.741 -274.741
-21 390.955 -388.955
-22 552.479 -550.479
-23 780.908 -778.908
-24 1103.957 -1101.957
+1 24.395000000 -24.395000000
+2 34.484000000 -34.484000000
+3 48.756000000 -48.756000000
+4 68.943000000 -68.943000000
+5 97.494000000 -97.494000000
+6 137.874000000 -137.874000000
+7 194.980000000 -194.980000000
+8 276.741000000 -274.741000000
+9 390.955000000 -388.955000000
+10 552.479000000 -550.479000000
+11 780.908000000 -778.908000000
+12 1103.957000000 -1101.957000000
+13 24.395000000 -24.395000000
+14 34.484000000 -34.484000000
+15 48.756000000 -48.756000000
+16 68.943000000 -68.943000000
+17 97.494000000 -97.494000000
+18 137.874000000 -137.874000000
+19 194.980000000 -194.980000000
+20 276.741000000 -274.741000000
+21 390.955000000 -388.955000000
+22 552.479000000 -550.479000000
+23 780.908000000 -778.908000000
+24 1103.957000000 -1101.957000000
-- !sql_test_Boolean_DecimalV2_1 --
\N \N \N \N
-1 0.000 0.0000 0.000
-2 0.000 0.0000 0.000
-3 0.000 0.0000 0.000
-4 0.000 0.0000 0.000
-5 0.000 0.0000 0.000
-6 0.000 0.0000 0.000
-7 0.000 0.0000 0.000
-8 275.741 0.0036 1.000
-9 389.955 0.0025 1.000
-10 551.479 0.0018 1.000
-11 779.908 0.0012 1.000
-12 1102.957 0.0009 1.000
-13 0.000 0.0000 0.000
-14 0.000 0.0000 0.000
-15 0.000 0.0000 0.000
-16 0.000 0.0000 0.000
-17 0.000 0.0000 0.000
-18 0.000 0.0000 0.000
-19 0.000 0.0000 0.000
-20 275.741 0.0036 1.000
-21 389.955 0.0025 1.000
-22 551.479 0.0018 1.000
-23 779.908 0.0012 1.000
-24 1102.957 0.0009 1.000
+1 0E-9 0E-9 0E-9
+2 0E-9 0E-9 0E-9
+3 0E-9 0E-9 0E-9
+4 0E-9 0E-9 0E-9
+5 0E-9 0E-9 0E-9
+6 0E-9 0E-9 0E-9
+7 0E-9 0E-9 0E-9
+8 275.741000000 0.003626592 1.000000000
+9 389.955000000 0.002564398 1.000000000
+10 551.479000000 0.001813306 1.000000000
+11 779.908000000 0.001282203 1.000000000
+12 1102.957000000 0.000906654 1.000000000
+13 0E-9 0E-9 0E-9
+14 0E-9 0E-9 0E-9
+15 0E-9 0E-9 0E-9
+16 0E-9 0E-9 0E-9
+17 0E-9 0E-9 0E-9
+18 0E-9 0E-9 0E-9
+19 0E-9 0E-9 0E-9
+20 275.741000000 0.003626592 1.000000000
+21 389.955000000 0.002564398 1.000000000
+22 551.479000000 0.001813306 1.000000000
+23 779.908000000 0.001282203 1.000000000
+24 1102.957000000 0.000906654 1.000000000
-- !sql_test_Boolean_DecimalV2_notn_1 --
-1 0.000 0.0000 0.000
-2 0.000 0.0000 0.000
-3 0.000 0.0000 0.000
-4 0.000 0.0000 0.000
-5 0.000 0.0000 0.000
-6 0.000 0.0000 0.000
-7 0.000 0.0000 0.000
-8 275.741 0.0036 1.000
-9 389.955 0.0025 1.000
-10 551.479 0.0018 1.000
-11 779.908 0.0012 1.000
-12 1102.957 0.0009 1.000
-13 0.000 0.0000 0.000
-14 0.000 0.0000 0.000
-15 0.000 0.0000 0.000
-16 0.000 0.0000 0.000
-17 0.000 0.0000 0.000
-18 0.000 0.0000 0.000
-19 0.000 0.0000 0.000
-20 275.741 0.0036 1.000
-21 389.955 0.0025 1.000
-22 551.479 0.0018 1.000
-23 779.908 0.0012 1.000
-24 1102.957 0.0009 1.000
+1 0E-9 0E-9 0E-9
+2 0E-9 0E-9 0E-9
+3 0E-9 0E-9 0E-9
+4 0E-9 0E-9 0E-9
+5 0E-9 0E-9 0E-9
+6 0E-9 0E-9 0E-9
+7 0E-9 0E-9 0E-9
+8 275.741000000 0.003626592 1.000000000
+9 389.955000000 0.002564398 1.000000000
+10 551.479000000 0.001813306 1.000000000
+11 779.908000000 0.001282203 1.000000000
+12 1102.957000000 0.000906654 1.000000000
+13 0E-9 0E-9 0E-9
+14 0E-9 0E-9 0E-9
+15 0E-9 0E-9 0E-9
+16 0E-9 0E-9 0E-9
+17 0E-9 0E-9 0E-9
+18 0E-9 0E-9 0E-9
+19 0E-9 0E-9 0E-9
+20 275.741000000 0.003626592 1.000000000
+21 389.955000000 0.002564398 1.000000000
+22 551.479000000 0.001813306 1.000000000
+23 779.908000000 0.001282203 1.000000000
+24 1102.957000000 0.000906654 1.000000000
-- !sql_test_Boolean_DecimalV2_2 --
\N \N
@@ -5725,109 +5725,109 @@
-- !sql_test_TinyInt_DecimalV2_0 --
\N \N \N
-1 25.395 -23.395
-2 36.484 -32.484
-3 51.756 -45.756
-4 72.943 -64.943
-5 102.494 -92.494
-6 143.874 -131.874
-7 201.980 -187.980
-8 283.741 -267.741
-9 398.955 -380.955
-10 561.479 -541.479
-11 790.908 -768.908
-12 1114.957 -1090.957
-13 25.395 -23.395
-14 36.484 -32.484
-15 51.756 -45.756
-16 72.943 -64.943
-17 102.494 -92.494
-18 143.874 -131.874
-19 201.980 -187.980
-20 283.741 -267.741
-21 398.955 -380.955
-22 561.479 -541.479
-23 790.908 -768.908
-24 1114.957 -1090.957
+1 25.395000000 -23.395000000
+2 36.484000000 -32.484000000
+3 51.756000000 -45.756000000
+4 72.943000000 -64.943000000
+5 102.494000000 -92.494000000
+6 143.874000000 -131.874000000
+7 201.980000000 -187.980000000
+8 283.741000000 -267.741000000
+9 398.955000000 -380.955000000
+10 561.479000000 -541.479000000
+11 790.908000000 -768.908000000
+12 1114.957000000 -1090.957000000
+13 25.395000000 -23.395000000
+14 36.484000000 -32.484000000
+15 51.756000000 -45.756000000
+16 72.943000000 -64.943000000
+17 102.494000000 -92.494000000
+18 143.874000000 -131.874000000
+19 201.980000000 -187.980000000
+20 283.741000000 -267.741000000
+21 398.955000000 -380.955000000
+22 561.479000000 -541.479000000
+23 790.908000000 -768.908000000
+24 1114.957000000 -1090.957000000
-- !sql_test_TinyInt_DecimalV2_notn_0 --
-1 25.395 -23.395
-2 36.484 -32.484
-3 51.756 -45.756
-4 72.943 -64.943
-5 102.494 -92.494
-6 143.874 -131.874
-7 201.980 -187.980
-8 283.741 -267.741
-9 398.955 -380.955
-10 561.479 -541.479
-11 790.908 -768.908
-12 1114.957 -1090.957
-13 25.395 -23.395
-14 36.484 -32.484
-15 51.756 -45.756
-16 72.943 -64.943
-17 102.494 -92.494
-18 143.874 -131.874
-19 201.980 -187.980
-20 283.741 -267.741
-21 398.955 -380.955
-22 561.479 -541.479
-23 790.908 -768.908
-24 1114.957 -1090.957
+1 25.395000000 -23.395000000
+2 36.484000000 -32.484000000
+3 51.756000000 -45.756000000
+4 72.943000000 -64.943000000
+5 102.494000000 -92.494000000
+6 143.874000000 -131.874000000
+7 201.980000000 -187.980000000
+8 283.741000000 -267.741000000
+9 398.955000000 -380.955000000
+10 561.479000000 -541.479000000
+11 790.908000000 -768.908000000
+12 1114.957000000 -1090.957000000
+13 25.395000000 -23.395000000
+14 36.484000000 -32.484000000
+15 51.756000000 -45.756000000
+16 72.943000000 -64.943000000
+17 102.494000000 -92.494000000
+18 143.874000000 -131.874000000
+19 201.980000000 -187.980000000
+20 283.741000000 -267.741000000
+21 398.955000000 -380.955000000
+22 561.479000000 -541.479000000
+23 790.908000000 -768.908000000
+24 1114.957000000 -1090.957000000
-- !sql_test_TinyInt_DecimalV2_1 --
\N \N \N \N
-1 24.395 0.0409 1.000
-2 68.968 0.0579 2.000
-3 146.268 0.0615 3.000
-4 275.772 0.0580 4.000
-5 487.470 0.0512 5.000
-6 827.244 0.0435 6.000
-7 1364.860 0.0359 7.000
-8 2205.928 0.0290 8.000
-9 3509.595 0.0230 9.000
-10 5514.790 0.0181 10.000
-11 8578.988 0.0141 11.000
-12 13235.484 0.0108 12.000
-13 24.395 0.0409 1.000
-14 68.968 0.0579 2.000
-15 146.268 0.0615 3.000
-16 275.772 0.0580 4.000
-17 487.470 0.0512 5.000
-18 827.244 0.0435 6.000
-19 1364.860 0.0359 7.000
-20 2205.928 0.0290 8.000
-21 3509.595 0.0230 9.000
-22 5514.790 0.0181 10.000
-23 8578.988 0.0141 11.000
-24 13235.484 0.0108 12.000
+1 24.395000000 0.040992007 1.000000000
+2 68.968000000 0.057997912 2.000000000
+3 146.268000000 0.061530889 3.000000000
+4 275.772000000 0.058018943 4.000000000
+5 487.470000000 0.051285207 5.000000000
+6 827.244000000 0.043517995 6.000000000
+7 1364.860000000 0.035901118 7.000000000
+8 2205.928000000 0.029012733 8.000000000
+9 3509.595000000 0.023079586 9.000000000
+10 5514.790000000 0.018133057 10.000000000
+11 8578.988000000 0.014104228 11.000000000
+12 13235.484000000 0.010879844 12.000000000
+13 24.395000000 0.040992007 1.000000000
+14 68.968000000 0.057997912 2.000000000
+15 146.268000000 0.061530889 3.000000000
+16 275.772000000 0.058018943 4.000000000
+17 487.470000000 0.051285207 5.000000000
+18 827.244000000 0.043517995 6.000000000
+19 1364.860000000 0.035901118 7.000000000
+20 2205.928000000 0.029012733 8.000000000
+21 3509.595000000 0.023079586 9.000000000
+22 5514.790000000 0.018133057 10.000000000
+23 8578.988000000 0.014104228 11.000000000
+24 13235.484000000 0.010879844 12.000000000
-- !sql_test_TinyInt_DecimalV2_notn_1 --
-1 24.395 0.0409 1.000
-2 68.968 0.0579 2.000
-3 146.268 0.0615 3.000
-4 275.772 0.0580 4.000
-5 487.470 0.0512 5.000
-6 827.244 0.0435 6.000
-7 1364.860 0.0359 7.000
-8 2205.928 0.0290 8.000
-9 3509.595 0.0230 9.000
-10 5514.790 0.0181 10.000
-11 8578.988 0.0141 11.000
-12 13235.484 0.0108 12.000
-13 24.395 0.0409 1.000
-14 68.968 0.0579 2.000
-15 146.268 0.0615 3.000
-16 275.772 0.0580 4.000
-17 487.470 0.0512 5.000
-18 827.244 0.0435 6.000
-19 1364.860 0.0359 7.000
-20 2205.928 0.0290 8.000
-21 3509.595 0.0230 9.000
-22 5514.790 0.0181 10.000
-23 8578.988 0.0141 11.000
-24 13235.484 0.0108 12.000
+1 24.395000000 0.040992007 1.000000000
+2 68.968000000 0.057997912 2.000000000
+3 146.268000000 0.061530889 3.000000000
+4 275.772000000 0.058018943 4.000000000
+5 487.470000000 0.051285207 5.000000000
+6 827.244000000 0.043517995 6.000000000
+7 1364.860000000 0.035901118 7.000000000
+8 2205.928000000 0.029012733 8.000000000
+9 3509.595000000 0.023079586 9.000000000
+10 5514.790000000 0.018133057 10.000000000
+11 8578.988000000 0.014104228 11.000000000
+12 13235.484000000 0.010879844 12.000000000
+13 24.395000000 0.040992007 1.000000000
+14 68.968000000 0.057997912 2.000000000
+15 146.268000000 0.061530889 3.000000000
+16 275.772000000 0.058018943 4.000000000
+17 487.470000000 0.051285207 5.000000000
+18 827.244000000 0.043517995 6.000000000
+19 1364.860000000 0.035901118 7.000000000
+20 2205.928000000 0.029012733 8.000000000
+21 3509.595000000 0.023079586 9.000000000
+22 5514.790000000 0.018133057 10.000000000
+23 8578.988000000 0.014104228 11.000000000
+24 13235.484000000 0.010879844 12.000000000
-- !sql_test_TinyInt_DecimalV2_2 --
\N \N
@@ -9435,109 +9435,109 @@
-- !sql_test_SmallInt_DecimalV2_0 --
\N \N \N
-1 34.395 -14.395
-2 54.484 -14.484
-3 88.756 -8.756
-4 148.943 11.057
-5 257.494 62.506
-6 457.874 182.126
-7 834.980 445.020
-8 1555.741 1004.259
-9 2949.955 2170.045
-10 5671.479 4568.521
-11 11019.908 9460.092
-12 21582.957 19377.043
-13 34.395 -14.395
-14 54.484 -14.484
-15 88.756 -8.756
-16 148.943 11.057
-17 257.494 62.506
-18 457.874 182.126
-19 834.980 445.020
-20 1555.741 1004.259
-21 2949.955 2170.045
-22 5671.479 4568.521
-23 11019.908 9460.092
-24 21582.957 19377.043
+1 34.395000000 -14.395000000
+2 54.484000000 -14.484000000
+3 88.756000000 -8.756000000
+4 148.943000000 11.057000000
+5 257.494000000 62.506000000
+6 457.874000000 182.126000000
+7 834.980000000 445.020000000
+8 1555.741000000 1004.259000000
+9 2949.955000000 2170.045000000
+10 5671.479000000 4568.521000000
+11 11019.908000000 9460.092000000
+12 21582.957000000 19377.043000000
+13 34.395000000 -14.395000000
+14 54.484000000 -14.484000000
+15 88.756000000 -8.756000000
+16 148.943000000 11.057000000
+17 257.494000000 62.506000000
+18 457.874000000 182.126000000
+19 834.980000000 445.020000000
+20 1555.741000000 1004.259000000
+21 2949.955000000 2170.045000000
+22 5671.479000000 4568.521000000
+23 11019.908000000 9460.092000000
+24 21582.957000000 19377.043000000
-- !sql_test_SmallInt_DecimalV2_notn_0 --
-1 34.395 -14.395
-2 54.484 -14.484
-3 88.756 -8.756
-4 148.943 11.057
-5 257.494 62.506
-6 457.874 182.126
-7 834.980 445.020
-8 1555.741 1004.259
-9 2949.955 2170.045
-10 5671.479 4568.521
-11 11019.908 9460.092
-12 21582.957 19377.043
-13 34.395 -14.395
-14 54.484 -14.484
-15 88.756 -8.756
-16 148.943 11.057
-17 257.494 62.506
-18 457.874 182.126
-19 834.980 445.020
-20 1555.741 1004.259
-21 2949.955 2170.045
-22 5671.479 4568.521
-23 11019.908 9460.092
-24 21582.957 19377.043
+1 34.395000000 -14.395000000
+2 54.484000000 -14.484000000
+3 88.756000000 -8.756000000
+4 148.943000000 11.057000000
+5 257.494000000 62.506000000
+6 457.874000000 182.126000000
+7 834.980000000 445.020000000
+8 1555.741000000 1004.259000000
+9 2949.955000000 2170.045000000
+10 5671.479000000 4568.521000000
+11 11019.908000000 9460.092000000
+12 21582.957000000 19377.043000000
+13 34.395000000 -14.395000000
+14 54.484000000 -14.484000000
+15 88.756000000 -8.756000000
+16 148.943000000 11.057000000
+17 257.494000000 62.506000000
+18 457.874000000 182.126000000
+19 834.980000000 445.020000000
+20 1555.741000000 1004.259000000
+21 2949.955000000 2170.045000000
+22 5671.479000000 4568.521000000
+23 11019.908000000 9460.092000000
+24 21582.957000000 19377.043000000
-- !sql_test_SmallInt_DecimalV2_1 --
\N \N \N \N
-1 243.950 0.4099 10.000
-2 689.680 0.5799 20.000
-3 1950.240 0.8204 40.000
-4 5515.440 1.1603 11.057
-5 15599.040 1.6411 62.506
-6 44119.680 2.3209 44.252
-7 124787.200 3.2823 55.060
-8 352948.480 4.6420 177.036
-9 998284.800 6.5648 220.270
-10 2823572.480 9.2841 156.689
-11 7986257.920 13.1297 101.196
-12 22588559.360 18.5682 626.774
-13 243.950 0.4099 10.000
-14 689.680 0.5799 20.000
-15 1950.240 0.8204 40.000
-16 5515.440 1.1603 11.057
-17 15599.040 1.6411 62.506
-18 44119.680 2.3209 44.252
-19 124787.200 3.2823 55.060
-20 352948.480 4.6420 177.036
-21 998284.800 6.5648 220.270
-22 2823572.480 9.2841 156.689
-23 7986257.920 13.1297 101.196
-24 22588559.360 18.5682 626.774
+1 243.950000000 0.409920066 10.000000000
+2 689.680000000 0.579979121 20.000000000
+3 1950.240000000 0.820411847 40.000000000
+4 5515.440000000 1.160378864 11.057000000
+5 15599.040000000 1.641126633 62.506000000
+6 44119.680000000 2.320959717 44.252000000
+7 124787.200000000 3.282387937 55.060000000
+8 352948.480000000 4.642037274 177.036000000
+9 998284.800000000 6.564860048 220.270000000
+10 2823572.480000000 9.284125053 156.689000000
+11 7986257.920000000 13.129753766 101.196000000
+12 22588559.360000000 18.568266941 626.774000000
+13 243.950000000 0.409920066 10.000000000
+14 689.680000000 0.579979121 20.000000000
+15 1950.240000000 0.820411847 40.000000000
+16 5515.440000000 1.160378864 11.057000000
+17 15599.040000000 1.641126633 62.506000000
+18 44119.680000000 2.320959717 44.252000000
+19 124787.200000000 3.282387937 55.060000000
+20 352948.480000000 4.642037274 177.036000000
+21 998284.800000000 6.564860048 220.270000000
+22 2823572.480000000 9.284125053 156.689000000
+23 7986257.920000000 13.129753766 101.196000000
+24 22588559.360000000 18.568266941 626.774000000
-- !sql_test_SmallInt_DecimalV2_notn_1 --
-1 243.950 0.4099 10.000
-2 689.680 0.5799 20.000
-3 1950.240 0.8204 40.000
-4 5515.440 1.1603 11.057
-5 15599.040 1.6411 62.506
-6 44119.680 2.3209 44.252
-7 124787.200 3.2823 55.060
-8 352948.480 4.6420 177.036
-9 998284.800 6.5648 220.270
-10 2823572.480 9.2841 156.689
-11 7986257.920 13.1297 101.196
-12 22588559.360 18.5682 626.774
-13 243.950 0.4099 10.000
-14 689.680 0.5799 20.000
-15 1950.240 0.8204 40.000
-16 5515.440 1.1603 11.057
-17 15599.040 1.6411 62.506
-18 44119.680 2.3209 44.252
-19 124787.200 3.2823 55.060
-20 352948.480 4.6420 177.036
-21 998284.800 6.5648 220.270
-22 2823572.480 9.2841 156.689
-23 7986257.920 13.1297 101.196
-24 22588559.360 18.5682 626.774
+1 243.950000000 0.409920066 10.000000000
+2 689.680000000 0.579979121 20.000000000
+3 1950.240000000 0.820411847 40.000000000
+4 5515.440000000 1.160378864 11.057000000
+5 15599.040000000 1.641126633 62.506000000
+6 44119.680000000 2.320959717 44.252000000
+7 124787.200000000 3.282387937 55.060000000
+8 352948.480000000 4.642037274 177.036000000
+9 998284.800000000 6.564860048 220.270000000
+10 2823572.480000000 9.284125053 156.689000000
+11 7986257.920000000 13.129753766 101.196000000
+12 22588559.360000000 18.568266941 626.774000000
+13 243.950000000 0.409920066 10.000000000
+14 689.680000000 0.579979121 20.000000000
+15 1950.240000000 0.820411847 40.000000000
+16 5515.440000000 1.160378864 11.057000000
+17 15599.040000000 1.641126633 62.506000000
+18 44119.680000000 2.320959717 44.252000000
+19 124787.200000000 3.282387937 55.060000000
+20 352948.480000000 4.642037274 177.036000000
+21 998284.800000000 6.564860048 220.270000000
+22 2823572.480000000 9.284125053 156.689000000
+23 7986257.920000000 13.129753766 101.196000000
+24 22588559.360000000 18.568266941 626.774000000
-- !sql_test_SmallInt_DecimalV2_2 --
\N \N
@@ -13039,109 +13039,109 @@
-- !sql_test_Integer_DecimalV2_0 --
\N \N \N
-1 23819.395 23770.605
-2 47579.484 47510.516
-3 95093.756 94996.244
-4 190113.943 189976.057
-5 380142.494 379947.506
-6 760182.874 759907.126
-7 1520239.980 1519850.020
-8 3040320.741 3039769.259
-9 6080434.955 6079655.045
-10 12160596.479 12159493.521
-11 24320824.908 24319265.092
-12 48641147.957 48638942.043
-13 23819.395 23770.605
-14 47579.484 47510.516
-15 95093.756 94996.244
-16 190113.943 189976.057
-17 380142.494 379947.506
-18 760182.874 759907.126
-19 1520239.980 1519850.020
-20 3040320.741 3039769.259
-21 6080434.955 6079655.045
-22 12160596.479 12159493.521
-23 24320824.908 24319265.092
-24 48641147.957 48638942.043
+1 23819.395000000 23770.605000000
+2 47579.484000000 47510.516000000
+3 95093.756000000 94996.244000000
+4 190113.943000000 189976.057000000
+5 380142.494000000 379947.506000000
+6 760182.874000000 759907.126000000
+7 1520239.980000000 1519850.020000000
+8 3040320.741000000 3039769.259000000
+9 6080434.955000000 6079655.045000000
+10 12160596.479000000 12159493.521000000
+11 24320824.908000000 24319265.092000000
+12 48641147.957000000 48638942.043000000
+13 23819.395000000 23770.605000000
+14 47579.484000000 47510.516000000
+15 95093.756000000 94996.244000000
+16 190113.943000000 189976.057000000
+17 380142.494000000 379947.506000000
+18 760182.874000000 759907.126000000
+19 1520239.980000000 1519850.020000000
+20 3040320.741000000 3039769.259000000
+21 6080434.955000000 6079655.045000000
+22 12160596.479000000 12159493.521000000
+23 24320824.908000000 24319265.092000000
+24 48641147.957000000 48638942.043000000
-- !sql_test_Integer_DecimalV2_notn_0 --
-1 23819.395 23770.605
-2 47579.484 47510.516
-3 95093.756 94996.244
-4 190113.943 189976.057
-5 380142.494 379947.506
-6 760182.874 759907.126
-7 1520239.980 1519850.020
-8 3040320.741 3039769.259
-9 6080434.955 6079655.045
-10 12160596.479 12159493.521
-11 24320824.908 24319265.092
-12 48641147.957 48638942.043
-13 23819.395 23770.605
-14 47579.484 47510.516
-15 95093.756 94996.244
-16 190113.943 189976.057
-17 380142.494 379947.506
-18 760182.874 759907.126
-19 1520239.980 1519850.020
-20 3040320.741 3039769.259
-21 6080434.955 6079655.045
-22 12160596.479 12159493.521
-23 24320824.908 24319265.092
-24 48641147.957 48638942.043
+1 23819.395000000 23770.605000000
+2 47579.484000000 47510.516000000
+3 95093.756000000 94996.244000000
+4 190113.943000000 189976.057000000
+5 380142.494000000 379947.506000000
+6 760182.874000000 759907.126000000
+7 1520239.980000000 1519850.020000000
+8 3040320.741000000 3039769.259000000
+9 6080434.955000000 6079655.045000000
+10 12160596.479000000 12159493.521000000
+11 24320824.908000000 24319265.092000000
+12 48641147.957000000 48638942.043000000
+13 23819.395000000 23770.605000000
+14 47579.484000000 47510.516000000
+15 95093.756000000 94996.244000000
+16 190113.943000000 189976.057000000
+17 380142.494000000 379947.506000000
+18 760182.874000000 759907.126000000
+19 1520239.980000000 1519850.020000000
+20 3040320.741000000 3039769.259000000
+21 6080434.955000000 6079655.045000000
+22 12160596.479000000 12159493.521000000
+23 24320824.908000000 24319265.092000000
+24 48641147.957000000 48638942.043000000
-- !sql_test_Integer_DecimalV2_1 --
\N \N \N \N
-1 580479.025 975.4047 9.875
-2 1639541.780 1378.7553 26.048
-3 4634014.020 1949.4010 19.556
-4 13102272.435 2756.5525 38.092
-5 37052107.230 3898.1373 13.388
-6 104790444.330 5512.6057 83.512
-7 296378374.100 7795.9021 175.900
-8 838265048.345 11025.0017 0.475
-9 2370943947.975 15591.6580 256.595
-10 6706009456.555 22049.8785 484.529
-11 18967397655.860 31183.2228 173.836
-12 53647878113.065 44099.6747 744.257
-13 580479.025 975.4047 9.875
-14 1639541.780 1378.7553 26.048
-15 4634014.020 1949.4010 19.556
-16 13102272.435 2756.5525 38.092
-17 37052107.230 3898.1373 13.388
-18 104790444.330 5512.6057 83.512
-19 296378374.100 7795.9021 175.900
-20 838265048.345 11025.0017 0.475
-21 2370943947.975 15591.6580 256.595
-22 6706009456.555 22049.8785 484.529
-23 18967397655.860 31183.2228 173.836
-24 53647878113.065 44099.6747 744.257
+1 580479.025000000 975.404796065 9.875000000
+2 1639541.780000000 1378.755364807 26.048000000
+3 4634014.020000000 1949.401099352 19.556000000
+4 13102272.435000000 2756.552514396 38.092000000
+5 37052107.230000000 3898.137321271 13.388000000
+6 104790444.330000000 5512.605712462 83.512000000
+7 296378374.100000000 7795.902143810 175.900000000
+8 838265048.345000000 11025.001722631 0.475000000
+9 2370943947.975000000 15591.658011822 256.595000000
+10 6706009456.555000000 22049.878599185 484.529000000
+11 18967397655.860000000 31183.222892957 173.836000000
+12 53647878113.065000000 44099.674783332 744.257000000
+13 580479.025000000 975.404796065 9.875000000
+14 1639541.780000000 1378.755364807 26.048000000
+15 4634014.020000000 1949.401099352 19.556000000
+16 13102272.435000000 2756.552514396 38.092000000
+17 37052107.230000000 3898.137321271 13.388000000
+18 104790444.330000000 5512.605712462 83.512000000
+19 296378374.100000000 7795.902143810 175.900000000
+20 838265048.345000000 11025.001722631 0.475000000
+21 2370943947.975000000 15591.658011822 256.595000000
+22 6706009456.555000000 22049.878599185 484.529000000
+23 18967397655.860000000 31183.222892957 173.836000000
+24 53647878113.065000000 44099.674783332 744.257000000
-- !sql_test_Integer_DecimalV2_notn_1 --
-1 580479.025 975.4047 9.875
-2 1639541.780 1378.7553 26.048
-3 4634014.020 1949.4010 19.556
-4 13102272.435 2756.5525 38.092
-5 37052107.230 3898.1373 13.388
-6 104790444.330 5512.6057 83.512
-7 296378374.100 7795.9021 175.900
-8 838265048.345 11025.0017 0.475
-9 2370943947.975 15591.6580 256.595
-10 6706009456.555 22049.8785 484.529
-11 18967397655.860 31183.2228 173.836
-12 53647878113.065 44099.6747 744.257
-13 580479.025 975.4047 9.875
-14 1639541.780 1378.7553 26.048
-15 4634014.020 1949.4010 19.556
-16 13102272.435 2756.5525 38.092
-17 37052107.230 3898.1373 13.388
-18 104790444.330 5512.6057 83.512
-19 296378374.100 7795.9021 175.900
-20 838265048.345 11025.0017 0.475
-21 2370943947.975 15591.6580 256.595
-22 6706009456.555 22049.8785 484.529
-23 18967397655.860 31183.2228 173.836
-24 53647878113.065 44099.6747 744.257
+1 580479.025000000 975.404796065 9.875000000
+2 1639541.780000000 1378.755364807 26.048000000
+3 4634014.020000000 1949.401099352 19.556000000
+4 13102272.435000000 2756.552514396 38.092000000
+5 37052107.230000000 3898.137321271 13.388000000
+6 104790444.330000000 5512.605712462 83.512000000
+7 296378374.100000000 7795.902143810 175.900000000
+8 838265048.345000000 11025.001722631 0.475000000
+9 2370943947.975000000 15591.658011822 256.595000000
+10 6706009456.555000000 22049.878599185 484.529000000
+11 18967397655.860000000 31183.222892957 173.836000000
+12 53647878113.065000000 44099.674783332 744.257000000
+13 580479.025000000 975.404796065 9.875000000
+14 1639541.780000000 1378.755364807 26.048000000
+15 4634014.020000000 1949.401099352 19.556000000
+16 13102272.435000000 2756.552514396 38.092000000
+17 37052107.230000000 3898.137321271 13.388000000
+18 104790444.330000000 5512.605712462 83.512000000
+19 296378374.100000000 7795.902143810 175.900000000
+20 838265048.345000000 11025.001722631 0.475000000
+21 2370943947.975000000 15591.658011822 256.595000000
+22 6706009456.555000000 22049.878599185 484.529000000
+23 18967397655.860000000 31183.222892957 173.836000000
+24 53647878113.065000000 44099.674783332 744.257000000
-- !sql_test_Integer_DecimalV2_2 --
\N \N
diff --git a/regression-test/suites/nereids_arith_p0/load.groovy
b/regression-test/suites/nereids_arith_p0/load.groovy
index 711c6691d40..ff8eedfa3c0 100644
--- a/regression-test/suites/nereids_arith_p0/load.groovy
+++ b/regression-test/suites/nereids_arith_p0/load.groovy
@@ -21,6 +21,8 @@ suite("load") {
sql "drop table if exists expr_test"
sql "drop table if exists expr_test_not_nullable"
+ sql "ADMIN SET FRONTEND CONFIG ('disable_decimalv2' = 'false')"
+
sql """
CREATE TABLE IF NOT EXISTS `expr_test` (
`id` int null,
@@ -32,7 +34,7 @@ suite("load") {
`klint` largeint(40) null,
`kfloat` float null,
`kdbl` double null,
- `kdcml` decimal(9, 3) null,
+ `kdcml` decimalv2(9, 3) null,
`kchr` char(10) null,
`kvchr` varchar(10) null,
`kstr` string null,
@@ -59,7 +61,7 @@ suite("load") {
`klint` largeint(40) not null,
`kfloat` float not null,
`kdbl` double not null,
- `kdcml` decimal(9, 3) not null,
+ `kdcml` decimalv2(9, 3) not null,
`kchr` char(10) not null,
`kvchr` varchar(10) not null,
`kstr` string not null,
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
