572
572
# 16. A function changes non-trans-table.
574
# For row-based logging, there is an extra commit for the
575
# non-transactional changes saved in the transaction cache to
577
call p_verify_status_increment(0, 0, 0, 0);
581
call p_verify_status_increment(0, 0, 1, 0);
581
call p_verify_status_increment(0, 0, 0, 0);
585
call p_verify_status_increment(0, 0, 1, 0);
584
588
# 17. Read-only statement, a function changes non-trans-table.
590
# For row-based logging, there is an extra commit for the
591
# non-transactional changes saved in the transaction cache to
586
594
select f1() from t1;
590
call p_verify_status_increment(1, 0, 1, 0);
598
call p_verify_status_increment(1, 0, 2, 0);
594
call p_verify_status_increment(1, 0, 1, 0);
602
call p_verify_status_increment(1, 0, 2, 0);
597
605
# 18. Read-write statement: UPDATE, change 0 (transactional) rows.