502
502
--echo # 12. Read-write statement: IODKU, change 0 rows.
504
504
insert t1 set a=2 on duplicate key update a=2;
505
call p_verify_status_increment(1, 0, 1, 0);
505
call p_verify_status_increment(2, 2, 1, 0);
507
call p_verify_status_increment(1, 0, 1, 0);
507
call p_verify_status_increment(2, 2, 1, 0);
509
509
--echo # 13. Read-write statement: INSERT IGNORE, change 0 rows.
511
511
insert ignore t1 set a=2;
512
call p_verify_status_increment(1, 0, 1, 0);
512
call p_verify_status_increment(2, 2, 1, 0);
514
call p_verify_status_increment(1, 0, 1, 0);
514
call p_verify_status_increment(2, 2, 1, 0);
516
516
--echo # 14. Read-write statement: INSERT IGNORE, change 1 row.