main.join_cache 'innodb'                 w1 [ fail ]

        Test ended at 2018-11-01 15:59:13

CURRENT_TEST: main.join_cache

mysqltest: At line 707: query 'SELECT City.Name, Country.Name, CountryLanguage.Language

FROM City,Country,CountryLanguage

WHERE City.Country=Country.Code AND

CountryLanguage.Country=Country.Code AND

City.Name LIKE 'L%' AND Country.Population > 3000000 AND

CountryLanguage.Percentage > 50 AND

LENGTH(Language) < LENGTH(City.Name) - 2' failed: 1030: Got error 14 "Bad address" from storage engine MyISAM

The result from queries just before the failure was:

< snip >

Panevezys	Lithuania

EXPLAIN

SELECT City.Name, Country.Name, CountryLanguage.Language

FROM City,Country,CountryLanguage

WHERE City.Country=Country.Code AND

CountryLanguage.Country=Country.Code AND

City.Name LIKE 'L%' AND Country.Population > 3000000 AND

CountryLanguage.Percentage > 50 AND

LENGTH(Language) < LENGTH(City.Name) - 2;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	SIMPLE	CountryLanguage	ALL	PRIMARY,Percentage	NULL	NULL	NULL	984	Using where

1	SIMPLE	Country	hash_ALL	PRIMARY	#hash#PRIMARY	3	world.CountryLanguage.Country	239	Using where; Using join buffer (flat, BNLH join)

1	SIMPLE	City	hash_ALL	Country	#hash#Country	3	world.CountryLanguage.Country	4079	Using where; Using join buffer (flat, BNLH join)

SELECT City.Name, Country.Name, CountryLanguage.Language

FROM City,Country,CountryLanguage

WHERE City.Country=Country.Code AND

CountryLanguage.Country=Country.Code AND

City.Name LIKE 'L%' AND Country.Population > 3000000 AND

CountryLanguage.Percentage > 50 AND

LENGTH(Language) < LENGTH(City.Name) - 2;