Changeset: f3c85ff77038 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f3c85ff77038
Modified Files:
sql/backends/monet5/sql_upgrades.c
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
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:
Upgrade fix and check approval.
diffs (truncated from 676 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
@@ -1505,7 +1505,7 @@ sql_update_mar2018(Client c, mvc *sql)
"INSERT INTO sys.systemfunctions\n"
"SELECT id FROM sys.functions\n"
"WHERE schema_id = (SELECT id FROM sys.schemas WHERE
name = 'sys')\n"
- "AND name IN ('comment_on', 'function_type_keyword');\n"
+ "AND name IN ('comment_on', 'function_type_keyword',
'no_op');\n"
"ALTER TABLE sys.keywords SET READ WRITE;\n"
"INSERT INTO sys.keywords VALUES ('COMMENT'),
('CONTINUE'), ('START'), ('TRUNCATE');\n"
"-- ALTER TABLE sys.keywords SET READ ONLY;\n"
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
@@ -5819,7 +5819,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5814,7 +5814,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5106,7 +5106,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5106,7 +5106,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5869,7 +5869,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
@@ -5869,7 +5869,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5819,7 +5819,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5106,7 +5106,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5106,7 +5106,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -5869,7 +5869,7 @@ ALTER TABLE sys.systemfunctions ALTER CO
INSERT INTO sys.systemfunctions
SELECT id FROM sys.functions
WHERE schema_id = (SELECT id FROM sys.schemas WHERE name = 'sys')
-AND name IN ('comment_on', 'function_type_keyword');
+AND name IN ('comment_on', 'function_type_keyword', 'no_op');
ALTER TABLE sys.keywords SET READ WRITE;
INSERT INTO sys.keywords VALUES ('COMMENT'), ('CONTINUE'), ('START'),
('TRUNCATE');
-- ALTER TABLE sys.keywords SET READ ONLY;
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
@@ -139,7 +139,6 @@ Ready.
\dSf sys."broadcast"
\dSf sys."clearrejects"
\dSf sys."columnsize"
-\dSf sys."comment_on"
\dSf sys."contains"
\dSf sys."corr"
\dSf sys."createorderindex"
@@ -227,6 +226,7 @@ Ready.
\dSf sys."netmask"
\dSf sys."network"
\dSf sys."newurl"
+\dSf sys."no_op"
\dSf sys."optimizer_stats"
\dSf sys."optimizers"
\dSf sys."password_hash"
@@ -372,7 +372,11 @@ Ready.
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
+SYSTEM SCHEMA bam
+SYSTEM SCHEMA json
+SYSTEM SCHEMA profiler
SYSTEM SCHEMA sys
+SYSTEM SCHEMA tmp
SYSTEM TABLE sys._columns
SYSTEM TABLE sys._tables
SYSTEM TABLE sys.args
@@ -900,7 +904,7 @@ CREATE TABLE "tmp"."keys" ("id" INTEGER,
CREATE TABLE "tmp"."objects" ("id" INTEGER, "name" VARCHAR(1024), "nr"
INTEGER);
CREATE TABLE "tmp"."triggers" ("id" INTEGER, "name" VARCHAR(1024), "table_id"
INTEGER, "time" SMALLINT, "orientation" SMALLINT, "event" SMALLINT, "old_name"
VARCHAR(1024), "new_name" VARCHAR(1024), "condition" VARCHAR(2048), "statement"
VARCHAR(2048));
SELECT * FROM (SELECT p.* FROM "sys"."_columns" AS p UNION ALL SELECT t.* FROM
"tmp"."_columns" AS t) AS columns;
-create view sys.commented_function_signatures as select f.id as fid, s.name as
schema, f.name as fname, sys.function_type_keyword(f.type) as category, case
when sf.function_id is null then false else true end as system, case rank()
over (partition by f.id order by p.number asc) when 1 then f.name else null end
as name, case rank() over (partition by f.id order by p.number desc) when 1
then c.remark else null end as remark, p.type, p.type_digits, p.type_scale,
row_number() over (order by f.id, p.number) as line from sys.functions f join
sys.comments c on f.id = c.id join sys.schemas s on f.schema_id = s.id left
outer join sys.systemfunctions sf on f.id = sf.function_id left outer join
sys.args p on f.id = p.func_id and p.inout = 1 order by line;
+create view sys.commented_function_signatures as select f.id as fid, s.name as
schema, f.name as fname, sys.function_type_keyword(f.type) as category,
sf.function_id is not null as system, case rank() over (partition by f.id order
by p.number asc) when 1 then f.name else null end as name, case rank() over
(partition by f.id order by p.number desc) when 1 then c.remark else null end
as remark, p.type, p.type_digits, p.type_scale, row_number() over (order by
f.id, p.number) as line from sys.functions f join sys.comments c on f.id = c.id
join sys.schemas s on f.schema_id = s.id left outer join sys.systemfunctions sf
on f.id = sf.function_id left outer join sys.args p on f.id = p.func_id and
p.inout = 1 order by line;
create view sys.dependencies_vw as select d.id, i1.obj_type, i1.name,
d.depend_id as used_by_id, i2.obj_type as used_by_obj_type, i2.name as
used_by_name, d.depend_type, dt.dependency_type_name from sys.dependencies d
join sys.ids i1 on d.id = i1.id join sys.ids i2 on d.depend_id = i2.id join
sys.dependency_types dt on d.depend_type = dt.dependency_type_id order by id,
depend_id;
create view sys.dependency_args_on_types as select dt.id as type_id,
dt.sqlname as type_name, f.id as function_id, f.name as function_name, a.id as
arg_id, a.name as arg_name, a.number as arg_nr, dep.depend_type as depend_type
from sys.args as a, sys.functions as f, sys.types as dt, sys.dependencies as
dep where dep.id = dt.id and dep.depend_id = a.id and a.func_id = f.id and
dep.depend_type = 15 order by dt.sqlname, f.name, a.number, a.name;
create view sys.dependency_columns_on_functions as select c.table_id, c.id as
column_id, c.name, f.id as function_id, f.name as function_name, f.type as
function_type, dep.depend_type as depend_type from sys.functions as f,
sys.columns as c, sys.dependencies as dep where c.id = dep.id and f.id =
dep.depend_id and dep.depend_type = 7 and f.type <> 2 order by c.name,
c.table_id, f.name, f.id;
@@ -927,7 +931,7 @@ create view sys.dependency_tables_on_vie
create view sys.dependency_views_on_functions as select v.schema_id as
view_schema_id, v.id as view_id, v.name as view_name, f.name as function_name,
f.type as function_type, dep.depend_type as depend_type from sys.functions as
f, sys.tables as v, sys.dependencies as dep where v.id = dep.id and f.id =
dep.depend_id and dep.depend_type = 7 and f.type <> 2 and v.type in (1, 11)
order by v.name, v.schema_id, f.name, f.id;
create view sys.dependency_views_on_procdures as select v.name as view_name,
p.name as proc_name, p.type as proc_type, dep.depend_type as depend_type from
sys.functions as p, sys.tables as v, sys.dependencies as dep where v.id =
dep.id and p.id = dep.depend_id and dep.depend_type = 13 and p.type = 2 and
v.type in (1, 11) order by v.name, v.schema_id, p.name, p.id;
create view sys.dependency_views_on_views as select v1.schema_id as
view1_schema_id, v1.id as view1_id, v1.name as view1_name, v2.schema_id as
view2_schema_id, v2.id as view2_id, v2.name as view2_name, dep.depend_type as
depend_type from sys.tables as v1, sys.tables as v2, sys.dependencies as dep
where v1.id = dep.id and v2.id = dep.depend_id and dep.depend_type = 5 and
v1.type in (1, 11) and v2.type in (1, 11) order by v1.schema_id, v1.name,
v2.schema_id, v2.name;
-create view sys.describe_all_objects as select s.name as sname, t.name, s.name
|| '.' || t.name as fullname, cast(case t.type when 1 then 2 else 1 end as
smallint) as ntype, (case when t.system then 'SYSTEM ' else '' end) ||
tt.table_type_name as type, t.system, c.remark as remark from sys._tables t
left outer join sys.comments c on t.id = c.id left outer join sys.schemas s on
t.schema_id = s.id left outer join sys.table_types tt on t.type =
tt.table_type_id union all select s.name as sname, sq.name, s.name || '.' ||
sq.name as fullname, cast(4 as smallint) as ntype, 'SEQUENCE' as type, false as
system, c.remark as remark from sys.sequences sq left outer join sys.comments c
on sq.id = c.id left outer join sys.schemas s on sq.schema_id = s.id union all
select distinct s.name as sname, f.name, s.name || '.' || f.name as fullname,
cast(8 as smallint) as ntype, (case when sf.function_id is not null then
'SYSTEM ' else '' end) || sys.function_type_keyword(f.type) as type, case when
sf.fu
nction_id is null then false else true end as system, c.remark as remark from
sys.functions f left outer join sys.comments c on f.id = c.id left outer join
sys.schemas s on f.schema_id = s.id left outer join sys.systemfunctions sf on
f.id = sf.function_id union all select s.name as sname, s.name, s.name as
fullname, cast(16 as smallint) as ntype, (case when s.system then 'SYSTEM
SCHEMA' else 'SCHEMA' end) as type, s.system, c.remark as remark from
sys.schemas s left outer join sys.comments c on s.id = c.id order by system,
name, sname, ntype;
+create view sys.describe_all_objects as select s.name as sname, t.name, s.name
|| '.' || t.name as fullname, cast(case t.type when 1 then 2 else 1 end as
smallint) as ntype, (case when t.system then 'SYSTEM ' else '' end) ||
tt.table_type_name as type, t.system, c.remark as remark from sys._tables t
left outer join sys.comments c on t.id = c.id left outer join sys.schemas s on
t.schema_id = s.id left outer join sys.table_types tt on t.type =
tt.table_type_id union all select s.name as sname, sq.name, s.name || '.' ||
sq.name as fullname, cast(4 as smallint) as ntype, 'SEQUENCE' as type, false as
system, c.remark as remark from sys.sequences sq left outer join sys.comments c
on sq.id = c.id left outer join sys.schemas s on sq.schema_id = s.id union all
select distinct s.name as sname, f.name, s.name || '.' || f.name as fullname,
cast(8 as smallint) as ntype, (case when sf.function_id is not null then
'SYSTEM ' else '' end) || sys.function_type_keyword(f.type) as type,
sf.function_id
is not null as system, c.remark as remark from sys.functions f left outer join
sys.comments c on f.id = c.id left outer join sys.schemas s on f.schema_id =
s.id left outer join sys.systemfunctions sf on f.id = sf.function_id union all
select null as sname, s.name, s.name as fullname, cast(16 as smallint) as
ntype, (case when s.system then 'SYSTEM SCHEMA' else 'SCHEMA' end) as type,
s.system, c.remark as remark from sys.schemas s left outer join sys.comments c
on s.id = c.id order by system, name, sname, ntype;
create view sys.environment as select * from sys.env();
create view sys.geometry_columns as select cast(null as varchar(1)) as
f_table_catalog, s.name as f_table_schema, t.name as f_table_name, c.name as
f_geometry_column, cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as
integer) as coord_dimension, c.type_scale as srid, get_type(c.type_digits, 0)
as type from sys.columns c, sys.tables t, sys.schemas s where c.table_id = t.id
and t.schema_id = s.id and c.type in (select sqlname from sys.types where
systemname in ('wkb', 'wkba'));
create view sys.ids (id, name, schema_id, table_id, table_name, obj_type,
sys_table) as select id, name, cast(null as int) as schema_id, cast(null as
int) as table_id, cast(null as varchar(124)) as table_name, 'author' as
obj_type, 'sys.auths' as sys_table from sys.auths union all select id, name,
cast(null as int) as schema_id, cast(null as int) as table_id, cast(null as
varchar(124)) as table_name, 'schema', 'sys.schemas' from sys.schemas union all
select id, name, schema_id, id as table_id, name as table_name, case when type
= 1 then 'view' else 'table' end, 'sys._tables' from sys._tables union all
select id, name, schema_id, id as table_id, name as table_name, case when type
= 1 then 'view' else 'table' end, 'tmp._tables' from tmp._tables union all
select c.id, c.name, t.schema_id, c.table_id, t.name as table_name, 'column',
'sys._columns' from sys._columns c join sys._tables t on c.table_id = t.id
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name,
'co
lumn', 'tmp._columns' from tmp._columns c join tmp._tables t on c.table_id =
t.id union all select k.id, k.name, t.schema_id, k.table_id, t.name as
table_name, 'key', 'sys.keys' from sys.keys k join sys._tables t on k.table_id
= t.id union all select k.id, k.name, t.schema_id, k.table_id, t.name as
table_name, 'key', 'tmp.keys' from tmp.keys k join sys._tables t on k.table_id
= t.id union all select i.id, i.name, t.schema_id, i.table_id, t.name as
table_name, 'index', 'sys.idxs' from sys.idxs i join sys._tables t on
i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id,
t.name as table_name, 'index', 'tmp.idxs' from tmp.idxs i join sys._tables t on
i.table_id = t.id union all select g.id, g.name, t.schema_id, g.table_id,
t.name as table_name, 'trigger', 'sys.triggers' from sys.triggers g join
sys._tables t on g.table_id = t.id union all select g.id, g.name, t.schema_id,
g.table_id, t.name as table_name, 'trigger', 'tmp.triggers' from tmp.triggers g
join sys._table
s t on g.table_id = t.id union all select id, name, schema_id, cast(null as
int) as table_id, cast(null as varchar(124)) as table_name, case when type = 2
then 'procedure' else 'function' end, 'sys.functions' from sys.functions union
all select a.id, a.name, f.schema_id, cast(null as int) as table_id, cast(null
as varchar(124)) as table_name, case when f.type = 2 then 'procedure arg' else
'function arg' end, 'sys.args' from sys.args a join sys.functions f on
a.func_id = f.id union all select id, name, schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, 'sequence', 'sys.sequences'
from sys.sequences union all select id, sqlname, schema_id, cast(null as int)
as table_id, cast(null as varchar(124)) as table_name, 'type', 'sys.types' from
sys.types where id > 2000 order by id;
@@ -956,7 +960,6 @@ create function sys.bbp () returns table
create function "broadcast" (p inet) returns inet external name
inet."broadcast";
create procedure sys.clearrejects() external name sql.copy_rejects_clear;
create function sys.columnsize(nme string, i bigint, d bigint) returns bigint
begin case when nme = 'boolean' then return i; when nme = 'char' then return
2*i; when nme = 'smallint' then return 2 * i; when nme = 'int' then return 4 *
i; when nme = 'bigint' then return 8 * i; when nme = 'hugeint' then return 16 *
i; when nme = 'timestamp' then return 8 * i; when nme = 'varchar' then case
when cast(d as bigint) << 8 then return i; when cast(d as bigint) << 16 then
return 2 * i; when cast(d as bigint) << 32 then return 4 * i; else return 8 *
i; end case; else return 8 * i; end case; end;
-create procedure sys.comment_on(obj_id integer, obj_remark varchar(65000))
begin if obj_id is not null and obj_id > 0 then if obj_remark is null or
obj_remark = '' then delete from sys.comments where id = obj_id; elseif exists
(select id from sys.comments where id = obj_id) then update sys.comments set
remark = obj_remark where id = obj_id; else insert into sys.comments values
(obj_id, obj_remark); end if; end if; end;
create function contains(a geometry, x double, y double) returns boolean
external name geom."Contains";
create aggregate corr(e1 bigint, e2 bigint) returns double external name
"aggr"."corr";
create aggregate corr(e1 double, e2 double) returns double external name
"aggr"."corr";
@@ -1079,6 +1082,7 @@ create function "netmask" (p inet) retur
create function "network" (p inet) returns inet external name inet."network";
create function newurl(protocol string, hostname string, "port" int, file
string) returns url external name url."new";
create function newurl(protocol string, hostname string, file string) returns
url external name url."new";
+create procedure sys.no_op() begin declare dummy integer; end;
create function sys.optimizer_stats() returns table (optname string, count
int, timing bigint) external name inspect.optimizer_stats;
create function sys.optimizers () returns table (name string, def string,
status string) external name sql.optimizers;
create function sys.password_hash (username string) returns string external
name sql.password;
@@ -1403,7 +1407,7 @@ drop function pcre_replace(string, strin
[ "sys", "args", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "sys", "auths", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "sys", "columns", "SELECT * FROM (SELECT p.* FROM
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t)
AS columns;", "VIEW", true, "COMMIT", "WRITABLE" ]
-[ "sys", "commented_function_signatures", "create view
sys.commented_function_signatures as select f.id as fid, s.name as schema,
f.name as fname, sys.function_type_keyword(f.type) as category, case when
sf.function_id is null then false else true end as system, case rank() over
(partition by f.id order by p.number asc) when 1 then f.name else null end as
name, case rank() over (partition by f.id order by p.number desc) when 1 then
c.remark else null end as remark, p.type, p.type_digits, p.type_scale,
row_number() over (order by f.id, p.number) as line from sys.functions f join
sys.comments c on f.id = c.id join sys.schemas s on f.schema_id = s.id left
outer join sys.systemfunctions sf on f.id = sf.function_id left outer join
sys.args p on f.id = p.func_id and p.inout = 1 order by line;", "VIEW", true,
"COMMIT", "WRITABLE" ]
+[ "sys", "commented_function_signatures", "create view
sys.commented_function_signatures as select f.id as fid, s.name as schema,
f.name as fname, sys.function_type_keyword(f.type) as category, sf.function_id
is not null as system, case rank() over (partition by f.id order by p.number
asc) when 1 then f.name else null end as name, case rank() over (partition by
f.id order by p.number desc) when 1 then c.remark else null end as remark,
p.type, p.type_digits, p.type_scale, row_number() over (order by f.id,
p.number) as line from sys.functions f join sys.comments c on f.id = c.id join
sys.schemas s on f.schema_id = s.id left outer join sys.systemfunctions sf on
f.id = sf.function_id left outer join sys.args p on f.id = p.func_id and
p.inout = 1 order by line;", "VIEW", true, "COMMIT", "WRITABLE" ]
[ "sys", "comments", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "sys", "db_user_info", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "sys", "dependencies", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
@@ -1434,7 +1438,7 @@ drop function pcre_replace(string, strin
[ "sys", "dependency_views_on_functions", "create view
sys.dependency_views_on_functions as select v.schema_id as view_schema_id, v.id
as view_id, v.name as view_name, f.name as function_name, f.type as
function_type, dep.depend_type as depend_type from sys.functions as f,
sys.tables as v, sys.dependencies as dep where v.id = dep.id and f.id =
dep.depend_id and dep.depend_type = 7 and f.type <> 2 and v.type in (1, 11)
order by v.name, v.schema_id, f.name, f.id;", "VIEW", true, "COMMIT",
"WRITABLE" ]
[ "sys", "dependency_views_on_procdures", "create view
sys.dependency_views_on_procdures as select v.name as view_name, p.name as
proc_name, p.type as proc_type, dep.depend_type as depend_type from
sys.functions as p, sys.tables as v, sys.dependencies as dep where v.id =
dep.id and p.id = dep.depend_id and dep.depend_type = 13 and p.type = 2 and
v.type in (1, 11) order by v.name, v.schema_id, p.name, p.id;", "VIEW",
true, "COMMIT", "WRITABLE" ]
[ "sys", "dependency_views_on_views", "create view
sys.dependency_views_on_views as select v1.schema_id as view1_schema_id, v1.id
as view1_id, v1.name as view1_name, v2.schema_id as view2_schema_id, v2.id as
view2_id, v2.name as view2_name, dep.depend_type as depend_type from sys.tables
as v1, sys.tables as v2, sys.dependencies as dep where v1.id = dep.id and v2.id
= dep.depend_id and dep.depend_type = 5 and v1.type in (1, 11) and v2.type in
(1, 11) order by v1.schema_id, v1.name, v2.schema_id, v2.name;", "VIEW",
true, "COMMIT", "WRITABLE" ]
-[ "sys", "describe_all_objects", "create view sys.describe_all_objects
as select s.name as sname, t.name, s.name || '.' || t.name as fullname,
cast(case t.type when 1 then 2 else 1 end as smallint) as ntype, (case when
t.system then 'SYSTEM ' else '' end) || tt.table_type_name as type, t.system,
c.remark as remark from sys._tables t left outer join sys.comments c on t.id =
c.id left outer join sys.schemas s on t.schema_id = s.id left outer join
sys.table_types tt on t.type = tt.table_type_id union all select s.name as
sname, sq.name, s.name || '.' || sq.name as fullname, cast(4 as smallint) as
ntype, 'SEQUENCE' as type, false as system, c.remark as remark from
sys.sequences sq left outer join sys.comments c on sq.id = c.id left outer join
sys.schemas s on sq.schema_id = s.id union all select distinct s.name as sname,
f.name, s.name || '.' || f.name as fullname, cast(8 as smallint) as ntype,
(case when sf.function_id is not null then 'SYSTEM ' else '' end) ||
sys.function_type_keywor
d(f.type) as type, case when sf.function_id is null then false else true end
as system, c.remark as remark from sys.functions f left outer join sys.comments
c on f.id = c.id left outer join sys.schemas s on f.schema_id = s.id left outer
join sys.systemfunctions sf on f.id = sf.function_id union all select s.name as
sname, s.name, s.name as fullname, cast(16 as smallint) as ntype, (case when
s.system then 'SYSTEM SCHEMA' else 'SCHEMA' end) as type, s.system, c.remark as
remark from sys.schemas s left outer join sys.comments c on s.id = c.id order
by system, name, sname, ntype;", "VIEW", true, "COMMIT",
"WRITABLE" ]
+[ "sys", "describe_all_objects", "create view sys.describe_all_objects
as select s.name as sname, t.name, s.name || '.' || t.name as fullname,
cast(case t.type when 1 then 2 else 1 end as smallint) as ntype, (case when
t.system then 'SYSTEM ' else '' end) || tt.table_type_name as type, t.system,
c.remark as remark from sys._tables t left outer join sys.comments c on t.id =
c.id left outer join sys.schemas s on t.schema_id = s.id left outer join
sys.table_types tt on t.type = tt.table_type_id union all select s.name as
sname, sq.name, s.name || '.' || sq.name as fullname, cast(4 as smallint) as
ntype, 'SEQUENCE' as type, false as system, c.remark as remark from
sys.sequences sq left outer join sys.comments c on sq.id = c.id left outer join
sys.schemas s on sq.schema_id = s.id union all select distinct s.name as sname,
f.name, s.name || '.' || f.name as fullname, cast(8 as smallint) as ntype,
(case when sf.function_id is not null then 'SYSTEM ' else '' end) ||
sys.function_type_keywor
d(f.type) as type, sf.function_id is not null as system, c.remark as remark
from sys.functions f left outer join sys.comments c on f.id = c.id left outer
join sys.schemas s on f.schema_id = s.id left outer join sys.systemfunctions sf
on f.id = sf.function_id union all select null as sname, s.name, s.name as
fullname, cast(16 as smallint) as ntype, (case when s.system then 'SYSTEM
SCHEMA' else 'SCHEMA' end) as type, s.system, c.remark as remark from
sys.schemas s left outer join sys.comments c on s.id = c.id order by system,
name, sname, ntype;", "VIEW", true, "COMMIT", "WRITABLE" ]
[ "sys", "environment", "create view sys.environment as select * from
sys.env();", "VIEW", true, "COMMIT", "WRITABLE" ]
[ "sys", "function_languages", NULL, "TABLE", true,
"COMMIT", "READONLY" ]
[ "sys", "function_types", NULL, "TABLE", true,
"COMMIT", "READONLY" ]
@@ -1746,7 +1750,7 @@ drop function pcre_replace(string, strin
[ "dependency_views_on_views", "view2_id", "int", 32, 0, NULL,
true, 4, NULL ]
[ "dependency_views_on_views", "view2_name", "varchar", 1024, 0,
NULL, true, 5, NULL ]
[ "dependency_views_on_views", "depend_type", "smallint", 16, 0,
NULL, true, 6, NULL ]
-[ "describe_all_objects", "sname", "varchar", 1024, 0,
NULL, true, 0, NULL ]
+[ "describe_all_objects", "sname", "varchar", 0, 0,
NULL, true, 0, NULL ]
[ "describe_all_objects", "name", "varchar", 1024, 0, NULL,
true, 1, NULL ]
[ "describe_all_objects", "fullname", "varchar", 2049, 0,
NULL, true, 2, NULL ]
[ "describe_all_objects", "ntype", "smallint", 16, 0,
NULL, true, 3, NULL ]
@@ -2236,7 +2240,6 @@ drop function pcre_replace(string, strin
[ "sys", "code", "unicode", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "clob", 0, 0,
"out", "arg_1", "int", 32, 0, "in", 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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "code", "unicode", "str", "Internal C", "Scalar
function", false, false, false, "res_0", "varchar", 0,
0, "out", "arg_1", "int", 32, 0, "in", 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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "columnsize", "create function sys.columnsize(nme string, i
bigint, d bigint) returns bigint begin case when nme = 'boolean' then return i;
when nme = 'char' then return 2*i; when nme = 'smallint' then return 2 * i;
when nme = 'int' then return 4 * i; when nme = 'bigint' then return 8 * i; when
nme = 'hugeint' then return 16 * i; when nme = 'timestamp' then return 8 * i;
when nme = 'varchar' then case when cast(d as bigint) << 8 then return i; when
cast(d as bigint) << 16 then return 2 * i; when cast(d as bigint) << 32 then
return 4 * i; else return 8 * i; end case; else return 8 * i; end case; end;",
"user", "SQL", "Scalar function", false, false, false, "result",
"bigint", 64, 0, "out", "nme", "clob", 0, 0,
"in", "i", "bigint", 64, 0, "in", "d", "bigint",
64, 0, "in", 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, NUL
L, 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", "comment_on", "create procedure sys.comment_on(obj_id
integer, obj_remark varchar(65000)) begin if obj_id is not null and obj_id > 0
then if obj_remark is null or obj_remark = '' then delete from sys.comments
where id = obj_id; elseif exists (select id from sys.comments where id =
obj_id) then update sys.comments set remark = obj_remark where id = obj_id;
else insert into sys.comments values (obj_id, obj_remark); end if; end if;
end;", "user", "SQL", "Procedure", true, false, false, "obj_id",
"int", 32, 0, "in", "obj_remark", "varchar", 65000, 0,
"in", 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, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "concat", "+", "calc", "Internal C", "Scalar
function", false, false, false, "res_0", "char", 0, 0,
"out", "arg_1", "char", 0, 0, "in", "arg_2", "char",
0, 0, "in", 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", "concat", "+", "calc", "Internal C", "Scalar
function", false, false, false, "res_0", "clob", 0, 0,
"out", "arg_1", "clob", 0, 0, "in", "arg_2", "clob",
0, 0, "in", 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", "concat", "+", "calc", "Internal C", "Scalar
function", false, false, false, "res_0", "varchar", 0,
0, "out", "arg_1", "varchar", 0, 0, "in",
"arg_2", "varchar", 0, 0, "in", 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 ]
@@ -2526,6 +2529,7 @@ drop function pcre_replace(string, strin
[ "sys", "newurl", "create function newurl(protocol string,
hostname string, \"port\" int, file string) returns url external name
url.\"new\";", "url", "MAL", "Scalar function", false, false, false,
"result", "url", 0, 0, "out", "protocol", "clob", 0,
0, "in", "hostname", "clob", 0, 0, "in", "port", "int",
32, 0, "in", "file", "clob", 0, 0, "in", 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", "newurl", "create function newurl(protocol string,
hostname string, file string) returns url external name url.\"new\";", "url",
"MAL", "Scalar function", false, false, false, "result", "url",
0, 0, "out", "protocol", "clob", 0, 0, "in",
"hostname", "clob", 0, 0, "in", "file", "clob", 0, 0,
"in", 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", "next_value_for", "next_value", "sql", "Internal C",
"Scalar function", true, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "varchar", 0, 0, "in",
"arg_2", "varchar", 0, 0, "in", 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", "no_op", "create procedure sys.no_op() begin declare
dummy integer; end;", "user", "SQL", "Procedure", true, false,
false, 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, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "not", "not", "calc", "Internal C", "Scalar function",
false, false, false, "res_0", "boolean", 1, 0, "out",
"arg_1", "boolean", 1, 0, "in", 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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "not_exist", "not_exist", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "boolean", 1,
0, "out", "arg", "any", 0, 0, "in", 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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "not_ilike", "not_ilike", "algebra", "Internal C",
"Scalar function", false, false, false, "res_0", "boolean",
1, 0, "out", "arg_1", "char", 0, 0, "in",
"arg_2", "char", 0, 0, "in", 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 ]
@@ -3734,7 +3738,6 @@ drop function pcre_replace(string, strin
% name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar # type
% 3, 17, 3, 35, 9 # length
-[ "sys", "comments", "sys", "comment_on", "PROCEDURE" ]
[ "sys", "columns", "sys", "dependencies_columns_on_functions",
"FUNCTION" ]
[ "sys", "dependencies", "sys", "dependencies_columns_on_functions",
"FUNCTION" ]
[ "sys", "functions", "sys", "dependencies_columns_on_functions",
"FUNCTION" ]
@@ -3792,8 +3795,6 @@ drop function pcre_replace(string, strin
% name, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
% 3, 17, 13, 3, 35, 9 # length
-[ "sys", "comments", "id", "sys", "comment_on", "PROCEDURE"
]
-[ "sys", "comments", "remark", "sys", "comment_on",
"PROCEDURE" ]
[ "sys", "dependencies", "depend_id", "sys",
"dependencies_columns_on_functions", "FUNCTION" ]
[ "sys", "dependencies", "depend_type", "sys",
"dependencies_columns_on_functions", "FUNCTION" ]
[ "sys", "dependencies", "id", "sys",
"dependencies_columns_on_functions", "FUNCTION" ]
@@ -5088,7 +5089,6 @@ drop function pcre_replace(string, strin
[ "code" ]
[ "code" ]
[ "columnsize" ]
-[ "comment_on" ]
[ "concat" ]
[ "concat" ]
[ "concat" ]
@@ -5392,6 +5392,7 @@ drop function pcre_replace(string, strin
[ "newurl" ]
[ "newurl" ]
[ "next_value_for" ]
+[ "no_op" ]
[ "not" ]
[ "not_exist" ]
[ "not_ilike" ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -143,7 +143,6 @@ Ready.
\dSf sys."broadcast"
\dSf sys."clearrejects"
\dSf sys."columnsize"
-\dSf sys."comment_on"
\dSf sys."contains"
\dSf sys."corr"
\dSf sys."createorderindex"
@@ -231,6 +230,7 @@ Ready.
\dSf sys."netmask"
\dSf sys."network"
\dSf sys."newurl"
+\dSf sys."no_op"
\dSf sys."optimizer_stats"
\dSf sys."optimizers"
\dSf sys."password_hash"
@@ -376,7 +376,11 @@ Ready.
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
+SYSTEM SCHEMA bam
+SYSTEM SCHEMA json
+SYSTEM SCHEMA profiler
SYSTEM SCHEMA sys
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
