Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Panic is Wikipedia import cause by a Replace into a table with Full text indexes #7593

Closed
timsehn opened this issue Mar 11, 2024 · 2 comments · Fixed by dolthub/go-mysql-server#2386
Assignees
Labels
bug Something isn't working integrations Issues with tools connecting to/querying Dolt panic sql Issue with SQL

Comments

@timsehn
Copy link
Contributor

timsehn commented Mar 11, 2024

Panic

panic: runtime error: index out of range [2] with length 2

goroutine 342225 [running]:
github.com/dolthub/go-mysql-server/sql/fulltext.TableEditor.Delete({{{0x13173c3b0, 0x1402a51e140}, {0x0, 0x0}, {0x1402a2bc168, 0x3, 0x3}}, {0x1402a486780, 0x2, 0x2}}, ...)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/fulltext/fulltext_editor.go:385 +0xc60
github.com/dolthub/go-mysql-server/sql/fulltext.MultiTableEditor.Delete({{0x13173c3b0, 0x14028a90a00}, {0x1402a233b40, 0x1, 0x1}}, 0x1400008a900?, {0x1402b614540, 0x2, 0x2})
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/fulltext/multi_editor.go:117 +0xa0
github.com/dolthub/go-mysql-server/sql/rowexec.(*insertIter).Next(0x1402a2ccdd0, 0x1402a13d7c0)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/rowexec/insert.go:150 +0xb7c
github.com/dolthub/go-mysql-server/sql/plan.(*TableEditorIter).Next(0x1402a1e1810, 0x1402a13d7c0)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/plan/table_editor.go:55 +0x70
github.com/dolthub/go-mysql-server/sql/rowexec.(*accumulatorIter).Next(0x14024225740, 0x1402a13d7c0)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/rowexec/dml_iters.go:513 +0x164
github.com/dolthub/go-mysql-server/sql/rowexec.transactionCommittingIter.Next(...)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/rowexec/transaction_iters.go:78
github.com/dolthub/go-mysql-server/sql/plan.(*trackedRowIter).Next(0x1402a286740, 0x14028a457a0?)
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/sql/plan/process.go:357 +0x30
github.com/dolthub/go-mysql-server/server.(*Handler).doQuery.func2()
	/Users/timsehn/go/pkg/mod/github.com/dolthub/[email protected]/server/handler.go:388 +0xe8
golang.org/x/sync/errgroup.(*Group).Go.func1()
	/Users/timsehn/go/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:75 +0x58
created by golang.org/x/sync/errgroup.(*Group).Go in goroutine 146
	/Users/timsehn/go/pkg/mod/golang.org/x/[email protected]/errgroup/errgroup.go:72 +0x98

Query

