{"id":801,"date":"2007-03-12T05:58:27","date_gmt":"2007-03-11T19:58:27","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/03\/12\/irritation-of-the-day\/"},"modified":"2009-02-21T13:50:50","modified_gmt":"2009-02-21T03:50:50","slug":"irritation-of-the-day","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/03\/12\/irritation-of-the-day\/","title":{"rendered":"irritation of the day&#8230;."},"content":{"rendered":"<p>There&#8217;s a lot of things about the MySQL bug tracking system i like&#8230; but there&#8217;s a few things that annoy the heck out of me.<\/p>\n<p>Today it&#8217;s the fact that if you put a term in the &#8220;with any of the words&#8221; field on advanced search that&#8217;s an number (e.g. &#8216;839&#8217; as you&#8217;re looking for bugs that talk about error 839) you get taken to bug numebr 839. Funnily enough, this has nothing to do with an NDB problem I&#8217;m trying to see the status of. grr&#8230;<\/p>\n<p>and now, back to your regular programming&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There&#8217;s a lot of things about the MySQL bug tracking system i like&#8230; but there&#8217;s a few things that annoy the heck out of me. Today it&#8217;s the fact that if you put a term in the &#8220;with any of &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2007\/03\/12\/irritation-of-the-day\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[85,628],"class_list":["post-801","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-bug","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-cV","jetpack-related-posts":[{"id":2313,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/03\/03\/undocumented-alter-table-that-does-nothing\/","url_meta":{"origin":801,"position":0},"title":"Undocumented ALTER TABLE that does *nothing* (useful)","author":"Stewart Smith","date":"2011-03-03","format":false,"excerpt":"(at least since MySQL 5.1.42) alter table t1 force; Pretty neat huh? In fact, in Drizzle this will end up doing a copying alter table. Not useful. There's an over four year old bug report in MySQL (Bug#24091). I'm just going to remove that bit from the parser in Drizzle\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4035,"url":"https:\/\/www.flamingspork.com\/blog\/2016\/02\/26\/mysql-contributions-status\/","url_meta":{"origin":801,"position":1},"title":"MySQL Contributions status","author":"Stewart Smith","date":"2016-02-26","format":false,"excerpt":"This post is an update to the status of various MySQL bugs (some with patches) that I've filed over the past couple of years (or that people around me have). I'm not looking at POWER specific ones, as there are these too, but each of these bugs here deal with\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3752,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/06\/03\/mysql-5-6-on-power-patch-available\/","url_meta":{"origin":801,"position":2},"title":"MySQL 5.6 on POWER (patch available)","author":"Stewart Smith","date":"2014-06-03","format":false,"excerpt":"The following sentence is brought to you by IBM Legal. The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. Okay, now that is out of the way.... If you're the kind of person who follows the MySQL bugs database closely or subscribes\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2101,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/08\/05\/update-on-a-tale-of-a-bug\/","url_meta":{"origin":801,"position":3},"title":"Update on &#8220;A Tale Of a Bug&#8221;","author":"Stewart Smith","date":"2010-08-05","format":false,"excerpt":"The bug I talked about a little while ago has now also had the fix I wrote committed to the mysql-trunk 5.5.6-m3 repository.","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":720,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/06\/30\/mysql-bug-deskbar-plugin\/","url_meta":{"origin":801,"position":4},"title":"MySQL Bug Deskbar plugin","author":"Stewart Smith","date":"2006-06-30","format":false,"excerpt":"Over at my junkcode section, I have mysqlbug.py which is a plugin for the GNOME deskbar panel applet. If you've used Quicksilver on MacOSX, then you know the kind of app that Deskbar Applet is. This one lets you type \"bug 1234\" and be given the action of \"open mysql\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2418,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/11\/21\/information-on-bug12704861-which-doesnt-exist-in-any-public-bug-tracker\/","url_meta":{"origin":801,"position":5},"title":"Information on Bug#12704861 (which doesn&#8217;t exist in any public bug tracker)","author":"Stewart Smith","date":"2011-11-21","format":false,"excerpt":"Some of you may be aware that MySQL is increasingly using an Oracle-internal bug tracker. You can see these large bug numbers mentioned alongside smaller public bug numbers in recent MySQL release notes. If you're particularly unlucky, you \u00c2\u00a0just get a big Oracle-internal bug number. For a recently fixed bug,\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=801"}],"version-history":[{"count":2,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/801\/revisions"}],"predecessor-version":[{"id":1519,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/801\/revisions\/1519"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}