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
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.
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.