Changeset: c611c8b5ec86 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c611c8b5ec86
Modified Files:
        sql/test/pg_regress/Tests/aggregates.stable.err
        sql/test/pg_regress/Tests/aggregates.stable.out
        sql/test/pg_regress/Tests/alter_table.stable.err
        sql/test/pg_regress/Tests/alter_table.stable.out
        sql/test/pg_regress/Tests/arrays.stable.err
        sql/test/pg_regress/Tests/arrays.stable.out
        sql/test/pg_regress/Tests/bit.stable.err
        sql/test/pg_regress/Tests/bit.stable.out
        sql/test/pg_regress/Tests/boolean.stable.err
        sql/test/pg_regress/Tests/boolean.stable.out
        sql/test/pg_regress/Tests/box.stable.err
        sql/test/pg_regress/Tests/box.stable.out
        sql/test/pg_regress/Tests/btree_index.stable.err
        sql/test/pg_regress/Tests/btree_index.stable.out
        sql/test/pg_regress/Tests/case.stable.err
        sql/test/pg_regress/Tests/case.stable.out
        sql/test/pg_regress/Tests/circle.stable.err
        sql/test/pg_regress/Tests/circle.stable.out
        sql/test/pg_regress/Tests/cluster.stable.err
        sql/test/pg_regress/Tests/cluster.stable.out
        sql/test/pg_regress/Tests/comments.stable.err
        sql/test/pg_regress/Tests/comments.stable.out
        sql/test/pg_regress/Tests/conversion.stable.err
        sql/test/pg_regress/Tests/conversion.stable.out
        sql/test/pg_regress/Tests/copy2.stable.err
        sql/test/pg_regress/Tests/copy2.stable.out
        sql/test/pg_regress/Tests/create_aggregate.stable.err
        sql/test/pg_regress/Tests/create_aggregate.stable.out
        sql/test/pg_regress/Tests/create_index.stable.err
        sql/test/pg_regress/Tests/create_index.stable.out
        sql/test/pg_regress/Tests/create_misc.stable.err
        sql/test/pg_regress/Tests/create_misc.stable.out
        sql/test/pg_regress/Tests/create_operator.stable.err
        sql/test/pg_regress/Tests/create_operator.stable.out
        sql/test/pg_regress/Tests/create_table.stable.err
        sql/test/pg_regress/Tests/create_table.stable.out
        sql/test/pg_regress/Tests/create_type.stable.err
        sql/test/pg_regress/Tests/create_type.stable.out
        sql/test/pg_regress/Tests/create_view.stable.err
        sql/test/pg_regress/Tests/create_view.stable.out
        sql/test/pg_regress/Tests/date.stable.err
        sql/test/pg_regress/Tests/date.stable.out
        sql/test/pg_regress/Tests/domain.stable.err
        sql/test/pg_regress/Tests/domain.stable.out
        sql/test/pg_regress/Tests/drop.stable.err
        sql/test/pg_regress/Tests/drop.stable.out
        sql/test/pg_regress/Tests/errors.stable.err
        sql/test/pg_regress/Tests/errors.stable.out
        sql/test/pg_regress/Tests/float4.stable.err
        sql/test/pg_regress/Tests/float4.stable.out
        sql/test/pg_regress/Tests/float8.stable.err
        sql/test/pg_regress/Tests/float8.stable.out
        sql/test/pg_regress/Tests/foreign_key.stable.err
        sql/test/pg_regress/Tests/foreign_key.stable.out
        sql/test/pg_regress/Tests/geometry.stable.err
        sql/test/pg_regress/Tests/geometry.stable.out
        sql/test/pg_regress/Tests/hash_index.stable.err
        sql/test/pg_regress/Tests/hash_index.stable.out
        sql/test/pg_regress/Tests/horology.stable.err
        sql/test/pg_regress/Tests/horology.stable.out
        sql/test/pg_regress/Tests/inet.stable.err
        sql/test/pg_regress/Tests/inet.stable.out
        sql/test/pg_regress/Tests/inherit.stable.err
        sql/test/pg_regress/Tests/inherit.stable.out
        sql/test/pg_regress/Tests/insert.stable.err
        sql/test/pg_regress/Tests/insert.stable.out
        sql/test/pg_regress/Tests/int2.stable.err
        sql/test/pg_regress/Tests/int2.stable.out
        sql/test/pg_regress/Tests/int4.stable.err
        sql/test/pg_regress/Tests/int4.stable.out
        sql/test/pg_regress/Tests/int8.stable.err
        sql/test/pg_regress/Tests/int8.stable.out
        sql/test/pg_regress/Tests/interval.stable.err
        sql/test/pg_regress/Tests/interval.stable.out
        sql/test/pg_regress/Tests/join.stable.err
        sql/test/pg_regress/Tests/join.stable.out
        sql/test/pg_regress/Tests/limit.stable.err
        sql/test/pg_regress/Tests/limit.stable.out
        sql/test/pg_regress/Tests/lseg.stable.err
        sql/test/pg_regress/Tests/lseg.stable.out
        sql/test/pg_regress/Tests/mule_internal.stable.err
        sql/test/pg_regress/Tests/mule_internal.stable.out
        sql/test/pg_regress/Tests/name.stable.err
        sql/test/pg_regress/Tests/name.stable.out
        sql/test/pg_regress/Tests/namespace.stable.err
        sql/test/pg_regress/Tests/namespace.stable.out
        sql/test/pg_regress/Tests/numeric.stable.err
        sql/test/pg_regress/Tests/numeric.stable.out
        sql/test/pg_regress/Tests/numeric_big.stable.err
        sql/test/pg_regress/Tests/numeric_big.stable.out
        sql/test/pg_regress/Tests/numerology.stable.err
        sql/test/pg_regress/Tests/numerology.stable.out
        sql/test/pg_regress/Tests/oid.stable.err
        sql/test/pg_regress/Tests/oid.stable.out
        sql/test/pg_regress/Tests/oidjoins.stable.err
        sql/test/pg_regress/Tests/oidjoins.stable.out
        sql/test/pg_regress/Tests/opr_sanity.stable.err
        sql/test/pg_regress/Tests/opr_sanity.stable.out
        sql/test/pg_regress/Tests/path.stable.err
        sql/test/pg_regress/Tests/path.stable.out
        sql/test/pg_regress/Tests/plpgsql.stable.err
        sql/test/pg_regress/Tests/plpgsql.stable.out
        sql/test/pg_regress/Tests/point.stable.err
        sql/test/pg_regress/Tests/point.stable.out
        sql/test/pg_regress/Tests/polygon.stable.err
        sql/test/pg_regress/Tests/polygon.stable.out
        sql/test/pg_regress/Tests/polymorphism.stable.err
        sql/test/pg_regress/Tests/polymorphism.stable.out
        sql/test/pg_regress/Tests/portals.stable.err
        sql/test/pg_regress/Tests/portals.stable.out
        sql/test/pg_regress/Tests/portals_p2.stable.err
        sql/test/pg_regress/Tests/portals_p2.stable.out
        sql/test/pg_regress/Tests/prepare.stable.err
        sql/test/pg_regress/Tests/prepare.stable.out
        sql/test/pg_regress/Tests/privileges.stable.err
        sql/test/pg_regress/Tests/privileges.stable.out
        sql/test/pg_regress/Tests/random.stable.err
        sql/test/pg_regress/Tests/random.stable.out
        sql/test/pg_regress/Tests/rangefuncs.stable.err
        sql/test/pg_regress/Tests/rangefuncs.stable.out
        sql/test/pg_regress/Tests/reltime.stable.err
        sql/test/pg_regress/Tests/reltime.stable.out
        sql/test/pg_regress/Tests/rowtypes.stable.err
        sql/test/pg_regress/Tests/rowtypes.stable.out
        sql/test/pg_regress/Tests/rules.stable.err
        sql/test/pg_regress/Tests/rules.stable.out
        sql/test/pg_regress/Tests/sanity_check.stable.err
        sql/test/pg_regress/Tests/sanity_check.stable.out
        sql/test/pg_regress/Tests/select.stable.err
        sql/test/pg_regress/Tests/select.stable.out
        sql/test/pg_regress/Tests/select_distinct.stable.err
        sql/test/pg_regress/Tests/select_distinct.stable.out
        sql/test/pg_regress/Tests/select_distinct_on.stable.err
        sql/test/pg_regress/Tests/select_distinct_on.stable.out
        sql/test/pg_regress/Tests/select_having.stable.err
        sql/test/pg_regress/Tests/select_having.stable.out
        sql/test/pg_regress/Tests/select_implicit.stable.err
        sql/test/pg_regress/Tests/select_implicit.stable.out
        sql/test/pg_regress/Tests/select_into.stable.err
        sql/test/pg_regress/Tests/select_into.stable.out
        sql/test/pg_regress/Tests/select_views.stable.err
        sql/test/pg_regress/Tests/select_views.stable.out
        sql/test/pg_regress/Tests/sequence.stable.err
        sql/test/pg_regress/Tests/sequence.stable.out
        sql/test/pg_regress/Tests/sql_ascii.stable.err
        sql/test/pg_regress/Tests/sql_ascii.stable.out
        sql/test/pg_regress/Tests/stats.stable.err
        sql/test/pg_regress/Tests/stats.stable.out
        sql/test/pg_regress/Tests/strings.stable.err
        sql/test/pg_regress/Tests/strings.stable.out
        sql/test/pg_regress/Tests/subselect.stable.err
        sql/test/pg_regress/Tests/subselect.stable.out
        sql/test/pg_regress/Tests/temp.stable.err
        sql/test/pg_regress/Tests/temp.stable.out
        sql/test/pg_regress/Tests/time.stable.err
        sql/test/pg_regress/Tests/time.stable.out
        sql/test/pg_regress/Tests/timestamp.stable.err
        sql/test/pg_regress/Tests/timestamp.stable.out
        sql/test/pg_regress/Tests/timestamptz.stable.err
        sql/test/pg_regress/Tests/timestamptz.stable.out
        sql/test/pg_regress/Tests/timetz.stable.err
        sql/test/pg_regress/Tests/timetz.stable.out
        sql/test/pg_regress/Tests/tinterval.stable.err
        sql/test/pg_regress/Tests/tinterval.stable.out
        sql/test/pg_regress/Tests/transactions.stable.err
        sql/test/pg_regress/Tests/transactions.stable.out
        sql/test/pg_regress/Tests/triggers.stable.err
        sql/test/pg_regress/Tests/triggers.stable.out
        sql/test/pg_regress/Tests/truncate.stable.err
        sql/test/pg_regress/Tests/truncate.stable.out
        sql/test/pg_regress/Tests/type_sanity.stable.err
        sql/test/pg_regress/Tests/type_sanity.stable.out
        sql/test/pg_regress/Tests/union.stable.err
        sql/test/pg_regress/Tests/union.stable.out
        sql/test/pg_regress/Tests/update.stable.err
        sql/test/pg_regress/Tests/update.stable.out
        sql/test/pg_regress/Tests/vacuum.stable.err
        sql/test/pg_regress/Tests/vacuum.stable.out
        sql/test/pg_regress/Tests/without_oid.stable.err
        sql/test/pg_regress/Tests/without_oid.stable.out
