Test subquery2.sql (id c952acc49888) (out)
subquery2.stable.err.FILTERED 2019-12-03 07:37:22.668936658 +0100subquery2.test.err.FILTERED 2019-12-03 07:37:22.688937569 +0100
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
..................
# 18 lines, 63 words,
8 8 8 8
9 # 18:55:45 > 9 ! 9 # 07:37:22 > 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:37:22 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=35946" "--set" "mapi_usock=/var/tmp/mtest-24631/.s.monetdb.35946" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/c952acc49888-6-1-1/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
11 # 18:55:45 > 11 ! 11 # 07:37:22 > 11
12 12 ! 12 12
13 #client1:!ERROR:MALException:client.quit:Server stopped 13 ! 13 #DFLOWworker5:!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:37:22 > 17
18 18 ! 18 # 07:37:22 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-24631" "--port=35946" 18
19 19 ! 19 # 07:37:22 > 19
20 # 18:55:46 > 20 ! 20 20
21 # 18:55:46 > "Done." 21 ! 21 #~ MAPI = (monetdb) /var/tmp/mtest-24631/.s.monetdb.35946 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-24631/.s.monetdb.35946 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-24631/.s.monetdb.35946 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:37:22 > 45
+ 46 # 07:37:22 > "Done." 46
+ 47 # 07:37:22 > 47
23 23 48 48