518
518
# 12. Read-write statement: IODKU, change 0 rows.
520
520
insert t1 set a=2 on duplicate key update a=2;
521
call p_verify_status_increment(1, 0, 1, 0);
521
call p_verify_status_increment(2, 2, 1, 0);
525
call p_verify_status_increment(1, 0, 1, 0);
525
call p_verify_status_increment(2, 2, 1, 0);
528
528
# 13. Read-write statement: INSERT IGNORE, change 0 rows.
530
530
insert ignore t1 set a=2;
531
call p_verify_status_increment(1, 0, 1, 0);
531
call p_verify_status_increment(2, 2, 1, 0);
535
call p_verify_status_increment(1, 0, 1, 0);
535
call p_verify_status_increment(2, 2, 1, 0);
538
538
# 14. Read-write statement: INSERT IGNORE, change 1 row.