Changeset: 6656823fd5d0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6656823fd5d0
Removed Files:
        geom/sql/functions/Tests/ST_NumPoints.stable.err.Windows
Modified Files:
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
        sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
        
sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.oid32
Branch: default
Log Message:

Approvals.


diffs (238 lines):

diff --git a/geom/sql/functions/Tests/ST_NumPoints.stable.err.Windows 
b/geom/sql/functions/Tests/ST_NumPoints.stable.err.Windows
deleted file mode 100644
--- a/geom/sql/functions/Tests/ST_NumPoints.stable.err.Windows
+++ /dev/null
@@ -1,42 +0,0 @@
-stderr of test 'ST_NumPoints` in directory 'geom/sql/functions` itself:
-
-
-# 09:53:35 >  
-# 09:53:35 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=30630" "--set" 
"mapi_usock=/var/tmp/mtest-31357/.s.monetdb.30630" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_functions"
 "--set" "mal_listing=0"
-# 09:53:35 >  
-
-# builtin opt  gdk_dbpath = 
/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/monetdb5/dbfarm/demo
-# builtin opt  gdk_debug = 0
-# builtin opt  gdk_vmtrim = no
-# builtin opt  monet_prompt = >
-# builtin opt  monet_daemon = no
-# builtin opt  mapi_port = 50000
-# builtin opt  mapi_open = false
-# builtin opt  mapi_autosense = false
-# builtin opt  sql_optimizer = default_pipe
-# builtin opt  sql_debug = 0
-# cmdline opt  gdk_nr_threads = 0
-# cmdline opt  mapi_open = true
-# cmdline opt  mapi_port = 30630
-# cmdline opt  mapi_usock = /var/tmp/mtest-31357/.s.monetdb.30630
-# cmdline opt  monet_prompt = 
-# cmdline opt  mal_listing = 2
-# cmdline opt  gdk_dbpath = 
/export/scratch1/alvanaki/INSTALL/MonetDB-public/var/MonetDB/mTests_geom_sql_Tests_functions
-# cmdline opt  mal_listing = 0
-# cmdline opt  gdk_debug = 536870922
-
-# 09:53:35 >  
-# 09:53:35 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-31357" "--port=30630"
-# 09:53:35 >  
-
-MAPI  = (monetdb) /var/tmp/mtest-30133/.s.monetdb.37873
-QUERY = SELECT ST_NumPoints(ST_GeomFromText('polygon((77.29 29.07,77.42 
29.26,77.27 29.31,77.29 29.07))'));
-ERROR = !Geometry "POLYGON ((77.2900000000000060 29.0700000000000000, 
77.4200000000000020 29.2600000000000020, 77.2699999999999960 
29.3099999999999990, 77.2900000000000060 29.0700000000000000))" not a LineString
-MAPI  = (monetdb) /var/tmp/mtest-30133/.s.monetdb.37873
-QUERY = select st_numPoints(st_mpointFromText('multipoint(1 2 3, 4 5 6, 7 8 9, 
10 11 12)'));
-ERROR = !Geometry "MULTIPOINT Z (1.0000000000000000 2.0000000000000000 
3.0000000000000000, 4.0000000000000000 5.0000000000000000 6.0000000000000000, 
7.0000000000000000 8.0000000000000000 9.0000000000000000, 10.0000000000000000 
11.0000000000000000 12.0000000000000000)" not a LineString
-
-# 09:53:35 >  
-# 09:53:35 >  "Done."
-# 09:53:35 >  
-
diff --git 
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
 
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
--- 
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
+++ 
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
@@ -55,24 +55,24 @@ Ready.
 % .L # table_name
 % def # name
 % clob # type
-% 449 # length
-[ 
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();"
  ]
+% 541 # length
+[ 
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.garbageCollector();"
      ]
 #explain copy into ttt from 'a:\tmp/xyz';
 % .explain # table_name
 % mal # name
 % clob # type
-% 136 # length
-function user.s4_1{autoCommit=true}():void;
-    X_26:void := querylog.define("explain copy into ttt from 
\\'a:\\\\tmp/xyz\\';","default_pipe",12);
-barrier X_35 := language.dataflow();
-    X_2 := sql.mvc();
-    (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","a:\\tmp/xyz",-1,0,0,0);
-exit X_35;
-    X_15 := sql.append(X_2,"sys","ttt","a",X_12);
-    X_19 := sql.append(X_15,"sys","ttt","b",X_13);
-    X_21 := sql.append(X_19,"sys","ttt","c",X_14);
-    X_23 := aggr.count(X_14);
-    sql.affectedRows(X_21,X_23,"");
+% 121 # length
+function user.s4_1():void;
+    X_24:void := querylog.define("explain copy into ttt from 
\\'a:\\\\tmp/xyz\\';","default_pipe",12);
+barrier X_34 := language.dataflow();
+    X_1 := sql.mvc();
+    (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","a:\\tmp/xyz",-1,0,0,0);
+exit X_34;
+    X_14 := sql.append(X_1,"sys","ttt","a",X_11);
+    X_18 := sql.append(X_14,"sys","ttt","b",X_12);
+    X_20 := sql.append(X_18,"sys","ttt","c",X_13);
+    X_22 := aggr.count(X_13);
+    sql.affectedRows(X_20,X_22);
 end user.s4_1;
 #declare opt_pipe_name string;
 #set opt_pipe_name = ( select optimizer );
@@ -89,24 +89,24 @@ end user.s4_1;
 % .L # table_name
 % def # name
 % clob # type
-% 472 # length
-[ 
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.sql_append();optimizer.garbageCollector();"
   ]
+% 564 # length
+[ 
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.sql_append();optimizer.garbageCollector();"
       ]
 #explain copy into ttt from 'Z:/tmp/xyz';
 % .explain # table_name
 % mal # name
 % clob # type
-% 135 # length
-function user.s12_1{autoCommit=true}():void;
-    X_26:void := querylog.define("explain copy into ttt from 
\\'Z:/tmp/xyz\\';","user_1",12);
-barrier X_36 := language.dataflow();
-    X_2 := sql.mvc();
-    (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","Z:/tmp/xyz",-1,0,0,0);
-exit X_36;
-    X_15 := sql.append(X_2,"sys","ttt","a",X_12);
-    X_19 := sql.append(X_15,"sys","ttt","b",X_13);
-    X_23 := aggr.count(X_14);
-    X_21 := sql.append(X_19,"sys","ttt","c",X_14);
-    sql.affectedRows(X_21,X_23,"");
+% 120 # length
+function user.s12_1():void;
+    X_24:void := querylog.define("explain copy into ttt from 
\\'Z:/tmp/xyz\\';","user_1",12);
+barrier X_35 := language.dataflow();
+    X_1 := sql.mvc();
+    (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","Z:/tmp/xyz",-1,0,0,0);
+exit X_35;
+    X_14 := sql.append(X_1,"sys","ttt","a",X_11);
+    X_18 := sql.append(X_14,"sys","ttt","b",X_12);
+    X_22 := aggr.count(X_13);
+    X_20 := sql.append(X_18,"sys","ttt","c",X_13);
+    sql.affectedRows(X_20,X_22);
 end user.s12_1;
 #drop table ttt;
 
diff --git a/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit 
b/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
@@ -59,9 +59,9 @@ Ready.
 % .explain # table_name
 % mal # name
 % clob # type
-% 598 # length
+% 555 # length
 function 
user.s2_1(A0:str,A1:str,A2:int,A3:int,A4:int,A5:int,A6:int,A7:int,A8:int,A9:int,A10:str):void;
-    X_190:void := querylog.define("explain 
select\n\tp_brand,\n\tp_type,\n\tp_size,\n\tcount(distinct ps_suppkey) as 
supplier_cnt\nfrom\n\tpartsupp,\n\tpart\nwhere\n\tp_partkey = ps_partkey\n\tand 
p_brand <> \\'Brand#45\\'\n\tand p_type not like \\'MEDIUM POLISHED%\\'\n\tand 
p_size in (49, 14, 23, 45, 19, 3, 36, 9)\n\tand ps_suppkey not in 
(\n\t\tselect\n\t\t\ts_suppkey\n\t\tfrom\n\t\t\tsupplier\n\t\twhere\n\t\t\ts_comment
 like \\'%Customer%Complaints%\\'\n\t)\ngroup 
by\n\tp_brand,\n\tp_type,\n\tp_size\norder by\n\tsupplier_cnt 
desc,\n\tp_brand,\n\tp_type,\n\tp_size;","sequential_pipe",118);
+    X_190:void := querylog.define("explain select\n p_brand,\n p_type,\n 
p_size,\n count(distinct ps_suppkey) as supplier_cnt\nfrom\n partsupp,\n 
part\nwhere\n p_partkey = ps_partkey\n and p_brand <> \\'Brand#45\\'\n and 
p_type not like \\'MEDIUM POLISHED%\\'\n and p_size in (49, 14, 23, 45, 19, 3, 
36, 9)\n and ps_suppkey not in (\n select\n s_suppkey\n from\n supplier\n 
where\n s_comment like \\'%Customer%Complaints%\\'\n )\ngroup by\n p_brand,\n 
p_type,\n p_size\norder by\n supplier_cnt desc,\n p_brand,\n p_type,\n 
p_size;","sequential_pipe",118);
     X_152 := bat.new(nil:oid,nil:str);
     X_160 := bat.append(X_152,"sys.part");
     X_168 := bat.append(X_160,"sys.part");
diff --git a/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit 
b/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
@@ -65,7 +65,7 @@ Ready.
 % clob # type
 % 618 # length
 function user.s2_1(A0:str,A1:bte,A2:date,A3:date,A4:int,A5:str):void;
-    X_211:void := querylog.define("explain select\n s_name,\n 
s_address\nfrom\n supplier,\n nation\nwhere\n s_suppkey in (\n select\n 
ps_suppkey\n from\n partsupp\n where\n ps_partkey in (\n select\n p_partkey\n 
from\n part\n where\n p_name like \\'forest%\\'\n )\n and ps_availqty > (\n 
select\n 0.5 * sum(l_quantity)\n from\n lineitem\n where\n l_partkey = 
ps_partkey\n and l_suppkey = ps_suppkey\n and l_shipdate >= date 
\\'1994-01-01\\'\n and l_shipdate < date \\'1994-01-01\\' + interval \\'1\\' 
year\n )\n )\n and s_nationkey = n_nationkey\n and n_name = \\'CANADA\\'\norder 
by\n s_name;","sequential_pipe",144);
+    X_211:void := querylog.define("explain select\n s_name,\n 
s_address\nfrom\n supplier,\n nation\nwhere\n s_suppkey in (\n select\n 
ps_suppkey\n from\n partsupp\n where\n ps_partkey in (\n select\n p_partkey\n 
from\n part\n where\n p_name like \\'forest%\\'\n )\n and ps_availqty > (\n 
select\n 0.5 * sum(l_quantity)\n from\n lineitem\n where\n l_partkey = 
ps_partkey\n and l_suppkey = ps_suppkey\n and l_shipdate >= date 
\\'1994-01-01\\'\n and l_shipdate < date \\'1994-01-01\\' + interval \\'1\\' 
year\n )\n )\n and s_nationkey = n_nationkey\n and n_name = \\'CANADA\\'\norder 
by\n s_name;","sequential_pipe",142);
     X_188 := bat.new(nil:oid,nil:str);
     X_196 := bat.append(X_188,"sys.supplier");
     X_204 := bat.append(X_196,"sys.supplier");
@@ -110,12 +110,11 @@ function user.s2_1(A0:str,A1:bte,A2:date
     X_51:bat[:int] := algebra.projectionpath(C_42,C_32,X_50);
     (X_52,r1_55) := algebra.subjoin(X_30,X_51,nil:BAT,nil:BAT,false,nil:lng);
     C_55 := algebra.subinter(X_31,X_52,nil:BAT,nil:BAT,false,nil:lng);
-    X_220:bat[:oid] := algebra.projection(C_55,C_22);
     X_56:bat[:wrd] := 
sql.bind_idxbat(X_7,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
     (X_58,r1_61) := 
sql.bind_idxbat(X_7,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",2);
     X_60:bat[:wrd] := 
sql.bind_idxbat(X_7,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
     X_61 := sql.delta(X_56,X_58,r1_61,X_60);
-    X_62:bat[:wrd] := algebra.projection(X_220,X_61);
+    X_62:bat[:wrd] := algebra.projectionpath(C_55,C_22,X_61);
     C_63:bat[:oid] := sql.tid(X_7,"sys","lineitem");
     X_65:bat[:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",0);
     (C_67,r1_71) := sql.bind(X_7,"sys","lineitem","l_shipdate",2);
@@ -147,7 +146,7 @@ function user.s2_1(A0:str,A1:bte,A2:date
     (C_102,r1_125) := sql.bind(X_7,"sys","partsupp","ps_suppkey",2);
     X_104:bat[:int] := sql.bind(X_7,"sys","partsupp","ps_suppkey",1);
     X_105 := sql.delta(X_100,C_102,r1_125,X_104);
-    X_106:bat[:int] := algebra.projection(X_220,X_105);
+    X_106:bat[:int] := algebra.projectionpath(C_55,C_22,X_105);
     X_107 := algebra.projection(X_99,X_106);
     X_108 := algebra.projection(C_98,r1_106);
     X_109 := algebra.projection(X_108,X_90);
diff --git a/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit 
b/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
@@ -62,7 +62,7 @@ Ready.
 % clob # type
 % 729 # length
 function user.s2_1(A0:str,A1:str):void;
-    X_176:void := querylog.define("explain select\n s_name,\n count(*) as 
numwait\nfrom\n supplier,\n lineitem l1,\n orders,\n nation\nwhere\n s_suppkey 
= l1.l_suppkey\n and o_orderkey = l1.l_orderkey\n and o_orderstatus = \\'F\\'\n 
and l1.l_receiptdate > l1.l_commitdate\n and exists (\n select\n *\n from\n 
lineitem l2\n where\n l2.l_orderkey = l1.l_orderkey\n and l2.l_suppkey <> 
l1.l_suppkey\n )\n and not exists (\n select\n *\n from\n lineitem l3\n where\n 
l3.l_orderkey = l1.l_orderkey\n and l3.l_suppkey <> l1.l_suppkey\n and 
l3.l_receiptdate > l3.l_commitdate\n )\n and s_nationkey = n_nationkey\n and 
n_name = \\'SAUDI ARABIA\\'\ngroup by\n s_name\norder by\n numwait desc,\n 
s_name\nlimit 100;","sequential_pipe",121);
+    X_176:void := querylog.define("explain select\n s_name,\n count(*) as 
numwait\nfrom\n supplier,\n lineitem l1,\n orders,\n nation\nwhere\n s_suppkey 
= l1.l_suppkey\n and o_orderkey = l1.l_orderkey\n and o_orderstatus = \\'F\\'\n 
and l1.l_receiptdate > l1.l_commitdate\n and exists (\n select\n *\n from\n 
lineitem l2\n where\n l2.l_orderkey = l1.l_orderkey\n and l2.l_suppkey <> 
l1.l_suppkey\n )\n and not exists (\n select\n *\n from\n lineitem l3\n where\n 
l3.l_orderkey = l1.l_orderkey\n and l3.l_suppkey <> l1.l_suppkey\n and 
l3.l_receiptdate > l3.l_commitdate\n )\n and s_nationkey = n_nationkey\n and 
n_name = \\'SAUDI ARABIA\\'\ngroup by\n s_name\norder by\n numwait desc,\n 
s_name\nlimit 100;","sequential_pipe",120);
     X_151 := bat.new(nil:oid,nil:str);
     X_159 := bat.append(X_151,"sys.supplier");
     X_167 := bat.append(X_159,"sys.L1");
@@ -136,17 +136,16 @@ function user.s2_1(A0:str,A1:str):void;
     (X_88,r1_98) := algebra.subjoin(X_76,X_87,nil:BAT,nil:BAT,false,nil:lng);
     X_90:bat[:int] := algebra.projectionpath(X_88,r1_74,X_67);
     X_91 := bat.mirror(X_90);
-    X_186:bat[:oid] := algebra.projection(X_88,X_68);
     X_92:bat[:int] := sql.bind(X_3,"sys","lineitem","l_orderkey",0);
     (C_94,r1_108) := sql.bind(X_3,"sys","lineitem","l_orderkey",2);
     X_96:bat[:int] := sql.bind(X_3,"sys","lineitem","l_orderkey",1);
     X_97 := sql.delta(X_92,C_94,r1_108,X_96);
     X_98 := algebra.projection(C_4,X_97);
     X_99 := algebra.projection(C_25,X_98);
-    X_100:bat[:int] := algebra.projectionpath(X_186,X_46,X_99);
+    X_100:bat[:int] := algebra.projectionpath(X_88,X_68,X_46,X_99);
     (X_101,r1_125) := 
algebra.subjoin(X_100,X_98,nil:BAT,nil:BAT,false,nil:lng);
     X_103 := algebra.projection(r1_125,X_56);
-    X_104:bat[:int] := algebra.projection(X_186,X_58);
+    X_104:bat[:int] := algebra.projectionpath(X_88,X_68,X_58);
     X_105 := algebra.projection(X_101,X_104);
     X_106:bat[:bit] := batcalc.!=(X_103,X_105);
     C_107 := algebra.subselect(X_106,true,true,true,true,false);
diff --git a/sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit 
b/sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
@@ -58,7 +58,7 @@ Ready.
 % clob # type
 % 710 # length
 function 
user.s2_1(A0:int,A1:int,A2:int,A3:int,A4:str,A5:str,A6:str,A7:str,A8:str,A9:str,A10:str,A11:bte,A12:int,A13:int,A14:str,A15:str,A16:str,A17:str,A18:str,A19:str,A20:str):void;
-    X_160:void := querylog.define("explain select\n cntrycode,\n count(*) as 
numcust,\n sum(c_acctbal) as totacctbal\nfrom\n (\n select\n substring(c_phone 
from 1 for 2) as cntrycode,\n c_acctbal\n from\n customer\n where\n 
substring(c_phone from 1 for 2) in\n (\\'13\\', \\'31\\', \\'23\\', \\'29\\', 
\\'30\\', \\'18\\', \\'17\\')\n and c_acctbal > (\n select\n avg(c_acctbal)\n 
from\n customer\n where\n c_acctbal > 0.00\n and substring(c_phone from 1 for 
2) in\n (\\'13\\', \\'31\\', \\'23\\', \\'29\\', \\'30\\', \\'18\\', 
\\'17\\')\n )\n and not exists (\n select\n *\n from\n orders\n where\n 
o_custkey = c_custkey\n )\n ) as custsale\ngroup by\n cntrycode\norder by\n 
cntrycode;","sequential_pipe",102);
+    X_160:void := querylog.define("explain select\n cntrycode,\n count(*) as 
numcust,\n sum(c_acctbal) as totacctbal\nfrom\n (\n select\n substring(c_phone 
from 1 for 2) as cntrycode,\n c_acctbal\n from\n customer\n where\n 
substring(c_phone from 1 for 2) in\n (\\'13\\', \\'31\\', \\'23\\', \\'29\\', 
\\'30\\', \\'18\\', \\'17\\')\n and c_acctbal > (\n select\n avg(c_acctbal)\n 
from\n customer\n where\n c_acctbal > 0.00\n and substring(c_phone from 1 for 
2) in\n (\\'13\\', \\'31\\', \\'23\\', \\'29\\', \\'30\\', \\'18\\', 
\\'17\\')\n )\n and not exists (\n select\n *\n from\n orders\n where\n 
o_custkey = c_custkey\n )\n ) as custsale\ngroup by\n cntrycode\norder by\n 
cntrycode;","sequential_pipe",101);
     X_126 := bat.new(nil:oid,nil:str);
     X_134 := bat.append(X_126,"sys.custsale");
     X_142 := bat.append(X_134,"sys.L2");
diff --git 
a/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.oid32
 
b/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.oid32
--- 
a/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.oid32
+++ 
b/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.oid32
@@ -79,10 +79,9 @@ stderr of test 'offset_limited_32bit.SF-
 # 09:37:07 >  mclient -lsql -ftest -i -e --host=alf --port=33568 
 # 09:37:07 >  
 
-MAPI  = monetdb@maggie:35536
+MAPI  = monetdb@WIN2012:39044
 QUERY = SELECT * from tables OFFSET 2147483647; -- never finishes
-ERROR = !GDK reported error.
-        !CMDslice: argument out of range
+ERROR = !Illegal argument
 
 # 09:37:07 >  
 # 09:37:07 >  Done.
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to