Statistics about stdout of test 'subselect.Bug-6700` in directory 'sql/test/BugTracker-2019`: 61 lines, 318 words, 1297 chars in lines not matching '^$|^(\| |)#|^=` = 61 lines, 318 words, 1297 chars in lines not matching '^$|^(\| |)#` # 207 lines, 1019 words, 6026 chars in all lines stdout of test 'subselect.Bug-6700` in directory 'sql/test/BugTracker-2019` itself: # 09:38:46 > # 09:38:46 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36777" "--set" "mapi_usock=/var/tmp/mtest-26939/.s.monetdb.36777" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/@Monet-candidate/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_r=yes" "--set" "embedded_py=2" "--set" "embedded_c=true" # 09:38:46 > # MonetDB 5 server v11.33.2 (hg id: 6f4dcaf691d5) # This is an unreleased version # Serving database 'mTests_sql_test_BugTracker-2019', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers # Found 62.693 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://methuselah.da.cwi.nl:36777/ # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-26939/.s.monetdb.36777 # MonetDB/GIS module loaded # 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: 17_temporal.sql # loading sql script: 18_index.sql # loading sql script: 20_vacuum.sql # loading sql script: 21_dependency_views.sql # loading sql script: 22_clients.sql # loading sql script: 23_skyserver.sql # loading sql script: 25_debug.sql # loading sql script: 26_sysmon.sql # loading sql script: 27_rejects.sql # loading sql script: 39_analytics.sql # loading sql script: 39_analytics_hge.sql # loading sql script: 40_geom.sql # loading sql script: 40_json.sql # loading sql script: 40_json_hge.sql # loading sql script: 41_md5sum.sql # loading sql script: 45_uuid.sql # loading sql script: 46_profiler.sql # loading sql script: 51_sys_schema_extension.sql # loading sql script: 60_wlcr.sql # loading sql script: 72_fits.sql # loading sql script: 74_netcdf.sql # loading sql script: 75_lidar.sql # loading sql script: 75_shp.sql # loading sql script: 75_storagemodel.sql # loading sql script: 80_statistics.sql # loading sql script: 80_udf.sql # loading sql script: 80_udf_hge.sql # loading sql script: 85_bam.sql # loading sql script: 90_generator.sql # loading sql script: 90_generator_hge.sql # loading sql script: 99_system.sql # MonetDB/SQL module loaded # MonetDB/Python2 module loaded # MonetDB/R module loaded Ready. # 09:38:47 > # 09:38:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-26939" "--port=36777" # 09:38:47 > #start transaction; #create table "testTable1" ( # "A" varchar(255), # "B" varchar(255) #); #insert into "testTable1" values ('Cat1', 'Cat1'); [ 1 ] #insert into "testTable1" values ('Cat2', 'Cat2'); [ 1 ] #insert into "testTable1" values ('Cat3', 'Cat1'); [ 1 ] #create table "testTable2" ( # "A" varchar (255), # "B" double #); #insert into "testTable2" values ('Cat1', 2); [ 1 ] #insert into "testTable2" values ('Cat2', 3); [ 1 ] #insert into "testTable2" values ('Cat2', 4); [ 1 ] #insert into "testTable2" values (null, null); [ 1 ] #select "A", "B", ( # select count(1) # from "testTable1" "inner" # where ("inner"."B" = "outer"."A") #) from "testTable1" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, varchar, bigint # type % 4, 4, 1 # length [ "Cat1", "Cat1", 2 ] [ "Cat2", "Cat2", 1 ] [ "Cat3", "Cat1", 0 ] #select "A", "B", ( # select count(*) # from "testTable1" "inner" # where ("inner"."B" = "outer"."A") #) from "testTable1" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, varchar, bigint # type % 4, 4, 1 # length [ "Cat1", "Cat1", 2 ] [ "Cat2", "Cat2", 1 ] [ "Cat3", "Cat1", 0 ] #select "A", "B", ( # select count(1) # from "testTable1" "inner" # where ("inner"."B" = "outer"."A") and ("outer"."A" is not null) #) from "testTable1" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, varchar, bigint # type % 4, 4, 1 # length [ "Cat1", "Cat1", 2 ] [ "Cat2", "Cat2", 1 ] [ "Cat3", "Cat1", 0 ] #select "A", "B", ( # select count(*) # from "testTable1" "inner" # where ("inner"."B" = "outer"."A") and ("outer"."A" is not null) #) from "testTable1" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, varchar, bigint # type % 4, 4, 1 # length [ "Cat1", "Cat1", 2 ] [ "Cat2", "Cat2", 1 ] [ "Cat3", "Cat1", 0 ] #select "A", "B", ( # select sum("B") # from "testTable2" "inner" # where ( # "inner"."A" = "outer"."A" or # ("inner"."A" is null and "outer"."A" is null) # ) #) from "testTable2" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, double, double # type % 4, 24, 24 # length [ "Cat1", 2, 2 ] [ "Cat2", 3, 7 ] [ "Cat2", 4, 7 ] [ NULL, NULL, NULL ] #select "A", "B", ( # select sum("B") # from "testTable2" "inner" # where ( # "inner"."A" = "outer"."A" or # ("inner"."A" is null and "outer"."A" is null) # ) and ("A" = 'Cat7') #) from "testTable2" "outer"; % .outer, .outer, . # table_name # .outer, .outer, .L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, double, double # type % 4, 24, 24 # length [ "Cat1", 2, NULL ] [ "Cat2", 3, NULL ] [ "Cat2", 4, NULL ] [ NULL, NULL, NULL ] #select "A", "B", ( # select sum("B") # from "testTable2" "inner" # where ( # "inner"."A" = "outer"."A" or # ("inner"."A" is null and "outer"."A" is null) # ) and (true = false) #) from "testTable2" "outer"; % .outer, .outer, sys. # table_name # .outer, .outer, sys.L7 # table_name % A, B, L # name # A, B, L7 # name % varchar, double, double # type % 4, 24, 24 # length [ "Cat1", 2, NULL ] [ "Cat2", 3, NULL ] [ "Cat2", 4, NULL ] [ NULL, NULL, NULL ] #rollback; # 09:38:47 > # 09:38:47 > "Done." # 09:38:47 >