Am 24.03.20 um 09:35 schrieb Jeeukrishnan Kayshyap.:
> Hi ,I am a GSoC aspirant . I am trying to solve
> https://jira.mariadb.org/browse/MDEV-13648 .
>
> Firstly , I discussed a new algorithm with Igor Babev sir , but it
> was wrong as it will create space problem.
>
> Now , I am planning to add some code in Sql_yacc.yy :
>
> /*full join*/ after the right join where /*full join */ will contain :
>
> 1.left join implementation (similar to the implementation of left join
> in sql_yacc.yy (line no. 11956-11950))
> The result table will be in a temporary table ->tab1.
>
>
> 2.Use of right join doing the swapping of table (similar to right join
> in this part ;(line no. 11992-12030))
> the result of this will be stored in another temporary table ->tab2
>
>
> 3.Union all clause:
> implementation of union all clause to combine tab1 and tab2.
>
> So , Oleksandr Byelkin sir replied to me that , addition of UNION will
> make it more complicated.it could be done with less effort than adding
> full UNION.
I discussed it with Igor and we conclude that after all if use parsing
some parts of the query UNION will be simplest way.
>
> But at present I am not able to get any idea how to reduce the
> complexity or any kind of new idea to implement it . Please guide me
> in the right direction and help me to solve this issue.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp