Changeset: 269419c6653a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=269419c6653a Added Files: sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out.single Branch: Jul2017 Log Message:
Approve single-thread output. diffs (122 lines): diff --git a/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out.single b/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out.single new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out.single @@ -0,0 +1,117 @@ +stdout of test 'side-effect.Bug-6397` in directory 'sql/test/BugTracker-2017` itself: + + +# 10:56:59 > +# 10:56:59 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34093" "--set" "mapi_usock=/var/tmp/mtest-13037/.s.monetdb.34093" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2017" +# 10:56:59 > + +# MonetDB 5 server v11.27.6 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 7.330 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.nes.nl:34093/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-13037/.s.monetdb.34093 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 10:57:00 > +# 10:57:00 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13037" "--port=34093" +# 10:57:00 > + +#CREATE FUNCTION my_generate_series(start INT, finish INT) +#RETURNS TABLE (value INT) +#BEGIN +# DECLARE TABLE tmp_generate_series(value INT); +# DECLARE i INT; +# SET i = start; +# WHILE (i <= finish) DO +# INSERT INTO tmp_generate_series VALUES(i); +# SET i = i + 1; +# END WHILE; +# RETURN tmp_generate_series; +#END; +#explain select count(*) from my_generate_series(1,5) as t1, +#my_generate_series(1,100) as t2; +% .explain # table_name +% mal # name +% clob # type +% 153 # length +function user.s4_1():void; + X_5:void := querylog.define("explain select count(*) from my_generate_series(1,5) as t1,\nmy_generate_series(1,100) as t2;", "default_pipe", 33:int); + X_31 := bat.new(nil:str); + X_37 := bat.new(nil:int); + X_35 := bat.new(nil:int); + X_34 := bat.new(nil:str); + X_33 := bat.new(nil:str); + X_13:bat[:int] := user.my_generate_series(1:int, 5:int); + X_14 := aggr.count(X_13); + X_21 := sql.single(X_14); + X_19:bat[:int] := user.my_generate_series(1:int, 100:int); + X_20 := aggr.count(X_19); + X_22 := sql.single(X_20); + (X_23, X_24) := algebra.crossproduct(X_21, X_22); + X_25 := algebra.projection(X_23, X_21); + X_26 := algebra.projection(X_24, X_22); + X_27:bat[:lng] := batcalc.*(X_25, X_26); + X_38 := bat.append(X_31, ".L10"); + X_40 := bat.append(X_33, "L7"); + X_42 := bat.append(X_34, "bigint"); + X_44 := bat.append(X_35, 64:int); + X_46 := bat.append(X_37, 0:int); + sql.resultSet(X_38, X_40, X_42, X_44, X_46, X_27); +end user.s4_1; +#inline actions= 0 time=4 usec +#remap actions= 1 time=35 usec +#costmodel actions= 1 time=17 usec +#coercion actions= 0 time=4 usec +#evaluate actions= 8 time=51 usec +#emptybind actions= 0 time=1 usec +#pushselect actions= 0 time=8 usec +#aliases actions= 8 time=11 usec +#mergetable actions= 0 time=67 usec +#deadcode actions= 1 time=10 usec +#aliases actions= 0 time=1 usec +#constants actions= 4 time=10 usec +#commonTerms actions= 0 time=7 usec +#projectionpath actions= 0 time=6 usec +#deadcode actions= 0 time=7 usec +#reorder actions= 1 time=41 usec +#matpack actions= 0 time=0 usec +#dataflow actions= 1 time=27 usec +#multiplex actions= 0 time=3 usec +#profiler actions=1 time=2 usec +#candidates actions=1 time=2 usec +#garbagecollector actions= 1 time=85 usec +#total actions=25 time=547 usec +#select count(*) from my_generate_series(1,5) as t1, +#my_generate_series(1,100) as t2; +% .L10 # table_name +% L7 # name +% bigint # type +% 3 # length +[ 500 ] +#select count(*) from my_generate_series(1,5) as t1, +#my_generate_series(1,100) as t2; +% .L10 # table_name +% L7 # name +% bigint # type +% 3 # length +[ 500 ] +#select count(*) from my_generate_series(1,5) as t1, +#my_generate_series(1,100) as t2; +% .L10 # table_name +% L7 # name +% bigint # type +% 3 # length +[ 500 ] + +# 10:57:00 > +# 10:57:00 > "Done." +# 10:57:00 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
