Changeset: 8a121df3e2b3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8a121df3e2b3 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: Jul2017 Log Message:
Approve upgrade. diffs (truncated from 36304 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -350,4903 +350,4943 @@ insert into sys.functions values (146, ' insert into sys.args values (11626, 146, 'res_0', 'smallint', 16, 0, 0, 0); insert into sys.args values (11627, 146, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.args values (11628, 146, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (147, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.functions values (147, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11629, 147, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (11630, 147, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (11631, 147, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (148, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11632, 148, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (11633, 148, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (11630, 147, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (11631, 147, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (148, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11632, 148, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (11633, 148, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.args values (11634, 148, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (149, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.functions values (149, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11635, 149, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (11636, 149, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.args values (11637, 149, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (150, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11638, 150, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (11639, 150, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (11640, 150, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (11639, 150, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (11640, 150, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (151, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11641, 151, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (11642, 151, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (11643, 151, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (11643, 151, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (152, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11644, 152, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (11645, 152, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (11646, 152, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (153, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11647, 153, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (11648, 153, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (11649, 153, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (154, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11650, 154, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (11651, 154, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (11644, 152, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (11645, 152, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (11646, 152, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (153, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11647, 153, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (11648, 153, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (11649, 153, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (154, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11650, 154, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (11651, 154, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.args values (11652, 154, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (155, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.functions values (155, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11653, 155, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (11654, 155, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (11655, 155, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (11655, 155, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (156, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11656, 156, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (11657, 156, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (11658, 156, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (11657, 156, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (11658, 156, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (157, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11659, 157, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (11660, 157, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (11661, 157, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (11661, 157, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (158, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11662, 158, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11663, 158, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11664, 158, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (159, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11665, 159, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11666, 159, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11667, 159, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (160, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11668, 160, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11669, 160, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11662, 158, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11663, 158, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (11664, 158, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (159, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11665, 159, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11666, 159, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (11667, 159, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.functions values (160, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11668, 160, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11669, 160, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.args values (11670, 160, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (161, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11671, 161, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11672, 161, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11673, 161, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (161, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11671, 161, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11672, 161, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (11673, 161, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (162, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11674, 162, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11675, 162, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11676, 162, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (11674, 162, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11675, 162, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (11676, 162, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (163, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11677, 163, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11678, 163, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11677, 163, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (11678, 163, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.args values (11679, 163, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (164, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11680, 164, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (11681, 164, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11682, 164, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (165, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11682, 164, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (165, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); insert into sys.args values (11683, 165, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (11684, 165, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (11685, 165, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (166, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11686, 166, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (11687, 166, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (11688, 166, 'arg_2', 'decimal', 4, 0, 1, 2); -insert into sys.functions values (167, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11689, 167, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (11690, 167, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (11691, 167, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (11684, 165, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (11685, 165, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (166, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11686, 166, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11687, 166, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11688, 166, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (167, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11689, 167, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11690, 167, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11691, 167, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (168, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11692, 168, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (11693, 168, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (11694, 168, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (11692, 168, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11693, 168, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (11694, 168, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (169, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11695, 169, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (11696, 169, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (11697, 169, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (11695, 169, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11696, 169, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11697, 169, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (170, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11698, 170, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (11699, 170, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (11700, 170, 'arg_2', 'decimal', 9, 0, 1, 2); -insert into sys.functions values (171, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11701, 171, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (11702, 171, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (11703, 171, 'arg_2', 'decimal', 9, 0, 1, 2); -insert into sys.functions values (172, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11704, 172, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11705, 172, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11706, 172, 'arg_2', 'decimal', 4, 0, 1, 2); -insert into sys.functions values (173, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11707, 173, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11708, 173, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11709, 173, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (11698, 170, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11699, 170, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11700, 170, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (171, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11701, 171, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11702, 171, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (11703, 171, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (172, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11704, 172, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11705, 172, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11706, 172, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (173, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11707, 173, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11708, 173, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11709, 173, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (174, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11710, 174, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11711, 174, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11712, 174, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (11710, 174, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11711, 174, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (11712, 174, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (175, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11713, 175, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11714, 175, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11715, 175, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (11713, 175, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (11714, 175, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (11715, 175, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (176, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11716, 176, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11717, 176, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11718, 176, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.args values (11716, 176, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (11717, 176, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (11718, 176, 'arg_2', 'decimal', 4, 0, 1, 2); insert into sys.functions values (177, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11719, 177, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (11720, 177, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (11721, 177, 'arg_2', 'decimal', 18, 0, 1, 2); -insert into sys.functions values (178, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11722, 178, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11723, 178, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11724, 178, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (179, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11725, 179, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11726, 179, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11727, 179, 'arg_2', 'oid', 63, 0, 1, 2); +insert into sys.args values (11719, 177, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (11720, 177, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (11721, 177, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.functions values (178, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11722, 178, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (11723, 178, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (11724, 178, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.functions values (179, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (11725, 179, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (11726, 179, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (11727, 179, 'arg_2', 'decimal', 4, 0, 1, 2); insert into sys.functions values (180, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11728, 180, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11729, 180, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11730, 180, 'arg_2', 'oid', 63, 0, 1, 2); +insert into sys.args values (11728, 180, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (11729, 180, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (11730, 180, 'arg_2', 'decimal', 9, 0, 1, 2); insert into sys.functions values (181, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11731, 181, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11732, 181, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11733, 181, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (182, 'bit_and', 'and', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11734, 182, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11735, 182, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11736, 182, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (183, 'bit_or', 'or', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11737, 183, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11738, 183, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11739, 183, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (184, 'bit_xor', 'xor', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11740, 184, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11741, 184, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11742, 184, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (185, 'bit_not', 'not', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11743, 185, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11744, 185, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (186, 'left_shift', '<<', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11745, 186, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11746, 186, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11747, 186, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (187, 'right_shift', '>>', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11748, 187, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11749, 187, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11750, 187, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (188, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11751, 188, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11752, 188, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (189, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11753, 189, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11754, 189, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (190, 'sign', 'sign', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11755, 190, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (11756, 190, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (191, 'scale_up', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11757, 191, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11758, 191, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11759, 191, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (192, 'scale_down', 'dec_round', 'sql', 0, 1, false, false, false, 2000); -insert into sys.args values (11760, 192, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (11761, 192, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (11762, 192, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (193, 'sql_sub', '-', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11763, 193, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (11764, 193, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.args values (11765, 193, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (194, 'sql_add', '+', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11766, 194, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (11767, 194, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.args values (11768, 194, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (195, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (11769, 195, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (11770, 195, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.args values (11771, 195, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (196, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
