Changeset: 4ef37a1c7467 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4ef37a1c7467 Modified Files: sql/server/rel_exp.c Branch: default Log Message:
merged with Mar2025 diffs (76 lines): diff --git a/sql/ChangeLog.Mar2025 b/sql/ChangeLog.Mar2025 --- a/sql/ChangeLog.Mar2025 +++ b/sql/ChangeLog.Mar2025 @@ -1,3 +1,8 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Wed May 14 2025 Martin van Dinther <[email protected]> +- Corrected reading decimal type columns from external ODBC data sources + via proto_loader('odbc:...'). Those columns were mapped to varchar type + columns. Now they will be mapped to decimal type, when possible. + diff --git a/sql/test/proto_loader/odbc/Tests/All b/sql/test/proto_loader/odbc/Tests/All --- a/sql/test/proto_loader/odbc/Tests/All +++ b/sql/test/proto_loader/odbc/Tests/All @@ -4,4 +4,3 @@ HAVE_ODBC?monetodbc HAVE_SQLITE3ODBC&HAVE_DATA_PATH?sqlite3odbc HAVE_ODBC?monetodbc_datatypes KNOWNFAIL&HAVE_ODBC?monetodbc_bigdec_failure -KNOWNFAIL&HAVE_ODBC?monetodbc_interval_day_overflow diff --git a/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test b/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test --- a/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test +++ b/sql/test/proto_loader/odbc/Tests/monetodbc_interval_day_overflow.test @@ -1,16 +1,30 @@ -query II -select cast('99' as interval day) as val1, cast('-99' as interval day) as val2 +query III +select cast('99' as interval day) as val1, cast('-99' as interval day) as val2, cast(null as interval day) as valnil +---- +99 +-99 +NULL + +query III +select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99'' as interval day) as val1, cast(''-99'' as interval day) as val2, cast(null as interval day) as valnil' ---- 99 -99 +NULL query II -select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''99'' as interval day) as val1, cast(''-99'' as interval day) as val2' +select cast('101' as interval day) as val1, cast('-102' as interval day) as val2 ---- -99 --99 +101 +-102 -query II +query RR +select cast('101' as interval day) as val1, cast('-102' as interval day) as val2 +---- +101.000 +-102.000 + +query TT select cast('101' as interval day) as val1, cast('-102' as interval day) as val2 ---- 101 @@ -25,3 +39,15 @@ select * from 'odbc:DSN=MonetDB-Test;QUE 101 -102 +query RR +select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''101'' as interval day) as val1, cast(''-102'' as interval day) as val2' +---- +101.000 +-102.000 + +query TT +select * from 'odbc:DSN=MonetDB-Test;QUERY=select cast(''101'' as interval day) as val1, cast(''-102'' as interval day) as val2' +---- +101 +-102 + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
