3 ms·

Why would it only be run once? The WHERE condition of the outer query is run multiple times: once for each row, so of course it can return TRUE multiple times.

Why would it only be run once? The WHERE condition of the outer query is run multiple times: once for each row, so of course it can return TRUE multiple times. For example: DELETE FROM example WHERE id = (SELECT RANDOM(0, 100) FROM other_table LIMIT 1) This could delete multiple rows in principle, since there may be multiple rows where the `=` expression is true.

swid 1y ago
After thinking about it more, yes I agree with your take. Maybe it can even delete different ids using an =.
- Diggsey 1y ago
  FWIW, I tested this locally (using `DELETE FROM example WHERE id = RANDOM(1,100)`) and it did delete multiple rows in some cases, even without a subquery.