Re: Pulling up sublink may break join-removal logic

2020-04-28 Thread Andy Fan
On Wed, Apr 29, 2020 at 10:37 AM Richard Guo wrote: > > On Wed, Apr 29, 2020 at 8:23 AM David Rowley wrote: > >> On Tue, 28 Apr 2020 at 19:04, Richard Guo wrote: >> > I happened to notice $subject and not sure if it's an issue or not. When >> > we're trying to remove a LEFT JOIN, one of the req

Re: Pulling up sublink may break join-removal logic

2020-04-28 Thread Richard Guo
On Wed, Apr 29, 2020 at 8:23 AM David Rowley wrote: > On Tue, 28 Apr 2020 at 19:04, Richard Guo wrote: > > I happened to notice $subject and not sure if it's an issue or not. When > > we're trying to remove a LEFT JOIN, one of the requirements is the inner > > side needs to be a single baserel.

Re: Pulling up sublink may break join-removal logic

2020-04-28 Thread David Rowley
On Tue, 28 Apr 2020 at 19:04, Richard Guo wrote: > I happened to notice $subject and not sure if it's an issue or not. When > we're trying to remove a LEFT JOIN, one of the requirements is the inner > side needs to be a single baserel. If there is a join qual that is a > sublink and can be convert

Pulling up sublink may break join-removal logic

2020-04-28 Thread Richard Guo
Hi hackers, I happened to notice $subject and not sure if it's an issue or not. When we're trying to remove a LEFT JOIN, one of the requirements is the inner side needs to be a single baserel. If there is a join qual that is a sublink and can be converted to a semi join with the inner side rel, th