Abby Sassel

thanks Benoit, and for the linked detail. We'll triage this in the next week or so

thanks all. Suggesting we timebox investigation to 1 day

> These tests also seem to fail for unrelated reasons quite often in CI Do you have any recent examples? If so, mind adding them as comments [here](https://github.com/hasura/graphql-engine-mono/issues/4783)? Gil did...

hey folks, thanks for your patience! We can see it's highly anticipated so we plan to revisit [this RFC](https://github.com/hasura/graphql-engine/pull/3852) and continue speccing this feature out soon. We'll keep this issue...

UPDATE: we have a minimal repro, so you can ignore my original message below. Hey Benoit, thanks for this bug report! We're looking into this a priority, and working on...

Yep we got it, thanks @BenoitRanque ! We were able to repro, test and find the root issue ([internal team context](https://hasurahq.slack.com/archives/C01RZPEPF0W/p1664552180028929?thread_ts=1663028925.701849&cid=C01RZPEPF0W)). I'm confirming with the product eng team how to...

Hey Benoit, latest update. We've: - Isolated the error to the `LEFT (OUTER) JOIN` fragment in the above generated SQL. - Identified the root cause of the “correlated subqueries” error:...

Discussed after standup: This is blocked by https://github.com/cockroachdb/cockroach/issues/83255 but we have a [workaround in progress](https://github.com/hasura/graphql-engine-mono/pull/5787).

Luca [verified](https://hasurahq.slack.com/archives/C01RZPEPF0W/p1664264911879379?thread_ts=1664189927.687599&cid=C01RZPEPF0W) this works as expected yesterday, closing

Thanks @BenoitRanque ! Seems like we'll need to do two things: - [ ] https://github.com/hasura/graphql-engine/issues/8866 - [ ] [console/exploration: display conflict resolution modal (tbc) for tracked table conflicts](https://github.com/hasura/graphql-engine-mono/issues/5887)