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