On 9/10/24 07:47, Fabrice Chapuis wrote: Reply to list also Ccing list
no trigger on theses tables
On Mon, Sep 9, 2024 at 5:00 PM Adrian Klaver <[email protected] <mailto:[email protected]>> wrote:On 9/9/24 07:55, Fabrice Chapuis wrote: > Hi, > > table a and b are empty, this query does not return. It seems we enter > in infinite loop. > why this update does not return instantly? > > UPDATE table_a a > SET col1 = (SELECT MIN(b.col1) > FROM table_b b > WHERE b.col2 = a.col2) Do you have an UPDATE trigger on table_a? > > Regards, > > Fabrice > >-- Adrian Klaver[email protected] <mailto:[email protected]>
-- Adrian Klaver [email protected]
