Changeset: 4dc86d36f329 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4dc86d36f329 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.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.int128 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.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.int128 Branch: Jul2017 Log Message:
Approve upgrade output. diffs (256 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -24,6 +24,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 12:22:32 > # 12:22:32 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-1798" "--port=37256" diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -24,6 +24,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 13:21:57 > # 13:21:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29247" "--port=33065" diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -5341,6 +5341,18 @@ grant execute on aggregate sys.corr(huge grant execute on function json.filter(json, hugeint) to public; set schema "sys"; +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; + # 16:53:35 > # 16:53:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-30908" "--port=39660" diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -24,6 +24,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 15:26:18 > # 15:26:18 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21187" "--port=38946" diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out @@ -24,6 +24,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 15:41:18 > # 15:41:18 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-7576" "--port=32696" diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 @@ -5341,6 +5341,18 @@ grant execute on aggregate sys.corr(huge grant execute on function json.filter(json, hugeint) to public; set schema "sys"; +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; + # 18:26:24 > # 18:26:24 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-20759" "--port=37815" diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -22,6 +22,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 12:26:59 > # 12:26:59 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out @@ -19,6 +19,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/SQL module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 13:21:58 > # 13:21:58 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -5336,6 +5336,18 @@ grant execute on aggregate sys.corr(huge grant execute on function json.filter(json, hugeint) to public; set schema "testschema"; +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; + # 12:48:11 > # 12:48:11 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" diff --git a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -24,6 +24,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 15:26:24 > # 15:26:24 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out b/sql/test/testdb-upgrade/Tests/upgrade.stable.out --- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out @@ -19,6 +19,17 @@ stdout of test 'upgrade` in directory 's # MonetDB/SQL module loaded Ready. +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; # 16:00:56 > # 16:00:56 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 @@ -5333,6 +5333,18 @@ grant execute on aggregate sys.corr(huge grant execute on function json.filter(json, hugeint) to public; set schema "testschema"; +Running database upgrade commands: +GRANT SELECT ON sys.keywords TO PUBLIC; +GRANT SELECT ON sys.table_types TO PUBLIC; +GRANT SELECT ON sys.dependency_types TO PUBLIC; +GRANT SELECT ON sys.function_types TO PUBLIC; +GRANT SELECT ON sys.function_languages TO PUBLIC; +GRANT SELECT ON sys.key_types TO PUBLIC; +GRANT SELECT ON sys.index_types TO PUBLIC; +GRANT SELECT ON sys.privilege_codes TO PUBLIC; +GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; +GRANT SELECT ON sys.environment TO PUBLIC; + # 11:43:08 > # 11:43:08 > "/usr/bin/python2" "upgrade.SQL.py" "upgrade" _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
