Changeset: bef184d525ef for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bef184d525ef Modified Files: sql/test/pg_regress/Tests/numeric.sql Branch: default Log Message:
In future release the maximum size for decimals is 38 instead of 18. Adapting numeric test to the larger size, such that much more inserted values are accepted and results are closer to the PG results. diffs (31 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 @@ -2,17 +2,17 @@ -- NUMERIC -- -CREATE TABLE num_data (id integer, val numeric(18,10)); -CREATE TABLE num_exp_add (id1 integer, id2 integer, expected numeric(18,10)); -CREATE TABLE num_exp_sub (id1 integer, id2 integer, expected numeric(18,10)); -CREATE TABLE num_exp_div (id1 integer, id2 integer, expected numeric(18,10)); -CREATE TABLE num_exp_mul (id1 integer, id2 integer, expected numeric(18,10)); -CREATE TABLE num_exp_sqrt (id integer, expected numeric(18,10)); -CREATE TABLE num_exp_ln (id integer, expected numeric(18,10)); -CREATE TABLE num_exp_log10 (id integer, expected numeric(18,10)); -CREATE TABLE num_exp_power_10_ln (id integer, expected numeric(18,10)); +CREATE TABLE num_data (id integer, val numeric(38,10)); +CREATE TABLE num_exp_add (id1 integer, id2 integer, expected numeric(38,10)); +CREATE TABLE num_exp_sub (id1 integer, id2 integer, expected numeric(38,10)); +CREATE TABLE num_exp_div (id1 integer, id2 integer, expected numeric(38,10)); +CREATE TABLE num_exp_mul (id1 integer, id2 integer, expected numeric(38,10)); +CREATE TABLE num_exp_sqrt (id integer, expected numeric(38,10)); +CREATE TABLE num_exp_ln (id integer, expected numeric(38,10)); +CREATE TABLE num_exp_log10 (id integer, expected numeric(38,10)); +CREATE TABLE num_exp_power_10_ln (id integer, expected numeric(38,10)); -CREATE TABLE num_result (id1 integer, id2 integer, result numeric(18,10)); +CREATE TABLE num_result (id1 integer, id2 integer, result numeric(38,10)); -- ****************************** _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
