Changeset: 715e020e92db for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/715e020e92db
Added Files:
sql/test/BugTracker-2025/Tests/7734-epoch-missing-cast.test
Modified Files:
sql/server/rel_select.c
sql/test/BugTracker-2025/Tests/All
Branch: Mar2025
Log Message:
fix for issue #7734, properly cast value for function with fixed decimal
argument type
diffs (36 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -494,7 +494,7 @@ exp_fix_scale(mvc *sql, sql_subtype *ct,
int scale_diff = ((int) ct->scale - (int) et->scale);
if (scale_diff) {
- if (scale_diff < 0)
+ if (!ct->scale && scale_diff < 0)
return e;
sql_subtype st;
int scale = ct->scale;
diff --git a/sql/test/BugTracker-2025/Tests/7734-epoch-missing-cast.test
b/sql/test/BugTracker-2025/Tests/7734-epoch-missing-cast.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7734-epoch-missing-cast.test
@@ -0,0 +1,9 @@
+query T
+select epoch(1234567890.456)
+----
+2009-02-14 01:31:30.456000+02:00
+
+query T
+select epoch(1234567890.456000)
+----
+2009-02-14 01:31:30.456000+02:00
diff --git a/sql/test/BugTracker-2025/Tests/All
b/sql/test/BugTracker-2025/Tests/All
--- a/sql/test/BugTracker-2025/Tests/All
+++ b/sql/test/BugTracker-2025/Tests/All
@@ -43,5 +43,6 @@ 7702-stmt_convert_cands
7706-set-user
7730-generate-series-month-int
7732-table-exp-issue
+7734-epoch-missing-cast
7735-crossproduct-update
7736-scale-reduction-crash
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
