MonetDB: default - Cast to a smaller decimal to avoid overflow

[Pedro Ferreira]

Changeset: 54c0fad700b3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=54c0fad700b3
Modified Files:
        sql/test/bincopy/Tests/bincopy_support.py
Branch: default
Log Message:

Cast to a smaller decimal to avoid overflow


diffs (21 lines):

diff --git a/sql/test/bincopy/Tests/bincopy_support.py 
b/sql/test/bincopy/Tests/bincopy_support.py
--- a/sql/test/bincopy/Tests/bincopy_support.py
+++ b/sql/test/bincopy/Tests/bincopy_support.py
@@ -189,7 +189,7 @@ SELECT * FROM foo
     WHERE EXTRACT(MINUTE FROM ts) <> "minute"
     LIMIT 4;
 SELECT * FROM foo
-    WHERE 1000000 * EXTRACT(SECOND FROM ts) <> 1000000 * "second" + ms
+    WHERE 1000000 * CAST(EXTRACT(SECOND FROM ts) AS DECIMAL(13,6)) <> 1000000 
* "second" + ms
     LIMIT 4;
 
 SELECT * FROM foo
@@ -209,7 +209,7 @@ SELECT * FROM foo
     WHERE EXTRACT(MINUTE FROM tm) <> "minute"
     LIMIT 4;
 SELECT * FROM foo
-    WHERE 1000000 * EXTRACT(SECOND FROM tm) <> 1000000 * "second" + ms
+    WHERE 1000000 * CAST(EXTRACT(SECOND FROM tm) AS DECIMAL(13,6)) <> 1000000 
* "second" + ms
     LIMIT 4;
 
 """, [f"{NRECS} affected rows"])
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list