Changeset: e89ea96de1fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e89ea96de1fd Added Files: clients/odbc/ChangeLog.Jun2020 Modified Files: ChangeLog.Jun2020 MonetDB.spec clients/ChangeLog.Jun2020 clients/odbc/driver/ODBCUtil.c clients/odbc/driver/SQLColumnPrivileges.c clients/odbc/driver/SQLColumns.c clients/odbc/driver/SQLForeignKeys.c clients/odbc/driver/SQLPrepare.c clients/odbc/driver/SQLPrimaryKeys.c clients/odbc/driver/SQLProcedureColumns.c clients/odbc/driver/SQLProcedures.c clients/odbc/driver/SQLSpecialColumns.c clients/odbc/driver/SQLStatistics.c clients/odbc/driver/SQLTablePrivileges.c clients/odbc/driver/SQLTables.c common/stream/stream.h common/utils/mstring.h gdk/ChangeLog.Jun2020 gdk/gdk_aggr.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_cand.c gdk/gdk_firstn.c gdk/gdk_group.c gdk/gdk_join.c gdk/gdk_project.c gdk/gdk_select.c gdk/gdk_tracer.c gdk/gdk_unique.c monetdb5/ChangeLog.Jun2020 sql/ChangeLog.Jun2020 sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_execute.c sql/backends/monet5/sql_upgrades.c sql/common/sql_changeset.c sql/common/sql_hash.c sql/common/sql_keyword.c sql/common/sql_list.c sql/common/sql_mem.c sql/common/sql_stack.c sql/include/sql_mem.h sql/include/sql_relation.h sql/rel.txt sql/scripts/51_sys_schema_extension.sql sql/server/rel_distribute.c sql/server/rel_dump.c sql/server/rel_exp.c sql/server/rel_optimizer.c sql/server/rel_partition.c sql/server/rel_prop.c sql/server/rel_propagate.c sql/server/rel_rel.c sql/server/rel_select.c sql/server/rel_unnest.c sql/server/sql_partition.c sql/server/sql_qc.c sql/storage/store_sequence.c sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.stable.out sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out sql/test/BugTracker-2017/Tests/groupby_assertion.Bug-6338.stable.err sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/mergetables/Tests/sqlsmith-exists.stable.out sql/test/subquery/Tests/subquery5.sql sql/test/subquery/Tests/subquery5.stable.err sql/test/subquery/Tests/subquery5.stable.out sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 tools/merovingian/client/monetdb.c tools/merovingian/daemon/forkmserver.c Branch: scoping Log Message:
Merged with default diffs (truncated from 34084 to 300 lines): diff --git a/ChangeLog.Jun2020 b/ChangeLog.Jun2020 --- a/ChangeLog.Jun2020 +++ b/ChangeLog.Jun2020 @@ -1,12 +1,18 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Tue Feb 18 2020 Thodoris Zois <[email protected]> -- Added mserver5 option (--dbtrace=<path>) in order to be able to - specify the output directory of the produced traces. - -* Thu Feb 6 2020 Panagiotis Koutsourakis <[email protected]> -- Add port and host as fields in the .monetdb file. +* Mon Apr 20 2020 Sjoerd Mullender <[email protected]> +- A new system to deal with debug output has been implemented. There is + now an option --dbtrace to mserver5 that takes a file argument to which + debug output is written. The default value is the file mdbtrace.log + inside the database directory. This option can also be set through + the monetdb program. +- The home directory of the automatically created monetdb user was + changed from /var/MonetDB to /var/lib/monetdb (RPM based systems + only). This home directory is (currently) not used for anything, + though. +- Python 2 support has been removed. There is now only support for + using Python 3. * Thu Jan 30 2020 Sjoerd Mullender <[email protected]> - Removed support for bam and sam files. @@ -16,24 +22,3 @@ database property (raw_strings=yes|no) to control interpretation of strings. -* Fri Nov 29 2019 Panagiotis Koutsourakis <[email protected]> -- Added support for raw strings using the syntax r'' or R''. This means - that C-like escapes will remain uninterpreted within those strings. For - instance SELECT r'\"' returns a string of length two. The user needs - to escape single quotes by doubling them: SELECT r''''. - -* Fri Oct 25 2019 Joeri van Ruth <[email protected]> -- Added SQL function sys.hot_snapshot() which can be used to write - a snapshot of the database to a tar file. For example, - sys.hot_snapshot('/tmp/snapshot.tar'). If compression support is - compiled in, snapshots can also be compressed ('/tmp/snapshot.tar.gz'). - The tar file expands to a single directory with the same name as the - database that was snapshotted. This directory can be passed directly - as the --dbpath argument of mserver5 or it can be copied into an - existing dbfarm and started from monetdbd. - -* Sat Oct 12 2019 Martin Kersten <[email protected]> -- The MAL profiler now assigns the SQL TRACE output to the client record - thereby avoiding the interaction with other queries, but loosing - insight of competing queries. The stethoscope should be used for that. - diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -649,7 +649,9 @@ Recommends: %{name}-SQL-server5-hugeint% Suggests: %{name}-client%{?_isa} = %{version}-%{release} %endif %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7 -%systemd_requires +Requires(post): systemd +Requires(preun): systemd +Requires(postun): systemd %endif %description SQL-server5 diff --git a/clients/ChangeLog.Jun2020 b/clients/ChangeLog.Jun2020 --- a/clients/ChangeLog.Jun2020 +++ b/clients/ChangeLog.Jun2020 @@ -1,11 +1,20 @@ # ChangeLog file for clients # This file is updated with Maddlog +* Mon Apr 20 2020 Sjoerd Mullender <[email protected]> +- The monetdb-client-tools (Debian/Ubuntu) and MonetDB-client-tools + (Fedora/RHcontaining the stethoscope, tachograph, and tomograph has + been removed. A completely new version of stethoscope will be released + to replace the old version. + * Thu Apr 16 2020 Sjoerd Mullender <[email protected]> - Removed the possibility of using the MD5 checksum for authentication purposes. It was never actively used but was there as an option. Now the option has been removed. +* Thu Feb 6 2020 Panagiotis Koutsourakis <[email protected]> +- Add port and host as fields in the .monetdb file. + * Fri Oct 25 2019 Pedro Ferreira <[email protected]> - Added 'sessionid' column to system function sys.queue(), so each query gets tagged with the current session identifier diff --git a/clients/odbc/ChangeLog.Jun2020 b/clients/odbc/ChangeLog.Jun2020 new file mode 100644 --- /dev/null +++ b/clients/odbc/ChangeLog.Jun2020 @@ -0,0 +1,9 @@ +# ChangeLog file for odbc +# This file is updated with Maddlog + +* Mon Apr 20 2020 Sjoerd Mullender <[email protected]> +- The NUMERIC and FLOAT types are now handled fully. Before only DECIMAL, + FLOAT, and DOUBLE were handled fully. +- Some bugs were fixed in the passing back and forth between application + and server of values of type GUID (UUID). + diff --git a/clients/odbc/driver/ODBCUtil.c b/clients/odbc/driver/ODBCUtil.c --- a/clients/odbc/driver/ODBCUtil.c +++ b/clients/odbc/driver/ODBCUtil.c @@ -335,127 +335,548 @@ static struct scalars { int nargs; const char *repl; } scalars[] = { - {"abs", 1, "sys.\"abs\"(\1)", }, - {"acos", 1, "sys.\"acos\"(\1)", }, - {"ascii", 1, "sys.\"ascii\"(\1)", }, - {"asin", 1, "sys.\"asin\"(\1)", }, - {"atan", 1, "sys.\"atan\"(\1)", }, - {"atan2", 2, "sys.\"atan\"(\1,\2)", }, /* note: not atan2 */ - {"bit_length", 1, NULL, }, - {"ceiling", 1, "sys.\"ceiling\"(\1)", }, - {"char", 1, "sys.\"code\"(\1)", }, - {"character_length", 1, "sys.\"character_length\"(\1)", }, - {"char_length", 1, "sys.\"char_length\"(\1)", }, - {"concat", 2, "sys.\"concat\"(\1,\2)", }, - {"convert", 2, NULL, }, - {"cos", 1, "sys.\"cos\"(\1)", }, - {"cot", 1, "sys.\"cot\"(\1)", }, - {"curdate", 0, "sys.\"curdate\"()", }, - {"current_date", 0, "sys.\"current_date\"()", }, - {"current_time", 0, "sys.\"current_time\"()", }, - {"current_time", 1, NULL, }, - {"current_timestamp", 0, "sys.\"current_timestamp\"()", }, - {"current_timestamp", 1, NULL, }, - {"curtime", 0, "sys.\"curtime\"()", }, - {"database", 0, NULL, }, - {"dayname", 1, NULL, }, - {"dayofmonth", 1, "sys.\"dayofmonth\"(\1)", }, - {"dayofweek", 1, "sys.\"dayofweek\"(\1)", }, - {"dayofyear", 1, "sys.\"dayofyear\"(\1)", }, - {"degrees", 1, "sys.\"degrees\"(\1)", }, - {"difference", 2, "sys.\"difference\"(\1,\2)", }, - {"exp", 1, "sys.\"exp\"(\1)", }, - {"extract", 1, "EXTRACT(\1)", }, /* include "X FROM " in argument */ - {"floor", 1, "sys.\"floor\"(\1)", }, - {"hour", 1, "sys.\"hour\"(\1)", }, - {"ifnull", 2, "sys.\"coalesce\"(\1,\2)", }, - {"insert", 4, "sys.\"insert\"(\1,\2,\3,\4)", }, - {"lcase", 1, "sys.\"lcase\"(\1)", }, - {"left", 2, "sys.\"left\"(\1,\2)", }, - {"length", 1, "sys.\"length\"(\1)", }, - {"locate", 2, "sys.\"locate\"(\1,\2)", }, - {"locate", 3, "sys.\"locate\"(\1,\2,\3)", }, - {"log10", 1, "sys.\"log10\"(\1)", }, - {"log", 1, "sys.\"log\"(\1)", }, - {"ltrim", 1, "sys.\"ltrim\"(\1)", }, - {"minute", 1, "sys.\"minute\"(\1)", }, - {"mod", 2, "sys.\"mod\"(\1,\2)", }, - {"month", 1, "sys.\"month\"(\1)", }, - {"monthname", 1, NULL, }, - {"now", 0, "sys.\"now\"()", }, - {"octet_length", 1, "sys.\"octet_length\"(\1)", }, - {"pi", 0, "sys.\"pi\"()", }, - {"position", 1, "POSITION(\1)", }, /* includes " IN str" in first argument. Note: POSITION is implemented in the parser. */ - {"power", 2, "sys.\"power\"(\1,\2)", }, - {"quarter", 1, "sys.\"quarter\"(\1)", }, - {"radians", 1, "sys.\"radians\"(\1)", }, - {"rand", 0, "sys.\"rand\"()", }, - {"rand", 1, "sys.\"rand\"(\1)", }, - {"repeat", 2, "sys.\"repeat\"(\1,\2)", }, - {"replace", 3, "sys.\"replace\"(\1,\2,\3)", }, - {"right", 2, "sys.\"right\"(\1,\2)", }, - {"round", 2, "sys.\"round\"(\1,\2)", }, - {"rtrim", 1, "sys.\"rtrim\"(\1)", }, - {"second", 1, "sys.\"second\"(\1)", }, - {"sign", 1, "sys.\"sign\"(\1)", }, - {"sin", 1, "sys.\"sin\"(\1)", }, - {"soundex", 1, "sys.\"soundex\"(\1)", }, - {"space", 1, "sys.\"space\"(\1)", }, - {"sqrt", 1, "sys.\"sqrt\"(\1)", }, - {"substring", 3, "sys.\"substring\"(\1,\2,\3)", }, - {"tan", 1, "sys.\"tan\"(\1)", }, - {"timestampadd", 3, NULL, }, - {"timestampdiff", 3, NULL, }, - {"truncate", 2, "sys.\"ms_trunc\"(\1,\2)", }, - {"ucase", 1, "sys.\"ucase\"(\1)", }, - {"user", 0, NULL, }, - {"week", 1, "sys.\"week\"(\1)", }, - {"year", 1, "sys.\"year\"(\1)", }, - {NULL, 0, NULL, }, /* sentinel */ + { + .name = "abs", + .nargs = 1, + .repl = "sys.\"abs\"(\1)", + }, + { + .name = "acos", + .nargs = 1, + .repl = "sys.\"acos\"(\1)", + }, + { + .name = "ascii", + .nargs = 1, + .repl = "sys.\"ascii\"(\1)", + }, + { + .name = "asin", + .nargs = 1, + .repl = "sys.\"asin\"(\1)", + }, + { + .name = "atan", + .nargs = 1, + .repl = "sys.\"atan\"(\1)", + }, + { + .name = "atan2", + .nargs = 2, + .repl = "sys.\"atan\"(\1,\2)", /* note: not atan2 */ + }, + { + .name = "bit_length", + .nargs = 1, + .repl = NULL, + }, + { + .name = "ceiling", + .nargs = 1, + .repl = "sys.\"ceiling\"(\1)", + }, + { + .name = "char", + .nargs = 1, + .repl = "sys.\"code\"(\1)", + }, + { + .name = "character_length", + .nargs = 1, + .repl = "sys.\"character_length\"(\1)", + }, + { + .name = "char_length", + .nargs = 1, + .repl = "sys.\"char_length\"(\1)", + }, + { + .name = "concat", + .nargs = 2, + .repl = "sys.\"concat\"(\1,\2)", + }, + { + .name = "convert", + .nargs = 2, + .repl = NULL, + }, + { + .name = "cos", + .nargs = 1, + .repl = "sys.\"cos\"(\1)", + }, + { + .name = "cot", + .nargs = 1, + .repl = "sys.\"cot\"(\1)", + }, + { + .name = "curdate", + .nargs = 0, + .repl = "sys.\"curdate\"()", + }, + { + .name = "current_date", + .nargs = 0, + .repl = "sys.\"current_date\"()", + }, + { + .name = "current_time", + .nargs = 0, + .repl = "sys.\"current_time\"()", + }, + { + .name = "current_time", + .nargs = 1, + .repl = NULL, + }, + { + .name = "current_timestamp", + .nargs = 0, + .repl = "sys.\"current_timestamp\"()", + }, + { + .name = "current_timestamp", + .nargs = 1, + .repl = NULL, + }, + { + .name = "curtime", + .nargs = 0, + .repl = "sys.\"curtime\"()", + }, + { _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
