Test correlated.sql (id c952acc49888) (err)
correlated.stable.out.FILTERED 2019-12-03 07:17:55.000000000 +0100correlated.test.out.FILTERED 2019-12-03 07:17:55.000000000 +0100
1 Statistics about stdout of test 'correlated` in directory 'sql/test/subquery`: 1 1 Statistics about stdout of test 'correlated` in directory 'sql/test/subquery`: 1
2 730 lines, 3244 words, 10214 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 725 lines, 3225 words, 10153 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 730 lines, 3244 words, 10214 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 725 lines, 3225 words, 10153 chars in lines not matching '^$|^(\| |)#` 3
4 # 1011 lines, 6123 words, 26601 chars in all lines 4 ! 4 # 1004 lines, 6082 words, 26455 chars in all lines 4
5 5 5 5
..................
# .L3, sys.L6 # table_name
436 [ 4, 3 ] 436 436 [ 4, 3 ] 436
437 #SELECT CAST(SUM(i) AS BIGINT) FROM integers i1 WHERE i>(SELECT (i+i1.i)/2 FROM integers WHERE i=1); 437 -
438 % sys. # table_name 438 -
439 # sys.L5 # table_name 439 -
440 % L # name 440 -
441 # L5 # name 441 -
442 % bigint # type 442 -
443 % 1 # length 443 -
444 [ 5 ] 444 -
445 #SELECT CAST(SUM(i) AS BIGINT) FROM integers i1 WHERE i>(SELECT (SUM(i)+i1.i)/2 FROM integers WHERE i=1); 445 437 #SELECT CAST(SUM(i) AS BIGINT) FROM integers i1 WHERE i>(SELECT (SUM(i)+i1.i)/2 FROM integers WHERE i=1); 437