Changeset: c25d7596c28a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c25d7596c28a
Modified Files:
monetdb5/modules/mal/Tests/inspect05.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
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/sys-schema/Tests/systemfunctions.stable.out
Branch: default
Log Message:
Approved output
diffs (truncated from 359 to 300 lines):
diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out
b/monetdb5/modules/mal/Tests/inspect05.stable.out
--- a/monetdb5/modules/mal/Tests/inspect05.stable.out
+++ b/monetdb5/modules/mal/Tests/inspect05.stable.out
@@ -79,25 +79,26 @@ stdout of test 'inspect05` in directory
[ 48@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1],
l:bat[:any_1]...):void ", "OIDXmerge;" ]
[ 49@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1],
pieces:int):void ", "OIDXcreate;" ]
[ 50@0, "orderidx", "pattern", "bat", "(bv:bat[:any_1]):void
", "OIDXcreate;" ]
-[ 51@0, "partition", "pattern", "bat", "(b:bat[:any_1],
pieces:int, n:int):bat[:any_1] ", "CMDBATpartition2;" ]
-[ 52@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
-[ 53@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
-[ 54@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
-[ 55@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1], force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
-[ 56@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1]):bat[:any_1] ", "BKCbat_inplace;" ]
-[ 57@0, "reuse", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1, force:bit):bat[:any_1] ", "BKCbun_inplace_force;" ]
-[ 58@0, "reuseMap", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
-[ 59@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
-[ 60@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
-[ 61@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
-[ 62@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
-[ 63@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
-[ 64@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
-[ 65@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
-[ 66@0, "setName", "command", "bat", "(b:bat[:any_1],
t:str):void ", "BKCsetColumn;" ]
-[ 67@0, "setPersistent", "command", "bat",
"(b:bat[:any_1], s:str):void ", "BKCsetName;" ]
-[ 68@0, "setTransient", "command", "bat", "(b:bat[:any_1],
mode:str):bat[:any_1] ", "BKCsetAccess;" ]
-[ 69@0, "single", "command", "bat", "(b:bat[:any_1],
mode:bit):bat[:any_1] ", "BKCsetkey;" ]
+[ 51@0, "pack", "pattern", "bat", "(X_0:any_2...):bat[:any_2] ",
"MATpackValues;" ]
+[ 52@0, "partition", "pattern", "bat", "(b:bat[:any_1],
pieces:int, n:int):bat[:any_1] ", "CMDBATpartition2;" ]
+[ 53@0, "partition", "pattern", "bat",
"(b:bat[:any_1]):bat[:any_1]... ", "CMDBATpartition;" ]
+[ 54@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:oid] ", "BKCreuseBATmap;" ]
+[ 55@0, "replace", "command", "bat", "(b:bat[:any_1],
del:bat[:oid]):bat[:any_1] ", "BKCreuseBAT;" ]
+[ 56@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1], force:bit):bat[:any_1] ",
"BKCbat_inplace_force;" ]
+[ 57@0, "replace", "command", "bat", "(b:bat[:any_1],
rid:bat[:oid], val:bat[:any_1]):bat[:any_1] ", "BKCbat_inplace;" ]
+[ 58@0, "reuse", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1, force:bit):bat[:any_1] ", "BKCbun_inplace_force;" ]
+[ 59@0, "reuseMap", "command", "bat", "(b:bat[:any_1], h:oid,
t:any_1):bat[:any_1] ", "BKCbun_inplace;" ]
+[ 60@0, "save", "pattern", "bat", "(val:any_1):bat[:any_1] ",
"CMDBATsingle;" ]
+[ 61@0, "save", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetImprints;" ]
+[ 62@0, "setAccess", "command", "bat", "(b:bat[:any_1]):bit ",
"BKCsetHash;" ]
+[ 63@0, "setColumn", "command", "bat", "(nme:str):bit ",
"BKCsave;" ]
+[ 64@0, "setHash", "command", "bat", "(nme:bat[:any_1]):void
", "BKCsave2;" ]
+[ 65@0, "setImprints", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetPersistent;" ]
+[ 66@0, "setKey", "command", "bat", "(b:bat[:any_1]):void
", "BKCsetTransient;" ]
+[ 67@0, "setName", "command", "bat", "(b:bat[:any_1],
t:str):void ", "BKCsetColumn;" ]
+[ 68@0, "setPersistent", "command", "bat",
"(b:bat[:any_1], s:str):void ", "BKCsetName;" ]
+[ 69@0, "setTransient", "command", "bat", "(b:bat[:any_1],
mode:str):bat[:any_1] ", "BKCsetAccess;" ]
+[ 70@0, "single", "command", "bat", "(b:bat[:any_1],
mode:bit):bat[:any_1] ", "BKCsetkey;" ]
# 08:55:30 >
# 08:55:30 > Done.
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
---
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
@@ -34,11 +34,10 @@ stdout of test 'duplicates-not-eliminate
% 1023 # length
function user.s4_0():void;
X_142:void := querylog.define("explain select sys.timestamp_to_str(case
when task0.\"sys_created_on\" >= \\'1999-10-31 09:00:00\\' and
task0.\"sys_created_on\" < \\'2000-04-02 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2000-04-02 10:00:00\\' and
task0.\"sys_created_on\" < \\'2000-10-29 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2000-10-29 09:00:00\\' and
task0.\"sys_created_on\" < \\'2001-04-01 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2001-04-01 10:00:00\\' and
task0.\"sys_created_on\" < \\'2001-10-28 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2001-10-28 09:00:00\\' and
task0.\"sys_created_on\" < \\'2002-04-07 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'
2002-04-07 10:00:00\\' and
- X_1608:bat[:str] := bat.new(nil:str);
- X_1614:bat[:int] := bat.new(nil:int);
- X_1612:bat[:int] := bat.new(nil:int);
- X_1611:bat[:str] := bat.new(nil:str);
- X_1610:bat[:str] := bat.new(nil:str);
+ X_1608:bat[:str] := bat.pack("sys.L1":str);
+ X_1609:bat[:str] := bat.pack("yearref":str);
+ X_1610:bat[:str] := bat.pack("clob":str);
+ X_1611:bat[:int] := bat.pack(0:int);
X_188:bat[:timestamp] := bat.new(nil:timestamp);
X_200:bat[:bit] := batcalc.between(X_188:bat[:timestamp], "1999-10-31
09:00:00.000000":timestamp, "2000-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
X_203:bat[:bit] := batcalc.isnil(X_200:bat[:bit]);
@@ -227,12 +226,7 @@ function user.s4_0():void;
X_1601:bat[:timestamp] := batcalc.ifthenelse(X_245:bat[:bit],
X_1458:bat[:timestamp], X_1600:bat[:timestamp]);
X_1602:bat[:timestamp] := batcalc.ifthenelse(X_217:bat[:bit],
X_1454:bat[:timestamp], X_1601:bat[:timestamp]);
X_1604:bat[:str] := mal.manifold("mtime":str, "timestamp_to_str":str,
X_1602:bat[:timestamp], "%Y":str);
- X_1615:bat[:str] := bat.append(X_1608:bat[:str], "sys.L1":str);
- X_1617:bat[:str] := bat.append(X_1610:bat[:str], "yearref":str);
- X_1619:bat[:str] := bat.append(X_1611:bat[:str], "clob":str);
- X_1621:bat[:int] := bat.append(X_1612:bat[:int], 0:int);
- X_1623:bat[:int] := bat.append(X_1614:bat[:int], 0:int);
- sql.resultSet(X_1615:bat[:str], X_1617:bat[:str], X_1619:bat[:str],
X_1621:bat[:int], X_1623:bat[:int], X_1604:bat[:str]);
+ sql.resultSet(X_1608:bat[:str], X_1609:bat[:str], X_1610:bat[:str],
X_1611:bat[:int], X_1611:bat[:int], X_1604:bat[:str]);
end user.s4_0;
#inline actions= 0 time=24 usec
#remap actions=230 time=419 usec
diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
--- a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
+++ b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
@@ -56,33 +56,34 @@ Operation successful
| X_45:bat[:int] := bat.pack(0:int);
|
| sql.resultSet(X_41:bat[:str], X_42:bat[:str], X_43:bat[:str],
X_44:bat[:int], X_45:bat[:int], X_39:bat[:str]); |
| end user.s4_0;
|
-| #inline actions= 0 time=2 usec
|
+| #inline actions= 0 time=1 usec
|
| #remap actions= 0 time=2 usec
|
-| #costmodel actions= 1 time=3 usec
|
-| #coercion actions= 1 time=7 usec
|
-| #aliases actions= 1 time=8 usec
|
-| #evaluate actions= 0 time=7 usec
|
-| #emptybind actions= 0 time=0 usec
|
-| #pushselect actions= 5 time=34 usec
|
-| #aliases actions= 2 time=8 usec
|
-| #mergetable actions= 0 time=51 usec
|
-| #deadcode actions= 3 time=14 usec
|
-| #aliases actions= 0 time=1 usec
|
-| #constants actions= 2 time=8 usec
|
-| #commonTerms actions= 0 time=10 usec
|
-| #projectionpath actions= 0 time=4 usec
|
-| #deadcode actions= 0 time=11 usec
|
-| #reorder actions= 1 time=31 usec
|
-| #matpack actions= 0 time=1 usec
|
-| #multiplex actions= 0 time=2 usec
|
-| #profiler actions= 1 time=1 usec
|
+| #costmodel actions= 1 time=2 usec
|
+| #coercion actions= 1 time=5 usec
|
+| #aliases actions= 1 time=6 usec
|
+| #evaluate actions= 0 time=5 usec
|
+| #emptybind actions= 0 time=1 usec
|
+| #pushselect actions= 5 time=29 usec
|
+| #aliases actions= 2 time=6 usec
|
+| #mergetable actions= 0 time=35 usec
|
+| #deadcode actions= 3 time=8 usec
|
+| #aliases actions= 0 time=0 usec
|
+| #constants actions= 2 time=6 usec
|
+| #commonTerms actions= 0 time=6 usec
|
+| #projectionpath actions= 0 time=3 usec
|
+| #deadcode actions= 0 time=6 usec
|
+| #reorder actions= 1 time=20 usec
|
+| #matpack actions= 0 time=0 usec
|
+| #multiplex actions= 0 time=1 usec
|
+| #profiler actions= 1 time=2 usec
|
| #candidates actions= 1 time=1 usec
|
-| #deadcode actions= 0 time=11 usec
|
+| #deadcode actions= 0 time=7 usec
|
+| #postfix actions= 0 time=5 usec
|
| #wlc actions= 0 time=0 usec
|
-| #garbagecollector actions= 1 time=54 usec
|
-| #total actions=27 time=413 usec
|
+| #garbagecollector actions= 1 time=27 usec
|
+| #total actions=27 time=273 usec
|
+------------------------------------------------------------------------------------------------------------------------+
-53 rows
+54 rows
# 15:11:18 >
# 15:11:18 > "Done."
diff --git a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
--- a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
+++ b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
@@ -78,31 +78,32 @@ Operation successful
| end user.s4_0;
|
| #inline actions= 0 time=1 usec
|
| #remap actions= 0 time=1 usec
|
-| #costmodel actions= 1 time=1 usec
|
-| #coercion actions= 1 time=4 usec
|
-| #aliases actions= 1 time=5 usec
|
-| #evaluate actions= 0 time=4 usec
|
+| #costmodel actions= 1 time=2 usec
|
+| #coercion actions= 1 time=5 usec
|
+| #aliases actions= 1 time=6 usec
|
+| #evaluate actions= 0 time=5 usec
|
| #emptybind actions= 0 time=0 usec
|
-| #pushselect actions= 5 time=20 usec
|
+| #pushselect actions= 5 time=24 usec
|
| #aliases actions= 2 time=5 usec
|
-| #mergetable actions= 0 time=24 usec
|
-| #deadcode actions= 9 time=8 usec
|
-| #aliases actions= 0 time=0 usec
|
-| #constants actions= 1 time=5 usec
|
-| #commonTerms actions= 0 time=3 usec
|
+| #mergetable actions= 0 time=30 usec
|
+| #deadcode actions= 9 time=9 usec
|
+| #aliases actions= 0 time=1 usec
|
+| #constants actions= 1 time=6 usec
|
+| #commonTerms actions= 0 time=5 usec
|
| #projectionpath actions= 0 time=2 usec
|
-| #deadcode actions= 0 time=5 usec
|
-| #reorder actions= 1 time=15 usec
|
-| #matpack actions= 0 time=0 usec
|
+| #deadcode actions= 0 time=6 usec
|
+| #reorder actions= 1 time=18 usec
|
+| #matpack actions= 0 time=1 usec
|
| #multiplex actions= 0 time=1 usec
|
-| #profiler actions= 1 time=0 usec
|
+| #profiler actions= 1 time=1 usec
|
| #candidates actions= 1 time=1 usec
|
-| #deadcode actions= 0 time=4 usec
|
+| #deadcode actions= 0 time=6 usec
|
+| #postfix actions= 0 time=4 usec
|
| #wlc actions= 0 time=0 usec
|
-| #garbagecollector actions= 1 time=15 usec
|
-| #total actions=27 time=194 usec
|
+| #garbagecollector actions= 1 time=26 usec
|
+| #total actions=27 time=244 usec
|
+--------------------------------------------------------------------------------------------------------------------+
-46 rows
+47 rows
# 16:04:05 >
# 16:04:05 > "Done."
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
@@ -194,7 +194,7 @@ function user.s10_0():void;
X_23:bat[:oid] := sql.delta(X_18:bat[:oid], X_21:bat[:oid],
X_22:bat[:oid], X_20:bat[:oid]);
X_24:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
C_32:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
- (X_34:bat[:oid], X_35:bat[:oid]) := algebra.join(X_24:bat[:oid],
C_32:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
+ X_34:bat[:oid] := algebra.join(X_24:bat[:oid], C_32:bat[:oid], nil:BAT,
nil:BAT, false:bit, nil:lng);
X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]);
X_42:bat[:int] := algebra.projection(X_34:bat[:oid], X_17:bat[:int]);
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
@@ -127,7 +127,7 @@ function user.s8_0():void;
X_23:bat[:oid] := sql.delta(X_18:bat[:oid], X_21:bat[:oid],
X_22:bat[:oid], X_20:bat[:oid]);
X_24:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
C_32:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
- (X_34:bat[:oid], X_35:bat[:oid]) := algebra.join(X_24:bat[:oid],
C_32:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
+ X_34:bat[:oid] := algebra.join(X_24:bat[:oid], C_32:bat[:oid], nil:BAT,
nil:BAT, false:bit, nil:lng);
X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]);
X_42:bat[:int] := algebra.projection(X_34:bat[:oid], X_17:bat[:int]);
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -242,7 +242,9 @@ stdout of test 'check` in directory 'sql
\dSf sys."setoptimizer"
\dSf sys."setprinttimeout"
\dSf sys."setquerytimeout"
+\dSf sys."setsession"
\dSf sys."setsessiontimeout"
+\dSf sys."settimeout"
\dSf sys."setworkerlimit"
\dSf sys."shpattach"
\dSf sys."shpload"
@@ -701,7 +703,9 @@ SYSTEM PROCEDURE sys.setmemorylim
SYSTEM PROCEDURE sys.setoptimizer
SYSTEM PROCEDURE sys.setprinttimeout
SYSTEM PROCEDURE sys.setquerytimeout
+SYSTEM PROCEDURE sys.setsession
SYSTEM PROCEDURE sys.setsessiontimeout
+SYSTEM PROCEDURE sys.settimeout
SYSTEM PROCEDURE sys.setworkerlimit
SYSTEM PROCEDURE sys.shpattach
SYSTEM PROCEDURE sys.shpload
@@ -1142,8 +1146,11 @@ create procedure sys.setoptimizer("sessi
create procedure sys.setprinttimeout("timeout" integer) external name
clients.setprinttimeout;
create procedure sys.setquerytimeout("query" int) external name
clients.setquerytimeout;
create procedure sys.setquerytimeout("sessionid" int, "query" int) external
name clients.setquerytimeout;
+create procedure sys.setsession("timeout" bigint) external name
clients.setsession;
create procedure sys.setsessiontimeout("sessionid" int, "query" int) external
name clients.setsessiontimeout;
create procedure sys.setsessiontimeout("timeout" int) external name
clients.setsessiontimeout;
+create procedure sys.settimeout("query" bigint) external name
clients.settimeout;
+create procedure sys.settimeout("query" bigint, "session" bigint) external
name clients.settimeout;
create procedure sys.setworkerlimit("limit" int) external name
clients.setworkerlimit;
create procedure sys.setworkerlimit("sessionid" int, "limit" int) external
name clients.setworkerlimit;
create procedure shpattach(fname string) external name shp.attach;
@@ -2162,7 +2169,7 @@ drop function pcre_replace(string, strin
% .s, .f, .L47, .L50, .f, .fl, .ft, .f, .f, .f,
.L51, .L52, .L53, .L54, .L55, .L56, .L57, .L60, .L61, .L62,
.L63, .L64, .L65, .L66, .L67, .L70, .L71, .L72, .L73, .L74,
.L75, .L76, .L77, .L100, .L101, .L102, .L103, .L104, .L105, .L106,
.L107, .L110, .L111, .L112, .L113, .L114, .L115, .L116, .L117, .L120,
.L121, .L122, .L123, .L124, .L125, .L126, .L127, .L130, .L131, .L132,
.L133, .L134, .L135, .L136, .L137, .L140, .L141, .L142, .L143, .L144,
.L145, .L146, .L147, .L150, .L151, .L152, .L153, .L154, .L155, .L156,
.L157, .L160, .L161, .L162, .L163, .L164, .L165, .L166, .L167, .L170 #
table_name
% name, name, system, query, mod, language_name,
function_type_name, side_effect, varres, vararg, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, char, varchar, varchar,
varchar, varchar, boolean, boolean, boolean,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char # type
-% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
12, 7, 2, 1, 3, 10, 14, 4, 1, 3,
8, 14, 2, 1, 3, 9, 7, 2, 1, 3,
10, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 2, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
+% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
9, 7, 2, 1, 3, 14, 14, 4, 1, 3,
12, 14, 2, 1, 3, 11, 7, 2, 1, 3,
11, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 1, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
[ "bam", "bam_drop_file", "SYSTEM", "create procedure
bam.bam_drop_file(file_id bigint, dbschema smallint) external name
bam.bam_drop_file;", "bam", "MAL", "Procedure", true, false,
false, "file_id", "bigint", 64, 0, "in", "dbschema",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "bam", "bam_export", "SYSTEM", "create procedure
bam.bam_export(output_path string) external name bam.bam_export;", "bam",
"MAL", "Procedure", true, false, false, "output_path", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "bam", "bam_flag", "SYSTEM", "create function
bam.bam_flag(flag smallint, name string) returns boolean external name
bam.bam_flag;", "bam", "MAL", "Scalar function", false, false, false,
"result", "boolean", 1, 0, "out", "flag", "smallint",
16, 0, "in", "name", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -3312,8 +3319,11 @@ drop function pcre_replace(string, strin
[ "sys", "setprinttimeout", "SYSTEM", "create procedure
sys.setprinttimeout(\"timeout\" integer) external name
clients.setprinttimeout;", "clients", "MAL", "Procedure", true,
false, false, "timeout", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "setquerytimeout", "SYSTEM", "create procedure
sys.setquerytimeout(\"query\" int) external name clients.setquerytimeout;",
"clients", "MAL", "Procedure", true, false, false, "query",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "setquerytimeout", "SYSTEM", "create procedure
sys.setquerytimeout(\"sessionid\" int, \"query\" int) external name
clients.setquerytimeout;", "clients", "MAL", "Procedure", true,
false, false, "sessionid", "int", 32, 0, "in", "query",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
+[ "sys", "setsession", "SYSTEM", "create procedure
sys.setsession(\"timeout\" bigint) external name clients.setsession;",
"clients", "MAL", "Procedure", true, false, false, "timeout",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "setsessiontimeout", "SYSTEM", "create procedure
sys.setsessiontimeout(\"sessionid\" int, \"query\" int) external name
clients.setsessiontimeout;", "clients", "MAL", "Procedure", true,
false, false, "sessionid", "int", 32, 0, "in", "query",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "setsessiontimeout", "SYSTEM", "create procedure
sys.setsessiontimeout(\"timeout\" int) external name
clients.setsessiontimeout;", "clients", "MAL", "Procedure", true,
false, false, "timeout", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys", "settimeout", "SYSTEM", "create procedure
sys.settimeout(\"query\" bigint) external name clients.settimeout;",
"clients", "MAL", "Procedure", true, false, false, "query",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys", "settimeout", "SYSTEM", "create procedure
sys.settimeout(\"query\" bigint, \"session\" bigint) external name
clients.settimeout;", "clients", "MAL", "Procedure", true,
false, false, "query", "bigint", 64, 0, "in",
"session", "bigint", 64, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "setworkerlimit", "SYSTEM", "create procedure
sys.setworkerlimit(\"limit\" int) external name clients.setworkerlimit;",
"clients", "MAL", "Procedure", true, false, false, "limit",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "setworkerlimit", "SYSTEM", "create procedure
sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name
clients.setworkerlimit;", "clients", "MAL", "Procedure", true,
false, false, "sessionid", "int", 32, 0, "in", "limit",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "shpattach", "SYSTEM", "create procedure
shpattach(fname string) external name shp.attach;", "shp", "MAL",
"Procedure", true, false, false, "fname", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -244,7 +244,9 @@ stdout of test 'check` in directory 'sql
\dSf sys."setoptimizer"
\dSf sys."setprinttimeout"
\dSf sys."setquerytimeout"
+\dSf sys."setsession"
\dSf sys."setsessiontimeout"
+\dSf sys."settimeout"
\dSf sys."setworkerlimit"
\dSf sys."shpattach"
\dSf sys."shpload"
@@ -705,7 +707,9 @@ SYSTEM PROCEDURE sys.setmemorylim
SYSTEM PROCEDURE sys.setoptimizer
SYSTEM PROCEDURE sys.setprinttimeout
SYSTEM PROCEDURE sys.setquerytimeout
+SYSTEM PROCEDURE sys.setsession
SYSTEM PROCEDURE sys.setsessiontimeout
+SYSTEM PROCEDURE sys.settimeout
SYSTEM PROCEDURE sys.setworkerlimit
SYSTEM PROCEDURE sys.shpattach
SYSTEM PROCEDURE sys.shpload
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
