Changeset: 412fd700b82d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=412fd700b82d Added Files: sql/test/pg_regress/Tests/aggregates.stable.err sql/test/pg_regress/Tests/aggregates.stable.out Branch: default Log Message:
adding test outputs diffs (truncated from 309 to 300 lines): diff --git a/sql/test/pg_regress/Tests/aggregates.stable.err b/sql/test/pg_regress/Tests/aggregates.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/pg_regress/Tests/aggregates.stable.err @@ -0,0 +1,235 @@ +stderr of test 'aggregates` in directory 'sql/test/pg_regress` itself: + + +# 17:03:53 > +# 17:03:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34443" "--set" "mapi_usock=/var/tmp/mtest-939/.s.monetdb.34443" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" "mal_listing=0" +# 17:03:53 > + +# builtin opt gdk_dbpath = /ufs/dinther/INSTALL/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 = 34443 +# cmdline opt mapi_usock = /var/tmp/mtest-939/.s.monetdb.34443 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbpath = /ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress +# cmdline opt mal_listing = 0 +# cmdline opt gdk_debug = 536870922 + +# 17:03:54 > +# 17:03:54 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-939" "--port=34443" +# 17:03:54 > + +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT avg(four) AS avg_1 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT cast(avg(b) as numeric(10,3)) AS avg_107_943 FROM aggtest; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT avg(gpa) AS avg_3_4 FROM student; +ERROR = !SELECT: no such table 'student' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT sum(four) AS sum_1500 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT sum(a) AS sum_198 FROM aggtest; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT sum(b) AS avg_431_773 FROM aggtest; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT sum(gpa) AS avg_6_8 FROM student; +ERROR = !SELECT: no such table 'student' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT max(four) AS max_3 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT max(a) AS max_100 FROM aggtest; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT max(aggtest.b) AS max_324_78 FROM aggtest; +ERROR = !SELECT: no such table 'aggtest' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT max(student.gpa) AS max_3_7 FROM student; +ERROR = !SELECT: no such table 'student' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT count(four) AS cnt_1000 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT count(DISTINCT four) AS cnt_4 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = select ten, count(*), sum(four) from onek + group by ten order by ten; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = select ten, count(four), sum(DISTINCT four) from onek + group by ten order by ten; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT newavg(four) AS avg_1 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT newsum(four) AS sum_1500 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT newcnt(four) AS cnt_1000 FROM onek; +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = select ten, sum(distinct four) from onek a + group by ten + having exists (select 1 from onek b where sum(distinct a.four) = b.four); +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = select ten, sum(distinct four) from onek a + group by ten + having exists (select 1 from onek b + where sum(distinct a.four + b.four) = b.four); +ERROR = !SELECT: no such table 'onek' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = CREATE TEMPORARY TABLE bitwise_test( + i2 smallint, + i4 integer, + i8 bigint, + i INTEGER, + x smallint, + y BIT(4) +ERROR = !type (bit) unknown in: "create temporary table bitwise_test( + ! i2 smallint, + ! i4 integer, + ! i8 bigint, + ! i integer, + ! x smallint, + ! y bit(4)" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = ); +ERROR = !syntax error, unexpected ')' in: ")" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + BIT_AND(i2) AS "?", + BIT_OR(i4) AS "?" + FROM bitwise_test; +ERROR = !SELECT: no such table 'bitwise_test' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = COPY bitwise_test FROM STDIN NULL 'null'; +ERROR = !syntax error, unexpected IDENT, expecting BINARY or INTO in: "copy bitwise_test" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = 1 1 1 1 1 B0101 + 3 3 3 null 2 B0100 + 7 7 7 3 4 B1100 + \. + + SELECT + BIT_AND(i2) AS "1", + BIT_AND(i4) AS "1", + BIT_AND(i8) AS "1", + BIT_AND(i) AS "?", + BIT_AND(x) AS "0", + BIT_AND(y) AS "0100", + + BIT_OR(i2) AS "7", + BIT_OR(i4) AS "7", + BIT_OR(i8) AS "7", + BIT_OR(i) AS "?", + BIT_OR(x) AS "7", + BIT_OR(y) AS "1101" + FROM bitwise_test; +ERROR = !syntax error, unexpected sqlINT in: "1" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + -- boolean and transitions + -- null because strict + booland_statefunc(NULL, NULL) IS NULL AS "t", + booland_statefunc(TRUE, NULL) IS NULL AS "t", + booland_statefunc(FALSE, NULL) IS NULL AS "t", + booland_statefunc(NULL, TRUE) IS NULL AS "t", + booland_statefunc(NULL, FALSE) IS NULL AS "t", + -- and actual computations + booland_statefunc(TRUE, TRUE) AS "t", + NOT booland_statefunc(TRUE, FALSE) AS "t", + NOT booland_statefunc(FALSE, TRUE) AS "t", + NOT booland_statefunc(FALSE, FALSE) AS "t"; +ERROR = !SELECT: no such binary operator 'booland_statefunc(any,any)' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + -- boolean or transitions + -- null because strict + boolor_statefunc(NULL, NULL) IS NULL AS "t", + boolor_statefunc(TRUE, NULL) IS NULL AS "t", + boolor_statefunc(FALSE, NULL) IS NULL AS "t", + boolor_statefunc(NULL, TRUE) IS NULL AS "t", + boolor_statefunc(NULL, FALSE) IS NULL AS "t", + -- actual computations + boolor_statefunc(TRUE, TRUE) AS "t", + boolor_statefunc(TRUE, FALSE) AS "t", + boolor_statefunc(FALSE, TRUE) AS "t", + NOT boolor_statefunc(FALSE, FALSE) AS "t"; +ERROR = !SELECT: no such binary operator 'boolor_statefunc(any,any)' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + BOOL_AND(b1) AS "n", + BOOL_OR(b3) AS "n" + FROM bool_test; +ERROR = !SELECT: no such unary operator 'bool_and(boolean)' +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = COPY bool_test FROM STDIN NULL 'null'; +ERROR = !syntax error, unexpected IDENT, expecting BINARY or INTO in: "copy bool_test" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = TRUE null FALSE null + FALSE TRUE null null + null TRUE FALSE null + \. + + SELECT + BOOL_AND(b1) AS "f", + BOOL_AND(b2) AS "t", + BOOL_AND(b3) AS "f", + BOOL_AND(b4) AS "n", + BOOL_AND(NOT b2) AS "f", + BOOL_AND(NOT b3) AS "t" + FROM bool_test; +ERROR = !syntax error, unexpected BOOL_TRUE in: "true" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + EVERY(b1) AS "f", + EVERY(b2) AS "t", + EVERY(b3) AS "f", + EVERY(b4) AS "n", + EVERY(NOT b2) AS "f", + EVERY(NOT b3) AS "t" + FROM bool_test; +ERROR = !syntax error, unexpected ANY in: "select + ! every" +MAPI = (monetdb) /var/tmp/mtest-939/.s.monetdb.34443 +QUERY = SELECT + BOOL_OR(b1) AS "t", + BOOL_OR(b2) AS "t", + BOOL_OR(b3) AS "f", + BOOL_OR(b4) AS "n", + BOOL_OR(NOT b2) AS "f", + BOOL_OR(NOT b3) AS "t" + FROM bool_test; +ERROR = !syntax error, unexpected NOT in: "select + ! bool_or(b1) as "t", + ! bool_or(b2) as "t", + ! bool_or(b3) as "f", + ! bool_or(b4) as "n", + ! bool_or(not" + +# 17:03:54 > +# 17:03:54 > "Done." +# 17:03:54 > + diff --git a/sql/test/pg_regress/Tests/aggregates.stable.out b/sql/test/pg_regress/Tests/aggregates.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/pg_regress/Tests/aggregates.stable.out @@ -0,0 +1,64 @@ +stdout of test 'aggregates` in directory 'sql/test/pg_regress` itself: + + +# 17:03:53 > +# 17:03:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34443" "--set" "mapi_usock=/var/tmp/mtest-939/.s.monetdb.34443" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" "mal_listing=0" +# 17:03:53 > + +# MonetDB 5 server v11.18.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_pg_regress', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.356 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://uwakai.da.cwi.nl:34443/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-939/.s.monetdb.34443 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. +# SQL catalog created, loading sql scripts once +# loading sql script: 09_like.sql +# loading sql script: 10_math.sql +# loading sql script: 11_times.sql +# loading sql script: 12_url.sql +# loading sql script: 13_date.sql +# loading sql script: 14_inet.sql +# loading sql script: 15_querylog.sql +# loading sql script: 16_tracelog.sql +# loading sql script: 19_cluster.sql +# loading sql script: 20_vacuum.sql +# loading sql script: 21_dependency_functions.sql +# loading sql script: 22_clients.sql +# loading sql script: 23_skyserver.sql +# loading sql script: 24_zorder.sql +# loading sql script: 25_debug.sql +# loading sql script: 26_sysmon.sql +# loading sql script: 39_analytics.sql +# loading sql script: 40_geom.sql +# loading sql script: 40_json.sql +# loading sql script: 41_jsonstore.sql +# loading sql script: 45_uuid.sql +# loading sql script: 46_gsl.sql +# loading sql script: 75_storagemodel.sql +# loading sql script: 80_statistics.sql +# loading sql script: 80_udf.sql +# loading sql script: 90_generator.sql +# loading sql script: 99_system.sql + +# 17:03:54 > +# 17:03:54 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-939" "--port=34443" +# 17:03:54 > + +#CREATE TEMPORARY TABLE bool_test( _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list