| 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 |
21 lines, 198 words, 1276 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
| 3 |
= 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#` |
3 |
! |
3 |
= 21 lines, 198 words, 1276 chars in lines not matching '^$|^(\| |)#` |
3 |
| 4 |
# 18 lines, 63 words, 653 chars in all lines |
4 |
! |
4 |
# 43 lines, 282 words, 2274 chars in all lines |
4 |
| 5 |
|
5 |
|
5 |
|
5 |
| 8 |
|
8 |
|
8 |
|
8 |
| 9 |
# 18:55:45 > |
9 |
! |
9 |
# 07:17:51 > |
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 |
# 07:17:51 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33173" "--set" "mapi_usock=/var/tmp/mtest-57331/.s.monetdb.33173" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/Users/monet/scratch/c952acc49888-5-1-1/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" |
10 |
| 11 |
# 18:55:45 > |
11 |
! |
11 |
# 07:17:51 > |
11 |
| 12 |
|
12 |
! |
12 |
|
12 |
| 13 |
#client1:!ERROR:MALException:client.quit:Server stopped |
13 |
! |
13 |
#DFLOWworker2:!ERROR:SQLException:zero_or_one:21000!Cardinality violation, scalar value expected |
13 |
| 14 |
|
14 |
! |
14 |
#client2:!ERROR:ParseException:SQLparser:42000!SELECT: no such aggregate 'bit_or' |
14 |
| 15 |
# 18:55:46 > |
15 |
! |
15 |
#client2:!ERROR:SQLException:assert:M0M29!zero_or_one: cardinality violation, scalar expression expected |
15 |
| 16 |
# 18:55:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-31262" "--port=39342" |
16 |
! |
16 |
|
16 |
| 17 |
# 18:55:46 > |
17 |
! |
17 |
# 07:17:52 > |
17 |
| 18 |
|
18 |
! |
18 |
# 07:17:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-57331" "--port=33173" |
18 |
| 19 |
|
19 |
! |
19 |
# 07:17:52 > |
19 |
| 20 |
# 18:55:46 > |
20 |
! |
20 |
|
20 |
| 21 |
# 18:55:46 > "Done." |
21 |
! |
21 |
#~ MAPI = (monetdb) /var/tmp/mtest-57331/.s.monetdb.33173 |
21 |
| 22 |
# 18:55:46 > |
22 |
! |
22 |
QUERY = SELECT |
22 |
|
|
|
+ |
23 |
EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID = another_T.col1), |
23 |
|
|
|
+ |
24 |
(SELECT ColID FROM tbl_ProductSales) * DENSE_RANK() OVER (PARTITION BY AVG(DISTINCT col5)) |
24 |
|
|
|
+ |
25 |
FROM another_T GROUP BY col1, col2, col5, col8; --error, more than one row returned by a subquery used as an expression |
25 |
|
|
|
+ |
26 |
ERROR = !Cardinality violation, scalar value expected |
26 |
|
|
|
+ |
27 |
CODE = 21000 |
27 |
|
|
|
+ |
28 |
#~ MAPI = (monetdb) /var/tmp/mtest-57331/.s.monetdb.33173 |
28 |
|
|
|
+ |
29 |
QUERY = SELECT |
29 |
|
|
|
+ |
30 |
DISTINCT |
30 |
|
|
|
+ |
31 |
NOT col1 * col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MAX(col2) > 2), |
31 |
|
|
|
+ |
32 |
NOT AVG(col2) * col1 <> ANY (SELECT 20 FROM tbl_ProductSales HAVING MAX(col1) IS NOT NULL OR MIN(col1) < MIN(col2)), |
32 |
|
|
|
+ |
33 |
CAST (NOT col1 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER) | CAST (col2 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER), |
33 |
|
|
|
+ |
34 |
CAST (EXISTS (SELECT MAX(col5) * MAX(col4) FROM another_T GROUP BY col5, col4) AS INTEGER) & CAST (AVG(col1) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2) AS INTEGER) |
34 |
|
|
|
+ |
35 |
ERROR = !SELECT: no such aggregate 'bit_or' |
35 |
|
|
|
+ |
36 |
CODE = 42000 |
36 |
|
|
|
+ |
37 |
#~ MAPI = (monetdb) /var/tmp/mtest-57331/.s.monetdb.33173 |
37 |
|
|
|
+ |
38 |
QUERY = SELECT |
38 |
|
|
|
+ |
39 |
(SELECT MAX(col6) FROM tbl_ProductSales) IN (SELECT MIN(col3) FROM another_T) |
39 |
|
|
|
+ |
40 |
FROM another_T |
40 |
|
|
|
+ |
41 |
GROUP BY col1; --error, subquery returns more than 1 row |
41 |
|
|
|
+ |
42 |
ERROR = !zero_or_one: cardinality violation, scalar expression expected |
42 |
|
|
|
+ |
43 |
CODE = M0M29 |
43 |
|
|
|
+ |
44 |
|
44 |
|
|
|
+ |
45 |
# 07:17:52 > |
45 |
|
|
|
+ |
46 |
# 07:17:52 > "Done." |
46 |
|
|
|
+ |
47 |
# 07:17:52 > |
47 |
| 23 |
|
23 |
|
48 |
|
48 |