Changeset: 6753286922bd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6753286922bd
Modified Files:
sql/test/SQLancer/Tests/sqlancer20.SQL.py
Branch: default
Log Message:
Another variant of issue to be looked later, scale propagation missing
diffs (20 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
@@ -18,11 +18,15 @@ with SQLTestCase() as cli:
CREATE REMOTE TABLE "rt1" ("c0" BIGINT,"c1" INTERVAL MONTH) ON
'mapi:monetdb://localhost:%s/%s/sys/t1';
COMMIT;""" % (port, db)).assertSucceeded()
- # Issues related to digits and scale propagation in the sql layer
+ # Issues related to scale propagation in the sql layer
cli.execute("SELECT CAST(2 AS DECIMAL) & CAST(3 AS DOUBLE) FROM t1 where
t1.c0 = 1;") \
.assertSucceeded().assertDataResultMatch([(Decimal('0.002'),)])
cli.execute("SELECT CAST(2 AS DECIMAL) & CAST(3 AS DOUBLE) FROM rt1 where
rt1.c0 = 1;") \
.assertSucceeded().assertDataResultMatch([(Decimal('0.002'),)])
+ cli.execute("SELECT scale_down(146.0, 1) FROM t1 where t1.c0 = 1;") \
+ .assertSucceeded().assertDataResultMatch([(Decimal('14.6'),)])
+ cli.execute("SELECT scale_down(146.0, 1) FROM rt1 where rt1.c0 = 1;") \
+ .assertSucceeded().assertDataResultMatch([(Decimal('14.6'),)])
cli.execute("""
START TRANSACTION;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
