Changeset: 5349f49b8f79 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5349f49b8f79 Added Files: sql/backends/monet5/Tests/basket00.stable.err sql/backends/monet5/Tests/basket00.stable.out sql/backends/monet5/Tests/cqstream00.stable.err sql/backends/monet5/Tests/cqstream00.stable.out sql/backends/monet5/Tests/cqstream01.stable.err sql/backends/monet5/Tests/cqstream01.stable.out sql/backends/monet5/Tests/cqstream02.stable.err sql/backends/monet5/Tests/cqstream02.stable.out sql/backends/monet5/Tests/cqstream03.stable.err sql/backends/monet5/Tests/cqstream03.stable.out sql/backends/monet5/Tests/cquery00.stable.err sql/backends/monet5/Tests/cquery00.stable.out sql/backends/monet5/Tests/cquery05.stable.err sql/backends/monet5/Tests/cquery05.stable.out sql/backends/monet5/Tests/cquery10.stable.err sql/backends/monet5/Tests/cquery10.stable.out Branch: timetrails Log Message:
Approve output diffs (truncated from 996 to 300 lines): diff --git a/sql/backends/monet5/Tests/basket00.stable.err b/sql/backends/monet5/Tests/basket00.stable.err new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/basket00.stable.err @@ -0,0 +1,34 @@ +stderr of test 'basket00` in directory 'sql/backends/monet5` itself: + + +# 13:08:26 > +# 13:08:26 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39158" "--set" "mapi_usock=/var/tmp/mtest-16206/.s.monetdb.39158" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:08:26 > + +# builtin opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/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 = 39158 +# cmdline opt mapi_usock = /var/tmp/mtest-16206/.s.monetdb.39158 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5 +# cmdline opt gdk_debug = 536870922 + +# 13:08:27 > +# 13:08:27 > "mclient" "-lmal" "-ftest" "-Eutf-8" "--host=/var/tmp/mtest-16206" "--port=39158" +# 13:08:27 > + + +# 13:08:27 > +# 13:08:27 > "Done." +# 13:08:27 > + diff --git a/sql/backends/monet5/Tests/basket00.stable.out b/sql/backends/monet5/Tests/basket00.stable.out new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/basket00.stable.out @@ -0,0 +1,36 @@ +stdout of test 'basket00` in directory 'sql/backends/monet5` itself: + + +# 13:08:26 > +# 13:08:26 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39158" "--set" "mapi_usock=/var/tmp/mtest-16206/.s.monetdb.39158" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:08:26 > + +# MonetDB 5 server v11.26.0 +# This is an unreleased version +# Serving database 'mTests_sql_backends_monet5', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://vienna.da.cwi.nl:39158/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-16206/.s.monetdb.39158 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 13:08:27 > +# 13:08:27 > "mclient" "-lmal" "-ftest" "-Eutf-8" "--host=/var/tmp/mtest-16206" "--port=39158" +# 13:08:27 > + +#--------------------------# +# t t t t t t t t t t # name +# void timestamp str str str int int int int str # type +#--------------------------# +#baskets table + +# 13:08:27 > +# 13:08:27 > "Done." +# 13:08:27 > + diff --git a/sql/backends/monet5/Tests/cqstream00.stable.err b/sql/backends/monet5/Tests/cqstream00.stable.err new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/cqstream00.stable.err @@ -0,0 +1,34 @@ +stderr of test 'cqstream00` in directory 'sql/backends/monet5` itself: + + +# 13:18:56 > +# 13:18:56 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33396" "--set" "mapi_usock=/var/tmp/mtest-6019/.s.monetdb.33396" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:18:56 > + +# builtin opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/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 = 33396 +# cmdline opt mapi_usock = /var/tmp/mtest-6019/.s.monetdb.33396 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5 +# cmdline opt gdk_debug = 536870922 + +# 13:18:56 > +# 13:18:56 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-6019" "--port=33396" +# 13:18:56 > + + +# 13:18:58 > +# 13:18:58 > "Done." +# 13:18:58 > + diff --git a/sql/backends/monet5/Tests/cqstream00.stable.out b/sql/backends/monet5/Tests/cqstream00.stable.out new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/cqstream00.stable.out @@ -0,0 +1,82 @@ +stdout of test 'cqstream00` in directory 'sql/backends/monet5` itself: + + +# 13:18:56 > +# 13:18:56 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33396" "--set" "mapi_usock=/var/tmp/mtest-6019/.s.monetdb.33396" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:18:56 > + +# MonetDB 5 server v11.28.0 +# This is an unreleased version +# Serving database 'mTests_sql_backends_monet5', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://vienna.da.cwi.nl:33396/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-6019/.s.monetdb.33396 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 13:18:56 > +# 13:18:56 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-6019" "--port=33396" +# 13:18:56 > + +#create stream table stmp2 (t timestamp, sensor integer, val decimal(8,2)) ; +#insert into stmp2 values('2005-09-23 12:34:26.000',1,11.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:27.000',1,11.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:28.000',1,13.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:28.000',1,13.0); +[ 1 ] +#create table result1(like stmp2); +#create table result2(like stmp2); +#create procedure cq_splitter() +#begin +# insert into result1 select * from stmp2 where val <12; +# insert into result2 select * from stmp2 where val >12; +#end; +#select * from cquery.status(); +% .L1, .L1, .L1, .L1, .L1 # table_name +% tick, schema, function, state, errors # name +% timestamp, clob, clob, clob, clob # type +% 26, 3, 11, 7, 0 # length +[ NULL, "sys", "cq_splitter", "waiting", "" ] +#select 'RESULT'; +% .L2 # table_name +% L2 # name +% char # type +% 6 # length +[ "RESULT" ] +#select * from stmp2; +% sys.stmp2, sys.stmp2, sys.stmp2 # table_name +% t, sensor, val # name +% timestamp, int, decimal # type +% 26, 1, 10 # length +#select val from result1; +% sys.result1 # table_name +% val # name +% decimal # type +% 10 # length +[ 11.00 ] +[ 11.00 ] +#select val from result2; +% sys.result2 # table_name +% val # name +% decimal # type +% 10 # length +[ 13.00 ] +[ 13.00 ] +#drop procedure cq_splitter; +#drop table stmp2; +#drop table result1; +#drop table result2; + +# 13:18:58 > +# 13:18:58 > "Done." +# 13:18:58 > + diff --git a/sql/backends/monet5/Tests/cqstream01.stable.err b/sql/backends/monet5/Tests/cqstream01.stable.err new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/cqstream01.stable.err @@ -0,0 +1,34 @@ +stderr of test 'cqstream01` in directory 'sql/backends/monet5` itself: + + +# 13:05:16 > +# 13:05:16 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30307" "--set" "mapi_usock=/var/tmp/mtest-22244/.s.monetdb.30307" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:05:16 > + +# builtin opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/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 = 30307 +# cmdline opt mapi_usock = /var/tmp/mtest-22244/.s.monetdb.30307 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5 +# cmdline opt gdk_debug = 536870922 + +# 13:05:17 > +# 13:05:17 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-22244" "--port=30307" +# 13:05:17 > + + +# 13:05:18 > +# 13:05:18 > "Done." +# 13:05:18 > + diff --git a/sql/backends/monet5/Tests/cqstream01.stable.out b/sql/backends/monet5/Tests/cqstream01.stable.out new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/Tests/cqstream01.stable.out @@ -0,0 +1,69 @@ +stdout of test 'cqstream01` in directory 'sql/backends/monet5` itself: + + +# 13:05:16 > +# 13:05:16 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30307" "--set" "mapi_usock=/var/tmp/mtest-22244/.s.monetdb.30307" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/mk/cquery//Linux/var/MonetDB/mTests_sql_backends_monet5" +# 13:05:16 > + +# MonetDB 5 server v11.28.0 +# This is an unreleased version +# Serving database 'mTests_sql_backends_monet5', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://vienna.da.cwi.nl:30307/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-22244/.s.monetdb.30307 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 13:05:17 > +# 13:05:17 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-22244" "--port=30307" +# 13:05:17 > + +#create stream table stmp2 (t timestamp, sensor integer, val decimal(8,2)) ; +#create table result2(like stmp2); +#insert into stmp2 values('2005-09-23 12:34:26.000',1,9.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:27.000',1,11.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:28.000',1,13.0); +[ 1 ] +#insert into stmp2 values('2005-09-23 12:34:28.000',1,15.0); +[ 1 ] +#create procedure cq_window() +#begin +# -- The window ensures a maximal number of tuples to consider +# -- Could be considered a property of the stream table +# call cquery.window('sys','stmp2',2); +# insert into result2 select * from stmp2 where val >12; +#end; +#select 'RESULT'; +% .L2 # table_name +% L2 # name +% char # type +% 6 # length +[ "RESULT" ] +#select val from stmp2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
