[Maria-developers] Oracle compatibility : Update with same source and target
Hello Alexander, In the same spirit of MDEV-12137, can you create a task for update with same source and target ? Regard, Jérôme.
Hi Jerome, On 05/19/2017 05:36 PM, jerome brauge wrote:
Hello Alexander, In the same spirit of MDEV-12137, can you create a task for update with same source and target ?
Can you please send some SQL script examples that work in Oracle, but do not work in MariaDB? Thanks!
Regard, Jérôme.
Hi Alexander, Here is an example : use test; set sql_mode=oracle; DROP TABLE if exists t1; CREATE TABLE t1 (c1 INT, c2 INT); update t1 set c1=1 where c2 = (SELECT b.c2 FROM t1 b WHERE b.c1=0); --> ERROR 1093 (HY000) at line 5: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data Regards, Jérôme.
-----Message d'origine----- De : Alexander Barkov [mailto:bar@mariadb.org] Envoyé : vendredi 19 mai 2017 16:18 À : jerome brauge Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)' Objet : Re: Oracle compatibility : Update with same source and target
Hi Jerome,
On 05/19/2017 05:36 PM, jerome brauge wrote:
Hello Alexander, In the same spirit of MDEV-12137, can you create a task for update with same source and target ?
Can you please send some SQL script examples that work in Oracle, but do not work in MariaDB?
Thanks!
Regard, Jérôme.
Hi Jerome, On 05/19/2017 07:04 PM, jerome brauge wrote:
Hi Alexander,
Here is an example :
use test; set sql_mode=oracle; DROP TABLE if exists t1; CREATE TABLE t1 (c1 INT, c2 INT); update t1 set c1=1 where c2 = (SELECT b.c2 FROM t1 b WHERE b.c1=0);
--> ERROR 1093 (HY000) at line 5: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data
Thanks. I created a task, using your example: MDEV-12137 UPDATE statements with the same source and target
Regards, Jérôme.
-----Message d'origine----- De : Alexander Barkov [mailto:bar@mariadb.org] Envoyé : vendredi 19 mai 2017 16:18 À : jerome brauge Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)' Objet : Re: Oracle compatibility : Update with same source and target
Hi Jerome,
On 05/19/2017 05:36 PM, jerome brauge wrote:
Hello Alexander, In the same spirit of MDEV-12137, can you create a task for update with same source and target ?
Can you please send some SQL script examples that work in Oracle, but do not work in MariaDB?
Thanks!
Regard, Jérôme.
participants (2)
-
Alexander Barkov -
jerome brauge