maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Alexander,
Thanks for the explanation.
It's something we do not use. I did not think about it.
I look forward to your patch.

Regards,
Jérôme.

> -----Message d'origine-----
> De : Alexander Barkov [mailto:bar@xxxxxxxxxxx]
> Envoyé : lundi 27 février 2017 11:28
> À : jerome brauge
> Cc : maria-developers
> Objet : Re: MDEV-10598 - bb-10.2-compatibility
> 
> Hello Jerome,
> 
> 
> On 02/21/2017 07:18 PM, jerome brauge wrote:
> > Hello Alexander,
> > I've done this patch for MDEV-10598.
> > Can you review it ?
> 
> It seems we'll have to postpone this patch.
> 
> I'm currently working on:
> 
> MDEV-10598 Variable declarations can go after cursor declarations
> MDEV-12011 sql_mode=ORACLE: cursor%ROWTYPE in variable declarations
> So the trick with postponing variable declarations using a temporary list might
> not work properly after adding MDEV-10598 abd MDEV-12011, the order of
> cursors and variables is important.
> 
> Example:
> 
> DECLARE
>   CURSOR cur1 IS SELECT a,b FROM t1;
>   v cur1%ROWTYPE;
>   CURSOR cur2 IS SELECT v.a, v.b FROM DUAL; BEGIN
>   ...
> END;
> 
> 
> So the order of cur1, v and cur2 is important.
> 
> I'll let you known when I'm ready with %ROWTYPE tasks.
> 
> Thanks!
> 
> 
> >
> > Regards,
> > Jérôme.
> >