Statistics about stdout of test 'prepare-types.Bug-6724` in directory 'sql/test/BugTracker-2019`: 29 lines, 202 words, 976 chars in lines not matching '^$|^(\| |)#|^=` = 29 lines, 202 words, 976 chars in lines not matching '^$|^(\| |)#` # 73 lines, 409 words, 2657 chars in all lines stdout of test 'prepare-types.Bug-6724` in directory 'sql/test/BugTracker-2019` itself: # 20:57:29 > # 20:57:29 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30580" "--set" "mapi_usock=/var/tmp/mtest-12878/.s.monetdb.30580" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/ae96662f93e6-1-1-2/tests/sql/dbfarm/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" # 20:57:29 > # MonetDB 5 server v11.35.0 # This is an unreleased version # Serving database 'mTests_sql_test_BugTracker-2019', using 4 threads # Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers # Found 7.778 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://lab01.da.cwi.nl:30580/ # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-12878/.s.monetdb.30580 # MonetDB/GIS module loaded # MonetDB/SQL module loaded # 20:57:29 > # 20:57:29 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-12878" "--port=30580" # 20:57:29 > #start transaction; #create function mylength1(s string) returns int begin return length(s); end; #create function mylength2(s string, i int) returns int begin return length(s) + i; end; #prepare select mylength1(?); #prepare select mylength1(?); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name % varchar, int, int, str, str, str # type % 4, 2, 1, 0, 2, 2 # length [ "int", 32, 0, "", "L2", "L2" ] [ "clob", 0, 0, NULL, NULL, NULL ] #exec 7('abc'); % . # table_name # .L2 # table_name % L # name # L2 # name % int # type % 1 # length [ 3 ] #prepare select mylength2(?, 2); #prepare select mylength2(?, 2); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name % varchar, int, int, str, str, str # type % 7, 4, 1, 0, 2, 2 # length [ "int", 32, 0, "", "L2", "L2" ] [ "hugeint", 128, 0, NULL, NULL, NULL ] #rollback; #prepare select coalesce(cast(? as int), 23); #prepare select coalesce(cast(? as int), 23); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name % varchar, int, int, str, str, str # type % 3, 3, 1, 0, 2, 2 # length [ "int", 32, 0, "", "L3", "L3" ] [ "int", 32, 0, NULL, NULL, NULL ] #exec 11(1); % . # table_name # .L3 # table_name % L # name # L3 # name % int # type % 1 # length [ 1 ] # 20:57:29 > # 20:57:29 > "Done." # 20:57:29 >