maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Hi guys, could someone take a look at MDEV-6817?

i'm testing a stress test with aria and row_format=page
the problem is, running many

php>while(1){
mysql>select max(column) from table;
php> get the value, sum+1
mysql>insert into table (the value of column+1)
php>}

i got some problems...
the value of the first max(column) sometimes return an old value
in others words, the query isn't consistent, or the table invalidation
code is wrong

i got a value 296 at query cache
if i change the autocommit from 1 to 0, i got a value of 297, i could
use SQL_NO_CACHE and got the same 297 value


the problem only occur with row_format=page


-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle