[MDEV-19645] Update trigger with stored functions not working on updates with joins Created: 2019-05-30 Updated: 2019-06-03 Resolved: 2019-06-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Triggers |
| Affects Version/s: | 10.3.15 |
| Fix Version/s: | 10.2.25, 5.5.65, 10.1.41, 10.3.16, 10.4.6 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Henning Sander | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | trigger | ||
| Environment: |
Suse SLES12 and Debian stretch |
||
| Issue Links: |
|
||||||||
| Description |
|
Description: Preconditions: SQL Steps to reproduce: create table tu ( create table tc ( delimiter // create function addone(i integer) returns integer create trigger tu_au after update on tu insert into tu (ID, val) values (1,1); create temporary table t select 1 as ID; update tu join t using(ID) set val = 2 where ID = 1; select addone(1); update tu join t using(ID) set val = 3 where ID = 1; |
| Comments |
| Comment by Elena Stepanova [ 2019-06-03 ] |
|
Thanks for the report. The problem was fixed in the scope of |