Changeset: 644f0b977224 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=644f0b977224 Modified Files: sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out Branch: default Log Message:
Approve, especially white space and empyty line changes. diffs (164 lines): diff --git a/sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out b/sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out --- a/sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out +++ b/sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out @@ -1,36 +1,78 @@ stdout of test 'authorization.SF-1430616` in directory 'sql/test/BugTracker` itself: -# 15:18:11 > -# 15:18:11 > mserver5 "--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=30558 --set xrpc_port=46252 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 15:18:11 > +# 17:04:39 > +# 17:04:39 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=38700" "--set" "mapi_usock=/var/tmp/mtest-7090/.s.monetdb.38700" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/Monet-devel/var/MonetDB/mTests_sql_test_BugTracker" "--set" "embedded_r=yes" "--set" "embedded_py=true" +# 17:04:39 > -# MonetDB server v5.6.0, based on kernel v1.24.0 -# Serving database 'mTests_src_test_BugTracker' -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Copyright (c) 1993-2008 CWI, all rights reserved -# Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:30558/ -# MonetDB/SQL module v2.24.0 loaded +# MonetDB 5 server v11.24.0 (hg id: 0ab1bb99d0ea) +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:38700/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-7090/.s.monetdb.38700 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded +# MonetDB/Python module loaded +# MonetDB/R module loaded Ready. -#function user.main():void; -# clients.quit(); -#end main; +# 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_temporal.sql +# loading sql script: 18_index.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: 25_debug.sql +# loading sql script: 26_sysmon.sql +# loading sql script: 27_rejects.sql +# loading sql script: 39_analytics.sql +# loading sql script: 39_analytics_hge.sql +# loading sql script: 40_geom.sql +# loading sql script: 40_json.sql +# loading sql script: 40_json_hge.sql +# loading sql script: 41_md5sum.sql +# loading sql script: 45_uuid.sql +# loading sql script: 46_gsl.sql +# loading sql script: 46_profiler.sql +# loading sql script: 51_sys_schema_extension.sql +# loading sql script: 72_fits.sql +# loading sql script: 74_netcdf.sql +# loading sql script: 75_lidar.sql +# loading sql script: 75_shp.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 +# 17:04:39 > +# 17:04:39 > "./authorization.SF-1430616.SQL.sh" "authorization.SF-1430616" +# 17:04:39 > -# 10:24:37 > -# 10:24:37 > Mtimeout -timeout 300 ./authorization.SF-1430616.SQL authorization.SF-1430616 -# 10:24:37 > - -# 10:24:37 > -# 10:24:37 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 32887 -d mTests_sql_test_BugTracker -f "../../../../../../MonetDB/sql/test/BugTracker/Tests/authorization.SF-1430616.sql" -# 10:24:37 > +# 17:04:39 > +# 17:04:39 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 38700 -d mTests_sql_test_BugTracker -f "../../../../../../../../scratch1/sjoerd/src/MonetDB/devel/sql/test/BugTracker/Tests/authorization.SF-1430616-data.sql" +# 17:04:39 > CREATE USER "voc" WITH PASSWORD 'voc' NAME 'VOC Explorer' SCHEMA "sys"; Operation successful - SELECT users.name, users.fullname, schemas.name FROM users, schemas WHERE users.default_schema = schemas.id; @@ -41,13 +83,10 @@ SELECT users.name, users.fullname, schem | voc | VOC Explorer | sys | +---------+---------------+------+ 2 rows - CREATE SCHEMA "voc" AUTHORIZATION "voc"; Operation successful - ALTER USER "voc" SET SCHEMA "voc"; Operation successful - SELECT users.name, users.fullname, schemas.name FROM sys.users, sys.schemas WHERE users.default_schema = schemas.id; @@ -59,36 +98,30 @@ SELECT users.name, users.fullname, schem +---------+---------------+------+ 2 rows - -# 08:55:00 > -# 08:55:00 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 37211 -d mTests_sql_test_BugTracker -q -# 08:55:00 > +# 17:04:40 > +# 17:04:40 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 38700 -d mTests_sql_test_BugTracker -q +# 17:04:40 > auto commit mode: on -sql-> -# 15:18:12 > -# 15:18:12 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 30558 -d mTests_sql_test_BugTracker -f "../../../../../../MonetDB/sql/test/BugTracker/Tests/authorization.SF-1430616-drop_user.sql" -# 15:18:12 > +sql> +# 17:04:40 > +# 17:04:40 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -e -h localhost -p 38700 -d mTests_sql_test_BugTracker -f "../../../../../../../../scratch1/sjoerd/src/MonetDB/devel/sql/test/BugTracker/Tests/authorization.SF-1430616-drop_user.sql" +# 17:04:40 > START TRANSACTION; Operation successful - ALTER USER "voc" SET SCHEMA "sys"; Operation successful - DROP SCHEMA "voc"; Operation successful - DROP USER "voc"; Operation successful - COMMIT; Operation successful +# 17:04:40 > +# 17:04:40 > "Done." +# 17:04:40 > -# 15:18:12 > -# 15:18:12 > Done. -# 15:18:12 > - _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
