Changeset: 70ba1c1d0d94 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=70ba1c1d0d94
Modified Files:
sql/test/pg_regress/Tests/float8.sql
sql/test/pg_regress/Tests/float8.stable.err.Windows
sql/test/pg_regress/Tests/float8.stable.out
Branch: default
Log Message:
Disabled test using x ^ y as in MonetDB this is implemented as bit_xor which is
not meaningfull for doubles
diffs (46 lines):
diff --git a/sql/test/pg_regress/Tests/float8.sql
b/sql/test/pg_regress/Tests/float8.sql
--- a/sql/test/pg_regress/Tests/float8.sql
+++ b/sql/test/pg_regress/Tests/float8.sql
@@ -70,8 +70,9 @@ SELECT '' AS three, f.f1, f.f1 - '-10' A
FROM FLOAT8_TBL f
WHERE f.f1 > '0.0';
-SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
- FROM FLOAT8_TBL f where f.f1 = '1004.3';
+-- disabled next query as PostgreSQL interprets x ^ y differently (as power(x,
y)) than MonetDB (as bit-xor operator)
+--SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
+-- FROM FLOAT8_TBL f where f.f1 = '1004.3';
-- absolute value
SELECT '' AS five, f.f1, abs(f1) AS abs_f1
diff --git a/sql/test/pg_regress/Tests/float8.stable.err.Windows
b/sql/test/pg_regress/Tests/float8.stable.err.Windows
--- a/sql/test/pg_regress/Tests/float8.stable.err.Windows
+++ b/sql/test/pg_regress/Tests/float8.stable.err.Windows
@@ -89,10 +89,6 @@ ERROR = !conversion of string 'Infinity'
MAPI = monetdb@LAB03:31271
QUERY = SELECT cast('nan' as double) / cast('nan' as double);
ERROR = !conversion of string 'nan' to type dbl failed.
-MAPI = monetdb@LAB03:31271
-QUERY = SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
- FROM FLOAT8_TBL f where f.f1 = '1004.3';
-ERROR = !rounding of decimal (2.0) doesn't fit format (19.0)
MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
QUERY = SELECT '' AS five, f.f1, truncate(f1) AS trunc_f1
FROM FLOAT8_TBL f;
diff --git a/sql/test/pg_regress/Tests/float8.stable.out
b/sql/test/pg_regress/Tests/float8.stable.out
--- a/sql/test/pg_regress/Tests/float8.stable.out
+++ b/sql/test/pg_regress/Tests/float8.stable.out
@@ -191,13 +191,6 @@ Ready.
[ "", 1004.3, 1014.3 ]
[ "", 1.23456789e+200, 1.23456789e+200 ]
[ "", 1.23456789e-200, 10 ]
-#SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
-# FROM FLOAT8_TBL f where f.f1 = '1004.3';
-% .L, sys.L # table_name
-% one, square_f1 # name
-% char, decimal # type
-% 0, 40 # length
-[ "", 1006 ]
#SELECT '' AS five, f.f1, abs(f1) AS abs_f1
# FROM FLOAT8_TBL f;
% .L, sys.f, sys.L # table_name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
