Test subquery3.sql (id a7c289e8f33c) (out)
subquery3.stable.err.FILTERED 2019-12-03 21:41:33.854099200 +0100subquery3.test.err.FILTERED 2019-12-03 21:41:33.854099200 +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 # 124 lines, 788 words, 6062 chars in all lines 4
+ 5 5
+ 6 stderr of test 'subquery3` in directory 'sql/test/subquery` itself: 6
+ 7 7
+ 8 8
+ 9 # 21:41:32 > 9
+ 10 # 21:41:32 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32775" "--forcemito" "--dbpath=C:\monettesting\a7c289e8f33c-2-1-2\tests\sql\dbfarm\mTests_sql_test_subquery" "--set" "embedded_c=true" 10
+ 11 # 21:41:32 > 11
+ 12 12
+ 13 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: no such aggregate 'bit_and' 13
+ 14 #DFLOWworker1:!ERROR: BATproject: does not match always 14
+ 15 #DFLOWworker1:!ERROR:MALException:algebra.projection:GDK reported error: BATproject: does not match always 15
+ 16 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col5' unknown 16
+ 17 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col2' unknown 17
+ 18 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col2' unknown 18
+ 19 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col5' unknown 19
+ 20 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col5' unknown 20
+ 21 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col5' unknown 21
+ 22 #client2:!ERROR:ParseException:SQLparser:42S22!SELECT: no such column 't1.col2' 22
+ 23 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't2.col1' in query results without an aggregate function 23
+ 24 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'colid' unknown 24
+ 25 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'colid' unknown 25
+ 26 #client2:!ERROR:ParseException:SQLparser:42S22!SELECT: no such column 't1.col2' 26
+ 27 #client2:!ERROR:MALException:multiplex:42000!Program contains errors.:(NONE).multiplex 27
+ 28 #client2:!ERROR:MALException:multiplex:42000!Program contains errors.:(NONE).multiplex 28
+ 29 29
+ 30 # 21:41:33 > 30
+ 31 # 21:41:33 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=32775" 31
+ 32 # 21:41:33 > 32
+ 33 33
+ 34 #~ MAPI = monetdb@LAB03:32775 34
+ 35 QUERY = SELECT 35
+ 36 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), 36
+ 37 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) 37
+ 38 FROM another_T 38
+ 39 GROUP BY col1, col2, col5; 39
+ 40 ERROR = !SELECT: no such aggregate 'bit_and' 40
+ 41 CODE = 42000 41
+ 42 #~ MAPI = monetdb@LAB03:32775 42
+ 43 QUERY = SELECT 43
+ 44 EXISTS (SELECT RANK() OVER (PARTITION BY SUM(DISTINCT col5))) 44
+ 45 FROM another_T t1; 45
+ 46 ERROR = !GDK reported error: BATproject: does not match always 46
+ 47 #~ MAPI = monetdb@LAB03:32775 47
+ 48 QUERY = SELECT 48
+ 49 (SELECT AVG(col1) OVER (PARTITION BY col5 ORDER BY col1 ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 49
+ 50 FROM another_T t1; --error, more than one row returned by a subquery used as an expression 50
+ 51 ERROR = !SELECT: identifier 'col5' unknown 51
+ 52 CODE = 42000 52
+ 53 #~ MAPI = monetdb@LAB03:32775 53
+ 54 QUERY = SELECT 54
+ 55 (SELECT SUM(col2) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1 + ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 55
+ 56 FROM another_T t1 56
+ 57 GROUP BY col1; --error, subquery uses ungrouped column "t1.col2" from outer query 57
+ 58 ERROR = !SELECT: identifier 'col2' unknown 58
+ 59 CODE = 42000 59
+ 60 #~ MAPI = monetdb@LAB03:32775 60
+ 61 QUERY = SELECT 61
+ 62 (SELECT SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col2) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 62
+ 63 FROM another_T t1 63
+ 64 GROUP BY col1; --error, more than one row returned by a subquery used as an expression 64
+ 65 ERROR = !SELECT: identifier 'col2' unknown 65
+ 66 CODE = 42000 66
+ 67 #~ MAPI = monetdb@LAB03:32775 67
+ 68 QUERY = SELECT 68
+ 69 (SELECT DENSE_RANK() OVER (PARTITION BY col5 ORDER BY col1) FROM tbl_ProductSales) 69
+ 70 FROM another_T t1; --error, more than one row returned by a subquery used as an expression 70
+ 71 ERROR = !SELECT: identifier 'col5' unknown 71
+ 72 CODE = 42000 72
+ 73 #~ MAPI = monetdb@LAB03:32775 73
+ 74 QUERY = SELECT 74
+ 75 (SELECT DENSE_RANK() OVER (PARTITION BY MIN(col5) ORDER BY MAX(col8)) FROM tbl_ProductSales) 75
+ 76 FROM another_T t1 76
+ 77 GROUP BY col6; --error, more than one row returned by a subquery used as an expression 77
+ 78 ERROR = !SELECT: identifier 'col5' unknown 78
+ 79 CODE = 42000 79
+ 80 #~ MAPI = monetdb@LAB03:32775 80
+ 81 QUERY = SELECT 81
+ 82 (SELECT DENSE_RANK() OVER (PARTITION BY MIN(col5) ORDER BY col8 * ColID) FROM tbl_ProductSales) 82
+ 83 FROM another_T t1 83
+ 84 GROUP BY col6; --error, subquery uses ungrouped column "t1.col8" from outer query 84
+ 85 ERROR = !SELECT: identifier 'col5' unknown 85
+ 86 CODE = 42000 86
+ 87 #~ MAPI = monetdb@LAB03:32775 87
+ 88 QUERY = SELECT 88
+ 89 (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) 89
+ 90 FROM another_T t1 90
+ 91 GROUP BY col1; --error, more than one row returned by a subquery used as an expression 91
+ 92 ERROR = !SELECT: no such column 't1.col2' 92
+ 93 CODE = 42S22 93
+ 94 #~ MAPI = monetdb@LAB03:32775 94
+ 95 QUERY = SELECT 95
+ 96 (SELECT t2.col1 * SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1) ROWS UNBOUNDED PRECEDING) FROM another_T t2) 96
+ 97 FROM another_T t1 97
+ 98 GROUP BY col1; --error, column "t2.col1" must appear in the GROUP BY clause or be used in an aggregate function 98
+ 99 ERROR = !SELECT: cannot use non GROUP BY column 't2.col1' in query results without an aggregate function 99
+ 100 CODE = 42000 100
+ 101 #~ MAPI = monetdb@LAB03:32775 101
+ 102 QUERY = SELECT 102
+ 103 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales GROUP BY t1.col1) 103
+ 104 FROM another_T t1; 104
+ 105 ERROR = !SELECT: identifier 'colid' unknown 105
+ 106 CODE = 42000 106
+ 107 #~ MAPI = monetdb@LAB03:32775 107
+ 108 QUERY = SELECT 108
+ 109 (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) 109
+ 110 FROM another_T t1; 110
+ 111 ERROR = !SELECT: identifier 'colid' unknown 111
+ 112 CODE = 42000 112
+ 113 #~ MAPI = monetdb@LAB03:32775 113
+ 114 QUERY = SELECT 114
+ 115 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY MAX(t1.col2) * SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 115
+ 116 FROM another_T t1; 116
+ 117 ERROR = !SELECT: no such column 't1.col2' 117
+ 118 CODE = 42S22 118
+ 119 #~ MAPI = monetdb@LAB03:32775 119
+ 120 QUERY = SELECT 120
+ 121 (SELECT SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(t1.col2) * MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 121
+ 122 FROM another_T t1; 122
+ 123 ERROR = !Program contains errors.:(NONE).multiplex 123
+ 124 CODE = 42000 124
+ 125 125
+ 126 # 21:41:33 > 126
+ 127 # 21:41:33 > "Done." 127
+ 128 # 21:41:33 > 128
+ 129 129