Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
Test case:

--disable_abort_on_error

CREATE TABLE `table10_myisam_varchar_255_not_null` ( `col_varchar_255_latin1` varchar(255) CHARACTER SET latin1, `col_varchar_255_utf8_not_null_key` varchar(255) CHARACTER SET utf8 not null, `col_varchar_255_utf8_not_null` varchar(255) CHARACTER SET utf8 not null, `col_varchar_255_utf8` varchar(255) CHARACTER SET utf8, `col_varchar_255_utf8_key` varchar(255) CHARACTER SET utf8, `col_varchar_255_latin1_not_null_key` varchar(255) CHARACTER SET latin1 not null, `col_varchar_255_latin1_not_null` varchar(255) CHARACTER SET latin1 not null, `col_varchar_255_latin1_key` varchar(255) CHARACTER SET latin1, pk varchar(255) not null, /Indices/ key (`col_varchar_255_utf8_not_null_key` ), key (`col_varchar_255_utf8_key` ), key (`col_varchar_255_latin1_not_null_key` ), key (`col_varchar_255_latin1_key` ), primary key (pk)) ENGINE=myisam;
INSERT /*! IGNORE */ INTO table10_myisam_varchar_255_not_null VALUES ('g', 'nprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppy', 'not', 'n', 'pnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqa', 'wpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpuietwkrbtmrckibdvjswzoebdimrizo', 'twpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdn', 'b', 1) , ('ptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyy', 'bptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjt', 'ebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsag', 'pebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqa', 'i', 'lpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsct', 'plpebptwpnprhroncpjtwmo', 'c', 2) , ('z', 'rplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmp', 'nrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpz', 'gnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasn', 'dgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetoz', 'ydgnrplpebptw', 'yes', 'o', 3) , ('h', 'you\'re', 'qydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjl', 'aqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbsk', 'vaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpuietwkrbtmrckibdvjswzoebdimrizovaxcjufnwzyzhmepmnfbbwifalmsdsrvkzxgyzhbacoroqfnpinpsvlkqilkge', 'gvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosq', 'agvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpuietwkrbtmrckibdvjswzoebdimrizovaxcjufnwzyzhmepmnfbbwifalmsdsrvkzxgyzhbacoroqfnpinpsvlkqilkgenpjsixncvtglyxelmhpycwuiuxqefwtwvkovflshmfmqfh', 'qagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswra', 4) , ('pqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtf', 'gpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmuc', 'ygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctg', 'something', 'nygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzq', 'enygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergap', 'jenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqa', 'ejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhj', 5) , ('vejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqle', 'zvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmg', 'lzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpuietwkrbtmrckibdvjswzoebdimrizovaxcjufnwzyzhmepmnfbbwifalmsdsrvkzxg', 'tlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfil', 'my', 'stlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggag', 'p', 'g', 6) , ('qstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizaj', 'tqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqa', 'but', 'ctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonh', 'pctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxw', 'that', 'jpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpuietwkrbtmrckibdvjswzoebdimrizovaxcjufnwzyzhmepmnfbbwifalmsdsrvkzxgyzhbacoroqfnpinpsvlkqilkgenpjsixncvtglyxelmhpycwuiuxqefwtwvkovfls', 'r', 7) , ('g', 'm', 'when', 'gjpctqs', 'kgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaov', 'your', 'u', 'kkgjpctqstlzvejenygpqagv', 8) , ('u', 'pkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazb', 'lpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxp', 'hlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzo', 'vhlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrs', 'want', 'why', 'be', 9) , ('would', 'kvhlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldab', 'all', 'out', 'qkvhlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxi', 'a', 'jqkvhlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavk', 'wjqkvhlpkkgjpctqstlzvejenygpqagvaqydgnrplpebptwpnprhroncpjtwmonhkvecqehraogrqykdvxhcgrmqttjkefcilxufedgninthieoytwdnqkekrlvubmnlvwcsgbhmacmmffctgzasnamwvxflwvshsctrvamugloldoqwakvhuxfilhetspqxvxzoxpmzqwruvjlobpmoopfkfbpcldaxiriafxeghzsvkggagzuuoijfcnpsuaulrvyyspnbubuzpnwalcvnpqqhuctgsjxccqlghzksjmmqfpetkwdzrsxvlihscpcghqautjpqnmsagscsfdwnnwvlulrwtcldabdhcbffpopnpglaovutcwoivqarrkphkkazbrvryfsrbscgkttvgrvzergapsmxezigljjswrawmoeopbtfavkrxobtmmclkcdmgouoygohtybrdfofbskuwxmpfahjpfdanudldicjvecqtibgfspwaaetsuvucuimtdwwlmlmpaybhgesnbvzxihrqcslgymwdggcpzmbwlldrysuykcvvbovajrmjeqtmhaspbdomzrjazogbxamjtyjuvrhezkjmwzwfkjbheeetomdzaupmpexuaoemtwkededjbtejcgrchpcoaaibbeouhjuenvynnftwmokhhjmsmucnhqdxpxwsctefbjnbkffpdnudcsaqlsavjplbncfoppylnwidixrnmgxwyxirmfsjqvqhhrzzgvktirzgigtnqaaabaerambciayoetozmkvywlqledtkdktuastnpaysuexlktdprftanexnxizajmfacfgelzdgmftercdhfxosqpu', 10);
CREATE TABLE `table10_myisam_key_pk_parts_2_varchar_255_not_null` ( `col_varchar_255_utf8_not_null_key` varchar(255) CHARACTER SET utf8 not null, pk varchar(255) not null, `col_varchar_255_utf8_not_null` varchar(255) CHARACTER SET utf8 not null, `col_varchar_255_utf8_key` varchar(255) CHARACTER SET utf8, `col_varchar_255_utf8` varchar(255) CHARACTER SET utf8, `col_varchar_255_latin1_not_null_key` varchar(255) CHARACTER SET latin1 not null, `col_varchar_255_latin1_key` varchar(255) CHARACTER SET latin1, `col_varchar_255_latin1_not_null` varchar(255) CHARACTER SET latin1 not null, `col_varchar_255_latin1` varchar(255) CHARACTER SET latin1, /Indices/ key (`col_varchar_255_utf8_not_null_key` ), primary key (pk), key (`col_varchar_255_utf8_key` ), key (`col_varchar_255_latin1_not_null_key` ), key (`col_varchar_255_latin1_key` )) ENGINE=myisam /*!50100 PARTITION BY key (pk) partitions 2 */;
INSERT INTO `table10_myisam_key_pk_parts_2_varchar_255_not_null` ( `col_varchar_255_utf8_key` , `col_varchar_255_utf8_not_null` ) VALUES ( 'ktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpqncmlddrbwsltjevzcftedtgzurhnidhplgkdfxjhvzfracptasuipancaqgroulrhjfqtkqtlsi' , 'x' );
UPDATE `table10_myisam_key_pk_parts_2_varchar_255_not_null` SET `col_varchar_255_utf8` = 1 WHERE `col_varchar_255_utf8_not_null_key` IN ( 'jktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpqncmlddrbwsltjevzcftedtgzurhnidhplgk' , 'm' , 'zjktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpq' , 'vzjktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpqncml' , 'wvzjktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpqncmlddrbwsltjevzcftedtgzurhnidhplgkdfxjhvzfracpta' , 'twvzjktknqmmlzgoaiencddqtywkldauwlpahqnejfvektupgacqpqqjhtxltgwxaqifxoqanqstanooubmuilqbhjgaaivbjzbubuigbhwtadpxukwhbbfsxuqwzwwqldpqncmlddrbwsltjevzcftedtgzurhni' , 'tell' , 's' , 'w' , 'jtwvzjktknqmmlzgoaiencddqtywkldauwlpahqnejfvek' , 'her' ) ORDER BY `col_varchar_255_utf8_not_null` , `col_varchar_255_utf8_not_null_key`;
REPLACE INTO `table10_myisam_key_pk_parts_2_varchar_255_not_null` ( `col_varchar_255_latin1_not_null` ) SELECT `col_varchar_255_utf8_not_null_key` FROM `table10_myisam_varchar_255_not_null` WHERE `col_varchar_255_utf8_key` LIKE CONCAT( LEFT( 'k' , 7 ) , '%' ) ORDER BY `col_varchar_255_latin1_not_null` , `col_varchar_255_latin1` LIMIT 7;

