MonetDB: default - Adapted numeric.sql to get more statements to...

Martin van Dinther Fri, 18 Jul 2014 09:19:51 -0700

Changeset: c20a44439e2a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c20a44439e2a
Modified Files:
        sql/test/pg_regress/Tests/numeric.sql
        sql/test/pg_regress/Tests/numeric.stable.err
        sql/test/pg_regress/Tests/numeric.stable.out
        sql/test/pg_regress/postgresql2sql99.sh
Branch: default
Log Message:


Adapted numeric.sql to get more statements to work with MonetDB
Updated stable.out and stable.err


diffs (truncated from 3155 to 300 lines):

diff --git a/sql/test/pg_regress/Tests/numeric.sql 
b/sql/test/pg_regress/Tests/numeric.sql
--- a/sql/test/pg_regress/Tests/numeric.sql
+++ b/sql/test/pg_regress/Tests/numeric.sql
@@ -20,97 +20,97 @@ CREATE TABLE num_result (id1 integer, id
 -- * with a scale of 200
 -- ******************************
 
-START TRANSACTION;
-INSERT INTO num_exp_add VALUES (0,0,'0');
-INSERT INTO num_exp_sub VALUES (0,0,'0');
-INSERT INTO num_exp_mul VALUES (0,0,'0');
+--START TRANSACTION;
+INSERT INTO num_exp_add VALUES (0,0,'0.0');
+INSERT INTO num_exp_sub VALUES (0,0,'0.0');
+INSERT INTO num_exp_mul VALUES (0,0,'0.0');
 INSERT INTO num_exp_div VALUES (0,0,'NaN');
-INSERT INTO num_exp_add VALUES (0,1,'0');
-INSERT INTO num_exp_sub VALUES (0,1,'0');
-INSERT INTO num_exp_mul VALUES (0,1,'0');
+INSERT INTO num_exp_add VALUES (0,1,'0.0');
+INSERT INTO num_exp_sub VALUES (0,1,'0.0');
+INSERT INTO num_exp_mul VALUES (0,1,'0.0');
 INSERT INTO num_exp_div VALUES (0,1,'NaN');
 INSERT INTO num_exp_add VALUES (0,2,'-34338492.215397047');
 INSERT INTO num_exp_sub VALUES (0,2,'34338492.215397047');
-INSERT INTO num_exp_mul VALUES (0,2,'0');
-INSERT INTO num_exp_div VALUES (0,2,'0');
+INSERT INTO num_exp_mul VALUES (0,2,'0.0');
+INSERT INTO num_exp_div VALUES (0,2,'0.0');
 INSERT INTO num_exp_add VALUES (0,3,'4.31');
 INSERT INTO num_exp_sub VALUES (0,3,'-4.31');
-INSERT INTO num_exp_mul VALUES (0,3,'0');
-INSERT INTO num_exp_div VALUES (0,3,'0');
+INSERT INTO num_exp_mul VALUES (0,3,'0.0');
+INSERT INTO num_exp_div VALUES (0,3,'0.0');
 INSERT INTO num_exp_add VALUES (0,4,'7799461.4119');
 INSERT INTO num_exp_sub VALUES (0,4,'-7799461.4119');
-INSERT INTO num_exp_mul VALUES (0,4,'0');
-INSERT INTO num_exp_div VALUES (0,4,'0');
+INSERT INTO num_exp_mul VALUES (0,4,'0.0');
+INSERT INTO num_exp_div VALUES (0,4,'0.0');
 INSERT INTO num_exp_add VALUES (0,5,'16397.038491');
 INSERT INTO num_exp_sub VALUES (0,5,'-16397.038491');
-INSERT INTO num_exp_mul VALUES (0,5,'0');
-INSERT INTO num_exp_div VALUES (0,5,'0');
+INSERT INTO num_exp_mul VALUES (0,5,'0.0');
+INSERT INTO num_exp_div VALUES (0,5,'0.0');
 INSERT INTO num_exp_add VALUES (0,6,'93901.57763026');
 INSERT INTO num_exp_sub VALUES (0,6,'-93901.57763026');
-INSERT INTO num_exp_mul VALUES (0,6,'0');
-INSERT INTO num_exp_div VALUES (0,6,'0');
+INSERT INTO num_exp_mul VALUES (0,6,'0.0');
+INSERT INTO num_exp_div VALUES (0,6,'0.0');
 INSERT INTO num_exp_add VALUES (0,7,'-83028485');
 INSERT INTO num_exp_sub VALUES (0,7,'83028485');
-INSERT INTO num_exp_mul VALUES (0,7,'0');
-INSERT INTO num_exp_div VALUES (0,7,'0');
+INSERT INTO num_exp_mul VALUES (0,7,'0.0');
+INSERT INTO num_exp_div VALUES (0,7,'0.0');
 INSERT INTO num_exp_add VALUES (0,8,'74881');
 INSERT INTO num_exp_sub VALUES (0,8,'-74881');
-INSERT INTO num_exp_mul VALUES (0,8,'0');
-INSERT INTO num_exp_div VALUES (0,8,'0');
+INSERT INTO num_exp_mul VALUES (0,8,'0.0');
+INSERT INTO num_exp_div VALUES (0,8,'0.0');
 INSERT INTO num_exp_add VALUES (0,9,'-24926804.045047420');
 INSERT INTO num_exp_sub VALUES (0,9,'24926804.045047420');
-INSERT INTO num_exp_mul VALUES (0,9,'0');
-INSERT INTO num_exp_div VALUES (0,9,'0');
-INSERT INTO num_exp_add VALUES (1,0,'0');
-INSERT INTO num_exp_sub VALUES (1,0,'0');
-INSERT INTO num_exp_mul VALUES (1,0,'0');
+INSERT INTO num_exp_mul VALUES (0,9,'0.0');
+INSERT INTO num_exp_div VALUES (0,9,'0.0');
+INSERT INTO num_exp_add VALUES (1,0,'0.0');
+INSERT INTO num_exp_sub VALUES (1,0,'0.0');
+INSERT INTO num_exp_mul VALUES (1,0,'0.0');
 INSERT INTO num_exp_div VALUES (1,0,'NaN');
-INSERT INTO num_exp_add VALUES (1,1,'0');
-INSERT INTO num_exp_sub VALUES (1,1,'0');
-INSERT INTO num_exp_mul VALUES (1,1,'0');
+INSERT INTO num_exp_add VALUES (1,1,'0.0');
+INSERT INTO num_exp_sub VALUES (1,1,'0.0');
+INSERT INTO num_exp_mul VALUES (1,1,'0.0');
 INSERT INTO num_exp_div VALUES (1,1,'NaN');
 INSERT INTO num_exp_add VALUES (1,2,'-34338492.215397047');
 INSERT INTO num_exp_sub VALUES (1,2,'34338492.215397047');
-INSERT INTO num_exp_mul VALUES (1,2,'0');
-INSERT INTO num_exp_div VALUES (1,2,'0');
+INSERT INTO num_exp_mul VALUES (1,2,'0.0');
+INSERT INTO num_exp_div VALUES (1,2,'0.0');
 INSERT INTO num_exp_add VALUES (1,3,'4.31');
 INSERT INTO num_exp_sub VALUES (1,3,'-4.31');
-INSERT INTO num_exp_mul VALUES (1,3,'0');
-INSERT INTO num_exp_div VALUES (1,3,'0');
+INSERT INTO num_exp_mul VALUES (1,3,'0.0');
+INSERT INTO num_exp_div VALUES (1,3,'0.0');
 INSERT INTO num_exp_add VALUES (1,4,'7799461.4119');
 INSERT INTO num_exp_sub VALUES (1,4,'-7799461.4119');
-INSERT INTO num_exp_mul VALUES (1,4,'0');
-INSERT INTO num_exp_div VALUES (1,4,'0');
+INSERT INTO num_exp_mul VALUES (1,4,'0.0');
+INSERT INTO num_exp_div VALUES (1,4,'0.0');
 INSERT INTO num_exp_add VALUES (1,5,'16397.038491');
 INSERT INTO num_exp_sub VALUES (1,5,'-16397.038491');
-INSERT INTO num_exp_mul VALUES (1,5,'0');
-INSERT INTO num_exp_div VALUES (1,5,'0');
+INSERT INTO num_exp_mul VALUES (1,5,'0.0');
+INSERT INTO num_exp_div VALUES (1,5,'0.0');
 INSERT INTO num_exp_add VALUES (1,6,'93901.57763026');
 INSERT INTO num_exp_sub VALUES (1,6,'-93901.57763026');
-INSERT INTO num_exp_mul VALUES (1,6,'0');
-INSERT INTO num_exp_div VALUES (1,6,'0');
+INSERT INTO num_exp_mul VALUES (1,6,'0.0');
+INSERT INTO num_exp_div VALUES (1,6,'0.0');
 INSERT INTO num_exp_add VALUES (1,7,'-83028485');
 INSERT INTO num_exp_sub VALUES (1,7,'83028485');
-INSERT INTO num_exp_mul VALUES (1,7,'0');
-INSERT INTO num_exp_div VALUES (1,7,'0');
+INSERT INTO num_exp_mul VALUES (1,7,'0.0');
+INSERT INTO num_exp_div VALUES (1,7,'0.0');
 INSERT INTO num_exp_add VALUES (1,8,'74881');
 INSERT INTO num_exp_sub VALUES (1,8,'-74881');
-INSERT INTO num_exp_mul VALUES (1,8,'0');
-INSERT INTO num_exp_div VALUES (1,8,'0');
+INSERT INTO num_exp_mul VALUES (1,8,'0.0');
+INSERT INTO num_exp_div VALUES (1,8,'0.0');
 INSERT INTO num_exp_add VALUES (1,9,'-24926804.045047420');
 INSERT INTO num_exp_sub VALUES (1,9,'24926804.045047420');
-INSERT INTO num_exp_mul VALUES (1,9,'0');
-INSERT INTO num_exp_div VALUES (1,9,'0');
+INSERT INTO num_exp_mul VALUES (1,9,'0.0');
+INSERT INTO num_exp_div VALUES (1,9,'0.0');
 INSERT INTO num_exp_add VALUES (2,0,'-34338492.215397047');
 INSERT INTO num_exp_sub VALUES (2,0,'-34338492.215397047');
-INSERT INTO num_exp_mul VALUES (2,0,'0');
+INSERT INTO num_exp_mul VALUES (2,0,'0.0');
 INSERT INTO num_exp_div VALUES (2,0,'NaN');
 INSERT INTO num_exp_add VALUES (2,1,'-34338492.215397047');
 INSERT INTO num_exp_sub VALUES (2,1,'-34338492.215397047');
-INSERT INTO num_exp_mul VALUES (2,1,'0');
+INSERT INTO num_exp_mul VALUES (2,1,'0.0');
 INSERT INTO num_exp_div VALUES (2,1,'NaN');
 INSERT INTO num_exp_add VALUES (2,2,'-68676984.430794094');
-INSERT INTO num_exp_sub VALUES (2,2,'0');
+INSERT INTO num_exp_sub VALUES (2,2,'0.0');
 INSERT INTO num_exp_mul VALUES (2,2,'1179132047626883.596862135856320209');
 INSERT INTO num_exp_div VALUES (2,2,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (2,3,'-34338487.905397047');
@@ -143,18 +143,18 @@ INSERT INTO num_exp_mul VALUES (2,9,'855
 INSERT INTO num_exp_div VALUES (2,9,'1.37757299946438931811');
 INSERT INTO num_exp_add VALUES (3,0,'4.31');
 INSERT INTO num_exp_sub VALUES (3,0,'4.31');
-INSERT INTO num_exp_mul VALUES (3,0,'0');
+INSERT INTO num_exp_mul VALUES (3,0,'0.0');
 INSERT INTO num_exp_div VALUES (3,0,'NaN');
 INSERT INTO num_exp_add VALUES (3,1,'4.31');
 INSERT INTO num_exp_sub VALUES (3,1,'4.31');
-INSERT INTO num_exp_mul VALUES (3,1,'0');
+INSERT INTO num_exp_mul VALUES (3,1,'0.0');
 INSERT INTO num_exp_div VALUES (3,1,'NaN');
 INSERT INTO num_exp_add VALUES (3,2,'-34338487.905397047');
 INSERT INTO num_exp_sub VALUES (3,2,'34338496.525397047');
 INSERT INTO num_exp_mul VALUES (3,2,'-147998901.44836127257');
 INSERT INTO num_exp_div VALUES (3,2,'-.00000012551512084352');
 INSERT INTO num_exp_add VALUES (3,3,'8.62');
-INSERT INTO num_exp_sub VALUES (3,3,'0');
+INSERT INTO num_exp_sub VALUES (3,3,'0.0');
 INSERT INTO num_exp_mul VALUES (3,3,'18.5761');
 INSERT INTO num_exp_div VALUES (3,3,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (3,4,'7799465.7219');
@@ -183,11 +183,11 @@ INSERT INTO num_exp_mul VALUES (3,9,'-10
 INSERT INTO num_exp_div VALUES (3,9,'-.00000017290624149854');
 INSERT INTO num_exp_add VALUES (4,0,'7799461.4119');
 INSERT INTO num_exp_sub VALUES (4,0,'7799461.4119');
-INSERT INTO num_exp_mul VALUES (4,0,'0');
+INSERT INTO num_exp_mul VALUES (4,0,'0.0');
 INSERT INTO num_exp_div VALUES (4,0,'NaN');
 INSERT INTO num_exp_add VALUES (4,1,'7799461.4119');
 INSERT INTO num_exp_sub VALUES (4,1,'7799461.4119');
-INSERT INTO num_exp_mul VALUES (4,1,'0');
+INSERT INTO num_exp_mul VALUES (4,1,'0.0');
 INSERT INTO num_exp_div VALUES (4,1,'NaN');
 INSERT INTO num_exp_add VALUES (4,2,'-26539030.803497047');
 INSERT INTO num_exp_sub VALUES (4,2,'42137953.627297047');
@@ -198,7 +198,7 @@ INSERT INTO num_exp_sub VALUES (4,3,'779
 INSERT INTO num_exp_mul VALUES (4,3,'33615678.685289');
 INSERT INTO num_exp_div VALUES (4,3,'1809619.81714617169373549883');
 INSERT INTO num_exp_add VALUES (4,4,'15598922.8238');
-INSERT INTO num_exp_sub VALUES (4,4,'0');
+INSERT INTO num_exp_sub VALUES (4,4,'0.0');
 INSERT INTO num_exp_mul VALUES (4,4,'60831598315717.14146161');
 INSERT INTO num_exp_div VALUES (4,4,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (4,5,'7815858.450391');
@@ -223,11 +223,11 @@ INSERT INTO num_exp_mul VALUES (4,9,'-19
 INSERT INTO num_exp_div VALUES (4,9,'-.31289456112403769409');
 INSERT INTO num_exp_add VALUES (5,0,'16397.038491');
 INSERT INTO num_exp_sub VALUES (5,0,'16397.038491');
-INSERT INTO num_exp_mul VALUES (5,0,'0');
+INSERT INTO num_exp_mul VALUES (5,0,'0.0');
 INSERT INTO num_exp_div VALUES (5,0,'NaN');
 INSERT INTO num_exp_add VALUES (5,1,'16397.038491');
 INSERT INTO num_exp_sub VALUES (5,1,'16397.038491');
-INSERT INTO num_exp_mul VALUES (5,1,'0');
+INSERT INTO num_exp_mul VALUES (5,1,'0.0');
 INSERT INTO num_exp_div VALUES (5,1,'NaN');
 INSERT INTO num_exp_add VALUES (5,2,'-34322095.176906047');
 INSERT INTO num_exp_sub VALUES (5,2,'34354889.253888047');
@@ -242,7 +242,7 @@ INSERT INTO num_exp_sub VALUES (5,4,'-77
 INSERT INTO num_exp_mul VALUES (5,4,'127888068979.9935054429');
 INSERT INTO num_exp_div VALUES (5,4,'.00210232958726897192');
 INSERT INTO num_exp_add VALUES (5,5,'32794.076982');
-INSERT INTO num_exp_sub VALUES (5,5,'0');
+INSERT INTO num_exp_sub VALUES (5,5,'0.0');
 INSERT INTO num_exp_mul VALUES (5,5,'268862871.275335557081');
 INSERT INTO num_exp_div VALUES (5,5,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (5,6,'110298.61612126');
@@ -263,11 +263,11 @@ INSERT INTO num_exp_mul VALUES (5,9,'-40
 INSERT INTO num_exp_div VALUES (5,9,'-.00065780749354660427');
 INSERT INTO num_exp_add VALUES (6,0,'93901.57763026');
 INSERT INTO num_exp_sub VALUES (6,0,'93901.57763026');
-INSERT INTO num_exp_mul VALUES (6,0,'0');
+INSERT INTO num_exp_mul VALUES (6,0,'0.0');
 INSERT INTO num_exp_div VALUES (6,0,'NaN');
 INSERT INTO num_exp_add VALUES (6,1,'93901.57763026');
 INSERT INTO num_exp_sub VALUES (6,1,'93901.57763026');
-INSERT INTO num_exp_mul VALUES (6,1,'0');
+INSERT INTO num_exp_mul VALUES (6,1,'0.0');
 INSERT INTO num_exp_div VALUES (6,1,'NaN');
 INSERT INTO num_exp_add VALUES (6,2,'-34244590.637766787');
 INSERT INTO num_exp_sub VALUES (6,2,'34432393.793027307');
@@ -286,7 +286,7 @@ INSERT INTO num_exp_sub VALUES (6,5,'775
 INSERT INTO num_exp_mul VALUES (6,5,'1539707782.76899778633766');
 INSERT INTO num_exp_div VALUES (6,5,'5.72674008674192359679');
 INSERT INTO num_exp_add VALUES (6,6,'187803.15526052');
-INSERT INTO num_exp_sub VALUES (6,6,'0');
+INSERT INTO num_exp_sub VALUES (6,6,'0.0');
 INSERT INTO num_exp_mul VALUES (6,6,'8817506281.4517452372676676');
 INSERT INTO num_exp_div VALUES (6,6,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (6,7,'-82934583.42236974');
@@ -303,11 +303,11 @@ INSERT INTO num_exp_mul VALUES (6,9,'-23
 INSERT INTO num_exp_div VALUES (6,9,'-.00376709254265256789');
 INSERT INTO num_exp_add VALUES (7,0,'-83028485');
 INSERT INTO num_exp_sub VALUES (7,0,'-83028485');
-INSERT INTO num_exp_mul VALUES (7,0,'0');
+INSERT INTO num_exp_mul VALUES (7,0,'0.0');
 INSERT INTO num_exp_div VALUES (7,0,'NaN');
 INSERT INTO num_exp_add VALUES (7,1,'-83028485');
 INSERT INTO num_exp_sub VALUES (7,1,'-83028485');
-INSERT INTO num_exp_mul VALUES (7,1,'0');
+INSERT INTO num_exp_mul VALUES (7,1,'0.0');
 INSERT INTO num_exp_div VALUES (7,1,'NaN');
 INSERT INTO num_exp_add VALUES (7,2,'-117366977.215397047');
 INSERT INTO num_exp_sub VALUES (7,2,'-48689992.784602953');
@@ -330,7 +330,7 @@ INSERT INTO num_exp_sub VALUES (7,6,'-83
 INSERT INTO num_exp_mul VALUES (7,6,'-7796505729750.37795610');
 INSERT INTO num_exp_div VALUES (7,6,'-884.20756174009028770294');
 INSERT INTO num_exp_add VALUES (7,7,'-166056970');
-INSERT INTO num_exp_sub VALUES (7,7,'0');
+INSERT INTO num_exp_sub VALUES (7,7,'0.0');
 INSERT INTO num_exp_mul VALUES (7,7,'6893729321395225');
 INSERT INTO num_exp_div VALUES (7,7,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (7,8,'-82953604');
@@ -343,11 +343,11 @@ INSERT INTO num_exp_mul VALUES (7,9,'206
 INSERT INTO num_exp_div VALUES (7,9,'3.33089171198810413382');
 INSERT INTO num_exp_add VALUES (8,0,'74881');
 INSERT INTO num_exp_sub VALUES (8,0,'74881');
-INSERT INTO num_exp_mul VALUES (8,0,'0');
+INSERT INTO num_exp_mul VALUES (8,0,'0.0');
 INSERT INTO num_exp_div VALUES (8,0,'NaN');
 INSERT INTO num_exp_add VALUES (8,1,'74881');
 INSERT INTO num_exp_sub VALUES (8,1,'74881');
-INSERT INTO num_exp_mul VALUES (8,1,'0');
+INSERT INTO num_exp_mul VALUES (8,1,'0.0');
 INSERT INTO num_exp_div VALUES (8,1,'NaN');
 INSERT INTO num_exp_add VALUES (8,2,'-34263611.215397047');
 INSERT INTO num_exp_sub VALUES (8,2,'34413373.215397047');
@@ -374,7 +374,7 @@ INSERT INTO num_exp_sub VALUES (8,7,'831
 INSERT INTO num_exp_mul VALUES (8,7,'-6217255985285');
 INSERT INTO num_exp_div VALUES (8,7,'-.00090187120721280172');
 INSERT INTO num_exp_add VALUES (8,8,'149762');
-INSERT INTO num_exp_sub VALUES (8,8,'0');
+INSERT INTO num_exp_sub VALUES (8,8,'0.0');
 INSERT INTO num_exp_mul VALUES (8,8,'5607164161');
 INSERT INTO num_exp_div VALUES (8,8,'1.00000000000000000000');
 INSERT INTO num_exp_add VALUES (8,9,'-24851923.045047420');
@@ -383,11 +383,11 @@ INSERT INTO num_exp_mul VALUES (8,9,'-18
 INSERT INTO num_exp_div VALUES (8,9,'-.00300403532938582735');
 INSERT INTO num_exp_add VALUES (9,0,'-24926804.045047420');
 INSERT INTO num_exp_sub VALUES (9,0,'-24926804.045047420');
-INSERT INTO num_exp_mul VALUES (9,0,'0');
+INSERT INTO num_exp_mul VALUES (9,0,'0.0');
 INSERT INTO num_exp_div VALUES (9,0,'NaN');
 INSERT INTO num_exp_add VALUES (9,1,'-24926804.045047420');
 INSERT INTO num_exp_sub VALUES (9,1,'-24926804.045047420');
-INSERT INTO num_exp_mul VALUES (9,1,'0');
+INSERT INTO num_exp_mul VALUES (9,1,'0.0');
 INSERT INTO num_exp_div VALUES (9,1,'NaN');
 INSERT INTO num_exp_add VALUES (9,2,'-59265296.260444467');
 INSERT INTO num_exp_sub VALUES (9,2,'9411688.170349627');
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: default - Adapted numeric.sql to get more statements to...

Reply via email to