Changeset: 1387645d1633 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1387645d1633
Modified Files:
sql/test/emptydb/Tests/check.SQL.py
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/mergetables/Tests/part-elim.stable.out
Branch: sq2default
Log Message:
approved output
diffs (truncated from 391 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.SQL.py
b/sql/test/emptydb/Tests/check.SQL.py
--- a/sql/test/emptydb/Tests/check.SQL.py
+++ b/sql/test/emptydb/Tests/check.SQL.py
@@ -151,7 +151,7 @@ select count(*) from sys.storagemodelinp
-- triggers
select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
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
@@ -719,12 +719,14 @@ SYSTEM FUNCTION sys.soundex
SYSTEM FUNCTION sys.space
SYSTEM FUNCTION sys.splitpart
SYSTEM FUNCTION sys.sql_add
+SYSTEM FUNCTION sys.sql_anyequal
SYSTEM FUNCTION sys.sql_div
SYSTEM FUNCTION sys.sql_exists
SYSTEM FUNCTION sys.sql_max
SYSTEM FUNCTION sys.sql_min
SYSTEM FUNCTION sys.sql_mul
SYSTEM FUNCTION sys.sql_neg
+SYSTEM FUNCTION sys.sql_not_anyequal
SYSTEM FUNCTION sys.sql_not_exists
SYSTEM FUNCTION sys.sql_sub
SYSTEM FUNCTION sys.sqrt
@@ -1403,7 +1405,7 @@ select count(*) from sys.storagemodelinp
-- triggers
select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
@@ -1428,7 +1430,7 @@ drop function pcre_replace(string, strin
[ "wlc", 3, 3, true ]
[ "wlr", 3, 3, true ]
#select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t 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 left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-% .s, .t, .L15, .L16, .t, .L17, .L20 # table_name
+% .s, .t, ., .tt, .t, .ca, .at # table_name
% name, name, query, type, system, commit_action, access # name
% varchar, varchar, varchar, varchar, boolean,
char, char # type
% 3, 34, 2809, 5, 5, 8, 10 # length
@@ -2166,7 +2168,7 @@ drop function pcre_replace(string, strin
% varchar, varchar, varchar # type
% 0, 0, 0 # length
#select s.name, f.name, case f.system when true then 'SYSTEM' else '' end as
system, replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
'--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name, f.side_effect, f.varres, f.vararg, a0.name as name0,
a0.type as type0, a0.type_digits as type_digits0, a0.type_scale as type_scale0,
case a0.inout when 0 then 'out' when 1 then 'in' end as inout0, a1.name as
name1, a1.type as type1, a1.type_digits as type_digits1, a1.type_scale as
type_scale1, case a1.inout when 0 then 'out' when 1 then 'in' end as inout1,
a2.name as name2, a2.type as type2, a2.type_digits as type_digits2,
a2.type_scale as type_scale2, case a2.inout when 0 then 'out' when 1 then 'in'
end as inout2, a3.name as name3, a3.type as type3, a3.type_digits as
type_digits3, a3.type_scale as type_scale3, case a3.inout when 0 then 'out'
when 1 then 'in' end a
s inout3, a4.name as name4, a4.type as type4, a4.type_digits as type_digits4,
a4.type_scale as type_scale4, case a4.inout when 0 then 'out' when 1 then 'in'
end as inout4, a5.name as name5, a5.type as type5, a5.type_digits as
type_digits5, a5.type_scale as type_scale5, case a5.inout when 0 then 'out'
when 1 then 'in' end as inout5, a6.name as name6, a6.type as type6,
a6.type_digits as type_digits6, a6.type_scale as type_scale6, case a6.inout
when 0 then 'out' when 1 then 'in' end as inout6, a7.name as name7, a7.type as
type7, a7.type_digits as type_digits7, a7.type_scale as type_scale7, case
a7.inout when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8,
a8.type as type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8,
case a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as
name9, a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as
type_scale9, case a9.inout when 0 then 'out' when 1 then 'in' end as inout9,
a10.name as nam
e10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.inout when 0 then 'out' when 1 then 'in' end as inout10,
a11.name as name11, a11.type as type11, a11.type_digits as type_digits11,
a11.type_scale as type_scale11, case a11.inout when 0 then 'out' when 1 then
'in' end as inout11, a12.name as name12, a12.type as type12, a12.type_digits as
type_digits12, a12.type_scale as type_scale12, case a12.inout when 0 then 'out'
when 1 then 'in' end as inout12, a13.name as name13, a13.type as type13,
a13.type_digits as type_digits13, a13.type_scale as type_scale13, case
a13.inout when 0 then 'out' when 1 then 'in' end as inout13, a14.name as
name14, a14.type as type14, a14.type_digits as type_digits14, a14.type_scale as
type_scale14, case a14.inout when 0 then 'out' when 1 then 'in' end as inout14,
a15.name as name15, a15.type as type15, a15.type_digits as type_digits15,
a15.type_scale as type_scale15, case a15.inout when 0 then 'out' when 1 then '
in' end as inout15 from sys.functions f left outer join sys.schemas s on
f.schema_id = s.id left outer join sys.function_types as ft on f.type =
ft.function_type_id left outer join sys.function_languages fl on f.language =
fl.language_id left outer join sys.args a0 on a0.func_id = f.id and a0.number =
0 left outer join sys.args a1 on a1.func_id = f.id and a1.number = 1 left outer
join sys.args a2 on a2.func_id = f.id and a2.number = 2 left outer join
sys.args a3 on a3.func_id = f.id and a3.number = 3 left outer join sys.args a4
on a4.func_id = f.id and a4.number = 4 left outer join sys.args a5 on
a5.func_id = f.id and a5.number = 5 left outer join sys.args a6 on a6.func_id =
f.id and a6.number = 6 left outer join sys.args a7 on a7.func_id = f.id and
a7.number = 7 left outer join sys.args a8 on a8.func_id = f.id and a8.number =
8 left outer join sys.args a9 on a9.func_id = f.id and a9.number = 9 left outer
join sys.args a10 on a10.func_id = f.id and a10.number = 10 left outer join sy
s.args a11 on a11.func_id = f.id and a11.number = 11 left outer join sys.args
a12 on a12.func_id = f.id and a12.number = 12 left outer join sys.args a13 on
a13.func_id = f.id and a13.number = 13 left outer join sys.args a14 on
a14.func_id = f.id and a14.number = 14 left outer join sys.args a15 on
a15.func_id = f.id and a15.number = 15 order by s.name, f.name, query, name0,
type0, type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2, name3,
type3, type_digits3, type_scale3, inout3, name4, type4, type_digits4,
type_scale4, inout4, name5, type5, type_digits5, type_scale5, inout5, name6,
type6, type_digits6, type_scale6, inout6, name7, type7, type_digits7,
type_scale7, inout7, name8, type8, type_digits8, type_scale8, inout8, name9,
type9, type_digits9, type_scale9, inout9, name10, type10, type_digits10,
type_scale10, inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12,
type_scale12, inout12, name13, type13, type_digits13, type_scale13, inout13,
name14, type14, type_digits14, type_scale14, inout14, name15, type15,
type_digits15, type_scale15, inout15;
-% .s, .f, .L47, .L50, .f, .fl, .ft, .f, .f, .f,
.L51, .L52, .L53, .L54, .L55, .L56, .L57, .L60, .L61, .L62,
.L63, .L64, .L65, .L66, .L67, .L70, .L71, .L72, .L73, .L74,
.L75, .L76, .L77, .L100, .L101, .L102, .L103, .L104, .L105, .L106,
.L107, .L110, .L111, .L112, .L113, .L114, .L115, .L116, .L117, .L120,
.L121, .L122, .L123, .L124, .L125, .L126, .L127, .L130, .L131, .L132,
.L133, .L134, .L135, .L136, .L137, .L140, .L141, .L142, .L143, .L144,
.L145, .L146, .L147, .L150, .L151, .L152, .L153, .L154, .L155, .L156,
.L157, .L160, .L161, .L162, .L163, .L164, .L165, .L166, .L167, .L170 #
table_name
+% .s, .f, ., ., .f, .fl, .ft, .f, .f, .f,
.a0, .a0, .a0, .a0, ., .a1, .a1, .a1, .a1, .,
.a2, .a2, .a2, .a2, ., .a3, .a3, .a3, .a3, .,
.a4, .a4, .a4, .a4, ., .a5, .a5, .a5, .a5, .,
.a6, .a6, .a6, .a6, ., .a7, .a7, .a7, .a7, .,
.a8, .a8, .a8, .a8, ., .a9, .a9, .a9, .a9, .,
.a10, .a10, .a10, .a10, ., .a11, .a11, .a11, .a11, .,
.a12, .a12, .a12, .a12, ., .a13, .a13, .a13, .a13, .,
.a14, .a14, .a14, .a14, ., .a15, .a15, .a15, .a15, . #
table_name
% name, name, system, query, mod, language_name,
function_type_name, side_effect, varres, vararg, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, char, varchar, varchar,
varchar, varchar, boolean, boolean, boolean,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char # type
% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
9, 7, 2, 1, 3, 14, 14, 4, 1, 3,
12, 14, 2, 1, 3, 11, 7, 2, 1, 3,
11, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 1, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
@@ -3404,6 +3406,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_add", "SYSTEM", "timestamp_add_month_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "month_interval",
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 ]
[ "sys", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamp", 7, 0, "out", "arg_1",
"timestamp", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_anyequal", "SYSTEM", "anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "smallint", 16, 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 ]
@@ -3538,6 +3541,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "sec_interval",
13, 0, "out", "arg_1", "sec_interval", 13, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "smallint",
16, 0, "out", "arg_1", "smallint", 16, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "tinyint",
8, 0, "out", "arg_1", "tinyint", 8, 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", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_not_exists", "SYSTEM", "not_exist", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "decimal",
2, 0, "out", "arg_1", "decimal", 2, 0, "in",
"arg_2", "decimal", 2, 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 ]
@@ -5178,26 +5182,26 @@ drop function pcre_replace(string, strin
% varchar, varchar, bigint, bigint, bigint, bigint, bigint, boolean
# type
% 0, 0, 1, 1, 1, 1, 1, 5 # length
#select count(*) from sys.statistics;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select count(*) from sys.storagemodelinput;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-% .t, .g, .L3, .L4, .L5, .g, .g, .g, .g # table_name
+% .t, .g, ., ., ., .g, .g, .g, .g # table_name
% name, name, time, orientation, event, old_name,
new_name, condition, statement # name
% varchar, varchar, char, char, char, varchar,
varchar, varchar, varchar # type
% 7, 21, 10, 9, 6, 0, 0, 0, 110 # length
[ "_tables", "system_update_tables", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_tables
after update on sys._tables for each statement call sys_update_tables();" ]
[ "schemas", "system_update_schemas", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas
after update on sys.schemas for each statement call sys_update_schemas();"
]
-#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
-% .s, .t, .t, .t, .t, .t, .L7 # table_name
+#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
+% .s, .t, .t, .t, .t, .t, .et # table_name
% name, systemname, sqlname, digits, scale, radix, eclass
# name
% varchar, varchar, varchar, int, int, int, char #
type
% 3, 9, 14, 2, 1, 2, 9 # length
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
@@ -723,12 +723,14 @@ SYSTEM FUNCTION sys.soundex
SYSTEM FUNCTION sys.space
SYSTEM FUNCTION sys.splitpart
SYSTEM FUNCTION sys.sql_add
+SYSTEM FUNCTION sys.sql_anyequal
SYSTEM FUNCTION sys.sql_div
SYSTEM FUNCTION sys.sql_exists
SYSTEM FUNCTION sys.sql_max
SYSTEM FUNCTION sys.sql_min
SYSTEM FUNCTION sys.sql_mul
SYSTEM FUNCTION sys.sql_neg
+SYSTEM FUNCTION sys.sql_not_anyequal
SYSTEM FUNCTION sys.sql_not_exists
SYSTEM FUNCTION sys.sql_sub
SYSTEM FUNCTION sys.sqrt
@@ -1397,7 +1399,7 @@ select count(*) from sys.storagemodelinp
-- triggers
select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
@@ -1422,7 +1424,7 @@ drop function pcre_replace(string, strin
[ "wlc", 3, 3, true ]
[ "wlr", 3, 3, true ]
#select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t 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 left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-% .s, .t, .L15, .L16, .t, .L17, .L20 # table_name
+% .s, .t, ., .tt, .t, .ca, .at # table_name
% name, name, query, type, system, commit_action, access # name
% varchar, varchar, varchar, varchar, boolean,
char, char # type
% 3, 34, 2809, 5, 5, 8, 10 # length
@@ -2158,7 +2160,7 @@ drop function pcre_replace(string, strin
% varchar, varchar, varchar # type
% 0, 0, 0 # length
#select s.name, f.name, case f.system when true then 'SYSTEM' else '' end as
system, replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
'--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name, f.side_effect, f.varres, f.vararg, a0.name as name0,
a0.type as type0, a0.type_digits as type_digits0, a0.type_scale as type_scale0,
case a0.inout when 0 then 'out' when 1 then 'in' end as inout0, a1.name as
name1, a1.type as type1, a1.type_digits as type_digits1, a1.type_scale as
type_scale1, case a1.inout when 0 then 'out' when 1 then 'in' end as inout1,
a2.name as name2, a2.type as type2, a2.type_digits as type_digits2,
a2.type_scale as type_scale2, case a2.inout when 0 then 'out' when 1 then 'in'
end as inout2, a3.name as name3, a3.type as type3, a3.type_digits as
type_digits3, a3.type_scale as type_scale3, case a3.inout when 0 then 'out'
when 1 then 'in' end a
s inout3, a4.name as name4, a4.type as type4, a4.type_digits as type_digits4,
a4.type_scale as type_scale4, case a4.inout when 0 then 'out' when 1 then 'in'
end as inout4, a5.name as name5, a5.type as type5, a5.type_digits as
type_digits5, a5.type_scale as type_scale5, case a5.inout when 0 then 'out'
when 1 then 'in' end as inout5, a6.name as name6, a6.type as type6,
a6.type_digits as type_digits6, a6.type_scale as type_scale6, case a6.inout
when 0 then 'out' when 1 then 'in' end as inout6, a7.name as name7, a7.type as
type7, a7.type_digits as type_digits7, a7.type_scale as type_scale7, case
a7.inout when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8,
a8.type as type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8,
case a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as
name9, a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as
type_scale9, case a9.inout when 0 then 'out' when 1 then 'in' end as inout9,
a10.name as nam
e10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.inout when 0 then 'out' when 1 then 'in' end as inout10,
a11.name as name11, a11.type as type11, a11.type_digits as type_digits11,
a11.type_scale as type_scale11, case a11.inout when 0 then 'out' when 1 then
'in' end as inout11, a12.name as name12, a12.type as type12, a12.type_digits as
type_digits12, a12.type_scale as type_scale12, case a12.inout when 0 then 'out'
when 1 then 'in' end as inout12, a13.name as name13, a13.type as type13,
a13.type_digits as type_digits13, a13.type_scale as type_scale13, case
a13.inout when 0 then 'out' when 1 then 'in' end as inout13, a14.name as
name14, a14.type as type14, a14.type_digits as type_digits14, a14.type_scale as
type_scale14, case a14.inout when 0 then 'out' when 1 then 'in' end as inout14,
a15.name as name15, a15.type as type15, a15.type_digits as type_digits15,
a15.type_scale as type_scale15, case a15.inout when 0 then 'out' when 1 then '
in' end as inout15 from sys.functions f left outer join sys.schemas s on
f.schema_id = s.id left outer join sys.function_types as ft on f.type =
ft.function_type_id left outer join sys.function_languages fl on f.language =
fl.language_id left outer join sys.args a0 on a0.func_id = f.id and a0.number =
0 left outer join sys.args a1 on a1.func_id = f.id and a1.number = 1 left outer
join sys.args a2 on a2.func_id = f.id and a2.number = 2 left outer join
sys.args a3 on a3.func_id = f.id and a3.number = 3 left outer join sys.args a4
on a4.func_id = f.id and a4.number = 4 left outer join sys.args a5 on
a5.func_id = f.id and a5.number = 5 left outer join sys.args a6 on a6.func_id =
f.id and a6.number = 6 left outer join sys.args a7 on a7.func_id = f.id and
a7.number = 7 left outer join sys.args a8 on a8.func_id = f.id and a8.number =
8 left outer join sys.args a9 on a9.func_id = f.id and a9.number = 9 left outer
join sys.args a10 on a10.func_id = f.id and a10.number = 10 left outer join sy
s.args a11 on a11.func_id = f.id and a11.number = 11 left outer join sys.args
a12 on a12.func_id = f.id and a12.number = 12 left outer join sys.args a13 on
a13.func_id = f.id and a13.number = 13 left outer join sys.args a14 on
a14.func_id = f.id and a14.number = 14 left outer join sys.args a15 on
a15.func_id = f.id and a15.number = 15 order by s.name, f.name, query, name0,
type0, type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2, name3,
type3, type_digits3, type_scale3, inout3, name4, type4, type_digits4,
type_scale4, inout4, name5, type5, type_digits5, type_scale5, inout5, name6,
type6, type_digits6, type_scale6, inout6, name7, type7, type_digits7,
type_scale7, inout7, name8, type8, type_digits8, type_scale8, inout8, name9,
type9, type_digits9, type_scale9, inout9, name10, type10, type_digits10,
type_scale10, inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12,
type_scale12, inout12, name13, type13, type_digits13, type_scale13, inout13,
name14, type14, type_digits14, type_scale14, inout14, name15, type15,
type_digits15, type_scale15, inout15;
-% .s, .f, .L47, .L50, .f, .fl, .ft, .f, .f, .f,
.L51, .L52, .L53, .L54, .L55, .L56, .L57, .L60, .L61, .L62,
.L63, .L64, .L65, .L66, .L67, .L70, .L71, .L72, .L73, .L74,
.L75, .L76, .L77, .L100, .L101, .L102, .L103, .L104, .L105, .L106,
.L107, .L110, .L111, .L112, .L113, .L114, .L115, .L116, .L117, .L120,
.L121, .L122, .L123, .L124, .L125, .L126, .L127, .L130, .L131, .L132,
.L133, .L134, .L135, .L136, .L137, .L140, .L141, .L142, .L143, .L144,
.L145, .L146, .L147, .L150, .L151, .L152, .L153, .L154, .L155, .L156,
.L157, .L160, .L161, .L162, .L163, .L164, .L165, .L166, .L167, .L170 #
table_name
+% .s, .f, ., ., .f, .fl, .ft, .f, .f, .f,
.a0, .a0, .a0, .a0, ., .a1, .a1, .a1, .a1, .,
.a2, .a2, .a2, .a2, ., .a3, .a3, .a3, .a3, .,
.a4, .a4, .a4, .a4, ., .a5, .a5, .a5, .a5, .,
.a6, .a6, .a6, .a6, ., .a7, .a7, .a7, .a7, .,
.a8, .a8, .a8, .a8, ., .a9, .a9, .a9, .a9, .,
.a10, .a10, .a10, .a10, ., .a11, .a11, .a11, .a11, .,
.a12, .a12, .a12, .a12, ., .a13, .a13, .a13, .a13, .,
.a14, .a14, .a14, .a14, ., .a15, .a15, .a15, .a15, . #
table_name
% name, name, system, query, mod, language_name,
function_type_name, side_effect, varres, vararg, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, char, varchar, varchar,
varchar, varchar, boolean, boolean, boolean,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char # type
% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
11, 9, 2, 1, 3, 12, 14, 4, 1, 3,
8, 14, 2, 1, 3, 9, 7, 2, 1, 3,
10, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 1, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
@@ -3387,6 +3389,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_add", "SYSTEM", "timestamp_add_month_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "month_interval",
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 ]
[ "sys", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamp", 7, 0, "out", "arg_1",
"timestamp", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_anyequal", "SYSTEM", "anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "smallint", 16, 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 ]
@@ -3521,6 +3524,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "sec_interval",
13, 0, "out", "arg_1", "sec_interval", 13, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "smallint",
16, 0, "out", "arg_1", "smallint", 16, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "tinyint",
8, 0, "out", "arg_1", "tinyint", 8, 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", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_not_exists", "SYSTEM", "not_exist", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "decimal",
2, 0, "out", "arg_1", "decimal", 2, 0, "in",
"arg_2", "decimal", 2, 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 ]
@@ -5161,26 +5165,26 @@ drop function pcre_replace(string, strin
% varchar, varchar, bigint, bigint, bigint, bigint, bigint, boolean
# type
% 0, 0, 1, 1, 1, 1, 1, 5 # length
#select count(*) from sys.statistics;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select count(*) from sys.storagemodelinput;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-% .t, .g, .L3, .L4, .L5, .g, .g, .g, .g # table_name
+% .t, .g, ., ., ., .g, .g, .g, .g # table_name
% name, name, time, orientation, event, old_name,
new_name, condition, statement # name
% varchar, varchar, char, char, char, varchar,
varchar, varchar, varchar # type
% 7, 21, 10, 9, 6, 0, 0, 0, 110 # length
[ "_tables", "system_update_tables", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_tables
after update on sys._tables for each statement call sys_update_tables();" ]
[ "schemas", "system_update_schemas", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas
after update on sys.schemas for each statement call sys_update_schemas();"
]
-#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
-% .s, .t, .t, .t, .t, .t, .L7 # table_name
+#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
+% .s, .t, .t, .t, .t, .t, .et # table_name
% name, systemname, sqlname, digits, scale, radix, eclass
# name
% varchar, varchar, varchar, int, int, int, char #
type
% 3, 9, 14, 2, 1, 2, 9 # length
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -719,12 +719,14 @@ SYSTEM FUNCTION sys.soundex
SYSTEM FUNCTION sys.space
SYSTEM FUNCTION sys.splitpart
SYSTEM FUNCTION sys.sql_add
+SYSTEM FUNCTION sys.sql_anyequal
SYSTEM FUNCTION sys.sql_div
SYSTEM FUNCTION sys.sql_exists
SYSTEM FUNCTION sys.sql_max
SYSTEM FUNCTION sys.sql_min
SYSTEM FUNCTION sys.sql_mul
SYSTEM FUNCTION sys.sql_neg
+SYSTEM FUNCTION sys.sql_not_anyequal
SYSTEM FUNCTION sys.sql_not_exists
SYSTEM FUNCTION sys.sql_sub
SYSTEM FUNCTION sys.sqrt
@@ -1415,7 +1417,7 @@ select count(*) from sys.storagemodelinp
-- triggers
select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
@@ -1440,7 +1442,7 @@ drop function pcre_replace(string, strin
[ "wlc", 3, 3, true ]
[ "wlr", 3, 3, true ]
#select s.name, t.name, replace(replace(pcre_replace(pcre_replace(t.query,
'--.*\n*', '', ''), '[ \t\n]+', ' ', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t 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 left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-% .s, .t, .L15, .L16, .t, .L17, .L20 # table_name
+% .s, .t, ., .tt, .t, .ca, .at # table_name
% name, name, query, type, system, commit_action, access # name
% varchar, varchar, varchar, varchar, boolean,
char, char # type
% 3, 34, 2809, 5, 5, 8, 10 # length
@@ -2178,7 +2180,7 @@ drop function pcre_replace(string, strin
% varchar, varchar, varchar # type
% 0, 0, 0 # length
#select s.name, f.name, case f.system when true then 'SYSTEM' else '' end as
system, replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
'--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name, f.side_effect, f.varres, f.vararg, a0.name as name0,
a0.type as type0, a0.type_digits as type_digits0, a0.type_scale as type_scale0,
case a0.inout when 0 then 'out' when 1 then 'in' end as inout0, a1.name as
name1, a1.type as type1, a1.type_digits as type_digits1, a1.type_scale as
type_scale1, case a1.inout when 0 then 'out' when 1 then 'in' end as inout1,
a2.name as name2, a2.type as type2, a2.type_digits as type_digits2,
a2.type_scale as type_scale2, case a2.inout when 0 then 'out' when 1 then 'in'
end as inout2, a3.name as name3, a3.type as type3, a3.type_digits as
type_digits3, a3.type_scale as type_scale3, case a3.inout when 0 then 'out'
when 1 then 'in' end a
s inout3, a4.name as name4, a4.type as type4, a4.type_digits as type_digits4,
a4.type_scale as type_scale4, case a4.inout when 0 then 'out' when 1 then 'in'
end as inout4, a5.name as name5, a5.type as type5, a5.type_digits as
type_digits5, a5.type_scale as type_scale5, case a5.inout when 0 then 'out'
when 1 then 'in' end as inout5, a6.name as name6, a6.type as type6,
a6.type_digits as type_digits6, a6.type_scale as type_scale6, case a6.inout
when 0 then 'out' when 1 then 'in' end as inout6, a7.name as name7, a7.type as
type7, a7.type_digits as type_digits7, a7.type_scale as type_scale7, case
a7.inout when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8,
a8.type as type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8,
case a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as
name9, a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as
type_scale9, case a9.inout when 0 then 'out' when 1 then 'in' end as inout9,
a10.name as nam
e10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.inout when 0 then 'out' when 1 then 'in' end as inout10,
a11.name as name11, a11.type as type11, a11.type_digits as type_digits11,
a11.type_scale as type_scale11, case a11.inout when 0 then 'out' when 1 then
'in' end as inout11, a12.name as name12, a12.type as type12, a12.type_digits as
type_digits12, a12.type_scale as type_scale12, case a12.inout when 0 then 'out'
when 1 then 'in' end as inout12, a13.name as name13, a13.type as type13,
a13.type_digits as type_digits13, a13.type_scale as type_scale13, case
a13.inout when 0 then 'out' when 1 then 'in' end as inout13, a14.name as
name14, a14.type as type14, a14.type_digits as type_digits14, a14.type_scale as
type_scale14, case a14.inout when 0 then 'out' when 1 then 'in' end as inout14,
a15.name as name15, a15.type as type15, a15.type_digits as type_digits15,
a15.type_scale as type_scale15, case a15.inout when 0 then 'out' when 1 then '
in' end as inout15 from sys.functions f left outer join sys.schemas s on
f.schema_id = s.id left outer join sys.function_types as ft on f.type =
ft.function_type_id left outer join sys.function_languages fl on f.language =
fl.language_id left outer join sys.args a0 on a0.func_id = f.id and a0.number =
0 left outer join sys.args a1 on a1.func_id = f.id and a1.number = 1 left outer
join sys.args a2 on a2.func_id = f.id and a2.number = 2 left outer join
sys.args a3 on a3.func_id = f.id and a3.number = 3 left outer join sys.args a4
on a4.func_id = f.id and a4.number = 4 left outer join sys.args a5 on
a5.func_id = f.id and a5.number = 5 left outer join sys.args a6 on a6.func_id =
f.id and a6.number = 6 left outer join sys.args a7 on a7.func_id = f.id and
a7.number = 7 left outer join sys.args a8 on a8.func_id = f.id and a8.number =
8 left outer join sys.args a9 on a9.func_id = f.id and a9.number = 9 left outer
join sys.args a10 on a10.func_id = f.id and a10.number = 10 left outer join sy
s.args a11 on a11.func_id = f.id and a11.number = 11 left outer join sys.args
a12 on a12.func_id = f.id and a12.number = 12 left outer join sys.args a13 on
a13.func_id = f.id and a13.number = 13 left outer join sys.args a14 on
a14.func_id = f.id and a14.number = 14 left outer join sys.args a15 on
a15.func_id = f.id and a15.number = 15 order by s.name, f.name, query, name0,
type0, type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2, name3,
type3, type_digits3, type_scale3, inout3, name4, type4, type_digits4,
type_scale4, inout4, name5, type5, type_digits5, type_scale5, inout5, name6,
type6, type_digits6, type_scale6, inout6, name7, type7, type_digits7,
type_scale7, inout7, name8, type8, type_digits8, type_scale8, inout8, name9,
type9, type_digits9, type_scale9, inout9, name10, type10, type_digits10,
type_scale10, inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12,
type_scale12, inout12, name13, type13, type_digits13, type_scale13, inout13,
name14, type14, type_digits14, type_scale14, inout14, name15, type15,
type_digits15, type_scale15, inout15;
-% .s, .f, .L47, .L50, .f, .fl, .ft, .f, .f, .f,
.L51, .L52, .L53, .L54, .L55, .L56, .L57, .L60, .L61, .L62,
.L63, .L64, .L65, .L66, .L67, .L70, .L71, .L72, .L73, .L74,
.L75, .L76, .L77, .L100, .L101, .L102, .L103, .L104, .L105, .L106,
.L107, .L110, .L111, .L112, .L113, .L114, .L115, .L116, .L117, .L120,
.L121, .L122, .L123, .L124, .L125, .L126, .L127, .L130, .L131, .L132,
.L133, .L134, .L135, .L136, .L137, .L140, .L141, .L142, .L143, .L144,
.L145, .L146, .L147, .L150, .L151, .L152, .L153, .L154, .L155, .L156,
.L157, .L160, .L161, .L162, .L163, .L164, .L165, .L166, .L167, .L170 #
table_name
+% .s, .f, ., ., .f, .fl, .ft, .f, .f, .f,
.a0, .a0, .a0, .a0, ., .a1, .a1, .a1, .a1, .,
.a2, .a2, .a2, .a2, ., .a3, .a3, .a3, .a3, .,
.a4, .a4, .a4, .a4, ., .a5, .a5, .a5, .a5, .,
.a6, .a6, .a6, .a6, ., .a7, .a7, .a7, .a7, .,
.a8, .a8, .a8, .a8, ., .a9, .a9, .a9, .a9, .,
.a10, .a10, .a10, .a10, ., .a11, .a11, .a11, .a11, .,
.a12, .a12, .a12, .a12, ., .a13, .a13, .a13, .a13, .,
.a14, .a14, .a14, .a14, ., .a15, .a15, .a15, .a15, . #
table_name
% name, name, system, query, mod, language_name,
function_type_name, side_effect, varres, vararg, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, char, varchar, varchar,
varchar, varchar, boolean, boolean, boolean,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char # type
% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
9, 7, 2, 1, 3, 14, 14, 4, 1, 3,
12, 14, 3, 1, 3, 11, 7, 2, 1, 3,
11, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 1, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
@@ -3556,6 +3558,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_add", "SYSTEM", "timestamp_add_month_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "month_interval",
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 ]
[ "sys", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamp", 7, 0, "out", "arg_1",
"timestamp", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_add", "SYSTEM", "timestamp_add_msec_interval",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "timestamptz", 7, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", "arg_2", "sec_interval", 13,
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", "sql_anyequal", "SYSTEM", "anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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 ]
[ "sys", "sql_div", "SYSTEM", "/", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "smallint", 16, 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 ]
@@ -3738,6 +3741,7 @@ drop function pcre_replace(string, strin
[ "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "sec_interval",
13, 0, "out", "arg_1", "sec_interval", 13, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "smallint",
16, 0, "out", "arg_1", "smallint", 16, 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", "sql_neg", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "tinyint",
8, 0, "out", "arg_1", "tinyint", 8, 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", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "any", 0, 0,
"in", "arg_2", "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 ]
[ "sys", "sql_not_exists", "SYSTEM", "not_exist", "aggr",
"Internal C", "Scalar function", false, false, false, "res_0",
"boolean", 1, 0, "out", "arg_1", "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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "sql_sub", "SYSTEM", "-", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "decimal",
2, 0, "out", "arg_1", "decimal", 2, 0, "in",
"arg_2", "decimal", 2, 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 ]
@@ -5407,26 +5411,26 @@ drop function pcre_replace(string, strin
% varchar, varchar, bigint, bigint, bigint, bigint, bigint, boolean
# type
% 0, 0, 1, 1, 1, 1, 1, 5 # length
#select count(*) from sys.statistics;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select count(*) from sys.storagemodelinput;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 1 # length
[ 0 ]
#select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-% .t, .g, .L3, .L4, .L5, .g, .g, .g, .g # table_name
+% .t, .g, ., ., ., .g, .g, .g, .g # table_name
% name, name, time, orientation, event, old_name,
new_name, condition, statement # name
% varchar, varchar, char, char, char, varchar,
varchar, varchar, varchar # type
% 7, 21, 10, 9, 6, 0, 0, 0, 110 # length
[ "_tables", "system_update_tables", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_tables
after update on sys._tables for each statement call sys_update_tables();" ]
[ "schemas", "system_update_schemas", "AFTER", "STATEMENT",
"UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas
after update on sys.schemas for each statement call sys_update_schemas();"
]
-#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
-% .s, .t, .t, .t, .t, .t, .L7 # table_name
+#select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, eclass;
+% .s, .t, .t, .t, .t, .t, .et # table_name
% name, systemname, sqlname, digits, scale, radix, eclass
# name
% varchar, varchar, varchar, int, int, int, char #
type
% 3, 9, 14, 3, 1, 2, 9 # length
diff --git a/sql/test/mergetables/Tests/part-elim.stable.out
b/sql/test/mergetables/Tests/part-elim.stable.out
--- a/sql/test/mergetables/Tests/part-elim.stable.out
+++ b/sql/test/mergetables/Tests/part-elim.stable.out
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
