On 09/04/2014 06:21 AM, Roberto Spadim wrote:
my doubt is... i was trying to understand how could i create tests, since the result of statistic isn't deterministic how should i execute a test case like this?
there is very simple/limited support for this with the --replace-... commands in mysqltest, see: http://dev.mysql.com/doc/mysqltest/2.0/en/writing-tests-output-postprocessin... http://dev.mysql.com/doc/mysqltest/2.0/en/mysqltest-commands.html#idm4769095... http://dev.mysql.com/doc/mysqltest/2.0/en/mysqltest-commands.html#idm4769095... or you could wrap this up in a stored procedure call and check for expected value ranges in there ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/