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
