I was trying to check testcase from MariaDB on MySQL 5.6 using SQL Fiddle and got error. MySQL 5.5 works as expected:
5.6.6 - http://sqlfiddle.com/#!9/b30d5/1 - gives Incorrect key file for table 'base'; try to repair it: select * from base where hours_worked_per_week = 40 and weeks_worked_last_year = 52 and dob < '1949-11-21'
5.5.32 - http://sqlfiddle.com/#!2/b30d5/1 - works OK
I was trying to check testcase from MariaDB on MySQL 5.6 using SQL Fiddle and got error. MySQL 5.5 works as expected:
5.6.6 - http://sqlfiddle.com/#!9/b30d5/1 - gives
Incorrect key file for table 'base'; try to repair it: select * from base where hours_worked_per_week = 40 and weeks_worked_last_year = 52 and dob < '1949-11-21'5.5.32 - http://sqlfiddle.com/#!2/b30d5/1 - works OK