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:b...@mariadb.org] > 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. > > _______________________________________________ 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
