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