Wikitty

Killian Herbreteau (4fce34f7) at 20 Nov 09:09 removing useless ';' ... and 1 more commit

Julien Ruchaud (06d2345b) at 20 Nov 09:15 Merge branch 'mapper' into 'master' ... and 12 more commits

see #18

Julien Ruchaud (df7d1b2c) at 20 Nov 09:15

case: WITH test AS ( SELECT * FROM emptyTable ), test2 AS ( SELECT j.id, json_agg(t.*) AS test FROM toJoinTable j LEFT OUTER JOIN test t ON t.test1 = j.id GROUP BY j.id ) SELECT json_agg(t2.*) FROM test2 t2; Result [ {"id" : 1, "test" ... [More] : [null]}, {"id" : 2, "test" : [null, null]}, {"id" : 3, "test" : [null, null, null]} ] Should [ {"id" : 1, "test" : null}, {"id" : 2, "test" : null}, {"id" : 3, "test" : null} ] Sql correction COALESCE(json_agg(x.*) FILTER (WHERE joinProperties IS NOT NULL), null) As : WITH test AS ( SELECT * FROM emptyTable ), test2 AS ( SELECT j.id, COALESCE(json_agg(t.*) FILTER (WHERE t.test1 IS NOT NULL), null) as test FROM toJoinTable j LEFT OUTER JOIN test t ON t.test1 = j.id GROUP BY j.id ) SELECT json_agg(t2.*) FROM test2 t2; [Less]

case: WITH test AS ( SELECT * FROM emptyTable ), test2 AS ( SELECT j.id, json_agg(t.*) AS test FROM toJoinTable j LEFT OUTER JOIN test t ON t.test1 = j.id GROUP BY j.id ) SELECT json_agg(t2.*) FROM test2 t2; Result [ {"id" : 1, "test" ... [More] : [null]}, {"id" : 2, "test" : [null, null]}, {"id" : 3, "test" : [null, null, null]} ] Should [ {"id" : 1, "test" : null}, {"id" : 2, "test" : null}, {"id" : 3, "test" : null} ] Sql correction COALESCE(json_agg(x.*) FILTER (WHERE joinProperties IS NOT NULL), null) As : WITH test AS ( SELECT * FROM emptyTable ), test2 AS ( SELECT j.id, COALESCE(json_agg(t.*) FILTER (WHERE t.test1 IS NOT NULL), null) as test FROM toJoinTable j LEFT OUTER JOIN test t ON t.test1 = j.id GROUP BY j.id ) SELECT json_agg(t2.*) FROM test2 t2; [Less]

Jean Couteau (171d6b51) at 13 Nov 09:24 Merge du jaxx 2.43 ultreia et du jaxx 2.43 nuiton

Jean Couteau (a17d665c) at 13 Nov 09:29 [jgitflow-maven-plugin]updating poms for 2.45-SNAPSHOT development

Jean Couteau (171d6b51) at 13 Nov 09:29 Merge du jaxx 2.43 ultreia et du jaxx 2.43 nuiton ... and 69 more commits

Jean Couteau (fc8f4ec2) at 13 Nov 09:46 [jgitflow-maven-plugin]Updating develop poms back to pre merge state ... and 6 more commits