Statistics about stdout of test 'sqlitelogictest-having-not-null-not-in.Bug-6557` in directory 'sql/test/BugTracker-2018`:
         29 lines,       124 words,       525 chars   in lines not matching '^$|^(\| |)#|^=`
=        29 lines,       124 words,       525 chars   in lines not matching '^$|^(\| |)#`
#        70 lines,       349 words,      2038 chars   in all lines

stdout of test 'sqlitelogictest-having-not-null-not-in.Bug-6557` in directory 'sql/test/BugTracker-2018` itself:


# 12:02:07 >  
# 12:02:07 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35486" "--forcemito" "--dbpath=C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true"
# 12:02:07 >  

# MonetDB 5 server v11.36.0
# This is an unreleased version
# Serving database 'mTests_sql_test_BugTracker-2018', using 6 threads
# Compiled for i686-pc-winnt/32bit
# Found 1.999 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://win2k12r2:35486/
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded

# 12:02:08 >  
# 12:02:08 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=35486"
# 12:02:08 >  

#CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
#INSERT INTO tab0 VALUES(83,0,38), (26,0,79), (43,81,24);
[ 3     ]
#SELECT DISTINCT col2 FROM tab0 GROUP BY col2, col1 HAVING NOT NULL NOT IN ( AVG ( ALL + col1 ) );
% sys.tab0 # table_name
% col2 # name
% int # type
% 1 # length
#SELECT DISTINCT * FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0;
% sys.cor0,     sys.cor0,       sys.cor0 # table_name
% col1, col2,   col0 # name
% int,  int,    int # type
% 2,    2,      2 # length
[ 0,    38,     83      ]
[ 0,    79,     26      ]
[ 81,   24,     43      ]
#SELECT CAST(SUM(col0) AS BIGINT) FROM tab0 WHERE + + col0 BETWEEN NULL AND + col2;
% sys. # table_name
# sys.L3 # table_name
% L # name
# L3 # name
% bigint # type
% 1 # length
[ NULL  ]
#SELECT CAST(SUM(col0) AS BIGINT) FROM tab0 WHERE + + col0 NOT BETWEEN NULL AND + col2;
% sys. # table_name
# sys.L3 # table_name
% L # name
# L3 # name
% bigint # type
% 1 # length
[ NULL  ]
#finish
% sys. # table_name
# sys.L3 # table_name
% L # name
# L3 # name
% bigint # type
% 1 # length
[ NULL  ]
mdb>#EOD
#DROP TABLE tab0;

# 12:02:08 >  
# 12:02:08 >  "Done."
# 12:02:08 >