Branch: default
Log Message:

pg_regress: prepare canonical "empty" output for all new tests

executed:

egrep -v '^[MQE ]' sql/test/pg_regress/Tests/select_distinct_on.stable.err > 
/tmp/select_distinct_on.stable.err ; \mv -f /tmp/select_distinct_on.stable.err 
sql/test/pg_regress/Tests/select_distinct_on.stable.err
( head -n26 sql/test/pg_regress/Tests/select_distinct_on.stable.out ; echo -e 
'= ! Correct / expected output still needs to be provided / verified / approved 
! =\n\n\n= ! Correct / expected output still needs to be provided / verified / 
approved ! =' ; tail -n5 
sql/test/pg_regress/Tests/select_distinct_on.stable.out ) > 
/tmp/select_distinct_on.stable.out && \mv -f /tmp/select_distinct_on.stable.out 
sql/test/pg_regress/Tests/select_distinct_on.stable.out
for i in `tail -n+12 sql/test/pg_regress/Tests/All | egrep -v 
'^#|^select_distinct_on$'` ; do for j in out err ; do echo $i $j ; cat 
sql/test/pg_regress/Tests/select_distinct_on.stable.$j | sed 
"s|select_distinct_on|$i|g" > sql/test/pg_regress/Tests/$i.stable.$j ; done ; 
done


