Query problem

I have a table called VOLUN_BMI_RESULT. when I update this table(autoCommit is false), trigger will get execute and it inserts data in the VOLUN_BMI_RESULT$AUD.Before commiting this I am performing some other operation in that, I used the following query

Oracle


SELECT * FROM (SELECT RESULT,pkid FROM VOLUN_BMI_RESULT$AUD where VOLUN_ID = ‘SY-0900004’ ORDER BY pkid DESC, ROWNUM DESC) WHERE ROWNUM=1.

while debugging, when I execute above query from java API it is showing uncommited row(i.e row to be commited) as first row.which is correct and works fine.

MySQL


SELECT p.RESULT,pkid FROM VOLUN_BMI_RESULT$AUD p ,(SELECT @rownum:=0) r where p.VOLUN_ID = ‘SY-0900004’ order by p.pkid desc limit 1

while debugging, when I execute above query from java API it is showing max among commited rows as first row.

My problem is, why MySQL query is not showing uncommited row as Max row like oracle query.

Transaction isolation level.

By the way, trigger-based auditing will not work with statement-based replication if there are auto-increment columns.