Changeset: daeb06d67785 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=daeb06d67785
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/21_dependency_functions.sql
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
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.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.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.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.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
Branch: Mar2018
Log Message:
Fix typo in name of deprecated function.
dependencies_functions_os_triggers -> dependencies_functions_on_triggers
diffs (truncated from 817 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -1501,6 +1501,34 @@ sql_update_mar2018_samtools(Client c, mv
}
#endif /* HAVE_SAMTOOLS */
+static str
+sql_update_mar2018_sp1(Client c, mvc *sql)
+{
+ size_t bufsize = 2048, pos = 0;
+ char *buf = GDKmalloc(bufsize), *err = NULL;
+ char *schema = stack_get_string(sql, "current_schema");
+
+ if (buf == NULL)
+ throw(SQL, "sql_update_dec2016_sp3", SQLSTATE(HY001)
MAL_MALLOC_FAIL);
+ pos += snprintf(buf + pos, bufsize - pos,
+ "set schema \"sys\";\n"
+ "drop function
sys.dependencies_functions_os_triggers();\n"
+ "CREATE FUNCTION dependencies_functions_on_triggers()\n"
+ "RETURNS TABLE (sch varchar(100), usr varchar(100),
dep_type varchar(32))\n"
+ "RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER'
from functions as f, triggers as tri, dependencies as dep where dep.id = f.id
AND dep.depend_id =tri.id AND dep.depend_type = 8);\n"
+ "insert into sys.systemfunctions (select id from
sys.functions where name in ('dependencies_functions_on_triggers') and
schema_id = (select id from sys.schemas where name = 'sys') and id not in
(select function_id from sys.systemfunctions));\n"
+ "delete from systemfunctions where function_id not in
(select id from functions);\n");
+ if (schema)
+ pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", schema);
+ pos += snprintf(buf + pos, bufsize - pos, "commit;\n");
+ assert(pos < bufsize);
+
+ printf("Running database upgrade commands:\n%s\n", buf);
+ err = SQLstatementIntern(c, &buf, "update", 1, 0, NULL);
+ GDKfree(buf);
+ return err; /* usually MAL_SUCCEED */
+}
+
void
SQLupgrades(Client c, mvc *m)
{
@@ -1623,4 +1651,11 @@ SQLupgrades(Client c, mvc *m)
}
#endif
}
+
+ if (sql_bind_func(m->sa, s, "dependencies_functions_os_triggers", NULL,
NULL, F_UNION)) {
+ if ((err = sql_update_mar2018_sp1(c, m)) != NULL) {
+ fprintf(stderr, "!%s\n", err);
+ freeException(err);
+ }
+ }
}
diff --git a/sql/scripts/21_dependency_functions.sql
b/sql/scripts/21_dependency_functions.sql
--- a/sql/scripts/21_dependency_functions.sql
+++ b/sql/scripts/21_dependency_functions.sql
@@ -88,7 +88,7 @@ RETURNS TABLE (sch varchar(100), usr var
RETURN TABLE (SELECT f1.name, f2.name, 'DEP_FUNC' from functions as f1,
functions as f2, dependencies as dep where f1.id = dep.id AND f2.id =
dep.depend_id AND dep.depend_type = 7);
--Function f1 has a dependency on trigger tri
-CREATE FUNCTION dependencies_functions_os_triggers()
+CREATE FUNCTION dependencies_functions_on_triggers()
RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
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,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 15:50:22 >
# 15:50:22 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-17773" "--port=32731"
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
@@ -19,6 +19,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/SQL module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 16:05:46 >
# 16:05:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-68585" "--port=37702"
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,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 15:55:37 >
# 15:55:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-12365" "--port=35877"
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -24,6 +24,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 16:02:52 >
# 16:02:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5391" "--port=32916"
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
@@ -5352,6 +5352,17 @@ grant execute on function json.filter(js
set schema "sys";
commit;
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
+
# 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-chain/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
@@ -5352,6 +5352,17 @@ grant execute on function json.filter(js
set schema "sys";
commit;
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
+
# 15:43:25 >
# 15:43:25 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5725" "--port=37647"
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,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 15:50:23 >
# 15:50:23 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-17773" "--port=32731"
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,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 15:55:36 >
# 15:55:36 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-12365" "--port=35877"
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -24,6 +24,16 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
# 16:02:52 >
# 16:02:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5391" "--port=32916"
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
@@ -5352,6 +5352,17 @@ grant execute on function json.filter(js
set schema "sys";
commit;
+Running database upgrade commands:
+set schema "sys";
+drop function sys.dependencies_functions_os_triggers();
+CREATE FUNCTION dependencies_functions_on_triggers()
+RETURNS TABLE (sch varchar(100), usr varchar(100), dep_type varchar(32))
+RETURN TABLE (SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id AND dep.depend_id
=tri.id AND dep.depend_type = 8);
+insert into sys.systemfunctions (select id from sys.functions where name in
('dependencies_functions_on_triggers') and schema_id = (select id from
sys.schemas where name = 'sys') and id not in (select function_id from
sys.systemfunctions));
+delete from systemfunctions where function_id not in (select id from
functions);
+set schema "sys";
+commit;
+
# 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/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -150,7 +150,7 @@ Ready.
\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_functions_on_triggers"
\dSf sys."dependencies_keys_on_foreignkeys"
\dSf sys."dependencies_owners_on_schemas"
\dSf sys."dependencies_schemas_on_users"
@@ -513,7 +513,7 @@ SYSTEM FUNCTION sys.dependencies
SYSTEM FUNCTION sys.dependencies_columns_on_triggers
SYSTEM FUNCTION sys.dependencies_columns_on_views
SYSTEM FUNCTION sys.dependencies_functions_on_functions
-SYSTEM FUNCTION sys.dependencies_functions_os_triggers
+SYSTEM FUNCTION sys.dependencies_functions_on_triggers
SYSTEM FUNCTION sys.dependencies_keys_on_foreignkeys
SYSTEM FUNCTION sys.dependencies_owners_on_schemas
SYSTEM FUNCTION sys.dependencies_schemas_on_users
@@ -968,7 +968,7 @@ create function dependencies_columns_on_
create function dependencies_columns_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, tri.name, 'DEP_TRIGGER' from columns as c, triggers as tri,
dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and
dep.depend_type = 8);
create function dependencies_columns_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, v.name, 'DEP_VIEW' from columns as c, tables as v, dependencies as dep
where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
create function dependencies_functions_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2,
dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and
dep.depend_type = 7);
-create function dependencies_functions_os_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri,
dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and
dep.depend_type = 8);
+create function dependencies_functions_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri,
dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and
dep.depend_type = 8);
create function dependencies_keys_on_foreignkeys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id);
create function dependencies_owners_on_schemas() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
a.name, s.name, 'DEP_SCHEMA' from schemas as s, auths a where s.owner = a.id);
create function dependencies_schemas_on_users() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
s.name, u.name, 'DEP_USER' from schemas as s, users u where u.default_schema =
s.id);
@@ -2264,7 +2264,7 @@ drop function pcre_replace(string, strin
[ "sys", "dependencies_columns_on_triggers", "create function
dependencies_columns_on_triggers() returns table (sch varchar(100), usr
varchar(100), dep_type varchar(32)) return table (select c.name, tri.name,
'DEP_TRIGGER' from columns as c, triggers as tri, dependencies as dep where
dep.id = c.id and dep.depend_id =tri.id and dep.depend_type = 8);", "user",
"SQL", "Function returning a table", false, false, false, "sch",
"varchar", 100, 0, "out", "usr", "varchar", 100, 0,
"out", "dep_type", "varchar", 32, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "dependencies_columns_on_views", "create function
dependencies_columns_on_views() returns table (sch varchar(100), usr
varchar(100), dep_type varchar(32)) return table (select c.name, v.name,
'DEP_VIEW' from columns as c, tables as v, dependencies as dep where c.id =
dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type = 1);",
"user", "SQL", "Function returning a table", false, false, false, "sch",
"varchar", 100, 0, "out", "usr", "varchar", 100, 0,
"out", "dep_type", "varchar", 32, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "dependencies_functions_on_functions", "create function
dependencies_functions_on_functions() returns table (sch varchar(100), usr
varchar(100), dep_type varchar(32)) return table (select f1.name, f2.name,
'DEP_FUNC' from functions as f1, functions as f2, dependencies as dep where
f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7);", "user",
"SQL", "Function returning a table", false, false, false, "sch",
"varchar", 100, 0, "out", "usr", "varchar", 100, 0,
"out", "dep_type", "varchar", 32, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "dependencies_functions_os_triggers", "create function
dependencies_functions_os_triggers() returns table (sch varchar(100), usr
varchar(100), dep_type varchar(32)) return table (select f.name, tri.name,
'DEP_TRIGGER' from functions as f, triggers as tri, dependencies as dep where
dep.id = f.id and dep.depend_id =tri.id and dep.depend_type = 8);", "user",
"SQL", "Function returning a table", false, false, false, "sch",
"varchar", 100, 0, "out", "usr", "varchar", 100, 0,
"out", "dep_type", "varchar", 32, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
