Test subquery2.sql (id f56b8f83e70a) (out)
subquery2.stable.err.FILTERED 2019-09-11 22:05:37.907151528 +0200subquery2.test.err.FILTERED 2019-09-11 22:05:37.912151556 +0200
1 Statistics about stderr of test 'subquery2` in directory 'sql/test/subquery`: 1 1 Statistics about stderr of test 'subquery2` in directory 'sql/test/subquery`: 1
2 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 7 lines, 78 words, 471 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 7 lines, 78 words, 471 chars in lines not matching '^$|^(\| |)#` 3
4 # 18 lines, 63 words, 653 chars in all lines 4 ! 4 # 27 lines, 169 words, 1411 chars in all lines 4
5 5 5 5
..................
# 18 lines, 63 words,
8 8 8 8
9 # 18:55:45 > 9 ! 9 # 22:05:37 > 9
10 # 18:55:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39342" "--set" "mapi_usock=/var/tmp/mtest-31262/.s.monetdb.39342" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_subquery" "--set" "embedded_c=true" 10 ! 10 # 22:05:37 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=1" "--set" "mapi_open=true" "--set" "mapi_port=31979" "--set" "mapi_usock=/var/tmp/mtest-11063/.s.monetdb.31979" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/f56b8f83e70a-4-1-3/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
11 # 18:55:45 > 11 ! 11 # 22:05:37 > 11
12 12 ! 12 12
13 #client1:!ERROR:MALException:client.quit:Server stopped 13 ! 13 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function 13
14 14 ! 14 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function 14
15 # 18:55:46 > 15 ! 15 15
16 # 18:55:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-31262" "--port=39342" 16 ! 16 # 22:05:37 > 16
17 # 18:55:46 > 17 ! 17 # 22:05:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-11063" "--port=31979" 17
18 18 ! 18 # 22:05:37 > 18
19 19 ! 19 19
20 # 18:55:46 > 20 ! 20 #~ MAPI = (monetdb) /var/tmp/mtest-11063/.s.monetdb.31979 20
21 # 18:55:46 > "Done." 21 ! 21 QUERY = SELECT col1 IN (SELECT ColID + col1 FROM tbl_ProductSales) FROM another_T GROUP BY col1; 21
22 # 18:55:46 > 22 ! 22 ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function 22
+ 23 CODE = 42000 23
+ 24 #~ MAPI = (monetdb) /var/tmp/mtest-11063/.s.monetdb.31979 24
+ 25 QUERY = SELECT col1 IN (SELECT ColID + col1 FROM tbl_ProductSales) FROM another_T GROUP BY col1; 25
+ 26 ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function 26
+ 27 CODE = 42000 27
+ 28 28
+ 29 # 22:05:37 > 29
+ 30 # 22:05:37 > "Done." 30
+ 31 # 22:05:37 > 31
23 23 32 32