Re: infinite loop in an update statement

[Adrian Klaver]

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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> 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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>

--
Adrian Klaver
adrian.kla...@aklaver.com