On 1/7/17 6:39 AM, Pavel Stehule wrote: > ROW_COUNT .. shortcut for GET DIAGNOSTICS row_count = ROW_COUNT.
I don't see the point.
A check how much rows was impacted by query is relative often task. So we can do this task more user friendly.
Second motivation - ROW_COUNT is working for static and for dynamic SQL - it can be partial replace of FOUND variable.
But now, when I am thinking about it - it can be strange for some users too. Pretty often we use implicit LIMIT for query execution. So ROW_COUNT can be probably different than users expecting.