Statistics about stdout of test 'groupby_having_orderby_count.Bug-6624` in directory 'sql/test/BugTracker-2018`: 35 lines, 153 words, 701 chars in lines not matching '^$|^(\| |)#|^=` = 35 lines, 153 words, 701 chars in lines not matching '^$|^(\| |)#` # 70 lines, 334 words, 2050 chars in all lines stdout of test 'groupby_having_orderby_count.Bug-6624` in directory 'sql/test/BugTracker-2018` itself: # 03:01:02 > # 03:01:02 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33473" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\9f8602e8c51d-4-1-4\tests\sql\dbfarm\mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true" # 03:01:02 > # MonetDB 5 server v11.32.0 "default-9f8602e8c51d" # Serving database 'mTests_sql_test_BugTracker-2018', using 4 threads # Compiled for x86_64-pc-winnt/64bit # Found 11.991 GiB available main-memory. # Copyright (c) 1993 - July 2008 CWI. # Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved # Visit https://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://lab03:33473/ # MonetDB/GIS module loaded # MonetDB/SQL module loaded Ready. # 03:01:02 > # 03:01:02 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=33473" # 03:01:02 > #SELECT type,COUNT(id) FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY COUNT(id) DESC; % .columns, . # table_name # .columns, .L16 # table_name % type, L # name # type, L16 # name % varchar, bigint # type % 9, 3 # length [ "int", 211 ] [ "varchar", 137 ] [ "smallint", 52 ] [ "bigint", 50 ] [ "clob", 40 ] [ "boolean", 27 ] [ "timestamp", 11 ] #SELECT type,COUNT(id) FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY 2 DESC; % .columns, . # table_name # .columns, .L16 # table_name % type, L # name # type, L16 # name % varchar, bigint # type % 9, 3 # length [ "int", 211 ] [ "varchar", 137 ] [ "smallint", 52 ] [ "bigint", 50 ] [ "clob", 40 ] [ "boolean", 27 ] [ "timestamp", 11 ] #SELECT type,COUNT(id) as cnt FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY cnt DESC; % .columns, . # table_name # .columns, .L17 # table_name % type, cnt # name % varchar, bigint # type % 9, 3 # length [ "int", 211 ] [ "varchar", 137 ] [ "smallint", 52 ] [ "bigint", 50 ] [ "clob", 40 ] [ "boolean", 27 ] [ "timestamp", 11 ] # 03:01:02 > # 03:01:02 > "Done." # 03:01:02 >