diffs (truncated from 36788 to 300 lines):

diff --git a/sql/test/pg_regress/Tests/aggregates.stable.err 
b/sql/test/pg_regress/Tests/aggregates.stable.err
--- a/sql/test/pg_regress/Tests/aggregates.stable.err
+++ b/sql/test/pg_regress/Tests/aggregates.stable.err
@@ -1,9 +1,9 @@
 stderr of test 'aggregates` in directory 'sql/test/pg_regress` itself:
 
 
-# 17:09:48 >  
-# 17:09:48 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=38959" "--set" 
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" 
"mal_listing=0"
-# 17:09:48 >  
+# 17:11:18 >  
+# 17:11:18 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=38959" "--set" 
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" 
"mal_listing=0"
+# 17:11:18 >  
 
 # builtin opt  gdk_dbpath = /ufs/dinther/INSTALL/var/monetdb5/dbfarm/demo
 # builtin opt  gdk_debug = 0
@@ -25,213 +25,12 @@ stderr of test 'aggregates` in directory
 # cmdline opt  mal_listing = 0
 # cmdline opt  gdk_debug = 536870922
 
-# 17:09:48 >  
-# 17:09:48 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-1142" "--port=38959"
-# 17:09:48 >  
+# 17:11:19 >  
+# 17:11:19 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:11:19 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT avg(four) AS avg_1 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
-ERROR = !SELECT: no such table 'aggtest'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-QUERY = SELECT avg(gpa) AS avg_3_4  FROM student;
-ERROR = !SELECT: no such table 'student'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT sum(four) AS sum_1500 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT sum(a) AS sum_198 FROM aggtest;
-ERROR = !SELECT: no such table 'aggtest'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT sum(b) AS avg_431_773 FROM aggtest;
-ERROR = !SELECT: no such table 'aggtest'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT sum(gpa) AS avg_6_8  FROM student;
-ERROR = !SELECT: no such table 'student'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT max(four) AS max_3 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT max(a) AS max_100 FROM aggtest;
-ERROR = !SELECT: no such table 'aggtest'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
-ERROR = !SELECT: no such table 'aggtest'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT max(student.gpa) AS max_3_7 FROM student;
-ERROR = !SELECT: no such table 'student'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT count(four) AS cnt_1000 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-QUERY = SELECT count(four) AS cnt_1000 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT count(DISTINCT four) AS cnt_4 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-QUERY = SELECT newavg(four) AS avg_1 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT newsum(four) AS sum_1500 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-QUERY = SELECT newcnt(four) AS cnt_1000 FROM onek;
-ERROR = !SELECT: no such table 'onek'
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-QUERY = );
-ERROR = !syntax error, unexpected ')' in: ")"
-MAPI  = (monetdb) /var/tmp/mtest-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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-1142/.s.monetdb.38959
-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:09:49 >  
-# 17:09:49 >  "Done."
-# 17:09:49 >  
+# 17:11:19 >  
+# 17:11:19 >  "Done."
+# 17:11:19 >  
 
diff --git a/sql/test/pg_regress/Tests/aggregates.stable.out 
b/sql/test/pg_regress/Tests/aggregates.stable.out
--- a/sql/test/pg_regress/Tests/aggregates.stable.out
+++ b/sql/test/pg_regress/Tests/aggregates.stable.out
@@ -1,9 +1,9 @@
 stdout of test 'aggregates` in directory 'sql/test/pg_regress` itself:
 
 
-# 17:09:48 >  
-# 17:09:48 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=38959" "--set" 
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" 
"mal_listing=0"
-# 17:09:48 >  
+# 17:11:18 >  
+# 17:11:18 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=38959" "--set" 
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set" 
"mal_listing=0"
+# 17:11:18 >  
 
 # MonetDB 5 server v11.18.0
 # This is an unreleased version
@@ -13,52 +13,23 @@ stdout of test 'aggregates` in directory
 # 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
+# Listening for connection requests on mapi:monetdb://uwakai.da.cwi.nl:38959/
+# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-1142/.s.monetdb.38959
 # 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 >  
+# 17:11:19 >  
+# 17:11:19 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:11:19 >  
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to