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@aklaver.com
