Changeset: a151cf4b45d9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a151cf4b45d9
Modified Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
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-chain/Tests/upgrade.stable.out.ppc64.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-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-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: default
Log Message:
Approve upgrade for describe_accessible_tables.
diffs (truncated from 750 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -416,3 +416,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -416,3 +416,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -485,3 +485,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git
a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -416,3 +416,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -416,3 +416,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
@@ -485,3 +485,26 @@ GRANT EXECUTE ON AGGREGATE ST_MakeLine(G
update sys.functions set system = true where system <> true and schema_id =
2000 and name in ('st_collect', 'st_distancegeographic',
'st_dwithingeographic', 'st_dwithin', 'st_dwithin_noindex', 'st_dwithin2',
'st_intersectsgeographic', 'st_intersects', 'st_intersects_noindex',
'st_makeline');
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'geometry_columns';
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
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
@@ -56,3 +56,26 @@ update sys._tables set system = true whe
Running database upgrade commands:
drop function sys.similarity(string, string) cascade;
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
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
@@ -56,3 +56,26 @@ update sys._tables set system = true whe
Running database upgrade commands:
drop function sys.similarity(string, string) cascade;
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
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
@@ -125,3 +125,26 @@ update sys._tables set system = true whe
Running database upgrade commands:
drop function sys.similarity(string, string) cascade;
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -125,3 +125,26 @@ update sys._tables set system = true whe
Running database upgrade commands:
drop function sys.similarity(string, string) cascade;
+Running database upgrade commands:
+create view sys.describe_accessible_tables as
+ select
+ schemas.name as schema,
+ tables.name as table,
+ table_types.table_type_name as table_type,
+ privilege_codes.privilege_code_name as privs,
+ privileges.privileges as privs_code
+ from privileges
+ join sys.roles
+ on privileges.auth_id = roles.id
+ join sys.tables
+ on privileges.obj_id = tables.id
+ join sys.table_types
+ on tables.type = table_types.table_type_id
+ join sys.schemas
+ on tables.schema_id = schemas.id
+ join sys.privilege_codes
+ on privileges.privileges = privilege_codes.privilege_code_id
+ where roles.name = current_role;
+GRANT SELECT ON sys.describe_accessible_tables TO PUBLIC;
+update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'describe_accessible_tables';
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
