Changeset: 3d0d7e0fd22e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3d0d7e0fd22e
Modified Files:
        sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.sql
        sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.stable.out
Branch: Jun2020
Log Message:

No "huge" decimal in the output


diffs (24 lines):

diff --git a/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.sql 
b/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.sql
--- a/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.sql
+++ b/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.sql
@@ -132,7 +132,7 @@ SELECT
    DM_CustomerNation_N_NAME AS CustomerNation,
    DM_CustomerRegion_R_NAME AS CustomerRegion,
    avg(DM_Li_L_DISCOUNT) AS L_DISCOUNT_Customer_Nation_Supplier_Nation,
-   sum(DM_Li_L_QUANTITY) AS L_QUANTITY_Customer_Nation_Supplier_Nation,
+   CAST(sum(DM_Li_L_QUANTITY) AS DECIMAL(10,5)) AS 
L_QUANTITY_Customer_Nation_Supplier_Nation,
    O_ORDERDATE_Year,
    DM_Nation_N_NAME AS SupplierNation,
    DM_Region_R_NAME AS SupplierRegion 
diff --git a/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.stable.out 
b/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.stable.out
--- a/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.stable.out
+++ b/sql/test/BugTracker-2020/Tests/tpch-cube.Bug-6938.stable.out
@@ -113,7 +113,7 @@ stdout of test 'tpch-cube.Bug-6938` in d
 % .,   .,      .,      .,      .customerorderdetails,  .,      . # table_name
 % customernation,      customerregion, 
l_discount_customer_nation_supplier_nation,     
l_quantity_customer_nation_supplier_nation,     o_orderdate_year,       
suppliernation, supplierregion # name
 % char,        char,   double, decimal,        int,    char,   char # type
-% 25,  25,     24,     40,     1,      25,     25 # length
+% 25,  25,     24,     12,     1,      25,     25 # length
 [ NULL,        NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 #ROLLBACK;
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to