Changeset: 2753d4f55f68 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2753d4f55f68 Modified Files: sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128 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/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 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.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.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 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.int128 Branch: mangled Log Message:
Approve upgrade output, even though it's not (yet) correct. diffs (truncated from 96052 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 @@ -36,189 +36,189 @@ insert into sys.types values (33, 'wkba' insert into sys.types values (34, 'mbr', 'mbr', 0, 0, 0, 18, 2000); delete from sys.functions where id < 2000; delete from sys.args where func_id not in (select id from sys.functions); -insert into sys.functions values (30, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (30, 'faf%length(1,2)%int(32,0)%blob(0,0)', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false, 'length'); insert into sys.args values (44808, 30, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (44809, 30, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (31, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (31, 'faf%octet_length(1,2)%int(32,0)%blob(0,0)', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false, 'octet_length'); insert into sys.args values (44810, 31, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (44811, 31, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (35, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (35, 'faf%mbr_overlap(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap'); insert into sys.args values (44812, 35, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44813, 35, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44814, 35, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (36, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (36, 'faf%mbr_overlap(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap'); insert into sys.args values (44815, 36, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44816, 36, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44817, 36, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (37, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (37, 'faf%mbr_above(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_above'); insert into sys.args values (44818, 37, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44819, 37, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44820, 37, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (38, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (38, 'faf%mbr_above(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_above'); insert into sys.args values (44821, 38, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44822, 38, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44823, 38, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (39, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (39, 'faf%mbr_below(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_below'); insert into sys.args values (44824, 39, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44825, 39, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44826, 39, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (40, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (40, 'faf%mbr_below(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_below'); insert into sys.args values (44827, 40, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44828, 40, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44829, 40, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (41, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (41, 'faf%mbr_right(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_right'); insert into sys.args values (44830, 41, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44831, 41, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44832, 41, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (42, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (42, 'faf%mbr_right(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_right'); insert into sys.args values (44833, 42, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44834, 42, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44835, 42, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (43, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (43, 'faf%mbr_left(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_left'); insert into sys.args values (44836, 43, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44837, 43, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44838, 43, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (44, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (44, 'faf%mbr_left(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_left'); insert into sys.args values (44839, 44, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44840, 44, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44841, 44, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (45, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (45, 'faf%mbr_overlap_or_above(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_above'); insert into sys.args values (44842, 45, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44843, 45, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44844, 45, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (46, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (46, 'faf%mbr_overlap_or_above(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_above'); insert into sys.args values (44845, 46, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44846, 46, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44847, 46, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (47, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (47, 'faf%mbr_overlap_or_below(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_below'); insert into sys.args values (44848, 47, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44849, 47, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44850, 47, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (48, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (48, 'faf%mbr_overlap_or_below(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_below'); insert into sys.args values (44851, 48, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44852, 48, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44853, 48, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (49, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (49, 'faf%mbr_overlap_or_right(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_right'); insert into sys.args values (44854, 49, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44855, 49, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44856, 49, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (50, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (50, 'faf%mbr_overlap_or_right(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_right'); insert into sys.args values (44857, 50, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44858, 50, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44859, 50, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (51, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (51, 'faf%mbr_overlap_or_left(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_left'); insert into sys.args values (44860, 51, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44861, 51, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44862, 51, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (52, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (52, 'faf%mbr_overlap_or_left(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_overlap_or_left'); insert into sys.args values (44863, 52, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44864, 52, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44865, 52, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (53, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (53, 'faf%mbr_contains(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_contains'); insert into sys.args values (44866, 53, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44867, 53, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44868, 53, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (54, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (54, 'faf%mbr_contains(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_contains'); insert into sys.args values (44869, 54, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44870, 54, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44871, 54, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (55, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (55, 'faf%mbr_contained(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_contained'); insert into sys.args values (44872, 55, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44873, 55, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44874, 55, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (56, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (56, 'faf%mbr_contained(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_contained'); insert into sys.args values (44875, 56, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44876, 56, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44877, 56, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (57, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (57, 'faf%mbr_equal(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_equal'); insert into sys.args values (44878, 57, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44879, 57, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44880, 57, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (58, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (58, 'faf%mbr_equal(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_equal'); insert into sys.args values (44881, 58, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44882, 58, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44883, 58, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (59, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (59, 'faf%mbr_distance(1,3)%double(53,0)%geometry(0,0)%geometry(0,0)', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_distance'); insert into sys.args values (44884, 59, 'res_0', 'double', 53, 0, 0, 0); insert into sys.args values (44885, 59, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44886, 59, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (60, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (60, 'faf%mbr_distance(1,3)%double(53,0)%mbr(0,0)%mbr(0,0)', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true, 'mbr_distance'); insert into sys.args values (44887, 60, 'res_0', 'double', 53, 0, 0, 0); insert into sys.args values (44888, 60, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44889, 60, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (61, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (61, 'faf%left_shift(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'left_shift'); insert into sys.args values (44890, 61, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44891, 61, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44892, 61, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (62, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (62, 'faf%left_shift(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true, 'left_shift'); insert into sys.args values (44893, 62, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44894, 62, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44895, 62, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (63, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (63, 'faf%right_shift(1,3)%boolean(1,0)%geometry(0,0)%geometry(0,0)', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'right_shift'); insert into sys.args values (44896, 63, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44897, 63, 'arg_1', 'geometry', 0, 0, 1, 1); insert into sys.args values (44898, 63, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (64, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (64, 'faf%right_shift(1,3)%boolean(1,0)%mbr(0,0)%mbr(0,0)', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true, 'right_shift'); insert into sys.args values (44899, 64, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44900, 64, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44901, 64, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (65, 'faf%grouping(1,2)%tinyint(8,0)%any(0,0)', '', '', 0, 3, false, false, false, 2000, true, true, 'grouping'); insert into sys.args values (44902, 65, 'res_0', 'tinyint', 8, 0, 0, 0); insert into sys.args values (44903, 65, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (66, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (66, 'faf%grouping(1,2)%smallint(16,0)%any(0,0)', '', '', 0, 3, false, false, false, 2000, true, true, 'grouping'); insert into sys.args values (44904, 66, 'res_0', 'smallint', 16, 0, 0, 0); insert into sys.args values (44905, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (67, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (67, 'faf%grouping(1,2)%int(32,0)%any(0,0)', '', '', 0, 3, false, false, false, 2000, true, true, 'grouping'); insert into sys.args values (44906, 67, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (44907, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (68, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (68, 'faf%grouping(1,2)%bigint(64,0)%any(0,0)', '', '', 0, 3, false, false, false, 2000, true, true, 'grouping'); insert into sys.args values (44908, 68, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (44909, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (69, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (69, 'faf%grouping(1,2)%hugeint(128,0)%any(0,0)', '', '', 0, 3, false, false, false, 2000, true, true, 'grouping'); insert into sys.args values (44910, 69, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (44911, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (70, 'not_unique', 'not_unique', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (70, 'faf%not_unique(1,2)%boolean(1,0)%oid(63,0)', 'not_unique', 'aggr', 0, 3, false, false, false, 2000, true, true, 'not_unique'); insert into sys.args values (44912, 70, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44913, 70, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (71, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (71, 'faf%hash(1,2)%bigint(64,0)%any(0,0)', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true, 'hash'); insert into sys.args values (44914, 71, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (44915, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (72, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (72, 'faf%rotate_xor_hash(1,4)%bigint(64,0)%bigint(64,0)%int(32,0)%any(0,0)', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true, 'rotate_xor_hash'); insert into sys.args values (44916, 72, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (44917, 72, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.args values (44918, 72, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.args values (44919, 72, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (73, 'faf%=(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '=', 'calc', 0, 1, false, false, false, 2000, true, false, '='); insert into sys.args values (44920, 73, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44921, 73, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44922, 73, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (74, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (74, 'faf%<>(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '!=', 'calc', 0, 1, false, false, false, 2000, true, false, '<>'); insert into sys.args values (44923, 74, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44924, 74, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44925, 74, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (75, 'faf%isnull(1,2)%boolean(1,0)%any(0,0)', 'isnil', 'calc', 0, 1, false, false, false, 2000, true, true, 'isnull'); insert into sys.args values (44926, 75, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44927, 75, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (76, 'isnotnull', 'isnotnil', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (76, 'faf%isnotnull(1,2)%boolean(1,0)%any(0,0)', 'isnotnil', 'calc', 0, 1, false, false, false, 2000, true, true, 'isnotnull'); insert into sys.args values (44928, 76, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44929, 76, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (77, '>', '>', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (77, 'faf%>(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '>', 'calc', 0, 1, false, false, false, 2000, true, false, '>'); insert into sys.args values (44930, 77, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44931, 77, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44932, 77, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (78, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (78, 'faf%>=(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '>=', 'calc', 0, 1, false, false, false, 2000, true, false, '>='); insert into sys.args values (44933, 78, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44934, 78, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44935, 78, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (79, '<', '<', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (79, 'faf%<(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '<', 'calc', 0, 1, false, false, false, 2000, true, false, '<'); insert into sys.args values (44936, 79, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44937, 79, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44938, 79, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (80, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (80, 'faf%<=(1,3)%boolean(1,0)%any(0,0)%any(0,0)', '<=', 'calc', 0, 1, false, false, false, 2000, true, false, '<='); insert into sys.args values (44939, 80, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44940, 80, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44941, 80, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (81, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (81, 'faf%between(1,9)%boolean(1,0)%any(0,0)%any(0,0)%any(0,0)%boolean(1,0)%boolean(1,0)%boolean(1,0)%boolean(1,0)%boolean(1,0)', 'between', 'calc', 0, 1, false, false, false, 2000, true, false, 'between'); insert into sys.args values (44942, 81, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44943, 81, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (44944, 81, 'arg_2', 'any', 0, 0, 1, 2); @@ -228,311 +228,311 @@ insert into sys.args values (44947, 81, insert into sys.args values (44948, 81, 'arg_6', 'boolean', 1, 0, 1, 6); insert into sys.args values (44949, 81, 'arg_7', 'boolean', 1, 0, 1, 7); insert into sys.args values (44950, 81, 'arg_8', 'boolean', 1, 0, 1, 8); -insert into sys.functions values (82, 'zero_or_one', 'zero_or_one', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (82, 'faf%zero_or_one(1,2)%any(0,0)%any(0,0)', 'zero_or_one', 'aggr', 0, 3, false, false, false, 2000, true, true, 'zero_or_one'); insert into sys.args values (44951, 82, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (44952, 82, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (83, 'all', 'all', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (83, 'faf%all(1,2)%any(0,0)%any(0,0)', 'all', 'aggr', 0, 3, false, false, false, 2000, true, true, 'all'); insert into sys.args values (44953, 83, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (44954, 83, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (84, 'null', 'null', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (84, 'faf%null(1,2)%boolean(1,0)%any(0,0)', 'null', 'aggr', 0, 3, false, false, false, 2000, true, true, 'null'); insert into sys.args values (44955, 84, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44956, 84, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (85, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (85, 'faf%any(1,4)%boolean(1,0)%boolean(1,0)%boolean(1,0)%boolean(1,0)', 'any', 'sql', 0, 1, false, false, false, 2000, true, true, 'any'); insert into sys.args values (44957, 85, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44958, 85, 'arg_1', 'boolean', 1, 0, 1, 1); insert into sys.args values (44959, 85, 'arg_2', 'boolean', 1, 0, 1, 2); insert into sys.args values (44960, 85, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (86, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (86, 'faf%all(1,4)%boolean(1,0)%boolean(1,0)%boolean(1,0)%boolean(1,0)', 'all', 'sql', 0, 1, false, false, false, 2000, true, true, 'all'); insert into sys.args values (44961, 86, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44962, 86, 'arg_1', 'boolean', 1, 0, 1, 1); insert into sys.args values (44963, 86, 'arg_2', 'boolean', 1, 0, 1, 2); insert into sys.args values (44964, 86, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (87, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.functions values (87, 'faf%anyequal(1,2)%boolean(1,0)%any(0,0)', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true, 'anyequal'); 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.functions values (88, 'faf%allnotequal(1,2)%boolean(1,0)%any(0,0)', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true, true, 'allnotequal'); 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.functions values (89, 'faf%sql_anyequal(1,3)%boolean(1,0)%any(0,0)%any(0,0)', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true, 'sql_anyequal'); 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.functions values (90, 'faf%sql_not_anyequal(1,3)%boolean(1,0)%any(0,0)%any(0,0)', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true, 'sql_not_anyequal'); 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.functions values (91, 'faf%exist(1,2)%boolean(1,0)%any(0,0)', 'exist', 'aggr', 0, 3, false, false, false, 2000, true, true, 'exist'); 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.functions values (92, 'faf%not_exist(1,2)%boolean(1,0)%any(0,0)', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true, true, 'not_exist'); 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.functions values (93, 'faf%sql_exists(1,2)%boolean(1,0)%any(0,0)', 'exist', 'aggr', 0, 1, false, false, false, 2000, true, true, 'sql_exists'); 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); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
