Re: infinite loop in an update statement

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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 <adrian.klaver@xxxxxxxxxxx 
> <mailto:adrian.klaver@xxxxxxxxxxx>> 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
>     adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx