Test correlated.sql (id c952acc49888) (out)
correlated.stable.err.FILTERED 2019-12-03 07:17:55.000000000 +0100correlated.test.err.FILTERED 2019-12-03 07:17:55.000000000 +0100
1 Statistics about stderr of test 'correlated` in directory 'sql/test/subquery`: 1 1 Statistics about stderr of test 'correlated` in directory 'sql/test/subquery`: 1
2 54 lines, 551 words, 3289 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 56 lines, 577 words, 3458 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 55 lines, 561 words, 3347 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 57 lines, 587 words, 3516 chars in lines not matching '^$|^(\| |)#` 3
4 # 104 lines, 983 words, 7128 chars in all lines 4 ! 4 # 122 lines, 1175 words, 9074 chars in all lines 4
5 5 5 5
..................
# the original non-normalized output was
95 CODE = 42000 95 110 CODE = 42000 110
96 #~ MAPI = (monetdb) /var/tmp/mtest-31859/.s.monetdb.35446 96 ! 111 #~ MAPI = (monetdb) /var/tmp/mtest-57331/.s.monetdb.33173 111
+ 112 QUERY = SELECT CAST(SUM(i) AS BIGINT) FROM integers i1 WHERE i>(SELECT (i+i1.i)/2 FROM integers WHERE i=1); 112
+ 113 ERROR = !GDK reported error: BATproject: does not match always 113
+ 114 #~ MAPI = (monetdb) /var/tmp/mtest-57331/.s.monetdb.33173 114
97 QUERY = SELECT i, (SELECT SUM(s1.i) OVER (ORDER BY s1.i) FROM integers s1, integers s2 WHERE i1.i=s1.i LIMIT 1) FROM integers i1 ORDER BY i; --error 97 115 QUERY = SELECT i, (SELECT SUM(s1.i) OVER (ORDER BY s1.i) FROM integers s1, integers s2 WHERE i1.i=s1.i LIMIT 1) FROM integers i1 ORDER BY i; --error 115