I haven't thoughed about the resolving of "user_id" to the closed nested source

because I haven't discovered this side effect when I was not working with boolish filters.

 

After considering your advice I tried to use the first example with EXISTS by replacing "user_id" to

"public.inventories.user_id" and the side effect wasn't there anymore. Could have know that if had made more researcher beforehand.

 

Next time, if I find something, I will create a self-contained test case so that everyone can reproduces the error.

 

With best regards,

 

Wladimir