← Back to team overview

maria-developers team mailing list archive

Aria bug with query cache - wrong result and wrong table invalidation


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

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

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
Eng. Automação e Controle