Changeset: 495ad4e3f114 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=495ad4e3f114 Modified Files: 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/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.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: octbugs Log Message:
Approvals. diffs (truncated from 80824 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -1557,21 +1557,21 @@ insert into sys.functions values (393, ' insert into sys.args values (35916, 393, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (35917, 393, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (35918, 393, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (394, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35919, 394, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (35920, 394, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (394, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (35919, 394, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (35920, 394, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (35921, 394, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (395, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35922, 395, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (35923, 395, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (35922, 395, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (35923, 395, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (35924, 395, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (396, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35925, 396, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (35926, 396, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (35925, 396, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (35926, 396, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (35927, 396, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (397, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35928, 397, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35929, 397, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (397, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (35928, 397, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (35929, 397, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (35930, 397, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (398, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (35931, 398, 'res_0', 'sec_interval', 13, 0, 0, 0); @@ -1637,21 +1637,21 @@ insert into sys.functions values (414, ' insert into sys.args values (35975, 414, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (35976, 414, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (35977, 414, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (415, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35978, 415, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (35979, 415, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (415, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (35978, 415, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (35979, 415, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (35980, 415, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (416, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35981, 416, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (35982, 416, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (35981, 416, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (35982, 416, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (35983, 416, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (417, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35984, 417, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (35985, 417, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (35984, 417, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (35985, 417, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (35986, 417, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (418, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35987, 418, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35988, 418, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (418, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (35987, 418, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (35988, 418, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (35989, 418, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (419, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (35990, 419, 'res_0', 'sec_interval', 13, 0, 0, 0); @@ -1717,21 +1717,21 @@ insert into sys.functions values (435, ' insert into sys.args values (36034, 435, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (36035, 435, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (36036, 435, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (436, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36037, 436, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (36038, 436, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (436, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36037, 436, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (36038, 436, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (36039, 436, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (437, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36040, 437, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (36041, 437, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (36040, 437, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (36041, 437, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (36042, 437, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (438, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36043, 438, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (36044, 438, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.args values (36043, 438, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (36044, 438, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (36045, 438, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (439, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36046, 439, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (36047, 439, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (439, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36046, 439, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (36047, 439, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (36048, 439, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (440, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36049, 440, 'res_0', 'sec_interval', 13, 0, 0, 0); @@ -1794,2539 +1794,2507 @@ insert into sys.args values (36090, 455, insert into sys.args values (36091, 455, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.args values (36092, 455, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (456, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36093, 456, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (36094, 456, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.args values (36093, 456, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (36094, 456, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (36095, 456, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (457, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36096, 457, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (36097, 457, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (457, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36096, 457, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (36097, 457, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (36098, 457, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (458, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36099, 458, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (36100, 458, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (458, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36099, 458, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (36100, 458, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (36101, 458, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (459, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36102, 459, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (36103, 459, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (36104, 459, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (460, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (460, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36105, 460, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (36106, 460, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (36107, 460, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (461, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36108, 461, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (36109, 461, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.args values (36110, 461, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (462, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (461, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36108, 461, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (36109, 461, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (36110, 461, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (462, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36111, 462, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36112, 462, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36113, 462, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (463, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (463, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36114, 463, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36115, 463, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36116, 463, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (464, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (464, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36117, 464, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36118, 464, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36119, 464, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (465, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (465, 'bit_and', 'and', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36120, 465, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36121, 465, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36122, 465, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (466, 'bit_and', 'and', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (466, 'bit_or', 'or', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36123, 466, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36124, 466, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36125, 466, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (467, 'bit_or', 'or', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (467, 'bit_xor', 'xor', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36126, 467, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36127, 467, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36128, 467, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (468, 'bit_xor', 'xor', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (468, 'bit_not', 'not', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36129, 468, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36130, 468, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (36131, 468, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (469, 'bit_not', 'not', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36132, 469, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (36133, 469, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (470, 'left_shift', '<<', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (469, 'left_shift', '<<', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36131, 469, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (36132, 469, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (36133, 469, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (470, 'right_shift', '>>', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36134, 470, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36135, 470, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36136, 470, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (471, 'right_shift', '>>', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (471, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36137, 471, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36138, 471, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (36139, 471, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (472, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36140, 472, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (36141, 472, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (473, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36142, 473, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (36143, 473, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (474, 'sign', 'sign', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36144, 474, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (36145, 474, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (475, 'scale_up', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (472, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36139, 472, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (36140, 472, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.functions values (473, 'sign', 'sign', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36141, 473, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (36142, 473, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.functions values (474, 'scale_up', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36143, 474, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (36144, 474, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (36145, 474, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (475, 'scale_down', 'dec_round', 'sql', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36146, 475, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (36147, 475, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.args values (36148, 475, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (476, 'scale_down', 'dec_round', 'sql', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36149, 476, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (36150, 476, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.functions values (476, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36149, 476, 'res_0', 'month_interval', 3, 0, 0, 0); +insert into sys.args values (36150, 476, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (36151, 476, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (477, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36152, 477, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (36153, 477, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (477, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36152, 477, 'res_0', 'day_interval', 4, 0, 0, 0); +insert into sys.args values (36153, 477, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (36154, 477, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (478, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36155, 478, 'res_0', 'month_interval', 3, 0, 0, 0); -insert into sys.args values (36156, 478, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.args values (36155, 478, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (36156, 478, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (36157, 478, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (479, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36158, 479, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (36159, 479, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.args values (36160, 479, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (480, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36161, 480, 'res_0', 'day_interval', 4, 0, 0, 0); -insert into sys.args values (36162, 480, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.args values (36163, 480, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (479, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36158, 479, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (36159, 479, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (36160, 479, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.functions values (480, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36161, 480, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (36162, 480, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (36163, 480, 'arg_2', 'decimal', 2, 0, 1, 2); insert into sys.functions values (481, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36164, 481, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (36165, 481, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.args values (36166, 481, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (36164, 481, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (36165, 481, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (36166, 481, 'arg_2', 'decimal', 2, 0, 1, 2); insert into sys.functions values (482, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36167, 482, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (36168, 482, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.args values (36169, 482, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (483, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (36167, 482, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (36168, 482, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (36169, 482, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.functions values (483, 'bit_and', 'and', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36170, 483, 'res_0', 'decimal', 2, 0, 0, 0); insert into sys.args values (36171, 483, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.args values (36172, 483, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (484, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (484, 'bit_or', 'or', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36173, 484, 'res_0', 'decimal', 2, 0, 0, 0); insert into sys.args values (36174, 484, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.args values (36175, 484, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (485, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (485, 'bit_xor', 'xor', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36176, 485, 'res_0', 'decimal', 2, 0, 0, 0); insert into sys.args values (36177, 485, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.args values (36178, 485, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (486, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (486, 'bit_not', 'not', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (36179, 486, 'res_0', 'decimal', 2, 0, 0, 0); insert into sys.args values (36180, 486, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (36181, 486, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (487, 'bit_and', 'and', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36182, 487, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (36183, 487, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (36184, 487, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (488, 'bit_or', 'or', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36185, 488, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (36186, 488, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (36187, 488, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (489, 'bit_xor', 'xor', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36188, 489, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (36189, 489, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (36190, 489, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (490, 'bit_not', 'not', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (36191, 490, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (36192, 490, 'arg_1', 'decimal', 2, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
