Statistics about stdout of test 'subselect-contradiction.Bug-6683` in directory 'sql/test/BugTracker-2019`:
         39 lines,       128 words,       381 chars   in lines not matching '^$|^(\| |)#|^=`
=        39 lines,       128 words,       381 chars   in lines not matching '^$|^(\| |)#`
#       133 lines,       496 words,      3283 chars   in all lines

stdout of test 'subselect-contradiction.Bug-6683` in directory 'sql/test/BugTracker-2019` itself:


# 09:44:57 >  
# 09:44:57 >  "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32202" "--set" "mapi_usock=/var/tmp/mtest-21162/.s.monetdb.32202" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/fe8055a86502-5-1-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true"
# 09:44:57 >  

# MonetDB 5 server v11.33.12
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2019', using 8 threads
# Compiled for x86_64-redhat-linux-gnu/64bit with 128bit integers
# Found 31.375 GiB available main-memory.
# Copyright (c) 1993 - July 2008 CWI.
# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved
# Visit https://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://lab05.da.cwi.nl:32202/
# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-21162/.s.monetdb.32202
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded

Ready.

# 09:44:57 >  
# 09:44:57 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21162" "--port=32202"
# 09:44:57 >  

#START TRANSACTION;
#CREATE TABLE "sys"."unitTestDontDelete" ("A" VARCHAR(255),"B" BIGINT,"C" DOUBLE,"D" TIMESTAMP);
#INSERT INTO "sys"."unitTestDontDelete" VALUES (NULL, NULL, NULL, NULL);
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat1', 0, 0.5, '2013-06-10 11:10:10.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat2', 1, 1.5, '2013-06-11 12:11:11.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat1', 2, 2.5, '2013-06-12 13:12:12.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat2', 3, 3.5, '2013-06-13 14:13:13.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat1', 4, 4.5, '2013-06-14 15:14:14.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat2', 5, 5.5, '2013-06-15 16:15:15.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat1', 6, 6.5, '2013-06-16 17:16:16.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat2', 7, 7.5, '2013-06-17 18:17:17.000000');
[ 1     ]
#INSERT INTO "sys"."unitTestDontDelete" VALUES ('Cat1', 8, 8.5, '2013-06-18 19:18:18.000000');
[ 1     ]
#with "c3_t" as
#(
#  select
#    "c1_t"."A",
#    "c1_t"."B",
#    "c1_t"."C",
#    "c1_t"."D"
#  from
#    "unitTestDontDelete" as "c1_t"
#)
#select
#  (
#    select
#      sum("B")
#    from
#      "c3_t" as "c4_t"
#    where
#      (
#        ("c4_t"."C" >= (coalesce("c3_t"."C", 0.0) + cast('0x1.0p0' as double precision)))
#      )
#  )
#  as "c2_f1"
#from
#  "c3_t";
% . # table_name
# .L20 # table_name
% c2_f1 # name
% bigint # type
% 2 # length
[ 36    ]
[ 36    ]
[ 35    ]
[ 33    ]
[ 30    ]
[ 26    ]
[ 21    ]
[ 15    ]
[ 8     ]
[ NULL  ]
#with "c3_t" as
#(
#  select
#    "c1_t"."A",
#    "c1_t"."B",
#    "c1_t"."C",
#    "c1_t"."D"
#  from
#    "unitTestDontDelete" as "c1_t"
#)
#select
#  (
#    select
#      sum("B")
#    from
#      "c3_t" as "c4_t"
#    where
#      (
#        ("c4_t"."C" >= (coalesce("c3_t"."C", 0.0) + cast('0x1.0p0' as double precision)))
#        or
#        ( 1 = 0 )
#      )
#  )
#  as "c2_f1"
#from
#  "c3_t";
% . # table_name
# .L20 # table_name
% c2_f1 # name
% bigint # type
% 2 # length
[ 36    ]
[ 36    ]
[ 35    ]
[ 33    ]
[ 30    ]
[ 26    ]
[ 21    ]
[ 15    ]
[ 8     ]
#ROLLBACK;

# 09:44:58 >  
# 09:44:58 >  "Done."
# 09:44:58 >