← Back to team overview

maria-developers team mailing list archive

Re: Regarding GSoc :ADD FULL OUTER JOIN

 

Hi , in this reply what does parsing mean??The parsing done by parser
right??The process of analyzing a string of symbols is parsing right ?? Or
the parsing some parts of UNION query means something else in this reply?

Sorry sir ,but I am not clear about the process to make it simpler ,not
clear about the reply,can you tell me in other way or make simpler to me??

On Wed, Mar 25, 2020 at 1:06 PM Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>
wrote:

> 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@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~maria-developers
> > More help   : https://help.launchpad.net/ListHelp
>
>
>

References