Thanks! So, this is what Igor mentioned in MDEV-13648 thread: > For those of you who are preparing proposals for this project: > In your proposal you are expected to cover the following issues: > 1. How to build the tree for the result of re-writing for a join expression > with FULL OUTER JOIN. > (It's not trivial as the parser provides you only with one tree that can be > easily transformed into a > tree either for LEFT OUTER JOIN or for RIGHT OUTER JOIN, but not for both and > you need the > trees for two SELECTs, not just for one. You can get an idea how you could > build the > tree for the second SELECT in sql_view.cc). > 2. At what stage to do the re-writing: at the parser stage, at the beginning > of the context analysis > stage (see JOIN::prepare or at the beginning of the optimization stage (see > JOIN::optimizer). > 3. How to handle embedded FULL OUTER JOINs. > 4. How and when to check possible conversion to LEFT OUTER JOIN or RIGHT > OUTER JOIN. > 5. What adjustments must be done for different references to the tables used > in the original join > expression with FULL OUTER JOIN that may occur outside of this expression.
So, if we stick to point 1&2 will it make it comparable to other projects? Ofcourse, I'll try to complete the rest too, but for defining the sub-task as of now; will this suffice? Regards, Hemant Kumar Singh https://iamhks.com (https://link.getmailspring.com/link/6f54a257-ada3-4e97-a25e-1dc701b96...@getmailspring.com/0?redirect=https%3A%2F%2Fiamhks.com&recipient=bWFyaWEtZGlzY3Vzc0BsaXN0cy5sYXVuY2hwYWQubmV0) On Mar 14 2021, at 5:25 pm, Sergei Golubchik <s...@mariadb.org> wrote: > Hi, Hemant! > > On Mar 14, Hemant Kumar Singh wrote: > > Hi everyone, > > I am Hemant from Nepal, currently a Computer Science Junior at NIT > > Warangal, India willing to take part in GSoC 2021. > > > > I saw a major priority task "MDEV-13648- Add FULL OUTER JOIN to > > MariaDB" unresolved since gsoc 2019; but it's not listed in 2021 List > > of Ideas. So, I was just wondering whether I can contribute to this > > task for gsoc 2021. Can anyone confirm this? > > Yes, you absolutely can, and it's great that you're looking beyond > what's listed on our "GSoC 2021" page of suggestions. > > The thing is - GSoC rules were changed this year and there is less time > for coding than before. So in 2021 we offer smaller tasks that can > reasonably fit within the new GSoC format. > > For MDEV-13648, I think, we need to define some subtask, so that if you > implement that, the project would be still a success, even if you won't > have time for the full MDEV-13648. So - totally possible, and it'd be > perfect if you'll manage to do it all. But to make it comparable with > other tasks we should define this intermediate milestone within > MDEV-13648. > > Regards, > Sergei > VP of MariaDB Server Engineering > and secur...@mariadb.org >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp