Changeset: 6264e0e23a6d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6264e0e23a6d Added Files: sql/test/mosaic/Tests/join.options5 sql/test/mosaic/Tests/join.sql sql/test/mosaic/Tests/join.stable.err sql/test/mosaic/Tests/join.stable.out Branch: mosaic Log Message:
Add missing test files. diffs (truncated from 12581 to 300 lines): diff --git a/sql/test/mosaic/Tests/join.options5 b/sql/test/mosaic/Tests/join.options5 new file mode 100644 --- /dev/null +++ b/sql/test/mosaic/Tests/join.options5 @@ -0,0 +1,1 @@ +--debug=2097152 diff --git a/sql/test/mosaic/Tests/join.sql b/sql/test/mosaic/Tests/join.sql new file mode 100644 --- /dev/null +++ b/sql/test/mosaic/Tests/join.sql @@ -0,0 +1,58 @@ +START TRANSACTION; + +set optimizer='mosaic_pipe'; + +create table tmp3( i int, b boolean, f real,t timestamp); +insert into tmp3 values +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(2, false, 0.314,'2014-08-23 11:34:54.000000'), +(3, true, 0.314,'2014-08-23 11:34:54.000000'), +(2, false, 0.314,'2014-08-23 11:34:54.000000'), +(3, true, 0.314,'2014-08-23 11:34:54.000000'), +(2, false, 0.314,'2014-08-23 11:34:54.000000'), +(3, true, 0.314,'2014-08-23 11:34:54.000000'), +(4, true, 0.316,'2014-08-23 11:34:54.000000'), +(4, true, 0.316,'2014-08-23 11:34:54.000000'), +(4, false, 0.316,'2014-08-23 11:34:54.000000'), +(0, false, 0.316,'2014-08-23 11:34:54.000000'), +(5, false, 0.317,'2014-08-23 11:34:54.000000'), +(6, false, 0.317,'2014-08-23 11:34:54.000000'), +(7, false, 0.317,'2014-08-23 11:34:54.000000'), +(8, false, 0.317,'2014-08-23 11:34:54.000000'), +(9, false, 0.317,'2014-08-23 11:34:54.000000'); + + +alter table tmp3 set read only; + +alter table tmp3 alter column i set storage 'delta'; + +create table tmp4( i int, b boolean, f real,t timestamp); +insert into tmp4 values +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(3, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(4, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(5, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'), +(1, true, 0.314,'2014-08-23 11:34:54.000000'); + +explain select tmp3.i, tmp4.i from tmp3, tmp4 where tmp3.i = tmp4.i; +select tmp3.i, tmp4.i from tmp3, tmp4 where tmp3.i = tmp4.i; + +set optimizer = 'mosaiccoui_pipe'; + +explain select tmp3.i, tmp4.i from tmp3, tmp4 where tmp3.i = tmp4.i; +select tmp3.i, tmp4.i from tmp3, tmp4 where tmp3.i = tmp4.i; + +ROLLBACK; diff --git a/sql/test/mosaic/Tests/join.stable.err b/sql/test/mosaic/Tests/join.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/mosaic/Tests/join.stable.err @@ -0,0 +1,12191 @@ +stderr of test 'join` in directory 'sql/test/mosaic` itself: + + +# 13:25:01 > +# 13:25:01 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32105" "--set" "mapi_usock=/var/tmp/mtest-27046/.s.monetdb.32105" "--forcemito" "--dbpath=/home/aris/sources/monetdb/build/installation/var/MonetDB/mTests_sql_test_mosaic" "--debug=2097152" "--set" "embedded_c=true" +# 13:25:01 > + +# builtin opt gdk_dbpath = /home/aris/sources/monetdb/build/installation/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_ipv6 = 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 = 32105 +# cmdline opt mapi_usock = /var/tmp/mtest-27046/.s.monetdb.32105 +# cmdline opt gdk_dbpath = /home/aris/sources/monetdb/build/installation/var/MonetDB/mTests_sql_test_mosaic +# cmdline opt embedded_c = true +#COLnew()=tmp_21#0@0[str]TSRN +#COLnew()=tmp_313#0@0[str]TSRN +#BAThash: create hash(environment_key#10@0[str]TN); +#HASHnew: create hash(size 256, mask 256, width 2, total 1024 bytes); +#BAThash: hash construction 19 usec +#BAThash: statistics (10, entries 9, mask 255, max 2, avg 1.111111); +#BAThash: NOT persisting hash 17 +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec +#BATcheckhash: already has hash environment_key, waited 0 usec _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list