Hello Alexander, As I thought, there is the same issue with select. The following procedure produce a different result between Mariadb and Oracle.
set sql_mode=oracle; use test; DELIMITER $$ CREATE or replace procedure psselerr_field(res OUT VARCHAR) AS b1 INT; BEGIN b1:=10; select 1,cast(b1 as varchar(10)) into b1, res from dual; return ; END; $$ DELIMITER ; call psselerr_field (@res); select @res; Mariadb : res = 1 Oracle: res = 10 Best regards, Jérôme. > -----Message d'origine----- > De : jerome brauge > Envoyé : vendredi 21 juillet 2017 17:04 > À : maria-developers@lists.launchpad.net > Cc : Alexander Barkov; 'Sergei Golubchik' > Objet : Patch for MDEV-12874 - UPDATE statements with the same source > and target > > Hello, > > Here is a patch for MDEV-12874 (on branch 10.2-ext). > Can anyone review it ? > > Alexander, during my work on this MDEV, I've found a new issue with update > statement and Oracle compatibility. > > create table t1 (c1 integer, c2 integer, c3 integer); insert into t1(c1,c2,c3) > values (1,1,1); update t1 > set c1 = c1+1, > c2 = c1+1, > c3 = c2+1; > select * from t1; > > Mariadb : > +------+------+------+ > | c1 | c2 | c3 | > +------+------+------+ > | 2 | 3 | 4 | > +------+------+------+ > 1 row in set (0.00 sec) > > Oracle : > DVTORA> > C1 C2 C3 > ---------- ---------- ---------- > 2 2 2 > > Can you open a new MDEV for this ? > > Best 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
