Sorry for the delay. Once I saw Tom's reply on Nov 15, I tried his
suggestion about "whether we need to restrict the optimization so
that it doesn't occur if the subquery contains outer references
falling outside available_rels. " quickly, I'm sure such a restriction
can fix the bad case Richard provided. But even Tom "I'm not at
all clear about ..", I'd like to prepare myself better for this
discussion and that took some time. Then an internal urgent
project occupied my attention, the project is still in-progress
now:(
There has been no updates on this thread for some time, so this has been switched as Returned with Feedback. Feel free to open it in the next commitfest if you plan to continue on this.
Thank you vignesh C for this, I didn't give up yet, probably I can
