ROW_NUMBER and DELETE/UPDATE with ORDER BY

create or replace table t (a varchar(8));

insert into t values ('val1'),('val2'),('100'),('val4');

delete from t where a = 100 order by a;

get diagnostics condition 3 @n = row_number;

select @n;

CREATE TABLE t (a VARCHAR(8), b tinyint);

INSERT INTO t(a) VALUES ('val1'),('val2'),('100'),('val4'),('100');

SELECT * FROM t;

set sql_mode='';

UPDATE t SET b=1234 WHERE a = 100 ORDER BY a;

GET DIAGNOSTICS CONDITION 2 @n2 = ROW_NUMBER;

GET DIAGNOSTICS CONDITION 5 @n5 = ROW_NUMBER;

SELECT @n2, @n5;