1643
1643
pk code population_rate area_rate
1647
# MDEV-5069: Server crashes in SEL_ARG::increment_use_count with index_merge+index_merge_sort_union, FORCE INDEX
1652
pk integer auto_increment,
1657
key (c2)) ENGINE=myisam;
1658
ALTER TABLE t1 DISABLE KEYS;
1659
INSERT INTO t1 VALUES
1660
('West Virginia', 6121, NULL, 'California'),('Georgia', 60177, NULL, 'Arkansas'),
1661
('Delaware', 90, NULL, 'Oregon'),('Wyoming', 7, NULL, 'Missouri'),(
1662
'Delaware', 2, NULL, 'Utah'),('Wisconsin', 0, NULL, 'Iowa'),
1663
('Kansas', 0, NULL, 'Florida'),('Ohio', 34358, NULL, 'Colorado'),
1664
('Maine', 118, NULL, 'Texas'),('Mississippi', 0, NULL, 'Georgia'),
1665
('Tennessee', 4, NULL, 'N/A'),('Georgia', 0, NULL, 'New Hampshire'),
1666
('Wyoming', 2, NULL, 'N/A'),('Florida', 0, NULL, 'Arizona'),
1667
('Rhode Island', -24002, NULL, 'Michigan'),('Alabama', 142, NULL, 'Indiana'),
1668
('Colorado', 0, NULL, 'Louisiana'),('Michigan', 21194, NULL, 'Louisiana'),
1669
('Oklahoma', 31475, NULL, 'Alabama'),('Pennsylvania', 0, NULL, 'Oklahoma'),
1670
('Texas', 0, NULL, 'Texas'),('West Virginia', 5, NULL, 'Utah'),
1671
('Florida', 49653, NULL, 'Kentucky'),('Tennessee', 19075, NULL, 'Oregon'),
1672
('Maine', 3, NULL, 'Kansas, Kentucky, Iowa'),('Iowa', 1, NULL, 'South Dakota'),
1673
('Kansas', -4037, NULL, 'Virginia'),('Delaware', 22550, NULL, 'Utah'),
1674
('Illinois', 14634, NULL, 'South Carolina, Colorado'),
1675
('Kansas', 6, NULL, 'South Dakota'),('Delaware', 9, NULL, ''),
1676
('', 0, NULL, 'Utah, Delaware, Florida, Georgia, Nevada'),
1677
('Colorado', 8, NULL, 'Montana'),('Maryland', 2689, NULL, 'Hawaii'),
1678
('Florida', -12306, NULL, 'Delaware'),
1679
('Indiana', 38567, NULL, 'Iowa, Minnesota, Maine'),
1680
('Oklahoma', 9, NULL, 'Delaware, Kansas, Oregon, Nebraska, Maryland, Minnesota'),
1681
('Tennessee', 12460, NULL, NULL),('Kentucky', 0, NULL, 'Ohio'),
1682
('Nevada', 7, NULL, 'Vermont, Oregon, Oklahoma, Montana'),
1683
('Nebraska', 61966, NULL, 'Nevada'),('Alaska', 131, NULL, 'Louisiana, Maine'),
1684
('Wisconsin', 4, NULL, 'Nevada'),('South Carolina', 0, NULL, 'Washington'),
1685
('West Virginia', 51314, NULL, 'Ohio'),('Louisiana', 0, NULL, ''),
1686
('Pennsylvania', 0, NULL, 'Iowa, Idaho'),('Arkansas', 14010, NULL, 'Indiana'),
1687
('Wyoming', -15514, NULL, 'Maine'),('Georgia', 0, NULL, 'N/A'),
1688
('Kentucky', 1, NULL, 'Idaho'),('Wyoming', 60249, NULL, 'Indiana, Iowa'),
1689
('Pennsylvania', 69, NULL, 'W'),
1690
('New Mexico', 11480, NULL, 'Florida, Georgia, Hawaii'),
1691
('South Carolina', 9, NULL, 'Iowa'),('Virginia', 0, NULL, 'Connecticut'),
1692
('Mississippi', 19749, NULL, 'Rhode Island'),('Illinois', 5, NULL, 'Virginia'),
1693
('Texas', -1749, NULL, 'Tennessee'),('Arizona', 28, NULL, 'California'),
1694
('Florida', 62151, NULL, 'Kansas'),('California', 172, NULL, 'SC'),
1695
('New Jersey', 0, NULL, 'North Carolina'),('Wyoming', 4, NULL, 'I'),
1696
('Kansas', 10683, NULL, 'California'),('Arkansas', -14275, NULL, 'K'),
1697
('Arizona', 5, NULL, 'California, Delaware, Rhode Island, Maryland'),
1698
('Florida', 0, NULL, 'T'),('Alaska', 241, NULL, 'Virginia');
1699
ALTER TABLE t1 ENABLE KEYS;
1701
SELECT * FROM t1 FORCE KEY (PRIMARY , i , c1 , c2)
1702
WHERE pk = 255 OR i = 22 OR (pk IN (1 , 136) AND c2 IN ('c' , 'w') AND (c1 NOT BETWEEN 'e' AND 'i' OR c2 > 'g')) OR pk != 1 ;
1703
id select_type table type possible_keys key key_len ref rows Extra
1704
1 SIMPLE t1 ALL PRIMARY,c1,i,c2 NULL NULL NULL 69 Using where
1646
1706
set optimizer_switch= @optimizer_switch_save;