I've installed phpmyadmin, but couldn't so far reproduce the problem, the results differ starting from the first step: instead of
"If CLIENT-B executes QUERY-BAD the result-set is empty" i'm getting a valid result set.
So, please
1) enable general log (set global general_log=1);
2) execute your scenario;
3) then execute it again, only before each SELECT also run EXPLAIN EXTENDED SELECT ...
(still run the SELECTs too, to make sure that results didn't change because of the EXPLAIN);
4) attach the resulting general log (it shouldn't be big, but you can compress it if it makes sense) and, importantly, your cnf file.
Hi Daniel,
I've installed phpmyadmin, but couldn't so far reproduce the problem, the results differ starting from the first step: instead of
"If CLIENT-B executes QUERY-BAD the result-set is empty" i'm getting a valid result set.
So, please
1) enable general log (set global general_log=1);
2) execute your scenario;
3) then execute it again, only before each SELECT also run EXPLAIN EXTENDED SELECT ...
(still run the SELECTs too, to make sure that results didn't change because of the EXPLAIN);
4) attach the resulting general log (it shouldn't be big, but you can compress it if it makes sense) and, importantly, your cnf file.
Thanks!