Test case with no line wraps
LPexportBug625841_bug625841.test

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
The problem can be repeated on 5.3-main also.

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
Analysis:
The problem occurs because of the following scenario:

• Given a SELECT, the optimizer
  = picks range access plan
  = decides to use index condition pushdown, pushes the index condition down into storage engine, and the remainder condition happens to be empty ( the WHERE was "WHERE key LIKE (const)" so all of it was pushed down to index)

• We also need to use filesort() to handler ORDER BY clause. filesort() calls find_all_keys() which has this code:

...
if (quick_select)

/* Remember original bitmaps */
save_read_set= sort_form->read_set;
save_write_set= sort_form->write_set;
/* Set up temporary column read map for columns used by sort */
bitmap_clear_all(&sort_form->tmp_set);
/* Temporary set for register_used_fields and register_field_in_read_map */
sort_form->read_set= &sort_form->tmp_set;
register_used_fields(param);
if (select && select->cond)
select->cond->walk(&Item::register_field_in_read_map, 1,
(uchar*) sort_form);
sort_form->column_bitmaps_set(&sort_form->tmp_set, &sort_form->tmp_set);
...

Two things to note here:

1. When the code constructs table->read_set, it ignores any pushed index condition. Attempt to evaluate the condition causes the assert which this bug mentions.

2. The select->quick->reset() call is done BEFORE we update table->read_set. This has a consequence that:
= when one uses regular SELECT statement, DS-MRR is used. DS-MRR scans the index inside quick->reset() call, and SELECT statements work.
= when one uses REPLACE (or UPDATE/DELETE) statements, DS-MRR is disabled. Default MRR implementation scans the index in quick->get_next(), which is called when table->read_set is already incorrect. This is why REPLACE crashes while SELECT doesn't.

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
Modified tags to reflect the bug's nature.

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
Smaller testcase:

drop table t0, t1, t2;

create table t0 (a int);
insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table t1 (
key1 varchar(10),
col1 char(255), col2 char(255),
col3 char(244), col4 char(255),
key(key1)
);
create table t2 like t1;

insert into t1
select
1000+A.a+100*B.a + 10*C.a,
'col1val', 'col2val',
'col3val', 'col4val'
from t0 A, t0 B, t0 C;

REPLACE INTO t2(col2,col3,col4)
SELECT col2,col3,col4
FROM t1
WHERE `key1` LIKE CONCAT( LEFT( '1' , 7 ) , '%' )
ORDER BY col1 LIMIT 7;

Re: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' on REPLACE ... SELECT with MRR
Fixed in 5.3-dsmrr-cpk tree

Launchpad bug id: 625841