Changeset: 67ac4c2f5098 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/67ac4c2f5098
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
monetdb5/modules/mal/clients.c
sql/ChangeLog.Jul2021
sql/backends/monet5/sql_upgrades.c
sql/scripts/22_clients.sql
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
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
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
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.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.int128
Branch: Jul2021
Log Message:
Implemented function sys.current_sessionid().
diffs (truncated from 72739 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -8339,6 +8339,7 @@ stdout of test 'MAL-signatures` in direc
[ "clients", "changePassword", "pattern
clients.changePassword(X_0:str, X_1:str):void ", "CLTchangePassword;",
"" ]
[ "clients", "changeUsername", "pattern
clients.changeUsername(X_0:str, X_1:str):void ", "CLTchangeUsername;",
"" ]
[ "clients", "checkPermission", "pattern
clients.checkPermission(X_0:str, X_1:str):void ", "CLTcheckPermission;",
"" ]
+[ "clients", "current_sessionid", "pattern
clients.current_sessionid():int ", "CLTgetSessionID;", "" ]
[ "clients", "getId", "pattern clients.getId():int ",
"CLTgetClientId;", "" ]
[ "clients", "getInfo", "pattern clients.getInfo() (X_0:bat[:str],
X_1:bat[:str]) ", "CLTInfo;", "" ]
[ "clients", "getLogins", "command clients.getLogins() (X_0:bat[:oid],
X_1:bat[:str]) ", "CLTLogin;", "" ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -11625,6 +11625,7 @@ stdout of test 'MAL-signatures` in direc
[ "clients", "changePassword", "pattern
clients.changePassword(X_0:str, X_1:str):void ", "CLTchangePassword;",
"" ]
[ "clients", "changeUsername", "pattern
clients.changeUsername(X_0:str, X_1:str):void ", "CLTchangeUsername;",
"" ]
[ "clients", "checkPermission", "pattern
clients.checkPermission(X_0:str, X_1:str):void ", "CLTcheckPermission;",
"" ]
+[ "clients", "current_sessionid", "pattern
clients.current_sessionid():int ", "CLTgetSessionID;", "" ]
[ "clients", "getId", "pattern clients.getId():int ",
"CLTgetClientId;", "" ]
[ "clients", "getInfo", "pattern clients.getInfo() (X_0:bat[:str],
X_1:bat[:str]) ", "CLTInfo;", "" ]
[ "clients", "getLogins", "command clients.getLogins() (X_0:bat[:oid],
X_1:bat[:str]) ", "CLTLogin;", "" ]
diff --git a/monetdb5/modules/mal/clients.c b/monetdb5/modules/mal/clients.c
--- a/monetdb5/modules/mal/clients.c
+++ b/monetdb5/modules/mal/clients.c
@@ -968,6 +968,16 @@ bailout:
return msg;
}
+static str
+CLTgetSessionID(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci)
+{
+ (void) mb;
+ (void) stk;
+ (void) pci;
+ *getArgReference_int(stk,pci,0) = cntxt->idx;
+ return MAL_SUCCEED;
+}
+
#include "mel.h"
mel_func clients_init_funcs[] = {
pattern("clients", "setListing", CLTsetListing, false, "Turn on/off echo of
MAL instructions:\n1 - echo input,\n2 - show mal instruction,\n4 - show details
of type resolutoin, \n8 - show binding information.", args(1,2,
arg("",int),arg("flag",int))),
@@ -1019,6 +1029,7 @@ mel_func clients_init_funcs[] = {
pattern("clients", "setPassword", CLTsetPassword, false, "Set the password
for the given user", args(1,3, arg("",void),arg("user",str),arg("pass",str))),
pattern("clients", "checkPermission", CLTcheckPermission, false, "Check
permission for a user, requires hashed password (backendsum)", args(1,3,
arg("",void),arg("usr",str),arg("pw",str))),
pattern("clients", "getUsers", CLTgetUsers, false, "return a BAT with user id
and one with name available in the system", args(2,2,
batarg("",oid),batarg("",str))),
+ pattern("clients", "current_sessionid", CLTgetSessionID, false, "return
current session ID", args(1,1, arg("",int))),
{ .imp=NULL }
};
#include "mal_import.h"
diff --git a/sql/ChangeLog.Jul2021 b/sql/ChangeLog.Jul2021
--- a/sql/ChangeLog.Jul2021
+++ b/sql/ChangeLog.Jul2021
@@ -1,6 +1,11 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Tue May 11 2021 Sjoerd Mullender <[email protected]>
+- There is now a function sys.current_sessionid() to return the session
+ ID of the current session. This ID corresponds with the sessionid in
+ the sys.queue() result.
+
* Wed Apr 28 2021 Pedro Ferreira <[email protected]>
- Merge statements could not produce correct results on complex join
conditions, so a renovation was made. As a consequence, subqueries
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2377,6 +2377,13 @@ sql_update_jul2021(Client c, mvc *sql, c
"drop procedure
sys.reuse(string, string);\n"
"drop procedure
sys.vacuum(string, string);\n");
+ /* 22_clients.sql */
+ pos += snprintf(buf + pos, bufsize - pos,
+ "create function
sys.current_sessionid() returns int\n"
+ "external name
clients.current_sessionid;\n"
+ "grant execute on
function sys.current_sessionid to public;\n"
+ "update sys.functions
set system = true where system <> true and schema_id = 2000 and name =
'current_sessionid' = %d;\n", (int) F_FUNC);
+
/* 25_debug.sql */
pos += snprintf(buf + pos, bufsize - pos,
"drop procedure
sys.flush_log();\n");
diff --git a/sql/scripts/22_clients.sql b/sql/scripts/22_clients.sql
--- a/sql/scripts/22_clients.sql
+++ b/sql/scripts/22_clients.sql
@@ -127,3 +127,7 @@ grant execute on function sys.prepared_s
create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
grant select on sys.prepared_statements_args to public;
+
+create function sys.current_sessionid() returns int
+external name clients.current_sessionid;
+grant execute on function sys.current_sessionid to public;
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
@@ -323,3814 +323,3818 @@ insert into sys.functions values (107, '
insert into sys.args values (41605, 107, 'res_0', 'any', 0, 0, 0, 0);
insert into sys.args values (41606, 107, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (41607, 107, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (108, 'star', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.functions values (108, 'case', '', '', 0, 1, false, false,
false, 2000, true, true);
insert into sys.args values (41608, 108, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.functions values (109, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41609, 109, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41610, 109, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (41609, 108, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (41610, 108, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (109, 'star', '', '', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (41611, 109, 'res_0', 'any', 0, 0, 0, 0);
insert into sys.functions values (110, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41611, 110, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41612, 110, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (41612, 110, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41613, 110, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.functions values (111, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41613, 111, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41614, 111, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (41614, 111, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41615, 111, 'arg_1', 'smallint', 16, 0, 1, 1);
insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41615, 112, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41616, 112, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (41616, 112, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41617, 112, 'arg_1', 'int', 32, 0, 1, 1);
insert into sys.functions values (113, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41617, 113, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (41618, 113, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (41618, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41619, 113, 'arg_1', 'hugeint', 128, 0, 1, 1);
insert into sys.functions values (114, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41619, 114, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41620, 114, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (41620, 114, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (41621, 114, 'arg_1', 'bigint', 64, 0, 1, 1);
insert into sys.functions values (115, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41621, 115, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41622, 115, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (41622, 115, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41623, 115, 'arg_1', 'decimal', 2, 0, 1, 1);
insert into sys.functions values (116, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41623, 116, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41624, 116, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (41624, 116, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41625, 116, 'arg_1', 'decimal', 4, 0, 1, 1);
insert into sys.functions values (117, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41625, 117, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41626, 117, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (41626, 117, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41627, 117, 'arg_1', 'decimal', 9, 0, 1, 1);
insert into sys.functions values (118, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41627, 118, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41628, 118, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.functions values (119, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41629, 119, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41630, 119, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (41628, 118, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41629, 118, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.functions values (119, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41630, 119, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41631, 119, 'arg_1', 'decimal', 38, 0, 1, 1);
insert into sys.functions values (120, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41631, 120, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41632, 120, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (41632, 120, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41633, 120, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.functions values (121, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41633, 121, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41634, 121, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (41634, 121, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41635, 121, 'arg_1', 'smallint', 16, 0, 1, 1);
insert into sys.functions values (122, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41635, 122, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41636, 122, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (41636, 122, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41637, 122, 'arg_1', 'int', 32, 0, 1, 1);
insert into sys.functions values (123, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41637, 123, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41638, 123, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.functions values (124, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41639, 124, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (41640, 124, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (41641, 124, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.args values (41638, 123, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41639, 123, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.functions values (124, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41640, 124, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41641, 124, 'arg_1', 'hugeint', 128, 0, 1, 1);
insert into sys.functions values (125, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41642, 125, 'res_0', 'smallint', 16, 0, 0, 0);
-insert into sys.args values (41643, 125, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.args values (41644, 125, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.args values (41642, 125, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (41643, 125, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (41644, 125, 'arg_2', 'tinyint', 8, 0, 1, 2);
insert into sys.functions values (126, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41645, 126, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (41646, 126, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.args values (41647, 126, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (41645, 126, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (41646, 126, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (41647, 126, 'arg_2', 'smallint', 16, 0, 1, 2);
insert into sys.functions values (127, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41648, 127, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (41649, 127, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.args values (41650, 127, 'arg_2', 'bigint', 64, 0, 1, 2);
+insert into sys.args values (41648, 127, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (41649, 127, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (41650, 127, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.functions values (128, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41651, 128, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (41652, 128, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.args values (41653, 128, 'arg_2', 'hugeint', 128, 0, 1, 2);
+insert into sys.args values (41651, 128, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (41652, 128, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (41653, 128, 'arg_2', 'bigint', 64, 0, 1, 2);
insert into sys.functions values (129, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41654, 129, 'res_0', 'decimal', 2, 0, 0, 0);
-insert into sys.args values (41655, 129, 'arg_1', 'decimal', 2, 0, 1, 1);
-insert into sys.args values (41656, 129, 'arg_2', 'decimal', 2, 0, 1, 2);
+insert into sys.args values (41654, 129, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (41655, 129, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (41656, 129, 'arg_2', 'hugeint', 128, 0, 1, 2);
insert into sys.functions values (130, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41657, 130, 'res_0', 'decimal', 4, 0, 0, 0);
-insert into sys.args values (41658, 130, 'arg_1', 'decimal', 4, 0, 1, 1);
-insert into sys.args values (41659, 130, 'arg_2', 'decimal', 4, 0, 1, 2);
+insert into sys.args values (41657, 130, 'res_0', 'decimal', 2, 0, 0, 0);
+insert into sys.args values (41658, 130, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (41659, 130, 'arg_2', 'decimal', 2, 0, 1, 2);
insert into sys.functions values (131, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41660, 131, 'res_0', 'decimal', 9, 0, 0, 0);
-insert into sys.args values (41661, 131, 'arg_1', 'decimal', 9, 0, 1, 1);
-insert into sys.args values (41662, 131, 'arg_2', 'decimal', 9, 0, 1, 2);
+insert into sys.args values (41660, 131, 'res_0', 'decimal', 4, 0, 0, 0);
+insert into sys.args values (41661, 131, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (41662, 131, 'arg_2', 'decimal', 4, 0, 1, 2);
insert into sys.functions values (132, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41663, 132, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (41664, 132, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (41665, 132, 'arg_2', 'decimal', 18, 0, 1, 2);
+insert into sys.args values (41663, 132, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (41664, 132, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (41665, 132, 'arg_2', 'decimal', 9, 0, 1, 2);
insert into sys.functions values (133, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41666, 133, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (41667, 133, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (41668, 133, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.args values (41666, 133, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (41667, 133, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (41668, 133, 'arg_2', 'decimal', 18, 0, 1, 2);
insert into sys.functions values (134, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41669, 134, 'res_0', 'real', 24, 0, 0, 0);
-insert into sys.args values (41670, 134, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.args values (41671, 134, 'arg_2', 'real', 24, 0, 1, 2);
+insert into sys.args values (41669, 134, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (41670, 134, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (41671, 134, 'arg_2', 'decimal', 38, 0, 1, 2);
insert into sys.functions values (135, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (41672, 135, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (41673, 135, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.args values (41674, 135, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (136, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41675, 136, 'res_0', 'real', 24, 0, 0, 0);
-insert into sys.args values (41676, 136, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.functions values (137, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41677, 137, 'res_0', 'real', 24, 0, 0, 0);
-insert into sys.args values (41678, 137, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.functions values (138, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41679, 138, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (41680, 138, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (139, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41681, 139, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (41682, 139, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.functions values (140, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41683, 140, 'res_0', 'month_interval', 3, 0, 0,
0);
-insert into sys.args values (41684, 140, 'arg_1', 'month_interval', 3, 0, 1,
1);
+insert into sys.args values (41672, 135, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (41673, 135, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.args values (41674, 135, 'arg_2', 'real', 24, 0, 1, 2);
+insert into sys.functions values (136, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (41675, 136, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (41676, 136, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.args values (41677, 136, 'arg_2', 'double', 53, 0, 1, 2);
+insert into sys.functions values (137, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41678, 137, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (41679, 137, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.functions values (138, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41680, 138, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (41681, 138, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.functions values (139, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41682, 139, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (41683, 139, 'arg_1', 'double', 53, 0, 1, 1);
+insert into sys.functions values (140, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
+insert into sys.args values (41684, 140, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (41685, 140, 'arg_1', 'double', 53, 0, 1, 1);
insert into sys.functions values (141, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (41685, 141, 'res_0', 'day_interval', 4, 0, 0, 0);
-insert into sys.args values (41686, 141, 'arg_1', 'day_interval', 4, 0, 1, 1);
+insert into sys.args values (41686, 141, 'res_0', 'month_interval', 3, 0, 0,
0);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
