Test double-free.Bug-6757.sql (id 6b3b1396de21) (out)
double-free.Bug-6757.stable.err.FILTERED 2019-09-20 12:03:28.524794900 +0200double-free.Bug-6757.test.err.FILTERED 2019-09-20 12:03:28.555995000 +0200
1 Statistics about stderr of test 'double-free.Bug-6757` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stderr of test 'double-free.Bug-6757` in directory 'sql/test/BugTracker-2019`: 1
2 10 lines, 118 words, 738 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 398 lines, 1921 words, 12413 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 10 lines, 118 words, 738 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 398 lines, 1921 words, 12413 chars in lines not matching '^$|^(\| |)#` 3
4 # 29 lines, 185 words, 1467 chars in all lines 4 ! 4 # 571 lines, 2788 words, 22582 chars in all lines 4
5 5 5 5
..................
# 19:54:41 >
19 19 12 12
20 #~ MAPI = (monetdb) /var/tmp/mtest-25888/.s.monetdb.32780 20 ! 13 #client2:!ERROR:ParseException:SQLparser:22003!Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_130" ( 13
+ 14 #client2:!ERROR: "a1" char(1), 14
+ 15 #client2:!ERROR: "prob" decimal(38,3)" 15
+ 16 #client2:!ERROR:ParseException:SQLparser:42000!syntax error, unexpected ')' in: ")" 16
+ 17 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 17
+ 18 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 18
+ 19 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 19
+ 20 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 20
+ 21 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 21
+ 22 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 22
+ 23 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 23
+ 24 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 24
+ 25 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 25
+ 26 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 26
+ 27 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 27
+ 28 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 28
+ 29 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 29
+ 30 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 30
+ 31 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 31
+ 32 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 32
+ 33 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 33
+ 34 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 34
+ 35 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 35
+ 36 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 36
+ 37 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 37
+ 38 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 38
+ 39 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 39
+ 40 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 40
+ 41 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 41
+ 42 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 42
+ 43 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 43
+ 44 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 44
+ 45 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 45
+ 46 #client2:!ERROR:ParseException:SQLparser:22003!Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_172" ( 46
+ 47 #client2:!ERROR: "a1" char(1), 47
+ 48 #client2:!ERROR: "prob" decimal(38,3)" 48
+ 49 #client2:!ERROR:ParseException:SQLparser:42000!syntax error, unexpected ')' in: ")" 49
+ 50 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 50
+ 51 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 51
+ 52 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 52
+ 53 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 53
+ 54 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 54
+ 55 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 55
+ 56 #client2:!ERROR:ParseException:SQLparser:22003!Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_180" ( 56
+ 57 #client2:!ERROR: "a1" char(1), 57
+ 58 #client2:!ERROR: "prob" decimal(38,3)" 58
+ 59 #client2:!ERROR:ParseException:SQLparser:42000!syntax error, unexpected ')' in: ")" 59
+ 60 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 60
+ 61 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 61
+ 62 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 62
+ 63 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 63
+ 64 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 64
+ 65 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 65
+ 66 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 66
+ 67 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 67
+ 68 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 68
+ 69 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 69
+ 70 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 70
+ 71 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 71
+ 72 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 72
+ 73 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 73
+ 74 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 74
+ 75 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 75
+ 76 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 76
+ 77 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 77
+ 78 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 78
+ 79 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 79
+ 80 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 80
+ 81 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 81
+ 82 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 82
+ 83 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 83
+ 84 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 84
+ 85 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 85
+ 86 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 86
+ 87 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 87
+ 88 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 88
+ 89 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 89
+ 90 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 90
+ 91 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 91
+ 92 #client2:!ERROR:SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) 92
+ 93 93
+ 94 # 12:03:27 > 94
+ 95 # 12:03:27 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=31767" 95
+ 96 # 12:03:27 > 96
+ 97 97
+ 98 #~ MAPI = monetdb@LAB03:31767 98
+ 99 QUERY = CREATE TABLE "sys"."_cachedrel_130" ( 99
+ 100 "a1" CHAR(1), 100
+ 101 "prob" DECIMAL(38,3) 101
+ 102 ERROR = !Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_130" ( 102
+ 103 ! "a1" char(1), 103
+ 104 ! "prob" decimal(38,3)" 104
+ 105 CODE = 22003 105
+ 106 #~ MAPI = monetdb@LAB03:31767 106
+ 107 QUERY = ); 107
+ 108 ERROR = !syntax/parse error, 108
+ 109 # the original non-normalized output was: ERROR = !syntax error, unexpected ')' in: ")" 109
+ 110 CODE = 42000 110
+ 111 #~ MAPI = monetdb@LAB03:31767 111
+ 112 QUERY = CREATE TABLE "sys"."_cachedrel_134" ( 112
+ 113 "a1" INTEGER, 113
+ 114 "prob" FLOAT(51) 114
+ 115 ); 115
+ 116 ERROR = !Current transaction is aborted (please ROLLBACK) 116
+ 117 CODE = 25005 117
+ 118 #~ MAPI = monetdb@LAB03:31767 118
+ 119 QUERY = CREATE TABLE "sys"."_cachedrel_135" ( 119
+ 120 "a1" INTEGER, 120
+ 121 "prob" DOUBLE 121
+ 122 ); 122
+ 123 ERROR = !Current transaction is aborted (please ROLLBACK) 123
+ 124 CODE = 25005 124
+ 125 #~ MAPI = monetdb@LAB03:31767 125
+ 126 QUERY = CREATE TABLE "sys"."_cachedrel_136" ( 126
+ 127 "a1" INTEGER, 127
+ 128 "prob" DOUBLE 128
+ 129 ); 129
+ 130 ERROR = !Current transaction is aborted (please ROLLBACK) 130
+ 131 CODE = 25005 131
+ 132 #~ MAPI = monetdb@LAB03:31767 132
+ 133 QUERY = CREATE TABLE "sys"."_cachedrel_137" ( 133
+ 134 "a1" INTEGER, 134
+ 135 "prob" FLOAT(51) 135
+ 136 ); 136
+ 137 ERROR = !Current transaction is aborted (please ROLLBACK) 137
+ 138 CODE = 25005 138
+ 139 #~ MAPI = monetdb@LAB03:31767 139
+ 140 QUERY = CREATE TABLE "sys"."_cachedrel_138" ( 140
+ 141 "a1" INTEGER, 141
+ 142 "a2" INTEGER, 142
+ 143 "a3" INTEGER, 143
+ 144 "prob" DOUBLE 144
+ 145 ); 145
+ 146 ERROR = !Current transaction is aborted (please ROLLBACK) 146
+ 147 CODE = 25005 147
+ 148 #~ MAPI = monetdb@LAB03:31767 148
+ 149 QUERY = CREATE TABLE "sys"."_cachedrel_139" ( 149
+ 150 "a1" INTEGER, 150
+ 151 "a2" INTEGER, 151
+ 152 "a3" INTEGER, 152
+ 153 "prob" DOUBLE 153
+ 154 ); 154
+ 155 ERROR = !Current transaction is aborted (please ROLLBACK) 155
+ 156 CODE = 25005 156
+ 157 #~ MAPI = monetdb@LAB03:31767 157
+ 158 QUERY = CREATE TABLE "sys"."_cachedrel_140" ( 158
+ 159 "a1" INTEGER, 159
+ 160 "a2" INTEGER, 160
+ 161 "prob" DOUBLE 161
+ 162 ); 162
+ 163 ERROR = !Current transaction is aborted (please ROLLBACK) 163
+ 164 CODE = 25005 164
+ 165 #~ MAPI = monetdb@LAB03:31767 165
+ 166 QUERY = CREATE TABLE "sys"."_cachedrel_143" ( 166
+ 167 "a1" INTEGER, 167
+ 168 "prob" FLOAT(51) 168
+ 169 ); 169
+ 170 ERROR = !Current transaction is aborted (please ROLLBACK) 170
+ 171 CODE = 25005 171
+ 172 #~ MAPI = monetdb@LAB03:31767 172
+ 173 QUERY = CREATE TABLE "sys"."_cachedrel_144" ( 173
+ 174 "a1" INTEGER, 174
+ 175 "a2" INTEGER, 175
+ 176 "a3" INTEGER, 176
+ 177 "prob" DOUBLE 177
+ 178 ); 178
+ 179 ERROR = !Current transaction is aborted (please ROLLBACK) 179
+ 180 CODE = 25005 180
+ 181 #~ MAPI = monetdb@LAB03:31767 181
+ 182 QUERY = CREATE TABLE "sys"."_cachedrel_145" ( 182
+ 183 "a1" INTEGER, 183
+ 184 "a2" INTEGER, 184
+ 185 "a3" INTEGER, 185
+ 186 "prob" DOUBLE 186
+ 187 ); 187
+ 188 ERROR = !Current transaction is aborted (please ROLLBACK) 188
+ 189 CODE = 25005 189
+ 190 #~ MAPI = monetdb@LAB03:31767 190
+ 191 QUERY = CREATE TABLE "sys"."_cachedrel_146" ( 191
+ 192 "a1" INTEGER, 192
+ 193 "a2" INTEGER, 193
+ 194 "prob" DOUBLE 194
+ 195 ); 195
+ 196 ERROR = !Current transaction is aborted (please ROLLBACK) 196
+ 197 CODE = 25005 197
+ 198 #~ MAPI = monetdb@LAB03:31767 198
+ 199 QUERY = CREATE TABLE "sys"."_cachedrel_149" ( 199
+ 200 "a1" INTEGER, 200
+ 201 "a2" INTEGER, 201
+ 202 "prob" DOUBLE 202
+ 203 ); 203
+ 204 ERROR = !Current transaction is aborted (please ROLLBACK) 204
+ 205 CODE = 25005 205
+ 206 #~ MAPI = monetdb@LAB03:31767 206
+ 207 QUERY = CREATE TABLE "sys"."_cachedrel_150" ( 207
+ 208 "a1" INTEGER, 208
+ 209 "prob" FLOAT(51) 209
+ 210 ); 210
+ 211 ERROR = !Current transaction is aborted (please ROLLBACK) 211
+ 212 CODE = 25005 212
+ 213 #~ MAPI = monetdb@LAB03:31767 213
+ 214 QUERY = CREATE TABLE "sys"."_cachedrel_151" ( 214
+ 215 "a1" INTEGER, 215
+ 216 "a2" INTEGER, 216
+ 217 "a3" INTEGER, 217
+ 218 "prob" DOUBLE 218
+ 219 ); 219
+ 220 ERROR = !Current transaction is aborted (please ROLLBACK) 220
+ 221 CODE = 25005 221
+ 222 #~ MAPI = monetdb@LAB03:31767 222
+ 223 QUERY = CREATE TABLE "sys"."_cachedrel_152" ( 223
+ 224 "a1" INTEGER, 224
+ 225 "a2" INTEGER, 225
+ 226 "a3" INTEGER, 226
+ 227 "prob" DOUBLE 227
+ 228 ); 228
+ 229 ERROR = !Current transaction is aborted (please ROLLBACK) 229
+ 230 CODE = 25005 230
+ 231 #~ MAPI = monetdb@LAB03:31767 231
+ 232 QUERY = CREATE TABLE "sys"."_cachedrel_153" ( 232
+ 233 "a1" INTEGER, 233
+ 234 "a2" INTEGER, 234
+ 235 "prob" DOUBLE 235
+ 236 ); 236
+ 237 ERROR = !Current transaction is aborted (please ROLLBACK) 237
+ 238 CODE = 25005 238
+ 239 #~ MAPI = monetdb@LAB03:31767 239
+ 240 QUERY = CREATE TABLE "sys"."_cachedrel_156" ( 240
+ 241 "a1" INTEGER, 241
+ 242 "a2" INTEGER, 242
+ 243 "prob" DOUBLE 243
+ 244 ); 244
+ 245 ERROR = !Current transaction is aborted (please ROLLBACK) 245
+ 246 CODE = 25005 246
+ 247 #~ MAPI = monetdb@LAB03:31767 247
+ 248 QUERY = CREATE TABLE "sys"."_cachedrel_157" ( 248
+ 249 "a1" INTEGER, 249
+ 250 "a2" INTEGER, 250
+ 251 "prob" DOUBLE 251
+ 252 ); 252
+ 253 ERROR = !Current transaction is aborted (please ROLLBACK) 253
+ 254 CODE = 25005 254
+ 255 #~ MAPI = monetdb@LAB03:31767 255
+ 256 QUERY = CREATE TABLE "sys"."_cachedrel_158" ( 256
+ 257 "a1" INTEGER, 257
+ 258 "a2" INTEGER, 258
+ 259 "prob" DOUBLE 259
+ 260 ); 260
+ 261 ERROR = !Current transaction is aborted (please ROLLBACK) 261
+ 262 CODE = 25005 262
+ 263 #~ MAPI = monetdb@LAB03:31767 263
+ 264 QUERY = CREATE TABLE "sys"."_cachedrel_159" ( 264
+ 265 "a1" INTEGER, 265
+ 266 "a2" INTEGER, 266
+ 267 "prob" DOUBLE 267
+ 268 ); 268
+ 269 ERROR = !Current transaction is aborted (please ROLLBACK) 269
+ 270 CODE = 25005 270
+ 271 #~ MAPI = monetdb@LAB03:31767 271
+ 272 QUERY = CREATE TABLE "sys"."_cachedrel_161" ( 272
+ 273 "a1" INTEGER, 273
+ 274 "prob" FLOAT(51) 274
+ 275 ); 275
+ 276 ERROR = !Current transaction is aborted (please ROLLBACK) 276
+ 277 CODE = 25005 277
+ 278 #~ MAPI = monetdb@LAB03:31767 278
+ 279 QUERY = CREATE TABLE "sys"."_cachedrel_162" ( 279
+ 280 "a1" INTEGER, 280
+ 281 "a2" INTEGER, 281
+ 282 "a3" CHARACTER LARGE OBJECT, 282
+ 283 "a4" CHARACTER LARGE OBJECT, 283
+ 284 "prob" DOUBLE 284
+ 285 ); 285
+ 286 ERROR = !Current transaction is aborted (please ROLLBACK) 286
+ 287 CODE = 25005 287
+ 288 #~ MAPI = monetdb@LAB03:31767 288
+ 289 QUERY = CREATE TABLE "sys"."_cachedrel_163" ( 289
+ 290 "a1" INTEGER, 290
+ 291 "a2" INTEGER, 291
+ 292 "a3" CHARACTER LARGE OBJECT, 292
+ 293 "a4" CHARACTER LARGE OBJECT, 293
+ 294 "prob" DOUBLE 294
+ 295 ); 295
+ 296 ERROR = !Current transaction is aborted (please ROLLBACK) 296
+ 297 CODE = 25005 297
+ 298 #~ MAPI = monetdb@LAB03:31767 298
+ 299 QUERY = CREATE TABLE "sys"."_cachedrel_165" ( 299
+ 300 "a1" INTEGER, 300
+ 301 "prob" FLOAT(51) 301
+ 302 ); 302
+ 303 ERROR = !Current transaction is aborted (please ROLLBACK) 303
+ 304 CODE = 25005 304
+ 305 #~ MAPI = monetdb@LAB03:31767 305
+ 306 QUERY = CREATE TABLE "sys"."_cachedrel_166" ( 306
+ 307 "a1" INTEGER, 307
+ 308 "a2" INTEGER, 308
+ 309 "a3" INTEGER, 309
+ 310 "prob" DOUBLE 310
+ 311 ); 311
+ 312 ERROR = !Current transaction is aborted (please ROLLBACK) 312
+ 313 CODE = 25005 313
+ 314 #~ MAPI = monetdb@LAB03:31767 314
+ 315 QUERY = CREATE TABLE "sys"."_cachedrel_167" ( 315
+ 316 "a1" INTEGER, 316
+ 317 "a2" INTEGER, 317
+ 318 "a3" INTEGER, 318
+ 319 "prob" DOUBLE 319
+ 320 ); 320
+ 321 ERROR = !Current transaction is aborted (please ROLLBACK) 321
+ 322 CODE = 25005 322
+ 323 #~ MAPI = monetdb@LAB03:31767 323
+ 324 QUERY = CREATE TABLE "sys"."_cachedrel_168" ( 324
+ 325 "a1" INTEGER, 325
+ 326 "prob" FLOAT(51) 326
+ 327 ); 327
+ 328 ERROR = !Current transaction is aborted (please ROLLBACK) 328
+ 329 CODE = 25005 329
+ 330 #~ MAPI = monetdb@LAB03:31767 330
+ 331 QUERY = CREATE TABLE "sys"."_cachedrel_169" ( 331
+ 332 "a1" INTEGER, 332
+ 333 "a2" INTEGER, 333
+ 334 "a3" CHARACTER LARGE OBJECT, 334
+ 335 "a4" CHARACTER LARGE OBJECT, 335
+ 336 "prob" DOUBLE 336
+ 337 ); 337
+ 338 ERROR = !Current transaction is aborted (please ROLLBACK) 338
+ 339 CODE = 25005 339
+ 340 #~ MAPI = monetdb@LAB03:31767 340
+ 341 QUERY = CREATE TABLE "sys"."_cachedrel_170" ( 341
+ 342 "a1" INTEGER, 342
+ 343 "a2" INTEGER, 343
+ 344 "a3" CHARACTER LARGE OBJECT, 344
+ 345 "a4" CHARACTER LARGE OBJECT, 345
+ 346 "prob" DOUBLE 346
+ 347 ); 347
+ 348 ERROR = !Current transaction is aborted (please ROLLBACK) 348
+ 349 CODE = 25005 349
+ 350 #~ MAPI = monetdb@LAB03:31767 350
+ 351 QUERY = CREATE TABLE "sys"."_cachedrel_172" ( 351
+ 352 "a1" CHAR(1), 352
+ 353 "prob" DECIMAL(38,3) 353
+ 354 ERROR = !Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_172" ( 354
+ 355 ! "a1" char(1), 355
+ 356 ! "prob" decimal(38,3)" 356
+ 357 CODE = 22003 357
+ 358 #~ MAPI = monetdb@LAB03:31767 358
+ 359 QUERY = ); 359
+ 360 ERROR = !syntax/parse error, 360
+ 361 # the original non-normalized output was: ERROR = !syntax error, unexpected ')' in: ")" 361
+ 362 CODE = 42000 362
+ 363 #~ MAPI = monetdb@LAB03:31767 363
+ 364 QUERY = CREATE TABLE "sys"."_cachedrel_173" ( 364
+ 365 "a1" INTEGER, 365
+ 366 "a2" INTEGER, 366
+ 367 "prob" DOUBLE 367
+ 368 ); 368
+ 369 ERROR = !Current transaction is aborted (please ROLLBACK) 369
+ 370 CODE = 25005 370
+ 371 #~ MAPI = monetdb@LAB03:31767 371
+ 372 QUERY = CREATE TABLE "sys"."_cachedrel_174" ( 372
+ 373 "a1" INTEGER, 373
+ 374 "a2" INTEGER, 374
+ 375 "prob" DOUBLE 375
+ 376 ); 376
+ 377 ERROR = !Current transaction is aborted (please ROLLBACK) 377
+ 378 CODE = 25005 378
+ 379 #~ MAPI = monetdb@LAB03:31767 379
+ 380 QUERY = CREATE TABLE "sys"."_cachedrel_175" ( 380
+ 381 "a1" INTEGER, 381
+ 382 "prob" DOUBLE 382
+ 383 ); 383
+ 384 ERROR = !Current transaction is aborted (please ROLLBACK) 384
+ 385 CODE = 25005 385
+ 386 #~ MAPI = monetdb@LAB03:31767 386
+ 387 QUERY = CREATE TABLE "sys"."_cachedrel_176" ( 387
+ 388 "prob" DOUBLE 388
+ 389 ); 389
+ 390 ERROR = !Current transaction is aborted (please ROLLBACK) 390
+ 391 CODE = 25005 391
+ 392 #~ MAPI = monetdb@LAB03:31767 392
+ 393 QUERY = CREATE TABLE "sys"."_cachedrel_177" ( 393
+ 394 "a1" INTEGER, 394
+ 395 "prob" DOUBLE 395
+ 396 ); 396
+ 397 ERROR = !Current transaction is aborted (please ROLLBACK) 397
+ 398 CODE = 25005 398
+ 399 #~ MAPI = monetdb@LAB03:31767 399
+ 400 QUERY = CREATE TABLE "sys"."_cachedrel_178" ( 400
+ 401 "a1" INTEGER, 401
+ 402 "prob" DOUBLE 402
+ 403 ); 403
+ 404 ERROR = !Current transaction is aborted (please ROLLBACK) 404
+ 405 CODE = 25005 405
+ 406 #~ MAPI = monetdb@LAB03:31767 406
+ 407 QUERY = CREATE TABLE "sys"."_cachedrel_180" ( 407
+ 408 "a1" CHAR(1), 408
+ 409 "prob" DECIMAL(38,3) 409
+ 410 ERROR = !Decimal(38,3) isn't supported because P=38 > 18 in: "create table "sys"."_cachedrel_180" ( 410
+ 411 ! "a1" char(1), 411
+ 412 ! "prob" decimal(38,3)" 412
+ 413 CODE = 22003 413
+ 414 #~ MAPI = monetdb@LAB03:31767 414
+ 415 QUERY = ); 415
+ 416 ERROR = !syntax/parse error, 416
+ 417 # the original non-normalized output was: ERROR = !syntax error, unexpected ')' in: ")" 417
+ 418 CODE = 42000 418
+ 419 #~ MAPI = monetdb@LAB03:31767 419
+ 420 QUERY = CREATE TABLE "sys"."_cachedrel_181" ( 420
+ 421 "a1" INTEGER, 421
+ 422 "prob" FLOAT(51) 422
+ 423 ); 423
+ 424 ERROR = !Current transaction is aborted (please ROLLBACK) 424
+ 425 CODE = 25005 425
+ 426 #~ MAPI = monetdb@LAB03:31767 426
+ 427 QUERY = CREATE TABLE "sys"."_cachedrel_182" ( 427
+ 428 "a1" INTEGER, 428
+ 429 "a2" INTEGER, 429
+ 430 "a3" CHARACTER LARGE OBJECT, 430
+ 431 "a4" CHARACTER LARGE OBJECT, 431
+ 432 "prob" DOUBLE 432
+ 433 ); 433
+ 434 ERROR = !Current transaction is aborted (please ROLLBACK) 434
+ 435 CODE = 25005 435
+ 436 #~ MAPI = monetdb@LAB03:31767 436
+ 437 QUERY = CREATE TABLE "sys"."_cachedrel_183" ( 437
+ 438 "a1" INTEGER, 438
+ 439 "a2" INTEGER, 439
+ 440 "a3" CHARACTER LARGE OBJECT, 440
+ 441 "a4" CHARACTER LARGE OBJECT, 441
+ 442 "prob" DOUBLE 442
+ 443 ); 443
+ 444 ERROR = !Current transaction is aborted (please ROLLBACK) 444
+ 445 CODE = 25005 445
+ 446 #~ MAPI = monetdb@LAB03:31767 446
+ 447 QUERY = create or replace function pcre_replace(s string, pattern string, repl string, flags string) returns string external name pcre."replace"; 447
+ 448 ERROR = !Current transaction is aborted (please ROLLBACK) 448
+ 449 CODE = 25005 449
+ 450 #~ MAPI = monetdb@LAB03:31767 450
+ 451 QUERY = create view _cachedrel_1 as select idstr as a1, id as a2, prob from bm_0_obj_dict; 451
+ 452 ERROR = !Current transaction is aborted (please ROLLBACK) 452
+ 453 CODE = 25005 453
+ 454 #~ MAPI = monetdb@LAB03:31767 454
+ 455 QUERY = create view _cachedrel_2 as select a2 as a1, prob from _cachedrel_1; 455
+ 456 ERROR = !Current transaction is aborted (please ROLLBACK) 456
+ 457 CODE = 25005 457
+ 458 #~ MAPI = monetdb@LAB03:31767 458
+ 459 QUERY = create view _cachedrel_3 as select id as a1, type as a2, typestr as a3, prob from bm_0_obj_type; 459
+ 460 ERROR = !Current transaction is aborted (please ROLLBACK) 460
+ 461 CODE = 25005 461
+ 462 #~ MAPI = monetdb@LAB03:31767 462
+ 463 QUERY = create view _cachedrel_33 as select a1, a2, prob from _cachedrel_32; 463
+ 464 ERROR = !Current transaction is aborted (please ROLLBACK) 464
+ 465 CODE = 25005 465
+ 466 #~ MAPI = monetdb@LAB03:31767 466
+ 467 QUERY = create view _cachedrel_45 as select a1, a1 as a2, prob from _cachedrel_43; 467
+ 468 ERROR = !Current transaction is aborted (please ROLLBACK) 468
+ 469 CODE = 25005 469
+ 470 #~ MAPI = monetdb@LAB03:31767 470
+ 471 QUERY = create view _cachedrel_53 as select a1, prob from (values ('1',1.0)) as t__x41(a1,prob); 471
+ 472 ERROR = !Current transaction is aborted (please ROLLBACK) 472
+ 473 CODE = 25005 473
+ 474 #~ MAPI = monetdb@LAB03:31767 474
+ 475 QUERY = create view _cachedrel_55 as select a1, prob from (values ('2',1.0)) as t__x44(a1,prob); 475
+ 476 ERROR = !Current transaction is aborted (please ROLLBACK) 476
+ 477 CODE = 25005 477
+ 478 #~ MAPI = monetdb@LAB03:31767 478
+ 479 QUERY = create view _cachedrel_83 as select a1, a2, prob from _cachedrel_82; 479
+ 480 ERROR = !Current transaction is aborted (please ROLLBACK) 480
+ 481 CODE = 25005 481
+ 482 #~ MAPI = monetdb@LAB03:31767 482
+ 483 QUERY = create view _cachedrel_84 as select a1, prob from (values ('Functionele naam',1.0)) as t__x78(a1,prob); 483
+ 484 ERROR = !Current transaction is aborted (please ROLLBACK) 484
+ 485 CODE = 25005 485
+ 486 #~ MAPI = monetdb@LAB03:31767 486
+ 487 QUERY = create view _cachedrel_85 as select a1, a3 as a2, prob from _cachedrel_15; 487
+ 488 ERROR = !Current transaction is aborted (please ROLLBACK) 488
+ 489 CODE = 25005 489
+ 490 #~ MAPI = monetdb@LAB03:31767 490
+ 491 QUERY = create view _cachedrel_96 as select a1, a2, prob from _cachedrel_95; 491
+ 492 ERROR = !Current transaction is aborted (please ROLLBACK) 492
+ 493 CODE = 25005 493
+ 494 #~ MAPI = monetdb@LAB03:31767 494
+ 495 QUERY = create view _cachedrel_114 as select a1, a2, prob from _cachedrel_113; 495
+ 496 ERROR = !Current transaction is aborted (please ROLLBACK) 496
+ 497 CODE = 25005 497
+ 498 #~ MAPI = monetdb@LAB03:31767 498
+ 499 QUERY = create view _cachedrel_129 as select a1, prob from (values ('1',300.0),('2',100.0),('3',400.0),('4',100.0),('5',200.0),('6',10.0),('7',100.0)) as t__x132(a1,prob); 499
+ 500 ERROR = !Current transaction is aborted (please ROLLBACK) 500
+ 501 CODE = 25005 501
+ 502 #~ MAPI = monetdb@LAB03:31767 502
+ 503 QUERY = create view _cachedrel_131 as select idstr as a1, id as a2, prob from tr_0_obj_dict; 503
+ 504 ERROR = !Current transaction is aborted (please ROLLBACK) 504
+ 505 CODE = 25005 505
+ 506 #~ MAPI = monetdb@LAB03:31767 506
+ 507 QUERY = create view _cachedrel_132 as select a2 as a1, prob from _cachedrel_131; 507
+ 508 ERROR = !Current transaction is aborted (please ROLLBACK) 508
+ 509 CODE = 25005 509
+ 510 #~ MAPI = monetdb@LAB03:31767 510
+ 511 QUERY = create view _cachedrel_133 as select id as a1, type as a2, typestr as a3, prob from tr_0_obj_type; 511
+ 512 ERROR = !Current transaction is aborted (please ROLLBACK) 512
+ 513 CODE = 25005 513
+ 514 #~ MAPI = monetdb@LAB03:31767 514
+ 515 QUERY = create view _cachedrel_141 as select a2 as a1, prob from _cachedrel_140; 515
+ 516 ERROR = !Current transaction is aborted (please ROLLBACK) 516
+ 517 CODE = 25005 517
+ 518 #~ MAPI = monetdb@LAB03:31767 518
+ 519 QUERY = create view _cachedrel_142 as select a1, a2, prob from _cachedrel_140; 519
+ 520 ERROR = !Current transaction is aborted (please ROLLBACK) 520
+ 521 CODE = 25005 521
+ 522 #~ MAPI = monetdb@LAB03:31767 522
+ 523 QUERY = create view _cachedrel_147 as select a2 as a1, prob from _cachedrel_146; 523
+ 524 ERROR = !Current transaction is aborted (please ROLLBACK) 524
+ 525 CODE = 25005 525
+ 526 #~ MAPI = monetdb@LAB03:31767 526
+ 527 QUERY = create view _cachedrel_148 as select a1, a2, prob from _cachedrel_146; 527
+ 528 ERROR = !Current transaction is aborted (please ROLLBACK) 528
+ 529 CODE = 25005 529
+ 530 #~ MAPI = monetdb@LAB03:31767 530
+ 531 QUERY = create view _cachedrel_154 as select a2 as a1, prob from _cachedrel_153; 531
+ 532 ERROR = !Current transaction is aborted (please ROLLBACK) 532
+ 533 CODE = 25005 533
+ 534 #~ MAPI = monetdb@LAB03:31767 534
+ 535 QUERY = create view _cachedrel_155 as select a1, a2, prob from _cachedrel_153; 535
+ 536 ERROR = !Current transaction is aborted (please ROLLBACK) 536
+ 537 CODE = 25005 537
+ 538 #~ MAPI = monetdb@LAB03:31767 538
+ 539 QUERY = create view _cachedrel_160 as select a2 as a1, a1 as a2, prob from _cachedrel_159; 539
+ 540 ERROR = !Current transaction is aborted (please ROLLBACK) 540
+ 541 CODE = 25005 541
+ 542 #~ MAPI = monetdb@LAB03:31767 542
+ 543 QUERY = create view _cachedrel_164 as select a1, a3 as a2, prob from _cachedrel_163; 543
+ 544 ERROR = !Current transaction is aborted (please ROLLBACK) 544
+ 545 CODE = 25005 545
+ 546 #~ MAPI = monetdb@LAB03:31767 546
+ 547 QUERY = create view _cachedrel_171 as select a1, prob from (values ('1',5.0),('2',1.0)) as t__x171(a1,prob); 547
+ 548 ERROR = !Current transaction is aborted (please ROLLBACK) 548
+ 549 CODE = 25005 549
+ 550 #~ MAPI = monetdb@LAB03:31767 550
+ 551 QUERY = create view _cachedrel_179 as select a1, prob from (values ('1',5.0),('2',2.0),('3',1.0)) as t__x179(a1,prob); 551
+ 552 ERROR = !Current transaction is aborted (please ROLLBACK) 552
+ 553 CODE = 25005 553
+ 554 #~ MAPI = monetdb@LAB03:31767 554
+ 555 QUERY = create view _cachedrel_184 as select a1, a3 as a2, prob from _cachedrel_183; 555
+ 556 ERROR = !Current transaction is aborted (please ROLLBACK) 556
+ 557 CODE = 25005 557
+ 558 #~ MAPI = monetdb@LAB03:31767 558
+ 559 QUERY = create view _cachedrel_185 as select a1, a3 as a2, prob from _cachedrel_26; 559
+ 560 ERROR = !Current transaction is aborted (please ROLLBACK) 560
+ 561 CODE = 25005 561
+ 562 #~ MAPI = monetdb@LAB03:31767 562
21 QUERY = CREATE VIEW s0_ifThenElse_1_RESULT_result AS 21 563 QUERY = CREATE VIEW s0_ifThenElse_1_RESULT_result AS 563
..................
#~ MAPI = (monetdb) /var/tmp/mtest-2588
27 q0_x4 AS (SELECT a1||a2 AS a1, prob FROM (SELECT t__x12_1.a1 AS a1, t__x12_2.a1 AS a2, t__x12_1.prob * t__x12_2.prob AS prob FROM q0_x3 AS t__x12_1, 27 569 q0_x4 AS (SELECT a1||a2 AS a1, prob FROM (SELECT t__x12_1.a1 AS a1, t__x12_2.a1 AS a2, t__x12_1.prob * t__x12_2.prob AS prob FROM q0_x3 AS t__x12_1, 569
28 ERROR = !SELECT: no such FILTER function 'contains' 28 ! 570 ERROR = !Current transaction is aborted (please ROLLBACK) 570
29 CODE = 42000 29 ! 571 CODE = 25005 571
30 30 572 572