Test correlated.sql (id c952acc49888) (out)
correlated.stable.err.FILTERED 2019-12-03 07:37:25.999088227 +0100correlated.test.err.FILTERED 2019-12-03 07:37:26.039090047 +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 # 120 lines, 1161 words, 8913 chars in all lines 4
5 5 5 5
..................
# the original non-normalized output was
95 CODE = 42000 95 108 CODE = 42000 108
96 #~ MAPI = (monetdb) /var/tmp/mtest-31859/.s.monetdb.35446 96 ! 109 #~ MAPI = (monetdb) /var/tmp/mtest-24631/.s.monetdb.35946 109
+ 110 QUERY = SELECT CAST(SUM(i) AS BIGINT) FROM integers i1 WHERE i>(SELECT (i+i1.i)/2 FROM integers WHERE i=1); 110
+ 111 ERROR = !GDK reported error: BATproject: does not match always 111
+ 112 #~ MAPI = (monetdb) /var/tmp/mtest-24631/.s.monetdb.35946 112
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 113 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 113