Test subquery2.sql (id 0177627dc2e1) (out)
subquery2.stable.err.FILTERED 2019-09-20 21:13:26.490087693 +0200subquery2.test.err.FILTERED 2019-09-20 21:13:26.499087611 +0200
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 242 lines, 1088 words, 9923 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 242 lines, 1088 words, 9923 chars in lines not matching '^$|^(\| |)#` 3
4 # 18 lines, 63 words, 653 chars in all lines 4 ! 4 # 294 lines, 1311 words, 13192 chars in all lines 4
5 5 5 5
..................
# 18 lines, 63 words,
8 8 8 8
9 # 18:55:45 > 9 ! 9 # 21:13:16 > 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 # 21:13:16 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35896" "--set" "mapi_usock=/var/tmp/mtest-29872/.s.monetdb.35896" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
11 # 18:55:45 > 11 ! 11 # 21:13:16 > 11
12 12 12 12
13 #client1:!ERROR:MALException:client.quit:Server stopped 13 ! 13 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function 13
+ 14 could not find L4.L4 14
+ 15 another_t.col1 15
+ 16 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 16
+ 17 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 17
+ 18 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 18
+ 19 could not find L1.L1 19
+ 20 L11.L11 20
+ 21 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 21
+ 22 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 22
+ 23 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 23
+ 24 could not find another_t.col1 24
+ 25 L22.L22 25
+ 26 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 26
+ 27 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 27
+ 28 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 28
+ 29 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'L7' in query results without an aggregate function 29
+ 30 could not find tbl_productsales.colid 30
+ 31 another_t.col1 31
+ 32 another_t.col2 32
+ 33 another_t.col5 33
+ 34 another_t.col8 34
+ 35 L5.L5 35
+ 36 L6.L6 36
+ 37 L4.L4 37
+ 38 L14.L14 38
+ 39 L53.L53 39
+ 40 L21.L21 40
+ 41 L72.L72 41
+ 42 L73.L73 42
+ 43 L74.L74 43
+ 44 could not find L3.L3 44
+ 45 another_t.col1 45
+ 46 L13.L13 46
+ 47 L6.L5 47
+ 48 L10.L10 48
+ 49 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 49
+ 50 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 50
+ 51 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 51
+ 52 #client2:!ERROR:ParseException:SQLparser:42S22!SELECT: no such column 't1.col5' 52
+ 53 could not find another_t.col1 53
+ 54 another_t.col4 54
+ 55 L7.L7 55
+ 56 L2.L2 56
+ 57 L4.L4 57
+ 58 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 58
+ 59 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 59
+ 60 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 60
+ 61 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: identifier 'col7' unknown 61
+ 62 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 62
+ 63 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 63
+ 64 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 64
14 14 65 65
15 # 18:55:46 > 15 ! 66 Segmentation fault 66
16 # 18:55:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-31262" "--port=39342" 16 ! 67 PID: 23355 (mserver5) 67
17 # 18:55:46 > 17 ! 68 UID: 9375 (monet) 68
+ 69 GID: 60020 (da) 69
+ 70 Signal: 11 (SEGV) 70
+ 71 Timestamp: Fri 2019-09-20 21:13:16 CEST (10s ago) 71
+ 72 Command Line: mserver5 --debug=0 --set gdk_nr_threads 0 --set mapi_open true --set mapi_port 35896 --set mapi_usock /var/tmp/mtest-29872/.s.monetdb.35896 --forcemito --set gdk_vm_maxsize 8589934592 --dbpath=/export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/tests/sql/dbfarm/mTests_sql_test_subquery --set embedded_c true 72
+ 73 Executable: /export/scratch1/home/monet/testing/0177627dc2e1-5-1-4/install/bin/mserver5 73
+ 74 Control Group: /user.slice/user-9375.slice/session-193598.scope 74
+ 75 Unit: session-193598.scope 75
+ 76 Slice: user-9375.slice 76
+ 77 Session: 193598 77
+ 78 Owner UID: 9375 (monet) 78
+ 79 Boot ID: ffb99550b12f4aea8f810af2184a5537 79
+ 80 Machine ID: e337df3642554894abe42ddbaf212f1d 80
+ 81 Hostname: lab05.da.cwi.nl 81
+ 82 Storage: /var/lib/systemd/coredump/core.mserver5.9375.ffb99550b12f4aea8f810af2184a5537.23355.1569006796000000.lz4 82
+ 83 Message: Process 23355 (mserver5) of user 9375 dumped core. 83
18 18 84 84
+ 85 Stack trace of thread 23384: 85
+ 86 #0 0x00007f81ee638e75 exp_subtype (lib_sql.so) 86
+ 87 #1 0x00007f81ee6131fe rel_nop_ (lib_sql.so) 87
+ 88 #2 0x00007f81ee613d5a rel_compare_exp_ (lib_sql.so) 88
+ 89 #3 0x00007f81ee61a699 rel_compare (lib_sql.so) 89
+ 90 #4 0x00007f81ee618fab rel_select_exp (lib_sql.so) 90
+ 91 #5 0x00007f81ee61443a rel_selects (lib_sql.so) 91
+ 92 #6 0x00007f81ee573c4c sql_symbol2relation (lib_sql.so) 92
+ 93 #7 0x00007f81ee58c4c3 SQLparser (lib_sql.so) 93
+ 94 #8 0x00007f81f69d3022 runPhase (libmonetdb5.so.27) 94
+ 95 #9 0x00007f81f69d36c2 MSserveClient (libmonetdb5.so.27) 95
+ 96 #10 0x00007f81f69d3e24 MSscheduleClient (libmonetdb5.so.27) 96
+ 97 #11 0x00007f81f6a5b62d doChallenge (libmonetdb5.so.27) 97
+ 98 #12 0x00007f81f65f95c9 THRstarter (libbat.so.18) 98
+ 99 #13 0x00007f81f667dff9 thread_starter (libbat.so.18) 99
+ 100 #14 0x00007f81f3fcb36d start_thread (libpthread.so.0) 100
+ 101 #15 0x00007f81f3cffb4f __clone (libc.so.6) 101
19 19 102 102
20 # 18:55:46 > 20 ! 103 Stack trace of thread 23355: 103
21 # 18:55:46 > "Done." 21 ! 104 #0 0x00007f81f3fd599d __nanosleep (libpthread.so.0) 104
22 # 18:55:46 > 22 ! 105 #1 0x00007f81f667ff4e MT_sleep_ms (libbat.so.18) 105
+ 106 #2 0x0000000000402d2e main (mserver5) 106
+ 107 #3 0x00007f81f3c0f88a __libc_start_main (libc.so.6) 107
+ 108 #4 0x0000000000402e1a _start (mserver5) 108
+ 109 109
+ 110 Stack trace of thread 23357: 110
+ 111 #0 0x00007f81f3fd599d __nanosleep (libpthread.so.0) 111
+ 112 #1 0x00007f81f667ff4e MT_sleep_ms (libbat.so.18) 112
+ 113 #2 0x00007f81f69cf093 profilerHeartbeat (libmonetdb5.so.27) 113
+ 114 #3 0x00007f81f667dff9 thread_starter (libbat.so.18) 114
+ 115 #4 0x00007f81f3fcb36d start_thread (libpthread.so.0) 115
+ 116 #5 0x00007f81f3cffb4f __clone (libc.so.6) 116
+ 117 117
+ 118 Stack trace of thread 23379: 118
+ 119 #0 0x00007f81f3fd599d __nanosleep (libpthread.so.0) 119
+ 120 #1 0x00007f81f667ff4e MT_sleep_ms (libbat.so.18) 120
+ 121 #2 0x00007f81ee694b0a store_manager (lib_sql.so) 121
+ 122 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 122
+ 123 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 123
+ 124 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 124
+ 125 #6 0x00007f81f3cffb4f __clone (libc.so.6) 125
+ 126 126
+ 127 Stack trace of thread 23358: 127
+ 128 #0 0x00007f81f3cf3a5d poll (libc.so.6) 128
+ 129 #1 0x00007f81f6a59ed8 SERVERlistenThread (libmonetdb5.so.27) 129
+ 130 #2 0x00007f81f667dff9 thread_starter (libbat.so.18) 130
+ 131 #3 0x00007f81f3fcb36d start_thread (libpthread.so.0) 131
+ 132 #4 0x00007f81f3cffb4f __clone (libc.so.6) 132
+ 133 133
+ 134 Stack trace of thread 23380: 134
+ 135 #0 0x00007f81f3fd599d __nanosleep (libpthread.so.0) 135
+ 136 #1 0x00007f81f667ff4e MT_sleep_ms (libbat.so.18) 136
+ 137 #2 0x00007f81ee6a41f7 idle_manager (lib_sql.so) 137
+ 138 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 138
+ 139 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 139
+ 140 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 140
+ 141 #6 0x00007f81f3cffb4f __clone (libc.so.6) 141
+ 142 142
+ 143 Stack trace of thread 23394: 143
+ 144 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 144
+ 145 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 145
+ 146 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 146
+ 147 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 147
+ 148 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 148
+ 149 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 149
+ 150 #6 0x00007f81f3cffb4f __clone (libc.so.6) 150
+ 151 151
+ 152 Stack trace of thread 23396: 152
+ 153 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 153
+ 154 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 154
+ 155 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 155
+ 156 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 156
+ 157 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 157
+ 158 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 158
+ 159 #6 0x00007f81f3cffb4f __clone (libc.so.6) 159
+ 160 160
+ 161 Stack trace of thread 23390: 161
+ 162 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 162
+ 163 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 163
+ 164 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 164
+ 165 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 165
+ 166 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 166
+ 167 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 167
+ 168 #6 0x00007f81f3cffb4f __clone (libc.so.6) 168
+ 169 169
+ 170 Stack trace of thread 23389: 170
+ 171 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 171
+ 172 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 172
+ 173 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 173
+ 174 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 174
+ 175 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 175
+ 176 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 176
+ 177 #6 0x00007f81f3cffb4f __clone (libc.so.6) 177
+ 178 178
+ 179 Stack trace of thread 23388: 179
+ 180 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 180
+ 181 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 181
+ 182 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 182
+ 183 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 183
+ 184 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 184
+ 185 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 185
+ 186 #6 0x00007f81f3cffb4f __clone (libc.so.6) 186
+ 187 187
+ 188 Stack trace of thread 23392: 188
+ 189 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 189
+ 190 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 190
+ 191 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 191
+ 192 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 192
+ 193 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 193
+ 194 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 194
+ 195 #6 0x00007f81f3cffb4f __clone (libc.so.6) 195
+ 196 196
+ 197 Stack trace of thread 23395: 197
+ 198 #0 0x00007f81f3fd46d6 do_futex_wait.constprop.1 (libpthread.so.0) 198
+ 199 #1 0x00007f81f3fd47c8 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 199
+ 200 #2 0x00007f81f69ba568 q_dequeue (libmonetdb5.so.27) 200
+ 201 #3 0x00007f81f65f95c9 THRstarter (libbat.so.18) 201
+ 202 #4 0x00007f81f667dff9 thread_starter (libbat.so.18) 202
+ 203 #5 0x00007f81f3fcb36d start_thread (libpthread.so.0) 203
+ 204 #6 0x00007f81f3cffb4f __clone (libc.so.6) 204
+ 205 205
+ 206 # 21:13:16 > 206
+ 207 # 21:13:16 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29872" "--port=35896" 207
+ 208 # 21:13:16 > 208
+ 209 209
+ 210 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 210
+ 211 QUERY = SELECT col1 IN (SELECT ColID + col1 FROM tbl_ProductSales) FROM another_T GROUP BY col1; 211
+ 212 ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function 212
+ 213 CODE = 42000 213
+ 214 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 214
+ 215 QUERY = SELECT col1 IN (SELECT SUM(ColID + col1) FROM tbl_ProductSales) FROM another_T GROUP BY col1; 215
+ 216 ERROR = !Error in optimizer garbageCollector 216
+ 217 CODE = 42000 217
+ 218 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 218
+ 219 QUERY = SELECT 219
+ 220 EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID = another_T.col1), 220
+ 221 (SELECT ColID FROM tbl_ProductSales) * DENSE_RANK() OVER (PARTITION BY AVG(DISTINCT col5)) 221
+ 222 FROM another_T GROUP BY col1, col2, col5, col8; 222
+ 223 ERROR = !Error in optimizer garbageCollector 223
+ 224 CODE = 42000 224
+ 225 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 225
+ 226 QUERY = SELECT 226
+ 227 col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales), 227
+ 228 CAST(SUM(DISTINCT CASE WHEN col5 - col8 = (SELECT MIN(ColID / col2) FROM tbl_ProductSales) THEN col2 - 5 ELSE ABS(col1) END) AS BIGINT), 228
+ 229 (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER (PARTITION BY AVG(DISTINCT col5)) 229
+ 230 FROM another_T 230
+ 231 GROUP BY col1, col2, col5, col8; 231
+ 232 ERROR = !Error in optimizer garbageCollector 232
+ 233 CODE = 42000 233
+ 234 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 234
+ 235 QUERY = SELECT 235
+ 236 col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales), 236
+ 237 MIN(col8) OVER (PARTITION BY col5 ORDER BY col1 ROWS UNBOUNDED PRECEDING) 237
+ 238 FROM another_T 238
+ 239 GROUP BY col1, col2, col5, col8; 239
+ 240 ERROR = !SELECT: cannot use non GROUP BY column 'L7' in query results without an aggregate function 240
+ 241 CODE = 42000 241
+ 242 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 242
+ 243 QUERY = SELECT 243
+ 244 EXISTS (SELECT 1 FROM tbl_ProductSales), 244
+ 245 NOT EXISTS (SELECT 1 FROM tbl_ProductSales) 245
+ 246 FROM another_T 246
+ 247 GROUP BY col1; 247
+ 248 ERROR = !'aggr.not_exist' undefined in: aggr.not_exist(X_66:bat[:bte]); 248
+ 249 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 249
+ 250 QUERY = SELECT 250
+ 251 NOT -SUM(col2) NOT IN (SELECT ColID FROM tbl_ProductSales GROUP BY ColID HAVING SUM(ColID - col8) <> col5), 251
+ 252 NOT col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MAX(col8) > 2 AND MIN(col8) IS NOT NULL), 252
+ 253 NOT col2 <> ANY (SELECT 20 FROM tbl_ProductSales GROUP BY ColID HAVING NOT MAX(col1) <> col1 * AVG(col1 + ColID) * ColID), 253
+ 254 NOT EXISTS (SELECT ColID - 12 FROM tbl_ProductSales GROUP BY ColID HAVING MAX(col2) IS NULL OR NOT col8 <> 2 / col1) 254
+ 255 FROM another_T 255
+ 256 GROUP BY col1, col2, col5, col8; 256
+ 257 ERROR = !'aggr.subnot_exist' undefined in: X_420:bat[:bit] := aggr.subnot_exist(X_409:bat[:lng], X_417:bat[:oid], X_418:bat[:oid], false:bit); 257
+ 258 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 258
+ 259 QUERY = SELECT 259
+ 260 (SELECT MAX(col6) FROM tbl_ProductSales) IN (SELECT MIN(col3) FROM another_T) 260
+ 261 FROM another_T 261
+ 262 GROUP BY col1; --error, subquery returns more than 1 row 262
+ 263 ERROR = !Error in optimizer garbageCollector 263
+ 264 CODE = 42000 264
+ 265 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 265
+ 266 QUERY = SELECT 266
+ 267 t1.col1 = ALL (SELECT col4 + SUM(t1.col5) FROM another_T INNER JOIN tbl_ProductSales ON another_T.col1 = tbl_ProductSales.ColID) 267
+ 268 FROM another_T t1 268
+ 269 GROUP BY t1.col1; 269
+ 270 ERROR = !SELECT: no such column 't1.col5' 270
+ 271 CODE = 42S22 271
+ 272 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 272
+ 273 QUERY = SELECT 273
+ 274 SUM(col1) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2) 274
+ 275 FROM another_T 275
+ 276 GROUP BY col4; 276
+ 277 ERROR = !Error in optimizer garbageCollector 277
+ 278 CODE = 42000 278
+ 279 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 279
+ 280 QUERY = SELECT 280
+ 281 CASE WHEN NOT col1 NOT IN (SELECT (SELECT MAX(col7)) UNION (SELECT MIN(ColID) FROM tbl_ProductSales LEFT JOIN another_T t2 ON t2.col5 = t1.col1)) THEN 1 ELSE 2 END 281
+ 282 FROM another_T t1 282
+ 283 GROUP BY col1; 283
+ 284 ERROR = !SELECT: identifier 'col7' unknown 284
+ 285 CODE = 42000 285
+ 286 #~ MAPI = (monetdb) /var/tmp/mtest-29872/.s.monetdb.35896 286
+ 287 QUERY = SELECT 287
+ 288 t1.col1 IN (SELECT ColID FROM tbl_ProductSales GROUP BY t1.col1, tbl_ProductSales.ColID) 288
+ 289 FROM another_T t1 289
+ 290 GROUP BY col1; 290
+ 291 ERROR = !Error in optimizer garbageCollector 291
+ 292 CODE = 42000 292
+ 293 293
+ 294 Signal 13 294
+ 295 295
+ 296 # 21:13:26 > 296
+ 297 # 21:13:26 > "Done." 297
+ 298 # 21:13:26 > 298
23 23 299 299