REPLACE /* SearchMySQL::update */ INTO `searchindex` (si_page,si_title,si_text) VALUES (366,'anatoly karpov',' short description russian chess champion born 1951 distinguish andriy karpov family name hatnote yevgenyevich karpov lang eastern slavic useu800 mdyu800 dates date august 2022 infobox chess biography name anatoly karpov image anatoly karpov 2017 aprilu82ejpgu800 caption karpov inu800 2017 full_name anatoly yevgenyevich karpov country ublu800 soviet union until 1991 russia since 1991 birth_date birth date andu800 ageu800 1951 05u800 23u800 birth_place zlatoust russian sfsr soviet union title grandmaster chess grandmaster 1970 worldchampion ublu800 1975u8e280931985 undisputed 1993u8e280931999 fide rating peakrating 2780 july 1994 peakranking list ofu800 fide chess world number ones nou800. 1u800 january 1976 fideid 4100026 module infobox officeholder embed yesu800 office1 member ofu800 theu800 state duma foru800 tyumen oblast \\'su800 party list term_start1 21u800 december 2011 term_end1 party united russia anatoly yevgenyevich karpov lang-rusu800 links nou800 u8d0b0u8d0bdu8d0b0u8d182u8d0beu8cc81u8d0bbu8d0b8u8d0b9 u8d0b5u8d0b2u8d0b3u8d0b5u8cc81u8d0bdu8d18cu8d0b5u8d0b2u8d0b8u8d187 u8d0bau8d0b0u8cc81u8d180u8d0bfu8d0beu8d0b2 pu800 u8c990nu8c990u8cb88tolu8cab2u8c9aaj ju8c9aavu8cb88u8c9a1u8cab2enu8cab2ju8c9aavu8cab2u8c9aatu8c995 u8cb88karpu8c999f ; born mayu800 23u800 1951 isu800 au800 russian andu800 former soviet grandmaster chess chess grandmaster former world chess championship world chess champion u8e281a3and politician. widely regarded asu800 oneu800 ofu800 theu800 greatest chess players ofu800 allu800 time heu800 wasu800 theu800 12th world chess champion from 1975 tou800 1985 au800 three-time fide world champion 1993 1996 1998 twice world chess champion asu800 au800 member ofu800 theu800 ussr team 1985 1989 andu800 au800 sixu800-time winner ofu800 chess olympiad chess olympiads asu800 au800 member ofu800 theu800 ussr team 1972 1974 1980 1982 1986 1988 . theu800 international association ofu800 chess press awarded himu800 nine chess oscars 1973u8e2809377 1979 1980 1981 1984 . karpov karpov\\'su800 chess tournament successes include over 160u800 first-place finishes. cite webu800 first eric last vanu800 reem title karpov kortchnoi winu800 unzicker gala urlu800 publisher chessbase date august 11u800 2005 access-date july 2u800 2009 inu800 hisu800 1994 book myu800 best games karpov says heu800 played some 200u800 tournaments andu800 matches andu800 wonu800 more than 100u800. heu800 hadu800 au800 peak elou800 rating system elou800 rating ofu800 2780 andu800 hisu800 102u800 total months atu800 world number oneu800 isu800 theu800 list ofu800 world chess championships fourth-longest ofu800 allu800 time behind magnus carlsen garry kasparov andu800 emanuel lasker . karpov isu800 also anu800 elected member ofu800 theu800 state duma inu800 russia . since 2006 heu800 hasu800 chaired theu800 commission foru800 ecological safety andu800 environmental protection ofu800 theu800 civic chamber ofu800 theu800 russian federation andu800 since 2007 heu800 hasu800 been au800 member ofu800 theu800 public council under theu800 ministry ofu800 defence. cite webu800 date february 8u800 2021 title anatoly karpov elected asu800 deputy secretary general ofu800 theu800 assembly urlu800 access-date february 24u800 2022 website official site ofu800 theu800 eurasian peoples assembly language enu800-usu800 early life early life early life karpov wasu800 born into au800 russians russian family onu800 mayu800 23u800 1951 howu800 karpov wins pu800. xiii deep blue anu800 artificial intelligence milestone bats pu800. 44u800 inu800 zlatoust inu800 theu800 urals region ofu800 theu800 former soviet union andu800 learned tou800 play chess atu800 theu800 ageu800 ofu800 four. cite magazine title anatoly karpov last keene first raymond magazine chess life & review date october 1978 volume xxiii number 10u800 page 539u800 hisu800 early rise inu800 chess wasu800 swift asu800 heu800 became au800 candidate master byu800 ageu800 11u800. atu800 12u800 heu800 wasu800 accepted into mikhail botvinnik \\'su800 prestigious chess school though botvinnik made theu800 following remark about theu800 young karpov \\\"theu800 boyu800 does notu800 have au800 clue about chess andu800 there there\\'su800 nou800 future atu800 allu800 foru800 himu800 inu800 this profession.\\\" cite news urlu800 title getting itu800 offu800 hisu800 chess last arrabal first fernando date march 1u800 1992 work theu800 newu800 york times access-date february 15u800 2021 karpov acknowledged that hisu800 understanding ofu800 chess theory wasu800 very confused atu800 that time andu800 later wrote that theu800 homework botvinnik assigned greatly helped himu800 since itu800 required that heu800 consult chess books andu800 work diligently. cite book title karpov onu800 karpov au800 memoirs ofu800 au800 chess world champion author karpov au800. publisher atheneum year 1992 isbn 0u800-689u800-12060-5u800 karpov improved sou800 quickly under botvinnik botvinnik\\'su800 tutelage that heu800 became theu800 youngest soviet master inu800 history atu800 theu800 ageu800 ofu800 fifteen inu800 1966; this tied theu800 record established byu800 boris spassky inu800 1952. cite webu800 author editorial staff date april 15u800 2022 title boris spassky - theu800 russian chess grandmaster legend - chess player profile urlu800 access-date august 4u800 2022 website theu800 chess journal language enu800-usu800 cite webu800 title anatoly karpov urlu800 access-date august 4u800 2022 website u8d184u8d0b5u8d0b4u8d0b5u8d180u8d0b0u8d186u8d0b8u8d18f u8d188u8d0b0u8d185u8d0bcu8d0b0u8d182 u8d180u8d0beu8d181u8d181u8d0b8u8d0b8 language enu800 career career career young master file anatoly karpov 1967 .jpgu800 thumb karpov inu800 1967 karpov finished first inu800 hisu800 first international tournament inu800 tu8c599inec several months later ahead ofu800 viktor kupreichik . inu800 1967 heu800 wonu800 theu800 annual european junior chess championship niemeyer tournament inu800 groningen . cite magazine title junior meet magazine chess review date april 1968 volume 36u800 number 4u800 page 99u800 quote theu800 niemeyer international junior tournament inu800 groningen holland went tou800 karpov ofu800 theu800 soviet union with 5u8c2bdu8e280931u8c2bd half au800 point ahead ofu800 jocha ofu800 hungary. cite webu800 urlu800 title euu800-chu800 u18u800 fu800-au800 6768 1967 website 365chessu82ecomu800 access-date october 20u800 2013 karpov wonu800 au800 gold medal foru800 academic excellence inu800 high school andu800 entered moscow state university inu800 1968 tou800 study mathematics. heu800 later transferred tou800 leningrad state university eventually graduating from there inu800 economics. oneu800 reason foru800 theu800 transfer wasu800 tou800 beu800 closer tou800 hisu800 coach grandmaster semyon furman whou800 lived inu800 leningrad. inu800 hisu800 writings karpov credits furman asu800 au800 major influence onu800 hisu800 development asu800 au800 world-class player. cite news urlu800 first fernando last arrabal title getting itu800 offu800 hisu800 chess date march 1u800 1992 website theu800 nyu800 times access-date november 16u800 2022 inu800 1969 karpov became theu800 first soviet player since spassky 1955 tou800 winu800 theu800 world junior chess championship world junior championship scoring anu800 undefeated 10u800 11u800 inu800 theu800 final au800 group atu800 stockholm . cite webu800 urlu800 title wchu800 u20u800 finu800-au800 publisher 365chessu82ecomu800 access-date october 20u800 2013 this victory earned himu800 theu800 international master title. cite magazine title tenth junior world championship. stockholm august 10u800 u8e28093 29u800 1969 last trifunovich first petar magazine chess review date october 1969 volume 37u800 number 10u800 page 315u800 inu800 1970 karpov tied foru800 fourth andu800 fifth places with palu800 benko atu800 anu800 international tournament inu800 caracas venezuela cite webu800 urlu800 title caracas 1970 website 365chessu82ecomu800 access-date october 20u800 2013 andu800 earned theu800 grandmaster chess international grandmaster title. cite magazine title donu800\\'tu800 walk u8e28093 runu800 last kavalek first lubosh magazine chess life & review date september 1970 volume xxvu800 number 9u800 page 483u800 quote anatoli karpov isu800 au800 newu800 international grandmaster. playing \\\"waiting chess\\\" heu800 just made theu800 grandmaster norm. fide awarded himu800 theu800 title during itsu800 41st congress held during theu800 chess olympiad inu800 siegen west germany inu800 september 1970. cite magazine title fide fide\\'su800 41st -andu800 greatest -congress last cramer first fred magazine chess life & review date january 1971 volume xxvi number 1u800 page 24u800 quote theu800 congress awarded igmu800 titles tou800 anatoly karpov andu800 buchuti gurgenldze ofu800 theu800 ussr andu800 tou800 walter browne ofu800 australia. grandmaster grandmaster grandmaster karpov wonu800 theu800 1971 alekhine memorial tournament inu800 moscow jointly with leonid stein ahead ofu800 au800 star-studded field foru800 hisu800 first significant adult victory. cite webu800 urlu800 title alekhine memu800 1971 website wwwu800u82e365chessu82ecomu800 hisu800 elou800 rating system elou800 rating shot from 2540 inu800 1971 tou800 2660 inu800 1973 cite webu800 urlu800 title fide rating history karpov anatoly during which heu800 shared second place inu800 theu800 1973 ussr chess championship 1973 soviet championship oneu800 point behind boris spassky spassky cite webu800 urlu800 title 41st soviet chess championship moscow 1973 website wwwu800u82eolimpbaseu82eorgu800 andu800 qualified foru800 theu800 leningrad interzonal. cite webu800 urlu800 title leningrad interzonal 1973 website wwwu800u82e365chessu82ecomu800 candidate candidate candidate karpov karpov\\'su800 world junior championship qualified himu800 foru800 oneu800 ofu800 theu800 twou800 interzonal interzonals zonal qualifiers 1972-1975 mark weeks chess pages cite magazine title theu800 1973 interzonals last cramer first fred magazine chess life & review date january 1973 volume xxviii number 1u800 page 34u800 au800 stage inu800 theu800 world chess championship 1975 1975 world championship cycle tou800 choose theu800 challenger tou800 play world champion bobby fischer . heu800 finished equal first inu800 theu800 leningrad interzonal qualifying foru800 theu800 1974 candidates matches . karpov defeated levu800 polugaevsky byu800 theu800 score ofu800 3u800 5u800 inu800 theu800 first candidates match earning theu800 right tou800 face former champion boris spassky inu800 theu800 semifinal round. karpov wasu800 onu800 record saying that heu800 believed spassky would easily beat himu800 andu800 winu800 theu800 candidates cycle tou800 face fischer andu800 that heu800 karpov would winu800 theu800 following candidates cycle inu800 1977. spassky wonu800 theu800 first game asu800 black inu800 good style butu800 tenacious aggressive play from karpov secured himu800 overall victory byu800 4u8e288921 6u800. theu800 candidates final wasu800 played inu800 moscow with victor korchnoi . karpov took anu800 early lead winning theu800 second game against theu800 sicilian defence sicilian dragon then scoring another victory inu800 theu800 sixth game. following tenu800 consecutive draw chess draws korchnoi threw away au800 winning position inu800 theu800 seventeenth game tou800 give karpov au800 3u8e280930 lead. inu800 game 19u800 korchnoi succeeded inu800 winning au800 long chess endgame endgame then notched au800 speedy victory after au800 blunder byu800 karpov twou800 games later. three more draws theu800 last draw byu800 agreement agreed byu800 karpov when heu800 wasu800 inu800 au800 clearly better position closed theu800 match with karpov prevailing 3u8e288922 19u800 entitling himu800 tou800 move onu800 tou800 challenge fischer foru800 theu800 world title. chessgamesu82ecomu800 karpov - korchnoi candidates final 1974 match with fischer inu800 1975 match with fischer inu800 1975 match with fischer inu800 1975 though au800 world championship match between karpov andu800 fischer wasu800 highly anticipated those hopes were never realised. fischer notu800 only insisted that theu800 match beu800 theu800 first tou800 tenu800 wins draw chess draws notu800 counting butu800 also that theu800 champion retain theu800 crown ifu800 theu800 score wasu800 tied 9u8e280939. fide theu800 international chess federation refused tou800 allow this proviso andu800 gave both players au800 deadline ofu800 april 1u800 1975 tou800 agree tou800 play theu800 match under theu800 fide-approved rules. cite magazine last hochberg first burt date mayu800 1975 title news & views magazine chess life andu800 review location newburgh newu800 york publisher united states chess federation when fischer didu800 notu800 agree fide president maxu800 euwe declared onu800 april 3u800 1975 that fischer hadu800 forfeited hisu800 title andu800 karpov wasu800 theu800 newu800 world champion. cite book last byrne first robert author-link robert byrne chess player date 1976 title anatoly karpov theu800 road tou800 theu800 world chess championship location newu800 york publisher bantam books page 1u800 isbn 0u800-553u800-02876-6u800 karpov later attempted tou800 setu800 upu800 another match with fischer butu800 theu800 negotiations fell through. this thrust theu800 young karpov into theu800 role ofu800 world champion without having faced theu800 reigning champion. garry kasparov argued that karpov would have hadu800 good chances because heu800 hadu800 beaten spassky convincingly andu800 wasu800 au800 newu800 breed ofu800 tough professional andu800 indeed hadu800 higher quality games while fischer hadu800 been inactive foru800 three years. kasparov myu800 great predecessors part ivu800 fischer pu800. 474u800 this view isu800 echoed byu800 karpov himself. cite webu800 urlu800 title karpov onu800 fischer korchnoi kasparov andu800 theu800 chess world today publisher chessbase date february 5u800 2020 access-date february 6u800 2020 spassky thought that fischer would have wonu800 inu800 1975 butu800 karpov would have qualified again andu800 beaten fischer inu800 1978. inu800 anu800 article pdfu800 published inu800 2004 onu800 theu800 chesscafe website susan polgar wrote \\\"iu800 spoke tou800 boris spassky about this same issue andu800 heu800 believes that bobby would have wonu800 inu800 1975 butu800 that anatoly would have wonu800 theu800 rematch.\\\" karpov hasu800 said that ifu800 heu800 hadu800 hadu800 theu800 opportunity tou800 play fischer foru800 theu800 championship inu800 hisu800 twenties heu800 could have been au800 much better player asu800 au800 result. cite webu800 date mayu800 21u800 2021 title \\\"u8d0bau8d0b0u8d181u8d0bfu8d0b0u8d180u8d0beu8d0b2 u8d0bfu8d0beu8d0bbu8d183u8d187u8d0b8u8d0bb u8d0beu8d182 u8d0bcu8d0b5u8d0bdu8d18f 48u800 u8d0b1u8d0b5u8d181u8d0bfu8d0bbu8d0b0u8d182u8d0bdu8d18bu8d185 u8d183u8d180u8d0beu8d0bau8d0beu8d0b2\\\". u8d0b1u8d0beu8d0bbu8d18cu8d188u8d0beu8d0b5 u8d0b8u8d0bdu8d182u8d0b5u8d180u8d0b2u8d18cu8d18e u8d0bau8d0b0u8d180u8d0bfu8d0beu8d0b2u8d0b0 urlu800 access-date july 4u800 2022 website sport-expressu82eruu800 language ruu800 world champion -- this section isu800 linked from world chess championship -- file maxu800 euwe wife andu800 karpov 1976u82ejpgu800 thumb 300px karpov with fide president maxu800 euwe andu800 wife inu800 1976 determined tou800 prove himself au800 legitimate champion karpov participated inu800 nearly every major tournament foru800 theu800 next tenu800 years. heu800 convincingly wonu800 theu800 milan tournament inu800 1975 andu800 captured hisu800 first ofu800 three soviet titles inu800 1976. heu800 created au800 phenomenal streak ofu800 tournament wins against theu800 strongest players inu800 theu800 world. karpov held theu800 record foru800 most consecutive tournament victories 9u800 until itu800 wasu800 shattered byu800 garry kasparov 14u800 . asu800 au800 result most chess professionals soon agreed that karpov wasu800 au800 legitimate world champion. cite book last seirawan first yasser title winning chess strategies year 2005 publisher microsoft press isbn 978u800-1857443851 inu800 1978 karpov karpov\\'su800 first title defence wasu800 against viktor korchnoi theu800 opponent heu800 hadu800 defeated inu800 theu800 1973u8e2809375 candidates cycle; theu800 match wasu800 played atu800 baguio philippines with theu800 winner needing sixu800 victories. asu800 inu800 1974 karpov took anu800 early lead winning theu800 eighth game after seven draws tou800 open theu800 match. when theu800 score wasu800 5u8e288922 20u800 inu800 karpov karpov\\'su800 favour korchnoi staged au800 comeback andu800 wonu800 three ofu800 theu800 next four games tou800 draw level with karpov. karpov then wonu800 theu800 very next game tou800 retain theu800 title 6u8e288925 21u800 . chessgamesu82ecomu800 karpov vsu800 korchnoi 1978 three years later korchnoi reemerged asu800 theu800 candidates winner against german finalist robert hu8c3bcbner tou800 challenge karpov inu800 merano italy. karpov handily wonu800 this match 11u8e280937 6u8e288922 10u800 inu800 what isu800 remembered asu800 theu800 world chess championship 1981 \\\"massacre inu800 merano\\\" . karpov karpov\\'su800 tournament career reached au800 peak atu800 theu800 montreal \\\"tournament ofu800 stars\\\" tournament inu800 1979 where heu800 finished joint first 7u8e288921 10u800 with mikhail talu800 ahead ofu800 au800 field ofu800 strong grandmasters completed byu800 janu800 timman ljubomir ljubojeviu8c487 boris spassky vlastimil hort lajos portisch robert hu8c3bcbner bent larsen andu800 lubomir kavalek . heu800 dominated lasu800 palmas inu800 1977 with 13u8c2bd 15u800. heu800 also wonu800 theu800 prestigious bugojno tournament inu800 1978 shared 1980 andu800 1986 theu800 linares chess tournament linares tournament inu800 1981 shared with larry christiansen andu800 1994 theu800 tilburg tournament inu800 1977 1979 1980 1982 andu800 1983 andu800 theu800 ussr chess championship soviet championship inu800 1976 1983 andu800 1988. chessgamesu82ecomu800 anatoly karpov karpov represented theu800 soviet union atu800 sixu800 chess olympiads inu800 allu800 ofu800 which theu800 ussr wonu800 theu800 team gold medal. heu800 played asu800 theu800 first reserve atu800 20th chess olympiad skopje 1972 winning theu800 board prize with 13u800 15u800. atu800 21st chess olympiad nice 1974 heu800 advanced tou800 board oneu800 andu800 again wonu800 theu800 board prize with 12u800 14u800. atu800 24th chess olympiad lau800 valletta 1980 heu800 wasu800 again board oneu800 andu800 scored 9u800 12u800. atu800 25th chess olympiad lucerne 1982 heu800 scored 6u8c2bd 8u800 onu800 board oneu800. atu800 27th chess olympiad dubai 1986 heu800 scored 6u800 9u800 onu800 board twou800. hisu800 last wasu800 28th chess olympiad thessaloniki 1988 where onu800 board twou800 heu800 scored 8u800 10u800. inu800 olympiad play karpov lost only twou800 games outu800 ofu800 68u800 played. cite webu800 title karpov atu800 70u800 \\\"myu800 great blunder wasu800 iu800 agreed tou800 hold theu800 match with kasparov inu800 theu800 soviet union\\\" urlu800 access-date june 2u800 2022 website chess24u82ecomu800 language enu800 tou800 illustrate karpov karpov\\'su800 dominance over hisu800 peers asu800 champion hisu800 score wasu800 13u8e288921 22u800 versus spassky 8u800 19u800 versus robert hu8c3bcbner 12u8e288921 29u800 versus ulfu800 andersson 3u8e288921 10u800 versus vasily smyslov 1u800 19u800 versus mikhail talu800 19u800-7u800 23u800 versus ljubomir ljubojeviu8c487 . rivalry with kasparov rivalry with kasparov rivalry with kasparov excerpt karpov-kasparov rivalry overview fide champion again 1993u8e280931999 fide champion again 1993u8e280931999 fide champion again 1993u8e280931999 image anatoly karpovu82ejpgu800 thumb karpov inu800 1993 inu800 1992 karpov lost au800 candidates match against nigel short . butu800 inu800 theu800 world chess championship 1993 karpov reacquired theu800 fide world champion title when kasparov andu800 short split from fide. karpov defeated timman u8e28093 theu800 loser ofu800 theu800 candidates final against short. theu800 next major meeting ofu800 kasparov andu800 karpov wasu800 theu800 1994 linares chess tournament . theu800 field inu800 eventual finishing order wasu800 karpov kasparov alexei shirov shirov evgeny bareev bareev vladimir kramnik kramnik jou8c3abl lautier lautier viswanathan anand anand gata kamsky kamsky veselin topalov topalov vassily ivanchuk ivanchuk boris gelfand gelfand miguel illescas illescas judit polgu8c3a1r andu800 alexander beliavsky beliavsky ; with anu800 average elou800 rating system elou800 rating ofu800 2685 theu800 highest ever atu800 that time. impressed byu800 theu800 strength ofu800 theu800 tournament kasparov hadu800 said several days before theu800 tournament that theu800 winner could rightly beu800 called theu800 world champion ofu800 tournaments. perhaps spurred onu800 byu800 this comment karpov played theu800 best tournament ofu800 hisu800 life. heu800 wasu800 undefeated andu800 earned 11u800 points outu800 ofu800 13u800 theu800 best world-class tournament winning percentage since alekhine wonu800 sanu800 remo 1930 chess tournament sanu800 remo inu800 1930 finishing 2u8c2bd points ahead ofu800 second-place kasparov andu800 shirov. many ofu800 hisu800 wins were spectacular inu800 particular hisu800 winu800 over topalov isu800 considered possibly theu800 finest ofu800 hisu800 career . this performance against theu800 best players inu800 theu800 world putu800 hisu800 elou800 rating system elou800 rating tournament performance atu800 2985 theu800 highest performance rating chess performance rating ofu800 anyu800 player inu800 history upu800 until 2009 when magnus carlsen wonu800 theu800 category xxiu800 pearl spring chess tournament with au800 performance ofu800 3002. chess statistician jeff sonas considers karpov karpov\\'su800 linares performance theu800 best tournament result inu800 history. \\\"facts andu800 figures magnus carlsen carlsen\\'su800 performance inu800 nanjing\\\" . chessbase. retrieved october 26u800 2009. karpov defended hisu800 fide title against theu800 rising star gata kamsky 6u8e288923 9u800 inu800 1996. inu800 1998 fide largely scrapped theu800 oldu800 system ofu800 candidates matches instead having au800 large knockout event inu800 which au800 large number ofu800 players contested short matches against each other over just au800 fewu800 weeks. inu800 theu800 first ofu800 these events theu800 fide world chess championship 1998 champion karpov wasu800 seeded straight into theu800 final defeating viswanathan anand 2u8e288922 2u800 rapid tiebreak 2u8e280930 . inu800 theu800 subsequent cycle theu800 format wasu800 changed with theu800 champion having tou800 qualify. karpov refused tou800 defend hisu800 title andu800 ceased tou800 beu800 fide world champion after theu800 fide world chess championship 1999 . citation needed date july 2021 towards retirement towards retirement towards retirement karpov karpov\\'su800 classical tournament play hasu800 been seriously limited since 1997 since heu800 prefers tou800 beu800 more involved inu800 russian politics. heu800 hadu800 been au800 member ofu800 theu800 supreme soviet commission foru800 foreign affairs andu800 theu800 president ofu800 theu800 soviet peace fund before theu800 soviet union dissolved. inu800 addition heu800 hasu800 been involved inu800 several disputes with fide. cite webu800 date july 22u800 1999 title karpov mayu800 sueu800 over lvu800 tourney - lasu800 vegas sunu800 newspaper urlu800 access-date mayu800 6u800 2021 website lasvegassunu82ecomu800 language enu800 inu800 theu800 september 2009 fide rating list heu800 dropped outu800 ofu800 theu800 world world\\'su800 topu800 100u800 foru800 theu800 first time. karpov usually limits hisu800 play tou800 exhibition events andu800 hasu800 revamped hisu800 style tou800 specialize inu800 rapid chess. inu800 2002 heu800 wonu800 au800 match against kasparov defeating himu800 inu800 au800 rapid time control match 2u8c2bdu8e280931u8c2bd. inu800 2006 heu800 tied foru800 first with kasparov inu800 au800 blitz tournament ahead ofu800 korchnoi andu800 judit polgu8c3a1r. cite webu800 urlu800 title theu800 credit suisse blitz u8e28093 inu800 pictures date august 27u800 2006 publisher chessbase access-date october 21u800 2010 karpov andu800 kasparov played au800 mixed 12u800-game match from september 21u8e2809324 2009 inu800 valencia spain. itu800 consisted ofu800 four rapid oru800 semi-rapid andu800 eight blitz games andu800 took place exactly 25u800 years after theu800 twou800 players legendary encounter atu800 theu800 world chess championship 1984 . cite webu800 urlu800 title kasparov andu800 karpov tou800 play 12u800 games match inu800 valencia access-date july 8u800 2009 publisher chessdom archive-date july 12u800 2009 archive-urlu800 urlu800-status dead kasparov wonu800 theu800 match 9u8e280933. karpov played au800 match against yasser seirawan inu800 2012 inu800 stu800. louis missouri anu800 important center ofu800 theu800 north american chess scene winning 8u8e280936 5u8e288923 6u800 . cite webu800 urlu800 title karpov seirawan head tou800 rapid play inu800 saint louis date june 12u800 2012 publisher stu800 louis chess club access-date june 12u800 2012 inu800 november 2012 heu800 wonu800 theu800 capu800 du800\\'agde rapid tournament that bears hisu800 name anatoly karpov trophy beating vasyl ivanchuk ranked 9thu800 inu800 theu800 october 2012 fide world rankings inu800 theu800 final. professional andu800 political career after retirement from chess professional andu800 political career after retirement from chess professional andu800 political career after retirement from chess file karpov chess schoolu82ejpgu800 thumb karpov founded hisu800 chess school inu800 theu800 tanu800 building. theu800 sign bearing hisu800 name hasu800 been removed andu800 theu800 school isu800 inu800 theu800 process ofu800 changing itsu800 name. inu800 2003 karpov opened hisu800 first american chess school inu800 lindsborg kansas . cite webu800 title anatoly karpov international school ofu800 chess urlu800 access-date september 19u800 2021 website wwwu800u82eanatolykarpovchessschoolu82eorgu800 onu800 march 2u800 2022 theu800 school announced au800 name change tou800 international school ofu800 chess ofu800 theu800 midwest dueu800 tou800 theu800 russian invasion ofu800 ukraine . cite webu800 urlu800 title international school ofu800 chess ofu800 theu800 midwest website wwwu800u82efacebooku82ecomu800 karpov hasu800 been au800 member ofu800 theu800 6thu800 state duma sixth 7thu800 state duma seventh andu800 8thu800 state duma eighth russian state dumas . cite webu800 urlu800 title u8d0bau8d0b0u8d180u8d0bfu8d0beu8d0b2 u8d0b0u8d0bdu8d0b0u8d182u8d0beu8d0bbu8d0b8u8d0b9 u8d0b5u8d0b2u8d0b3u8d0b5u8d0bdu8d18cu8d0b5u8d0b2u8d0b8u8d187 website u8d0b3u8d0beu8d181u8d183u8d0b4u8d0b0u8d180u8d181u8d182u8d0b2u8d0b5u8d0bdu8d0bdu8d0b0u8d18f u8d0b4u8d183u8d0bcu8d0b0 since 2005 heu800 hasu800 been au800 member ofu800 theu800 public chamber ofu800 russia . heu800 hasu800 involved himself inu800 several humanitarian causes such asu800 advocating theu800 useu800 ofu800 iodised salt . cite webu800 urlu800 title stories from theu800 region website wwwu800u82eunicefu82eorgu800 access-date march 26u800 2018 archive-date january 8u800 2010 archive-urlu800 urlu800-status dead onu800 december 17u800 2012 karpov supported cite webu800 urlu800 title 2u800 u8d187u8d182u8d0b5u8d0bdu8d0b8u8d0b5 u8d184u8d0b7 u8e28496186614-6u800 \\\"u8d0be u8d0bcu8d0b5u8d180u8d0b0u8d185 u8d0b2u8d0beu8d0b7u8d0b4u8d0b5u8d0b9u8d181u8d182u8d0b2u8d0b8u8d18f u8d0bdu8d0b0 u8d0bbu8d0b8u8d186 u8d0bfu8d180u8d0b8u8d187u8d0b0u8d181u8d182u8d0bdu8d18bu8d185 u8d0ba u8d0bdu8d0b0u8d180u8d183u8d188u8d0b5u8d0bdu8d0b8u8d18e u8d0beu8d181u8d0bdu8d0beu8d0b2u8d0beu8d0bfu8d0beu8d0bbu8d0b0u8d0b3u8d0b0u8d18eu8d189u8d0b8u8d185 u8d0bfu8d180u8d0b0u8d0b2 u8d0b8 u8d181u8d0b2u8d0beu8d0b1u8d0beu8d0b4 u8d187u8d0b5u8d0bbu8d0beu8d0b2u8d0b5u8d0bau8d0b0 u8d0bfu8d180u8d0b0u8d0b2 u8d0b8 u8d181u8d0b2u8d0beu8d0b1u8d0beu8d0b4 u8d0b3u8d180u8d0b0u8d0b6u8d0b4u8d0b0u8d0bd u8d180u8d184\\\" u8e28093 u8d181u8d0b8u8d181u8d182u8d0b5u8d0bcu8d0b0 u8d0b0u8d0bdu8d0b0u8d0bbu8d0b8u8d0b7u8d0b0 u8d180u8d0b5u8d0b7u8d183u8d0bbu8d18cu8d182u8d0b0u8d182u8d0beu8d0b2 u8d0b3u8d0beu8d0bbu8d0beu8d181u8d0beu8d0b2u8d0b0u8d0bdu8d0b8u8d0b9 u8d0bdu8d0b0 u8d0b7u8d0b0u8d181u8d0b5u8d0b4u8d0b0u8d0bdu8d0b8u8d18fu8d185 u8d0b3u8d0beu8d181u8d183u8d0b4u8d0b0u8d180u8d181u8d182u8d0b2u8d0b5u8d0bdu8d0bdu8d0beu8d0b9 u8d0b4u8d183u8d0bcu8d18b website voteu82edumau82egovu800u82eruu800 access-date march 26u800 2018 theu800 lawu800 inu800 theu800 russian parliament banning adoption ofu800 russian orphans byu800 uu800u82esu800. citizens. karpov expressed support ofu800 theu800 annexation ofu800 crimea byu800 theu800 russian federation andu800 accused europe ofu800 trying tou800 demonize putin. cite webu800 urlu800 title u8d0b0u8d0bdu8d0b0u8d182u8d0beu8d0bbu8d0b8u8d0b9 u8d0bau8d0b0u8d180u8d0bfu8d0beu8d0b2 u8d0b5u8d0b2u8d180u8d0beu8d0bfu8d0b0 u8d0bfu8d18bu8d182u8d0b0u8d0b5u8d182u8d181u8d18f u8d0b4u8d0b5u8d0bcu8d0beu8d0bdu8d0b8u8d0b7u8d0b8u8d180u8d0beu8d0b2u8d0b0u8d182u8d18c u8d0bfu8d183u8d182u8d0b8u8d0bdu8d0b0 u8d0b0 u8d0bdu8d0b5 u8d180u8d0beu8d181u8d181u8d0b8u8d18e first u8d0b2u8d0bbu8d0b0u8d0b4u8d0b8u8d0bcu8d0b8u8d180 last u8d0bau8d0beu8d0b6u8d0b5u8d0bcu8d18fu8d0bau8d0b8u8d0bd website wwwu800u82eaifu800u82eruu800 date june 23u800 2015 access-date march 26u800 2018 inu800 august 2019 maxim dlugy said that karpov hadu800 been waiting since march foru800 theu800 approval ofu800 au800 nonu800-immigrant visa tou800 theu800 united states despite frequently visiting theu800 country since 1972. karpov hadu800 been scheduled tou800 teach au800 summer camp atu800 theu800 chess maxu800 academy. dlugy said that karpov hadu800 been questioned atu800 theu800 embassy ofu800 theu800 united states moscow usu800 embassy inu800 moscow about whether heu800 planned tou800 communicate with american politicians. cite news urlu800 title russian chess legend anatoly karpov unable tou800 getu800 uu800u82esu800. visa friend says date august 22u800 2019 work reuters access-date august 22u800 2019 language enu800 karpov wasu800 among theu800 russian state duma members placed under sanctions byu800 theu800 euu800 andu800 uku800 during theu800 russo-ukrainian waru800 . cite news urlu800 title u8d0b0u8d0bdu8d0b0u8d182u8d0beu8d0bbu8d0b8u8d0b9 u8d0bau8d0b0u8d180u8d0bfu8d0beu8d0b2 u8d0bfu8d0beu8d0bfu8d0b0u8d0b4u8d0b0u8d0b5u8d182 u8d0bfu8d0beu8d0b4 u8d181u8d0b0u8d0bdu8d0bau8d186u8d0b8u8d0b8 u8d0b5u8d0b2u8d180u8d0beu8d0bfu8d0b5u8d0b9u8d181u8d0bau8d0beu8d0b3u8d0be u8d181u8d0beu8d18eu8d0b7u8d0b0 website chess-newsu82eruu800 date february 23u800 2022 access-date february 23u800 2022 archive-date february 24u800 2022 archive-urlu800 urlu800-status dead cite webu800 title consolidated list ofu800 financial sanctions targets inu800 theu800 uku800 urlu800 access-date 16u800 april 2023 inu800 march 2022 after theu800 start ofu800 theu800 russian invasion ofu800 ukraine theu800 fide council suspended karpov karpov\\'su800 title ofu800 fide ambassador foru800 life. cite webu800 title theu800 official statement ofu800 fide council urlu800 access-date march 3u800 2022 website wwwu800u82efideu82ecomu800 language enu800 inu800 november 2022 karpov wasu800 placed inu800 anu800 induced coma after receiving au800 head injury. cite webu800 date 2022-10u800-31u800 title breaking news anatoly karpov inu800 hospital with fractured skull urlu800 access-date 2022-11u800-02u800 website chess news language enu800 karpov karpov\\'su800 daughter sofia andu800 theu800 russian chess federation said that heu800 hadu800 accidentally fallen. cite webu800 date 2022-10u800-31u800 title conflicting claims asu800 anatoly karpov enters induced coma assault oru800 au800 domestic accident urlu800 access-date 2022-11u800-02u800 website marca language enu800 karpov made au800 full recovery from theu800 injury. cite webu800 urlu800 title karpov isu800 back home date november 18u800 2022 candidate foru800 fide presidency candidate foru800 fide presidency candidate foru800 fide presidency inu800 march 2010 karpov announced that heu800 would beu800 au800 candidate foru800 theu800 presidency ofu800 fide. theu800 election took place inu800 september 2010 atu800 theu800 39th chess olympiad . cite webu800 first peter last doggers urlu800 date march 2u800 2010 title karpov candidate foru800 fide president access-date march 2u800 2010 publisher chess vibes archive-urlu800 archive-date march 5u800 2010 inu800 mayu800 au800 fundraising event took place inu800 newu800 york with theu800 participation ofu800 kasparov andu800 magnus carlsen whou800 both supported hisu800 bidu800 andu800 campaigned foru800 himu800. cite webu800 urlu800 title bigu800 karpov fund-raiser inu800 newu800 york date mayu800 18u800 2010 publisher chessbase access-date march 26u800 2018 nigel short also supported karpov karpov\\'su800 candidacy. onu800 september 29u800 2010 kirsan ilyumzhinov wasu800 reelected asu800 president ofu800 fide 95u800 votes tou800 55u800. cite news urlu800 title kirsan ilyumzhinov wins 2010 fide elections work chessdomu82ecomu800 year 2010 access-date october 11u800 2010 archive-date october 2u800 2010 archive-urlu800 urlu800-status dead style style style karpov karpov\\'su800 \\\" boau800 constrictor \\\" cite news urlu800 title chess ; revengeful karpov presses like au800 cool boau800 constrictor unsuspected strength shown last byrne first robert date september 17u800 1980 work theu800 newu800 york times access-date february 15u800 2021 cite news urlu800 title karpov au800 master ofu800 willpower squeeze play with amu800-world chess last goodman first david date december 19u800 1987 work apu800 news access-date february 15u800 2021 playing style isu800 solidly positional taking minimal risks butu800 reacting mercilessly tou800 theu800 slightest error byu800 hisu800 opponent. asu800 au800 result heu800 isu800 often compared tou800 josu8c3a9 rau8c3bal capablanca theu800 third world champion. cite magazine title keres annotates... twou800 karpov wins magazine chess life & review date january 1973 volume xxviii number 1u800 page 8u800 quote hisu800 general style ofu800 play isu800 rather calm centered onu800 positional considerations andu800 somehow recalling capablanca capablanca\\'su800 attitudes towards theu800 game. karpov himself describes hisu800 style asu800 follows letu800 usu800 sayu800 theu800 game mayu800 beu800 continued inu800 twou800 ways oneu800 ofu800 them isu800 au800 beautiful tactical blow that gives rise tou800 variations that donu800\\'tu800 yield tou800 precise calculations; theu800 other isu800 clear positional pressure that leads tou800 anu800 endgame with microscopic chances ofu800 victory.... iu800 would choose theu800 latter without thinking twice. ifu800 theu800 opponent offers keen play iu800 donu800\\'tu800 object; butu800 inu800 such cases iu800 getu800 less satisfaction even ifu800 iu800 winu800 than from au800 game conducted according tou800 allu800 theu800 rules ofu800 strategy with itsu800 ruthless logic. cite book last1 hooper first1 david author-link1 david vincent hooper last2 whyld first2 kenneth author-link2 kenu800 whyld year 1996 title theu800 oxford companion tou800 chess urlu800 location oxford publisher oxford university press page 192u800 isbn 0192800493 access-date 26u800 september 2016 notable games notable games notable games anu800 chess posu800 secright * viktor korchnoi vsu800. anatoly karpov moscow 1973 karpov sacrifice chess sacrifices au800 pawn foru800 au800 strong center andu800 chessgloss queenside attack. * anatoly karpov vsu800. gyula saxu800 linares 1983 karpov sacrifices foru800 anu800 attack that wins theu800 game 20u800 moves later after another spectacular sacrifice from karpov andu800 counter-sacrifice from saxu800. itu800 wonu800 theu800 tournament tournament\\'su800 first chessgloss brilliancy prize . this wasu800 notu800 theu800 first time karpov used theu800 sharp sicilian defence scheveningen variation#keres attack keres attack 6u800u82eg4u800 u8e28093 seeu800 hisu800 winu800 inu800 anatoly karpov vsu800. vlastimil hort alekhine memorial tournament moscow 1971 . * anatoly karpov vsu800. veselin topalov dosu800 hermanas 1994 this game features au800 sacrifice chess #sham sacrifices sham sacrifice ofu800 twou800 pieces which karpov regains with au800 chessgloss forcing move forcing variation culminating inu800 theu800 winu800 ofu800 anu800 theu800 exchange chess exchange with au800 technically wonu800 endgame. hobbies hobbies hobbies karpov karpov\\'su800 extensive stamp collection ofu800 postage stamps andu800 postal history ofu800 belgium belgian philately andu800 postage stamps andu800 postal history ofu800 theu800 democratic republic ofu800 theu800 congo belgian congo stamps andu800 postal history covering mail from 1742 through 1980 wasu800 sold byu800 david feldman philatelist david feldman feldman\\'su800 auction company between december 2011 cite webu800 urlu800 archive-urlu800 urlu800-status dead archive-date january 2u800 2013 title belgium collection formed byu800 anatoly karpov publisher david feldman year 2011 access-date october 12u800 2011 andu800 2012. heu800 isu800 also known tou800 have large chess stamp andu800 chess book collections. hisu800 private chess library consists ofu800 9u800 000u800 books. cite webu800 urlu800 title anatoly karpov theu800 owner ofu800 theu800 unique stamp collection publisher watch-cloneu82ecomu800 access-date march 28u800 2011 urlu800-status dead archive-urlu800 archive-date february 18u800 2011 honours andu800 awards honours andu800 awards honours andu800 awards * order ofu800 merit foru800 theu800 fatherland 3rdu800 class 2001 u8e28093 foru800 outstanding contribution tou800 theu800 implementation ofu800 charitable programmes theu800 strengthening ofu800 peace andu800 friendship between theu800 peoples * order ofu800 friendship 2011 u8e28093 foru800 hisu800 great contribution tou800 strengthening peace andu800 friendship between peoples andu800 productive social activities * order ofu800 lenin 1981 * order ofu800 theu800 redu800 banner ofu800 labour 1978 * order ofu800 merit ukraine order ofu800 merit 2ndu800 class ukraine november 13u800 2006 u8e28093 foru800 hisu800 contribution tou800 theu800 victims ofu800 theu800 chernobyl disaster * order ofu800 holy prince daniel ofu800 moscow 2ndu800 class 1996 * order ofu800 stu800. sergius ofu800 radonezh 2ndu800 class 2001 * medal \\\"foru800 outstanding contribution tou800 theu800 collector business inu800 russia\\\" * honorary member ofu800 theu800 soviet philately society 1979 * diploma ofu800 theu800 state duma ofu800 theu800 russian federation nou800. 1u800 * order \\\"foru800 outstanding achievements inu800 sport\\\" republic ofu800 cuba * medal ofu800 tsiolkovsky cosmonautics federation ofu800 russia * medal \\\"foru800 strengthening theu800 penal system\\\" 1stu800 andu800 2ndu800 class * breastplate ofu800 theu800 1stu800 degree ofu800 theu800 ministry ofu800 internal affairs russia interior ministry * international association ofu800 chess press 9u800 times voted theu800 best chess player ofu800 theu800 year andu800 awarded theu800 \\\" chess oscar \\\" * order ofu800 saint nestor theu800 chronicler 1stu800 class * asteroid 90414 karpov isu800 named after karpov cite webu800 urlu800 title kasparov u8e28093 karpov valencia 2009 dayu800 3u800 live - chessdom website tournamentsu82echessdomu82ecomu800 access-date march 26u800 2018 * anatoly karpov international chess tournament anu800 annual round-robin tournament held inu800 hisu800 honour inu800 poikovsky khanty-mansi autonomous okrug russia since 2000 cite webu800 urlu800 title background ofu800 theu800 tournament website 3rdu800 karpov international chess tournament access-date august 28u800 2015 archive-date mayu800 17u800 2021 archive-urlu800 urlu800-status dead books books books karpov hasu800 authored oru800 cou800-authored several books most ofu800 which have been translated into english. * karpov au800u82eeu800. ninth vertical. 1978. moscow molodaya gvardia. * cite book last1 karpov first1 anatoly last2 roshal first2 alexander author-link2 alexander roshal title chess isu800 myu800 life publisher pergamon press year 1979 isbn 0u800-0802-3119-5u800 * cite book last karpov first anatoly title theu800 open game inu800 action publisher pavilion books batsford year 1988 isbn 978u800-0713460964 * cite book last karpov first anatoly title theu800 semi-open game inu800 action publisher collier books collier year 1988 isbn 978u800-0020218012 * cite book last karpov first anatoly title theu800 closed openings inu800 action publisher macmillan publishers collier macmillan year 1990 isbn 978u800-0020339854 * cite book last karpov first anatoly title theu800 semi-closed openings inu800 action publisher collier macmillan year 1990 isbn 978u800-0020218050 * cite book last karpov first anatoly year 1990 title karpov onu800 karpov memoirs ofu800 au800 chess world champion publisher liberty publishing isbn 0u800-689u800-12060-5u800 also au800 1992 simon & schuster edition * cite book last karpov first anatoly year 1992 title beating theu800 gru8c3bcnfeld publisher batsford isbn 978u800-0u800-7134-6468-9u800 * cite book last karpov first anatoly title caro-kann defence advance variation andu800 gambit system publisher batsford year 2006 isbn 0u800-7134-9010-1u800 * cite book last karpov first anatoly title myu800 best games publisher edition olms year 2007 isbn 978u800-3u800-2830-1002-7u800 * cite book last1 karpov first1 anatoly last2 henley first2 ronu800 author-link2 ronu800 henley chess player title elista diaries karpovu8e28093kamsky karpovu8e28093anand anand mexico city 2007 world chess championship matches publisher batsford year 2007 isbn 978u800-0u800-923891-97u800-8u800 * cite book last karpov first anatoly title howu800 tou800 play theu800 english opening publisher batsford year 2007 isbn 978u800-0u800-7134-9065-7u800 references references references reflist further reading further reading further reading * reuben fine fine rueben 1983 . theu800 world world\\'su800 great chess games . dover publications dover . isbn 0u800-486u800-24512-8u800 . * hurst sarah 2002 . curse ofu800 kirsan adventures inu800 theu800 chess underworld . russell enterprises. isbn 978u800-1u800-88869-0u800-156u800 . * cite book last1 ku8c3a1rolyi first1 tibor author-link tibor ku8c3a1rolyi chess player last2 aplin first2 nick author-link2 nick aplin title endgame virtuoso anatoly karpov year 2007 publisher newu800 inu800 chess isbn 978u800-90u800-5691-202u800-4u800 * cite book last karolyi first tibor title karpov karpov\\'su800 strategic wins 1u800 theu800 making ofu800 au800 champion 1961u8e280931985 year 2011 publisher quality chess isbn 978u800-1u800-906552-41u800-1u800 * cite book last karolyi first tibor title karpov karpov\\'su800 strategic wins 2u800 theu800 prime years 1986u8e280932009 year 2011 publisher quality chess isbn 978u800-1u800-906552-42u800-8u800 * karpov anatoly 2003 . anatoly karpov karpov\\'su800 best games . anova books batsford . isbn 0u800-7134-7843-8u800 . * cite book last kasparov first garry author-link garry kasparov year 2006 title myu800 great predecessors part vu800 publisher everyman chess isbn 1u800-85744-404u800-3u800 * cite book last markland first peter author-link peter markland title theu800 best ofu800 karpov year 1975 publisher oxford university press isbn 978u800-0u800-19u800-217534-2u800 * edward gu800. winter winter edward gu800. editor 1981 . world chess champions . pergamon press . isbn 0u800-08u800-024094-1u800 . external links external links external links sister project links auto 1u800 * karpov karpov\\'su800 official homepage inu800 lang ruu800 * 365chessu82ecomu800 player anatoly_karpov * chessgames player 20719 * olimpbase player r93brrbf * edward winter chess historian edward winter \\\"books about korchnoi andu800 karpov\\\" chess notes * 25u800 minute video interview with karpov onlinechesslessonsu82enetu800 june 19u800 2012 * \\\"anatoly karpov tells allu800\\\" 2015 interview byu800 sport express translated byu800 chessbase part 1u800 part 2u800 part 3u800 part 4u800 su800-start su800-achu800 awu800 su800-befu800 before bobby fischer su800-ttlu800 title world chess championship world chess champion years 1975u8e280931985 su800-aftu800 after garry kasparov su800-befu800 before garry kasparov su800-ttlu800 title fu8c3a9du8c3a9ration internationale desu800 u8c3a9checs fide world chess championship world chess champion years 1993u8e280931999 su800-aftu800 after alexander khalifman su800-achu800 achu800 su800-befu800 before bobby fischer garry kasparov su800-ttlu800 title list ofu800 fide chess world number ones world nou800. 1u800 years january 1u800 1976 u8e28093 december 31u800 1983 july 1u800 1985 u8e28093 december 31u800 1985 su800-aftu800 after garry kasparov garry kasparov su800-endu800 world chess championships authority control defaultsort karpov anatoly category 1951 births category 20th-century russian male writers category 21st-century russian male writers category chess grandmasters category chess olympiad competitors category communist party ofu800 theu800 soviet union members category sixth convocation members ofu800 theu800 state duma russian federation category seventh convocation members ofu800 theu800 state duma russian federation category eighth convocation members ofu800 theu800 state duma russian federation category honorary members ofu800 theu800 russian academy ofu800 arts category honoured masters ofu800 sport ofu800 theu800 ussr category living people category members ofu800 theu800 civic chamber ofu800 theu800 russian federation category people from zlatoust category recipients ofu800 theu800 order \\\"foru800 merit tou800 theu800 fatherland\\\" 2ndu800 class category recipients ofu800 theu800 order \\\"foru800 merit tou800 theu800 fatherland\\\" 3rdu800 class category recipients ofu800 theu800 order ofu800 holy prince daniel ofu800 moscow category recipients ofu800 theu800 order ofu800 lenin category recipients ofu800 theu800 order ofu800 merit ukraine 2ndu800 class category recipients ofu800 theu800 order ofu800 merit ukraine 3rdu800 class category recipients ofu800 theu800 order ofu800 theu800 redu800 banner ofu800 labour category russian book andu800 manuscript collectors category russian individuals subject tou800 united kingdom sanctions category russian chess players category russian chess writers category russian male journalists category russian philatelists category russian sportsperson-politicians category saint petersburg state university alumni category soviet chess players category soviet chess writers category soviet journalists category soviet male writers category unicef goodwill ambassadors category world chess champions category world junior chess champions ')"

Table schema:

MySQL [media_wiki]> show create table searchindex;
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                                                                                                                                                                                                        |
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| searchindex | CREATE TABLE `searchindex` (
  `si_page` int unsigned NOT NULL,
  `si_title` varchar(255) NOT NULL DEFAULT '',
  `si_text` mediumtext NOT NULL,
  UNIQUE KEY `si_page` (`si_page`),
  FULLTEXT KEY `si_text` (`si_text`),
  FULLTEXT KEY `si_title` (`si_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
@timsehn timsehn added bug Something isn't working sql Issue with SQL integrations Issues with tools connecting to/querying Dolt panic labels Mar 11, 2024
@jycor
Copy link
Contributor

jycor commented Mar 11, 2024

Minimal repro, seems like something is going wrong when one of the tokens in the fulltext index is too long.

create table t (
  i int unsigned,
  t1 varchar(255),
  t2 mediumtext,
  unique key(i),
  fulltext key (t1),
  fulltext key (t2)
);

insert into t values (0, 'abc', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
replace into t values (0, 'abc', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');

There are 90 a's

@timsehn
Copy link
Contributor Author

timsehn commented Mar 11, 2024

This looks like an unchecked internal limit on the size of each token for fulltext indexes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working integrations Issues with tools connecting to/querying Dolt panic sql Issue with SQL
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants