Changeset: 3780fa0816a0 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3780fa0816a0 Added Files: sql/test/emptydb/Tests/check.SQL.py Removed Files: clients/Tests/SQL-dump.SQL.py clients/Tests/SQL-dump.stable.err clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/emptydb/Tests/check.SQL.py.src Modified Files: clients/Tests/All sql/backends/monet5/sql_upgrades.c sql/test/emptydb-upgrade-chain-hge/Tests/All sql/test/emptydb-upgrade-chain-hge/Tests/check.SQL.py.src sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/All sql/test/emptydb-upgrade-chain/Tests/check.SQL.py.src sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-hge/Tests/All sql/test/emptydb-upgrade-hge/Tests/check.SQL.py.src sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/All sql/test/emptydb-upgrade/Tests/check.SQL.py.src sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb/Tests/All sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out Branch: Dec2016 Log Message:
When upgrading, also modify maximum number of digits for decimal function arguments. Also see changeset 84b7fc2a39e7. diffs (truncated from 15834 to 300 lines): diff --git a/clients/Tests/All b/clients/Tests/All --- a/clients/Tests/All +++ b/clients/Tests/All @@ -1,4 +1,3 @@ exports HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBPY&HAVE_LIBR&HAVE_LIDAR&HAVE_NETCDF&HAVE_SAMTOOLS&HAVE_SHP&HAVE_SPHINXCLIENT?MAL-signatures -!BITS32&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIDAR&HAVE_NETCDF&HAVE_PCRE&HAVE_SHP&HAVE_SAMTOOLS?SQL-dump MERCURIAL?malcheck diff --git a/clients/Tests/SQL-dump.stable.err b/clients/Tests/SQL-dump.stable.err deleted file mode 100644 --- a/clients/Tests/SQL-dump.stable.err +++ /dev/null @@ -1,36 +0,0 @@ -stderr of test 'SQL-dump` in directory 'clients` itself: - - -# 15:01:36 > -# 15:01:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34237" "--set" "mapi_usock=/var/tmp/mtest-13451/.s.monetdb.34237" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_clients" "--set" "mal_listing=0" -# 15:01:36 > - -# builtin opt gdk_dbpath = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm/demo -# builtin opt gdk_debug = 0 -# builtin opt gdk_vmtrim = yes -# builtin opt monet_prompt = > -# builtin opt monet_daemon = no -# builtin opt mapi_port = 50000 -# builtin opt mapi_open = false -# builtin opt mapi_autosense = false -# builtin opt sql_optimizer = default_pipe -# builtin opt sql_debug = 0 -# cmdline opt gdk_nr_threads = 0 -# cmdline opt mapi_open = true -# cmdline opt mapi_port = 34237 -# cmdline opt mapi_usock = /var/tmp/mtest-13451/.s.monetdb.34237 -# cmdline opt monet_prompt = -# cmdline opt mal_listing = 2 -# cmdline opt gdk_dbpath = /ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_clients -# cmdline opt mal_listing = 0 - -# 15:01:36 > -# 15:01:36 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13451" "--port=34237" -# 15:01:36 > - - - -# 15:01:41 > -# 15:01:41 > "Done." -# 15:01:41 > - diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out deleted file mode 100644 --- a/clients/Tests/SQL-dump.stable.out +++ /dev/null @@ -1,7515 +0,0 @@ -stdout of test 'SQL-dump` in directory 'clients` itself: - - -# 15:01:36 > -# 15:01:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34237" "--set" "mapi_usock=/var/tmp/mtest-13451/.s.monetdb.34237" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_clients" "--set" "mal_listing=0" -# 15:01:36 > - -# MonetDB 5 server v11.17.0 (hg id: 51cced809df4) -# This is an unreleased version -# Serving database 'mTests_clients', using 8 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Found 15.591 GiB available main-memory. -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved -# Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://madrid.ins.cwi.nl:34237/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-13451/.s.monetdb.34237 -# MonetDB/GIS module loaded -# MonetDB/JAQL module loaded -# MonetDB/SQL module loaded - -Ready. -# SQL catalog created, loading sql scripts once -# loading sql script: 09_like.sql -# loading sql script: 10_math.sql -# loading sql script: 11_times.sql -# loading sql script: 12_url.sql -# loading sql script: 13_date.sql -# loading sql script: 14_inet.sql -# loading sql script: 15_querylog.sql -# loading sql script: 16_tracelog.sql -# loading sql script: 17_compress.sql -# loading sql script: 18_dictionary.sql -# loading sql script: 19_cluster.sql -# loading sql script: 20_vacuum.sql -# loading sql script: 21_dependency_functions.sql -# loading sql script: 22_clients.sql -# loading sql script: 23_skyserver.sql -# loading sql script: 24_zorder.sql -# loading sql script: 25_debug.sql -# loading sql script: 26_sysmon.sql -# loading sql script: 39_analytics.sql -# loading sql script: 40_geom.sql -# loading sql script: 40_json.sql -# loading sql script: 41_md5sum.sql -# loading sql script: 45_uuid.sql -# loading sql script: 46_gsl.sql -# loading sql script: 75_storagemodel.sql -# loading sql script: 80_statistics.sql -# loading sql script: 80_udf.sql -# loading sql script: 80_udf_hge.sql -# loading sql script: 85_bam.sql -# loading sql script: 90_generator.sql -# loading sql script: 90_generator_hge.sql -# loading sql script: 99_system.sql - -# 11:22:28 > -# 11:22:28 > "/usr/bin/python2" "SQL-dump.SQL.py" "SQL-dump" -# 11:22:28 > - -\dn -\dt -\dv -\ds -\df -\dSn -\dSt -\dSv -\dSs -\dSf -\dn bam -\dn json -\dn profiler -\dn sys -\dn tmp -\dSt bam.export -\dSt bam.files -\dSt bam.pg -\dSt bam.rg -\dSt bam.sq -\dSt sys._columns -\dSt sys._tables -\dSt sys.args -\dSt sys.auths -\dSt sys.connections -\dSt sys.db_user_info -\dSt sys.dependencies -\dSt sys.dependency_types -\dSt sys.functions -\dSt sys.idxs -\dSt sys.keys -\dSt sys.keywords -\dSt sys.netcdf_attrs -\dSt sys.netcdf_dims -\dSt sys.netcdf_files -\dSt sys.netcdf_vardim -\dSt sys.netcdf_vars -\dSt sys.objects -\dSt sys.privileges -\dSt sys.schemas -\dSt sys.sequences -\dSt sys.spatial_ref_sys -\dSt sys.statistics -\dSt sys.storagemodelinput -\dSt sys.systemfunctions -\dSt sys.table_types -\dSt sys.triggers -\dSt sys.types -\dSt sys.user_role -\dSt tmp._columns -\dSt tmp._tables -\dSt tmp.idxs -\dSt tmp.keys -\dSt tmp.objects -\dSt tmp.triggers -\dSv sys.columns -\dSv sys.environment -\dSv sys.geometry_columns -\dSv sys.optimizers -\dSv sys.querylog_calls -\dSv sys.querylog_catalog -\dSv sys.querylog_history -\dSv sys.queue -\dSv sys.rejects -\dSv sys.sessions -\dSv sys.storage -\dSv sys.storagemodel -\dSv sys.tables -\dSv sys.tablestoragemodel -\dSv sys.tracelog -\dSv sys.users -\dSf sys."abbrev" -\dSf sys."alpha" -\dSf sys."analyze" -\dSf sys."bbp" -\dSf sys."broadcast" -\dSf sys."chi2prob" -\dSf sys."clearrejects" -\dSf sys."columnsize" -\dSf sys."contains" -\dSf sys."corr" -\dSf sys."createorderindex" -\dSf sys."date_to_str" -\dSf sys."db_users" -\dSf sys."debug" -\dSf sys."degrees" -\dSf sys."dependencies_columns_on_functions" -\dSf sys."dependencies_columns_on_indexes" -\dSf sys."dependencies_columns_on_keys" -\dSf sys."dependencies_columns_on_triggers" -\dSf sys."dependencies_columns_on_views" -\dSf sys."dependencies_functions_on_functions" -\dSf sys."dependencies_functions_os_triggers" -\dSf sys."dependencies_keys_on_foreignkeys" -\dSf sys."dependencies_owners_on_schemas" -\dSf sys."dependencies_schemas_on_users" -\dSf sys."dependencies_tables_on_foreignkeys" -\dSf sys."dependencies_tables_on_functions" -\dSf sys."dependencies_tables_on_indexes" -\dSf sys."dependencies_tables_on_triggers" -\dSf sys."dependencies_tables_on_views" -\dSf sys."dependencies_views_on_functions" -\dSf sys."dependencies_views_on_triggers" -\dSf sys."droporderindex" -\dSf sys."env" -\dSf sys."environment" -\dSf sys."epoch" -\dSf sys."evalalgebra" -\dSf sys."fitsattach" -\dSf sys."fitsload" -\dSf sys."flush_log" -\dSf sys."fuse" -\dSf sys."generate_series" -\dSf sys."geometrytype" -\dSf sys."get_type" -\dSf sys."getanchor" -\dSf sys."getbasename" -\dSf sys."getcontent" -\dSf sys."getcontext" -\dSf sys."getdomain" -\dSf sys."getextension" -\dSf sys."getfile" -\dSf sys."gethost" -\dSf sys."getport" -\dSf sys."getproj4" -\dSf sys."getprotocol" -\dSf sys."getquery" -\dSf sys."getroboturl" -\dSf sys."getuser" -\dSf sys."has_m" -\dSf sys."has_z" -\dSf sys."hashsize" -\dSf sys."heapsize" -\dSf sys."host" -\dSf sys."hostmask" -\dSf sys."ilike" -\dSf sys."imprintsize" -\dSf sys."internaltransform" -\dSf sys."isaurl" -\dSf sys."isauuid" -\dSf sys."left_shift" -\dSf sys."left_shift_assign" -\dSf sys."lidarattach" -\dSf sys."lidarexport" -\dSf sys."lidarload" -\dSf sys."like" -\dSf sys."listdir" -\dSf sys."listdirpat" -\dSf sys."malfunctions" -\dSf sys."masklen" -\dSf sys."mbr" -\dSf sys."md5" -\dSf sys."median" -\dSf sys."ms_round" -\dSf sys."ms_str" -\dSf sys."ms_stuff" -\dSf sys."ms_trunc" -\dSf sys."netcdf_attach" -\dSf sys."netcdf_importvar" -\dSf sys."netmask" -\dSf sys."network" -\dSf sys."newurl" -\dSf sys."optimizer_stats" -\dSf sys."optimizers" -\dSf sys."password_hash" -\dSf sys."pause" -\dSf sys."quantile" -\dSf sys."querycache" -\dSf sys."querylog" -\dSf sys."querylog_calls" -\dSf sys."querylog_catalog" -\dSf sys."querylog_disable" -\dSf sys."querylog_empty" -\dSf sys."querylog_enable" -\dSf sys."queue" -\dSf sys."radians" -\dSf sys."rejects" -\dSf sys."resume" -\dSf sys."reuse" -\dSf sys."reverse" -\dSf sys."right_shift" -\dSf sys."right_shift_assign" -\dSf sys."sessions" -\dSf sys."setmasklen" -\dSf sys."setsession" -\dSf sys."settimeout" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
