MonetDB: default - adding test outputs
Changeset: 3e7b3ac2b314 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3e7b3ac2b314 Added Files: sql/test/pg_regress/Tests/boolean.stable.err sql/test/pg_regress/Tests/boolean.stable.out Branch: default Log Message: adding test outputs diffs (297 lines): diff --git a/sql/test/pg_regress/Tests/boolean.stable.err b/sql/test/pg_regress/Tests/boolean.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/pg_regress/Tests/boolean.stable.err @@ -0,0 +1,167 @@ +stderr of test 'boolean` in directory 'sql/test/pg_regress` itself: + + +# 16:51:47 +# 16:51:47 mserver5 --debug=10 --set gdk_nr_threads=0 --set mapi_open=true --set mapi_port=30210 --set mapi_usock=/var/tmp/mtest-399/.s.monetdb.30210 --set monet_prompt= --forcemito --set mal_listing=2 --dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress --set mal_listing=0 +# 16:51:47 + +# 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 = 5 +# 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 = 30210 +# cmdline opt mapi_usock = /var/tmp/mtest-399/.s.monetdb.30210 +# 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 + +# 16:51:48 +# 16:51:48 mclient -lsql -ftest -Eutf-8 -i -e --host=/var/tmp/mtest-399 --port=30210 +# 16:51:48 + +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT bool 'f' AS false; +ERROR = !incorrect boolean f in: select bool 'f' as +!syntax error, unexpected BOOL_FALSE in: false +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT bool 't' or bool 'f' AS true; +ERROR = !incorrect boolean t in: select bool 't' or +!syntax error, unexpected ALIAS in: bool +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT bool 't' and bool 'f' AS false; +ERROR = !incorrect boolean t in: select bool 't' and +!syntax error, unexpected ALIAS in: bool +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT not bool 'f' AS true; +ERROR = !incorrect boolean f in: select not bool 'f' as +!syntax error, unexpected BOOL_TRUE in: true +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT bool 't' = bool 'f' AS false; +ERROR = !incorrect boolean t in: select bool 't' = +!syntax error, unexpected ALIAS in: bool +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT bool 't' bool 'f' AS true; +ERROR = !incorrect boolean t in: select bool 't' +!syntax error, unexpected ALIAS in: bool +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL1 (f1) VALUES (bool 't'); +ERROR = !incorrect boolean t in: insert into booltbl1 (f1) values (bool 't') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True'); +ERROR = !incorrect boolean True in: insert into booltbl1 (f1) values (bool 'True') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT '' AS t_3, BOOLTBL1.*; +ERROR = !Column expression Table 'booltbl1' unknown +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT '' AS zero, BOOLTBL1.* + FROM BOOLTBL1 + WHERE booleq(bool 'false', f1); +ERROR = !SELECT: no such binary operator 'booleq(boolean,boolean)' +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL1 (f1) VALUES (bool 'f'); +ERROR = !incorrect boolean f in: insert into booltbl1 (f1) values (bool 'f') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL2 (f1) VALUES (bool 'f'); +ERROR = !incorrect boolean f in: insert into booltbl2 (f1) values (bool 'f') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL2 (f1) VALUES (bool 'False'); +ERROR = !incorrect boolean False in: insert into booltbl2 (f1) values (bool 'False') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL2 (f1) VALUES (bool 'FALSE'); +ERROR = !incorrect boolean FALSE in: insert into booltbl2 (f1) values (bool 'FALSE') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = INSERT INTO BOOLTBL2 (f1) + VALUES (bool 'XXX'); +ERROR = !incorrect boolean XXX in: insert into booltbl2 (f1) +! values (bool 'XXX') +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY = SELECT '' AS f_4, BOOLTBL2.*; +ERROR = !Column expression Table 'booltbl2' unknown +MAPI = (monetdb) /var/tmp/mtest-399/.s.monetdb.30210 +QUERY =
MonetDB: default - adding test outputs
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 = 5 +# 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