Changeset: 2e078ca5094d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2e078ca5094d Modified Files: sql/ChangeLog Branch: default Log Message:
Updated ChangeLog diffs (21 lines): diff --git a/sql/ChangeLog b/sql/ChangeLog --- a/sql/ChangeLog +++ b/sql/ChangeLog @@ -37,3 +37,17 @@ * Tue Jun 16 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - Removed obsolete json.output(json) function. + +* Tue Jun 30 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> +- Removed compability between interval types and other numeric types in + favor for a more strict SQL standard compliance. This means operations + between temporal types and other numeric types such as INT and + DECIMAL are no longer possible, instead use interval types. + e.g. SELECT date '2020-01-01' + 1; now gives the error. Instead do: + SELECT date '2020-01-01' + interval '1' day; if 1 was meant to be a + day interval. + Setting an interval variable such as the session's current timezone + with a number e.g. SET current_timezone = 1; is no longer possible. + Instead do SET current_timezone = interval '1' hour; + Casting between interval and other numeric types is no longer possible + as well, because they are not compatible. _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
