Test duplicates-not-eliminated-long-CASE-stmt.Bug-6697.sql (id 6b3b1396de21) (err)
duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.FILTERED 2019-09-20 11:12:27.549268959 +0200duplicates-not-eliminated-long-CASE-stmt.Bug-6697.test.out.FILTERED 2019-09-20 11:12:27.555268902 +0200
1 Statistics about stdout of test 'duplicates-not-eliminated-long-CASE-stmt.Bug-6697` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stdout of test 'duplicates-not-eliminated-long-CASE-stmt.Bug-6697` in directory 'sql/test/BugTracker-2019`: 1
2 258 lines, 1386 words, 23982 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 207 lines, 1331 words, 22369 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 258 lines, 1386 words, 23982 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 207 lines, 1331 words, 22369 chars in lines not matching '^$|^(\| |)#` 3
4 # 318 lines, 2419 words, 33700 chars in all lines 4 ! 4 # 267 lines, 2357 words, 32060 chars in all lines 4
5 5 5 5
..................
#explain SELECT sys.timestamp_to_str(ca
41 X_142:void := querylog.define("explain select sys.timestamp_to_str(case when task0.\"sys_created_on\" >= \\'1999-10-31 09:00:00\\' and task0.\"sys_created_on\" < \\'2000-04-02 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2000-04-02 10:00:00\\' and task0.\"sys_created_on\" < \\'2000-10-29 09:00:00\\' then task0.\"sys_created_on\" + interval \\'-25200\\' second when task0.\"sys_created_on\" >= \\'2000-10-29 09:00:00\\' and task0.\"sys_created_on\" < \\'2001-04-01 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2001-04-01 10:00:00\\' and task0.\"sys_created_on\" < \\'2001-10-28 09:00:00\\' then task0.\"sys_created_on\" + interval \\'-25200\\' second when task0.\"sys_created_on\" >= \\'2001-10-28 09:00:00\\' and task0.\"sys_created_on\" < \\'2002-04-07 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2002-04-07 10:00:00\\' and 41 41 X_142:void := querylog.define("explain select sys.timestamp_to_str(case when task0.\"sys_created_on\" >= \\'1999-10-31 09:00:00\\' and task0.\"sys_created_on\" < \\'2000-04-02 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2000-04-02 10:00:00\\' and task0.\"sys_created_on\" < \\'2000-10-29 09:00:00\\' then task0.\"sys_created_on\" + interval \\'-25200\\' second when task0.\"sys_created_on\" >= \\'2000-10-29 09:00:00\\' and task0.\"sys_created_on\" < \\'2001-04-01 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2001-04-01 10:00:00\\' and task0.\"sys_created_on\" < \\'2001-10-28 09:00:00\\' then task0.\"sys_created_on\" + interval \\'-25200\\' second when task0.\"sys_created_on\" >= \\'2001-10-28 09:00:00\\' and task0.\"sys_created_on\" < \\'2002-04-07 10:00:00\\' then task0.\"sys_created_on\" + interval \\'-28800\\' second when task0.\"sys_created_on\" >= \\'2002-04-07 10:00:00\\' and 41
42 barrier X_1771:bit := language.dataflow(); 42 -
43 X_1608:bat[:str] := bat.new(nil:str); 43 42 X_1608:bat[:str] := bat.new(nil:str); 42
..................
#explain SELECT sys.timestamp_to_str(ca
240 X_1623:bat[:int] := bat.append(X_1614:bat[:int], 0:int); 240 239 X_1623:bat[:int] := bat.append(X_1614:bat[:int], 0:int); 239
241 language.pass(X_200:bat[:bit]); 241 -
242 language.pass(X_229:bat[:bit]); 242 -
243 language.pass(X_256:bat[:bit]); 243 -
244 language.pass(X_283:bat[:bit]); 244 -
245 language.pass(X_310:bat[:bit]); 245 -
246 language.pass(X_340:bat[:bit]); 246 -
247 language.pass(X_364:bat[:bit]); 247 -
248 language.pass(X_393:bat[:bit]); 248 -
249 language.pass(X_421:bat[:bit]); 249 -
250 language.pass(X_448:bat[:bit]); 250 -
251 language.pass(X_474:bat[:bit]); 251 -
252 language.pass(X_504:bat[:bit]); 252 -
253 language.pass(X_529:bat[:bit]); 253 -
254 language.pass(X_558:bat[:bit]); 254 -
255 language.pass(X_586:bat[:bit]); 255 -
256 language.pass(X_612:bat[:bit]); 256 -
257 language.pass(X_639:bat[:bit]); 257 -
258 language.pass(X_669:bat[:bit]); 258 -
259 language.pass(X_694:bat[:bit]); 259 -
260 language.pass(X_723:bat[:bit]); 260 -
261 language.pass(X_750:bat[:bit]); 261 -
262 language.pass(X_777:bat[:bit]); 262 -
263 language.pass(X_804:bat[:bit]); 263 -
264 language.pass(X_834:bat[:bit]); 264 -
265 language.pass(X_858:bat[:bit]); 265 -
266 language.pass(X_887:bat[:bit]); 266 -
267 language.pass(X_915:bat[:bit]); 267 -
268 language.pass(X_942:bat[:bit]); 268 -
269 language.pass(X_968:bat[:bit]); 269 -
270 language.pass(X_998:bat[:bit]); 270 -
271 language.pass(X_1023:bat[:bit]); 271 -
272 language.pass(X_1052:bat[:bit]); 272 -
273 language.pass(X_1080:bat[:bit]); 273 -
274 language.pass(X_1106:bat[:bit]); 274 -
275 language.pass(X_1133:bat[:bit]); 275 -
276 language.pass(X_1163:bat[:bit]); 276 -
277 language.pass(X_1188:bat[:bit]); 277 -
278 language.pass(X_1217:bat[:bit]); 278 -
279 language.pass(X_1244:bat[:bit]); 279 -
280 language.pass(X_1271:bat[:bit]); 280 -
281 language.pass(X_1298:bat[:bit]); 281 -
282 language.pass(X_1328:bat[:bit]); 282 -
283 language.pass(X_1352:bat[:bit]); 283 -
284 language.pass(X_1381:bat[:bit]); 284 -
285 language.pass(X_1409:bat[:bit]); 285 -
286 language.pass(X_188:bat[:timestamp]); 286 -
287 language.pass(X_1436:bat[:bit]); 287 -
288 language.pass(X_1458:bat[:timestamp]); 288 -
289 language.pass(X_1454:bat[:timestamp]); 289 -
290 exit X_1771:bit; 290 -
291 sql.resultSet(X_1615:bat[:str], X_1617:bat[:str], X_1619:bat[:str], X_1621:bat[:int], X_1623:bat[:int], X_1604:bat[:str]); 291 240 sql.resultSet(X_1615:bat[:str], X_1617:bat[:str], X_1619:bat[:str], X_1621:bat[:int], X_1623:bat[:int], X_1604:bat[:str]); 240