Changeset: 48664ddf44ba for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/48664ddf44ba Modified Files: 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.stable.out 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.stable.out.int128 sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out 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.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: default Log Message:
Approve function renumbering. diffs (truncated from 178576 to 300 lines): diff --git a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -399,2582 +399,2554 @@ insert into sys.functions values (165, ' insert into sys.args values (45068, 165, 'res_0', 'clob', 0, 0, 0, 0); insert into sys.args values (45069, 165, 'arg_1', 'clob', 0, 0, 1, 1); insert into sys.args values (45070, 165, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (166, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (45071, 166, 'res_0', 'varchar', 0, 0, 0, 0); -insert into sys.args values (45072, 166, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.functions values (167, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (45073, 167, 'res_0', 'varchar', 0, 0, 0, 0); -insert into sys.args values (45074, 167, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (45075, 167, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (168, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (45076, 168, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (45077, 168, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (169, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (45078, 169, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (45079, 169, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (45080, 169, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (202, 'rank', 'rank', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45081, 202, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (45082, 202, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (203, 'dense_rank', 'dense_rank', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45083, 203, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (45084, 203, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (204, 'row_number', 'row_number', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45085, 204, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (45086, 204, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (205, 'percent_rank', 'percent_rank', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45087, 205, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.functions values (198, 'rank', 'rank', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45071, 198, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (45072, 198, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (199, 'dense_rank', 'dense_rank', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45073, 199, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (45074, 199, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (200, 'row_number', 'row_number', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45075, 200, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (45076, 200, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (201, 'percent_rank', 'percent_rank', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45077, 201, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (45078, 201, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (202, 'cume_dist', 'cume_dist', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45079, 202, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (45080, 202, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (203, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45081, 203, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (45082, 203, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45083, 203, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (204, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45084, 204, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (45085, 204, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45086, 204, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (205, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45087, 205, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (45088, 205, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (206, 'cume_dist', 'cume_dist', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45089, 206, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (45090, 206, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45089, 205, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (206, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45090, 206, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (45091, 206, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45092, 206, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (207, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45091, 207, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (45092, 207, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45093, 207, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (208, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45094, 208, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (45095, 208, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45096, 208, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (209, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45097, 209, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (45098, 209, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45099, 209, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (210, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45100, 210, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (45101, 210, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45102, 210, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (211, 'ntile', 'ntile', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45103, 211, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45104, 211, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45105, 211, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (45093, 207, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (45094, 207, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45095, 207, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (208, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45096, 208, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45097, 208, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (209, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45098, 209, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45099, 209, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45100, 209, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (210, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45101, 210, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45102, 210, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45103, 210, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (211, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45104, 211, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45105, 211, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45106, 211, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (212, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45106, 212, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45107, 212, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45107, 212, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45108, 212, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45109, 212, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (213, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45108, 213, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45109, 213, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45110, 213, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (45110, 213, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45111, 213, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45112, 213, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (214, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45111, 214, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45112, 214, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45113, 214, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (45113, 214, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45114, 214, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45115, 214, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (45116, 214, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (215, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45114, 215, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45115, 215, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45116, 215, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (45117, 215, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45118, 215, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45119, 215, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (45120, 215, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (216, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45117, 216, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45118, 216, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45119, 216, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (45121, 216, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45122, 216, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45123, 216, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (45124, 216, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (217, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45120, 217, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45121, 217, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45122, 217, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (45125, 217, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45126, 217, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45127, 217, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (45128, 217, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (218, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45123, 218, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45124, 218, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45125, 218, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.args values (45126, 218, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (219, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45127, 219, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45128, 219, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45129, 219, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.args values (45130, 219, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (220, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45131, 220, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45132, 220, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45133, 220, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (45134, 220, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (221, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45135, 221, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45136, 221, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45137, 221, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.args values (45138, 221, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (222, 'lag', 'lag', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45139, 222, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45140, 222, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45141, 222, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.args values (45142, 222, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (45129, 218, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45130, 218, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45131, 218, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (45132, 218, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (219, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45133, 219, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45134, 219, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (220, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45135, 220, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45136, 220, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45137, 220, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (221, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45138, 221, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45139, 221, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45140, 221, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (222, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45141, 222, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45142, 222, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45143, 222, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (223, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45143, 223, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45144, 223, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45144, 223, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45145, 223, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45146, 223, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (224, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45145, 224, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45146, 224, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45147, 224, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (45147, 224, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45148, 224, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45149, 224, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (225, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45148, 225, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45149, 225, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45150, 225, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (45150, 225, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45151, 225, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45152, 225, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (45153, 225, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (226, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45151, 226, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45152, 226, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45153, 226, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (45154, 226, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45155, 226, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45156, 226, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (45157, 226, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (227, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45154, 227, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45155, 227, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45156, 227, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (45158, 227, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45159, 227, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45160, 227, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (45161, 227, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (228, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45157, 228, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45158, 228, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45159, 228, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (45162, 228, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45163, 228, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45164, 228, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (45165, 228, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (229, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45160, 229, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45161, 229, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45162, 229, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.args values (45163, 229, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (230, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45164, 230, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45165, 230, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45166, 230, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.args values (45167, 230, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (231, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45168, 231, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45169, 231, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45170, 231, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (45171, 231, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (232, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45172, 232, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45173, 232, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45174, 232, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.args values (45175, 232, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (233, 'lead', 'lead', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45176, 233, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45177, 233, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45178, 233, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.args values (45179, 233, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (234, 'first_value', 'first_value', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45166, 229, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45167, 229, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45168, 229, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (45169, 229, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (230, 'first_value', 'first_value', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45170, 230, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45171, 230, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (231, 'last_value', 'last_value', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45172, 231, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45173, 231, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (232, 'nth_value', 'nth_value', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45174, 232, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (45175, 232, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45176, 232, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.functions values (233, 'count', 'count', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (45177, 233, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (45178, 233, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (45179, 233, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (234, 'min', 'min', 'sql', 0, 6, false, false, false, 2000, true, true); insert into sys.args values (45180, 234, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (45181, 234, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (235, 'last_value', 'last_value', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.functions values (235, 'max', 'max', 'sql', 0, 6, false, false, false, 2000, true, true); insert into sys.args values (45182, 235, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (45183, 235, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (236, 'nth_value', 'nth_value', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45184, 236, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45185, 236, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45186, 236, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (237, 'count', 'count', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45187, 237, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (45188, 237, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45189, 237, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (238, 'min', 'min', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (45190, 238, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45191, 238, 'arg_1', 'any', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
