Test subquery3.sql (id 7a4f3daf6d73) (out)
subquery3.stable.err.FILTERED 2020-03-26 22:06:21.379030835 +0100subquery3.test.err.FILTERED 2020-03-26 22:06:21.383030773 +0100
+ 1 Statistics about stderr of test 'subquery3` in directory 'sql/test/subquery`: 1
+ 2 78 lines, 601 words, 3868 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 78 lines, 601 words, 3868 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 103 lines, 699 words, 4847 chars in all lines 4
+ 5 5
+ 6 stderr of test 'subquery3` in directory 'sql/test/subquery` itself: 6
+ 7 7
+ 8 8
+ 9 # 22:06:21 > 9
+ 10 # 22:06:21 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-27527" "--port=34963" 10
+ 11 # 22:06:21 > 11
+ 12 12
+ 13 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 13
+ 14 QUERY = SELECT 14
+ 15 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), 15
+ 16 CAST (EXISTS (SELECT MAX(col5) * MAX(col4) FROM another_T GROUP BY col5, col4) AS INTEGER) & CAST (SUM(col4) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2) AS INTEGER) 16
+ 17 FROM another_T 17
+ 18 GROUP BY col1, col2, col5; 18
+ 19 ERROR = !SELECT: no such aggregate 'bit_and' 19
+ 20 CODE = 42000 20
+ 21 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 21
+ 22 QUERY = SELECT 22
+ 23 EXISTS (SELECT RANK() OVER (PARTITION BY SUM(DISTINCT col5))) 23
+ 24 FROM another_T t1; 24
+ 25 ERROR = !GDK reported error: BATproject: does not match always 25
+ 26 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 26
+ 27 QUERY = SELECT 27
+ 28 (SELECT AVG(col1) OVER (PARTITION BY col5 ORDER BY col1 ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 28
+ 29 FROM another_T t1; --error, more than one row returned by a subquery used as an expression 29
+ 30 ERROR = !SELECT: identifier 'col5' unknown 30
+ 31 CODE = 42000 31
+ 32 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 32
+ 33 QUERY = SELECT 33
+ 34 (SELECT SUM(col2) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1 + ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 34
+ 35 FROM another_T t1 35
+ 36 GROUP BY col1; --error, subquery uses ungrouped column "t1.col2" from outer query 36
+ 37 ERROR = !SELECT: identifier 'col2' unknown 37
+ 38 CODE = 42000 38
+ 39 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 39
+ 40 QUERY = SELECT 40
+ 41 (SELECT SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col2) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 41
+ 42 FROM another_T t1 42
+ 43 GROUP BY col1; --error, more than one row returned by a subquery used as an expression 43
+ 44 ERROR = !SELECT: identifier 'col2' unknown 44
+ 45 CODE = 42000 45
+ 46 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 46
+ 47 QUERY = SELECT 47
+ 48 (SELECT DENSE_RANK() OVER (PARTITION BY col5 ORDER BY col1) FROM tbl_ProductSales) 48
+ 49 FROM another_T t1; --error, more than one row returned by a subquery used as an expression 49
+ 50 ERROR = !SELECT: identifier 'col5' unknown 50
+ 51 CODE = 42000 51
+ 52 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 52
+ 53 QUERY = SELECT 53
+ 54 (SELECT DENSE_RANK() OVER (PARTITION BY MIN(col5) ORDER BY MAX(col8)) FROM tbl_ProductSales) 54
+ 55 FROM another_T t1 55
+ 56 GROUP BY col6; --error, more than one row returned by a subquery used as an expression 56
+ 57 ERROR = !SELECT: identifier 'col5' unknown 57
+ 58 CODE = 42000 58
+ 59 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 59
+ 60 QUERY = SELECT 60
+ 61 (SELECT DENSE_RANK() OVER (PARTITION BY MIN(col5) ORDER BY col8 * ColID) FROM tbl_ProductSales) 61
+ 62 FROM another_T t1 62
+ 63 GROUP BY col6; --error, subquery uses ungrouped column "t1.col8" from outer query 63
+ 64 ERROR = !SELECT: identifier 'col5' unknown 64
+ 65 CODE = 42000 65
+ 66 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 66
+ 67 QUERY = SELECT 67
+ 68 (SELECT t2.col1 * SUM(SUM(t1.col2)) OVER (PARTITION BY SUM(t1.col2) ORDER BY MAX(t1.col1) ROWS UNBOUNDED PRECEDING) FROM another_T t2) 68
+ 69 FROM another_T t1 69
+ 70 GROUP BY col1; --error, more than one row returned by a subquery used as an expression 70
+ 71 ERROR = !SELECT: no such column 't1.col2' 71
+ 72 CODE = 42S22 72
+ 73 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 73
+ 74 QUERY = SELECT 74
+ 75 (SELECT t2.col1 * SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1) ROWS UNBOUNDED PRECEDING) FROM another_T t2) 75
+ 76 FROM another_T t1 76
+ 77 GROUP BY col1; --error, column "t2.col1" must appear in the GROUP BY clause or be used in an aggregate function 77
+ 78 ERROR = !SELECT: cannot use non GROUP BY column 't2.col1' in query results without an aggregate function 78
+ 79 CODE = 42000 79
+ 80 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 80
+ 81 QUERY = SELECT 81
+ 82 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales GROUP BY t1.col1) 82
+ 83 FROM another_T t1; 83
+ 84 ERROR = !SELECT: identifier 'colid' unknown 84
+ 85 CODE = 42000 85
+ 86 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 86
+ 87 QUERY = SELECT 87
+ 88 (SELECT SUM(AVG(ColID + col1)) OVER (PARTITION BY SUM(ColID + col3) ORDER BY MAX(ColID) * col4 ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales GROUP BY t1.col1) 88
+ 89 FROM another_T t1; 89
+ 90 ERROR = !SELECT: identifier 'colid' unknown 90
+ 91 CODE = 42000 91
+ 92 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 92
+ 93 QUERY = SELECT 93
+ 94 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY MAX(t1.col2) * SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 94
+ 95 FROM another_T t1; 95
+ 96 ERROR = !SELECT: no such column 't1.col2' 96
+ 97 CODE = 42S22 97
+ 98 #~ MAPI = (monetdb) /var/tmp/mtest-27527/.s.monetdb.34963 98
+ 99 QUERY = SELECT 99
+ 100 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(t1.col2) * MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 100
+ 101 FROM another_T t1; 101
+ 102 ERROR = !Program contains errors.:(NONE).multiplex 102
+ 103 CODE = 42000 103
+ 104 104
+ 105 # 22:06:21 > 105
+ 106 # 22:06:21 > "Done." 106
+ 107 # 22:06:21 > 107
+ 108 108