Changeset: 17eea6016851 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=17eea6016851
Added 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/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
Modified Files:
        sql/test/pg_regress/Tests/char.stable.err
        sql/test/pg_regress/Tests/char.stable.out
        sql/test/pg_regress/Tests/strings_cast.stable.err
        sql/test/pg_regress/Tests/strings_cast.stable.out
        sql/test/pg_regress/Tests/strings_concat.stable.err
        sql/test/pg_regress/Tests/strings_concat.stable.out
        sql/test/pg_regress/Tests/strings_like.stable.err
        sql/test/pg_regress/Tests/strings_like.stable.out
        sql/test/pg_regress/Tests/text.stable.err
        sql/test/pg_regress/Tests/text.stable.out
        sql/test/pg_regress/Tests/varchar.stable.err
        sql/test/pg_regress/Tests/varchar.stable.out
Branch: default
Log Message:

adding sql test outputs


diffs (truncated from 35878 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: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 >  
+
+# 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 = 38959
+# cmdline opt  mapi_usock = /var/tmp/mtest-1142/.s.monetdb.38959
+# 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:09:48 >  
+# 17:09:48 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:09:48 >  
+
+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'
+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 >  
+
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: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 >  
+
+# 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: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:09:48 >  
+# 17:09:48 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:09:48 >  
+
+#CREATE TEMPORARY TABLE bool_test(  
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to