Changeset: c7b17f201c40 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c7b17f201c40 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit 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/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Branch: Jul2021 Log Message:
Upgrade approvals. diffs (truncated from 39868 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -323,3814 +323,3818 @@ insert into sys.functions values (107, ' insert into sys.args values (41600, 107, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (41601, 107, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (41602, 107, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (108, 'star', '', '', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (108, 'case', '', '', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (41603, 108, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.functions values (109, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41604, 109, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41605, 109, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (41604, 108, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (41605, 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 (41606, 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 (41606, 110, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41607, 110, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (41607, 110, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41608, 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 (41608, 111, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41609, 111, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (41609, 111, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41610, 111, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41610, 112, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41611, 112, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (41611, 112, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41612, 112, 'arg_1', 'int', 32, 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 (41612, 113, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (41613, 113, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (41613, 113, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41614, 113, 'arg_1', 'hugeint', 128, 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 (41614, 114, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41615, 114, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (41615, 114, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (41616, 114, 'arg_1', 'bigint', 64, 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 (41616, 115, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41617, 115, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (41617, 115, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41618, 115, 'arg_1', 'decimal', 2, 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 (41618, 116, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41619, 116, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (41619, 116, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41620, 116, 'arg_1', 'decimal', 4, 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 (41620, 117, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41621, 117, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (41621, 117, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41622, 117, 'arg_1', 'decimal', 9, 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 (41622, 118, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41623, 118, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.functions values (119, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41624, 119, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41625, 119, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (41623, 118, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41624, 118, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.functions values (119, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41625, 119, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41626, 119, 'arg_1', 'decimal', 38, 0, 1, 1); insert into sys.functions values (120, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41626, 120, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41627, 120, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (41627, 120, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41628, 120, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (121, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41628, 121, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41629, 121, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (41629, 121, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41630, 121, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (122, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41630, 122, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41631, 122, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (41631, 122, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41632, 122, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (123, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41632, 123, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41633, 123, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (124, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41634, 124, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (41635, 124, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (41636, 124, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (41633, 123, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41634, 123, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (124, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41635, 124, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41636, 124, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (125, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41637, 125, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (41638, 125, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (41639, 125, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (41637, 125, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (41638, 125, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (41639, 125, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (126, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41640, 126, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (41641, 126, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (41642, 126, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (41640, 126, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (41641, 126, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (41642, 126, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (127, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41643, 127, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (41644, 127, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (41645, 127, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (41643, 127, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (41644, 127, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (41645, 127, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (128, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41646, 128, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (41647, 128, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (41648, 128, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (41646, 128, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (41647, 128, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (41648, 128, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (129, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41649, 129, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (41650, 129, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (41651, 129, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.args values (41649, 129, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (41650, 129, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (41651, 129, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (130, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41652, 130, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (41653, 130, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (41654, 130, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (41652, 130, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (41653, 130, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (41654, 130, 'arg_2', 'decimal', 2, 0, 1, 2); insert into sys.functions values (131, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41655, 131, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (41656, 131, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (41657, 131, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (41655, 131, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (41656, 131, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (41657, 131, 'arg_2', 'decimal', 4, 0, 1, 2); insert into sys.functions values (132, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41658, 132, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (41659, 132, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (41660, 132, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.args values (41658, 132, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (41659, 132, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (41660, 132, 'arg_2', 'decimal', 9, 0, 1, 2); insert into sys.functions values (133, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41661, 133, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41662, 133, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (41663, 133, 'arg_2', 'decimal', 38, 0, 1, 2); +insert into sys.args values (41661, 133, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (41662, 133, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (41663, 133, 'arg_2', 'decimal', 18, 0, 1, 2); insert into sys.functions values (134, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41664, 134, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (41665, 134, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.args values (41666, 134, 'arg_2', 'real', 24, 0, 1, 2); +insert into sys.args values (41664, 134, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41665, 134, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (41666, 134, 'arg_2', 'decimal', 38, 0, 1, 2); insert into sys.functions values (135, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41667, 135, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41668, 135, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.args values (41669, 135, 'arg_2', 'double', 53, 0, 1, 2); -insert into sys.functions values (136, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41670, 136, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (41671, 136, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (137, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41672, 137, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (41673, 137, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (138, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41674, 138, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41675, 138, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.functions values (139, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41676, 139, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41677, 139, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.functions values (140, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41678, 140, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (41679, 140, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.args values (41667, 135, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (41668, 135, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (41669, 135, 'arg_2', 'real', 24, 0, 1, 2); +insert into sys.functions values (136, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (41670, 136, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41671, 136, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (41672, 136, 'arg_2', 'double', 53, 0, 1, 2); +insert into sys.functions values (137, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41673, 137, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (41674, 137, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.functions values (138, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41675, 138, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (41676, 138, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.functions values (139, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41677, 139, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41678, 139, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.functions values (140, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41679, 140, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41680, 140, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (141, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41680, 141, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (41681, 141, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (41681, 141, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (41682, 141, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (142, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41682, 142, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (41683, 142, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (143, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41684, 143, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41685, 143, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (41683, 142, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (41684, 142, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (143, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41685, 143, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (41686, 143, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (144, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41686, 144, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41687, 144, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (41687, 144, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41688, 144, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (145, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41688, 145, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41689, 145, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (41689, 145, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41690, 145, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (146, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41690, 146, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41691, 146, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (41691, 146, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41692, 146, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (147, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41692, 147, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41693, 147, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (41693, 147, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41694, 147, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (148, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41694, 148, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41695, 148, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (41695, 148, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41696, 148, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (149, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41696, 149, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41697, 149, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (41697, 149, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41698, 149, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (150, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41698, 150, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (41699, 150, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (41699, 150, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41700, 150, 'arg_1', 'real', 24, 0, 1, 1); insert into sys.functions values (151, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41700, 151, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (41701, 151, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (41701, 151, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (41702, 151, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.functions values (152, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41702, 152, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (41703, 152, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (41703, 152, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (41704, 152, 'arg_1', 'decimal', 4, 0, 1, 1); insert into sys.functions values (153, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41704, 153, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (41705, 153, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (41705, 153, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (41706, 153, 'arg_1', 'decimal', 9, 0, 1, 1); insert into sys.functions values (154, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41706, 154, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (41707, 154, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (41707, 154, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (41708, 154, 'arg_1', 'decimal', 18, 0, 1, 1); insert into sys.functions values (155, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41708, 155, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (41709, 155, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.args values (41709, 155, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (41710, 155, 'arg_1', 'decimal', 38, 0, 1, 1); insert into sys.functions values (156, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41710, 156, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (41711, 156, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (41711, 156, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (41712, 156, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (157, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (41712, 157, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (41713, 157, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (158, 'count_no_nil', 'count_no_nil', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (41714, 158, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.functions values (159, 'count', 'count', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (41715, 159, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (41716, 159, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (160, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (41717, 160, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (41718, 160, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (41713, 157, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (41714, 157, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (158, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (41715, 158, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (41716, 158, 'arg_1', 'sec_interval', 13, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
