Re: infinite loop in an update statement

[Adrian Klaver]

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