Changeset: a5c17afdab9f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a5c17afdab9f
Added Files:
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.test
Removed Files:
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.py
Branch: Jan2022
Log Message:
Converted test now that it properly fails on all platforms.
diffs (40 lines):
diff --git a/sql/test/BugTracker-2009/Tests/overflow.SF-2853458.py
b/sql/test/BugTracker-2009/Tests/overflow.SF-2853458.test
rename from sql/test/BugTracker-2009/Tests/overflow.SF-2853458.py
rename to sql/test/BugTracker-2009/Tests/overflow.SF-2853458.test
--- a/sql/test/BugTracker-2009/Tests/overflow.SF-2853458.py
+++ b/sql/test/BugTracker-2009/Tests/overflow.SF-2853458.test
@@ -1,30 +1,6 @@
-import sys, os, platform, pymonetdb
-
-db = os.getenv("TSTDB")
-port = int(os.getenv("MAPIPORT"))
-
-conn1 = pymonetdb.connect(database=db, port=port, autocommit=True,
username='monetdb', password='monetdb')
-cur1 = conn1.cursor()
-running_arch = platform.machine()
+statement error 22003!overflow in conversion of 9.2233720368547758e+18 to lng.
+select cast(power(2,63) as bigint)
-try:
- cur1.execute("select cast(power(2,63) as bigint);")
- if running_arch == 'ppc64':
- if cur1.fetchall() != [(9223372036854775807,)]:
- sys.stderr.write('[(9223372036854775807,)] expected\n')
- else:
- sys.stderr.write("Exception expected")
-except pymonetdb.DatabaseError as e:
- if running_arch == 'ppc64':
- raise e
- elif "overflow in conversion" not in str(e):
- sys.stderr.write('Wrong error %s, expected overflow in conversion' %
(str(e)))
-try:
- cur1.execute("select cast(power(2,64) as bigint);")
- sys.stderr.write("Exception expected")
-except pymonetdb.DatabaseError as e:
- if "overflow in conversion" not in str(e):
- sys.stderr.write('Wrong error %s, expected overflow in conversion' %
(str(e)))
+statement error 22003!overflow in conversion of 1.8446744073709552e+19 to lng.
+select cast(power(2,64) as bigint)
-cur1.close()
-conn1.close()
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
