Changeset: 4ad212341d73 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4ad212341d73
Modified Files:
clients/Tests/MAL-signatures-hge.test
sql/test/Dependencies/Tests/dependency_owner_schema_3.test
sql/test/Dump/Tests/dump-again.stable.out
sql/test/Dump/Tests/dump.stable.out
sql/test/Tests/comment-dump.test
sql/test/UserDump/Tests/dump.stable.out
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.py
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.py
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.py
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.py
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.py
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.py
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.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.py
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.py
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.int128
sql/test/emptydb/Tests/dump.SQL.py
sql/test/sql_dump/Tests/dump.test
sql/test/testdb-previous-upgrade-chain-hge/Tests/dump.stable.out
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/dump.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/dump.stable.out
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/dump.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/dump.stable.out
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/dump.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/dump.stable.out
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/dump.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
testing/sqllogictest.py
Branch: default
Log Message:
Approve tests.
diffs (truncated from 204896 to 300 lines):
diff --git a/clients/Tests/MAL-signatures-hge.test
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -1,4 +1,5 @@
hash-threshold 100000
+
query TTTTT nosort
select * from sys.malfunctions() order by module, "function", address,
signature, comment
----
diff --git a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
--- a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
+++ b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
@@ -126,7 +126,7 @@ DEP_FUNC
query TTT rowsort
SELECT c.name, v.name, 'DEP_VIEW' from sys.columns as c, sys.tables as v,
sys.dependencies as dep where c.id = dep.id AND v.id = dep.depend_id AND
dep.depend_type = 5 AND v.type in (1, 11, 21, 31) order by c.name, v.name
----
-2277 values hashing to be0394cfd4bbe2f3fb9af9fb43087e76
+2274 values hashing to f4b96600fba0faf630ad83449eaa46b0
query TTT rowsort
SELECT c.name, k.name, 'DEP_KEY' from sys.columns as c, sys.objects as kc,
sys.keys as k where kc."name" = c.name AND kc.id = k.id AND k.table_id =
c.table_id AND k.rkey = -1 order by c.name, k.name
diff --git a/sql/test/Dump/Tests/dump-again.stable.out
b/sql/test/Dump/Tests/dump-again.stable.out
--- a/sql/test/Dump/Tests/dump-again.stable.out
+++ b/sql/test/Dump/Tests/dump-again.stable.out
@@ -1,6 +1,6 @@
START TRANSACTION;
+SET SCHEMA "sys";
CREATE SEQUENCE "sys"."test_seq" AS INTEGER;
-SET SCHEMA "sys";
CREATE TABLE "sys"."test" (
"id" INTEGER,
"i" SMALLINT
diff --git a/sql/test/Dump/Tests/dump.stable.out
b/sql/test/Dump/Tests/dump.stable.out
--- a/sql/test/Dump/Tests/dump.stable.out
+++ b/sql/test/Dump/Tests/dump.stable.out
@@ -1,6 +1,6 @@
START TRANSACTION;
+SET SCHEMA "sys";
CREATE SEQUENCE "sys"."test_seq" AS INTEGER;
-SET SCHEMA "sys";
CREATE TABLE "sys"."test" (
"id" INTEGER,
"i" SMALLINT
diff --git a/sql/test/Tests/comment-dump.test b/sql/test/Tests/comment-dump.test
--- a/sql/test/Tests/comment-dump.test
+++ b/sql/test/Tests/comment-dump.test
@@ -73,7 +73,7 @@ select stmt from sys.dump_database(false
START TRANSACTION;
SET SCHEMA "sys";
CREATE SCHEMA "foo" AUTHORIZATION "monetdb";
-CREATE SEQUENCE "foo"."counter" AS BIGINT START WITH 1;
+CREATE SEQUENCE "foo"."counter" AS BIGINT;
CREATE TABLE "foo"."tab" ("i" INTEGER, "j" DECIMAL(4,2));
create view "foo"."vivi" as select * from tab@;
create "foo"."f" unction "foo"."f" () returns int begin return 42; end@;
@@ -82,7 +82,7 @@ create "foo"."f" unction "foo"."f" (i in
create "foo"."f" unction "foo"."f" (i int, j int, k int) returns int begin
return 45; end@;
create "foo"."f" unction "foo"."f" (i int, j int, k int, l int) returns int
begin return 45; end@;
create procedure "foo"."g" () be "foo"."g" in delete from tab where false;
end@;
-UPDATE sys.sequences seq SET start = 1 WHERE name = 'counter' AND schema_id =
(SELECT s.id FROM sys.schemas s WHERE s.name = 'foo');
+ALTER SEQUENCE "foo"."counter" RESTART WITH 1 NO CYCLE;
CREATE INDEX "idx" ON "foo"."tab"(j,i);
COMMENT ON COLUMN "foo"."tab"."i" IS 'ii';
COMMENT ON COLUMN "foo"."tab"."j" IS 'jj';
diff --git a/sql/test/UserDump/Tests/dump.stable.out
b/sql/test/UserDump/Tests/dump.stable.out
--- a/sql/test/UserDump/Tests/dump.stable.out
+++ b/sql/test/UserDump/Tests/dump.stable.out
@@ -1,4 +1,5 @@
START TRANSACTION;
+SET SCHEMA "sys";
CREATE USER "test" WITH ENCRYPTED PASSWORD
'ee26b0dd4af7e749aa1a8ee3c10ae9923f618980772e473f8819a5d4940e0db27ac185f8a0e1d5f84f88bc887fd67b143732c304cc5fa9ad8e6f57f50028a8ff'
NAME 'Test User' SCHEMA "sys";
CREATE USER "voc" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA "sys";
CREATE SCHEMA "test" AUTHORIZATION "test";
diff --git a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.py
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.py
--- a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.py
+++ b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.py
@@ -72,7 +72,7 @@ if len(sys.argv) == 2 and sys.argv[1] ==
for line in difflib.unified_diff(stable, srvout, fromfile='test',
tofile=f):
sys.stderr.write(line)
xit = 1
- if len(cltout) != 2 or cltout[0] != 'START TRANSACTION;' or cltout[1] !=
'COMMIT;':
+ if len(cltout) != 3 or cltout[0] != 'START TRANSACTION;' or cltout[1] !=
'SET SCHEMA "sys";' or cltout[2] != 'COMMIT;':
sys.stderr.write('\n'.join(cltout))
xit = 1
else:
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -249,3735 +249,3747 @@ insert into sys.args values (44964, 86,
insert into sys.functions values (87, 'anyequal', 'anyequal', 'aggr', 0, 3,
false, false, false, 2000, true, true);
insert into sys.args values (44965, 87, 'res_0', 'boolean', 1, 0, 0, 0);
insert into sys.args values (44966, 87, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (88, 'allnotequal', 'allnotequal', 'aggr', 0,
3, false, false, false, 2000, true, true);
-insert into sys.args values (44967, 88, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44968, 88, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (89, 'sql_anyequal', 'anyequal', 'aggr', 0,
1, false, false, false, 2000, true, true);
-insert into sys.args values (44969, 89, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44970, 89, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (44971, 89, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (90, 'sql_not_anyequal', 'not_anyequal',
'aggr', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (44972, 90, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44973, 90, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (44974, 90, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (91, 'exist', 'exist', 'aggr', 0, 3, false,
false, false, 2000, true, true);
-insert into sys.args values (44975, 91, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44976, 91, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (92, 'not_exist', 'not_exist', 'aggr', 0, 3,
false, false, false, 2000, true, true);
-insert into sys.args values (44977, 92, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44978, 92, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (93, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (44979, 93, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44980, 93, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (94, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (44981, 94, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (44982, 94, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (95, 'identity', 'identity', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (44983, 95, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (44984, 95, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (96, 'rowid', 'identity', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (44985, 96, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (44986, 96, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (97, 'rowid', 'rowid', 'calc', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (44987, 97, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (44988, 97, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (44989, 97, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (44990, 97, 'arg_3', 'clob', 0, 0, 1, 3);
-insert into sys.functions values (98, 'min', 'min', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (44991, 98, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (44992, 98, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (99, 'max', 'max', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (44993, 99, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (44994, 99, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (100, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44995, 100, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (44996, 100, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (44997, 100, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (101, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44998, 101, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (44999, 101, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45000, 101, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (102, 'least', 'min_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (45001, 102, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45002, 102, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45003, 102, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (103, 'greatest', 'max_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (45004, 103, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45005, 103, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45006, 103, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (104, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true, true);
-insert into sys.args values (45007, 104, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45008, 104, 'arg_1', 'boolean', 1, 0, 1, 1);
-insert into sys.args values (45009, 104, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (45010, 104, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (105, 'nullif', '', '', 0, 1, false, false,
false, 2000, true, true);
-insert into sys.args values (45011, 105, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45012, 105, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45013, 105, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (106, 'coalesce', '', '', 0, 1, false, false,
false, 2000, true, true);
-insert into sys.args values (45014, 106, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45015, 106, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45016, 106, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (107, 'casewhen', '', '', 0, 1, false, false,
false, 2000, true, true);
-insert into sys.args values (45017, 107, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45018, 107, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45019, 107, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (108, 'case', '', '', 0, 1, false, false,
false, 2000, true, true);
-insert into sys.args values (45020, 108, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (45021, 108, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (45022, 108, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (109, 'star', '', '', 0, 1, false, false,
false, 2000, true, true);
-insert into sys.args values (45023, 109, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.functions values (110, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45024, 110, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (45025, 110, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.functions values (111, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45026, 111, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (45027, 111, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (44967, 87, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (88, 'anyequal', 'anyequal', 'aggr', 0, 3,
false, false, false, 2000, true, true);
+insert into sys.args values (44968, 88, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44969, 88, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44970, 88, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (44971, 88, 'arg_3', 'oid', 63, 0, 1, 3);
+insert into sys.functions values (89, 'allnotequal', 'allnotequal', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (44972, 89, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44973, 89, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44974, 89, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (90, 'allnotequal', 'allnotequal', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (44975, 90, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44976, 90, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44977, 90, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (44978, 90, 'arg_3', 'oid', 63, 0, 1, 3);
+insert into sys.functions values (91, 'sql_anyequal', 'anyequal', 'aggr', 0,
1, false, false, false, 2000, true, true);
+insert into sys.args values (44979, 91, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44980, 91, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44981, 91, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (92, 'sql_not_anyequal', 'not_anyequal',
'aggr', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (44982, 92, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44983, 92, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44984, 92, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (93, 'exist', 'exist', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (44985, 93, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44986, 93, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (94, 'not_exist', 'not_exist', 'aggr', 0, 3,
false, false, false, 2000, true, true);
+insert into sys.args values (44987, 94, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44988, 94, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (95, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (44989, 95, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44990, 95, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (96, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (44991, 96, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (44992, 96, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (97, 'identity', 'identity', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (44993, 97, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (44994, 97, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (98, 'rowid', 'identity', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (44995, 98, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (44996, 98, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (99, 'rowid', 'rowid', 'calc', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (44997, 99, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (44998, 99, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (44999, 99, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.args values (45000, 99, 'arg_3', 'clob', 0, 0, 1, 3);
+insert into sys.functions values (100, 'min', 'min', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (45001, 100, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45002, 100, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (101, 'max', 'max', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (45003, 101, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45004, 101, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (102, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (45005, 102, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45006, 102, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45007, 102, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (103, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (45008, 103, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45009, 103, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45010, 103, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (104, 'least', 'min_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (45011, 104, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45012, 104, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45013, 104, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (105, 'greatest', 'max_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (45014, 105, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45015, 105, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45016, 105, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (106, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true, true);
+insert into sys.args values (45017, 106, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45018, 106, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (45019, 106, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (45020, 106, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (107, 'nullif', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (45021, 107, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45022, 107, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45023, 107, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (108, 'coalesce', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (45024, 108, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45025, 108, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45026, 108, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (109, 'casewhen', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (45027, 109, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45028, 109, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45029, 109, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (110, 'case', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (45030, 110, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (45031, 110, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (45032, 110, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (111, 'star', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (45033, 111, 'res_0', 'any', 0, 0, 0, 0);
insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45028, 112, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (45029, 112, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (45034, 112, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (45035, 112, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.functions values (113, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45030, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (45031, 113, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (45036, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (45037, 113, 'arg_1', 'smallint', 16, 0, 1, 1);
insert into sys.functions values (114, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45032, 114, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (45033, 114, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (45038, 114, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (45039, 114, 'arg_1', 'int', 32, 0, 1, 1);
insert into sys.functions values (115, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45034, 115, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (45035, 115, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (45040, 115, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (45041, 115, 'arg_1', 'hugeint', 128, 0, 1, 1);
insert into sys.functions values (116, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45036, 116, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (45037, 116, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (45042, 116, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (45043, 116, 'arg_1', 'bigint', 64, 0, 1, 1);
insert into sys.functions values (117, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45038, 117, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (45039, 117, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (45044, 117, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (45045, 117, 'arg_1', 'decimal', 2, 0, 1, 1);
insert into sys.functions values (118, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (45040, 118, 'res_0', 'decimal', 38, 0, 0, 0);
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
