| 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, 1406 chars in all lines |
4 |
| 5 |
|
5 |
|
5 |
|
5 |
| 8 |
|
8 |
|
8 |
|
8 |
| 9 |
# 18:55:45 > |
9 |
! |
9 |
# 21:28:09 > |
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 |
# 21:28:09 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=1" "--set" "mapi_open=true" "--set" "mapi_port=33035" "--set" "mapi_usock=/var/tmp/mtest-3641/.s.monetdb.33035" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/f56b8f83e70a-5-1-4/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" |
10 |
| 11 |
# 18:55:45 > |
11 |
! |
11 |
# 21:28:09 > |
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 |
# 21:28:10 > |
16 |
| 17 |
# 18:55:46 > |
17 |
! |
17 |
# 21:28:10 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-3641" "--port=33035" |
17 |
| 18 |
|
18 |
! |
18 |
# 21:28:10 > |
18 |
| 19 |
|
19 |
! |
19 |
|
19 |
| 20 |
# 18:55:46 > |
20 |
! |
20 |
#~ MAPI = (monetdb) /var/tmp/mtest-3641/.s.monetdb.33035 |
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-3641/.s.monetdb.33035 |
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 |
# 21:28:10 > |
29 |
|
|
|
+ |
30 |
# 21:28:10 > "Done." |
30 |
|
|
|
+ |
31 |
# 21:28:10 > |
31 |
| 23 |
|
23 |
|
32 |
|
32 |