{"id":781,"date":"2008-04-14T11:50:35","date_gmt":"2008-04-14T16:50:35","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-most-favourite-bugfix-in-mysql-5124-rc"},"modified":"2008-04-14T11:51:47","modified_gmt":"2008-04-14T16:51:47","slug":"my-favourite-bugfix-in-mysql-5124-rc","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc","title":{"rendered":"My favourite bugfix in MySQL 5.1.24-rc"},"content":{"rendered":"<p>I&#8217;ve been using MySQL 5.1 a lot more of late. Also, as of about a month ago, I&#8217;m now a Mac OS X user, so tend to use MySQL on OS X Leopard 10.5 a lot more for testing. I&#8217;ve found a rather annoying bug (in 5.1.23-rc) that is fixed in the current source tree, and will be in 5.1.24-rc&#8230;<\/p>\n<p>What&#8217;s annoying me? The fact that Control+R (which allows one to save typing, because you can go through the search history of <tt>~\/.mysql_history<\/tt>) segfaults the MySQL client. At first I thought something was wrong with my install when I saw the infamous &#8220;Segmentation fault&#8221; error. Turns out, its just <a href=\"http:\/\/bugs.mysql.com\/bug.php?id=33288\">mysql#33288<\/a>.<\/p>\n<p>I always hit ctrl+r without even thinking&#8230; Its just a shortcut ingrained in my fingers, because I predominantly use a shell. So, Mac OS X users can rejoice soon, as 5.1.24-rc is surely around the corner. In fact, there are numerous improvements, just read the <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/news-5-1-24.html\">changelog<\/a>.<\/p>\n<p>Technorati Tags: <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/mysql\" rel=\"tag\">mysql<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/mysql%205.1\" rel=\"tag\">mysql 5.1<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/5.1.24-rc\" rel=\"tag\">5.1.24-rc<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/bug\" rel=\"tag\">bug<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/search%20history\" rel=\"tag\">search history<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20My%20favourite%20bugfix%20in%20MySQL%205.1.24-rc&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F14%2Fmy-favourite-bugfix-in-mysql-5124-rc&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"b39d57aff3\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-781\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-781\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-781\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been using MySQL 5.1 a lot more of late. Also, as of about a month ago, I&#8217;m now a Mac OS X user, so tend to use MySQL on OS X Leopard 10.5 a lot more for testing. I&#8217;ve found a rather annoying bug (in 5.1.23-rc) that is fixed in the current source tree, [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20My%20favourite%20bugfix%20in%20MySQL%205.1.24-rc&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F14%2Fmy-favourite-bugfix-in-mysql-5124-rc&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"b39d57aff3\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-781\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-781\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-781\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-cB","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":780,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/compiling-mysql-udfs-on-mac-os-x","url_meta":{"origin":781,"position":0},"title":"Compiling MySQL UDFs on Mac OS X","date":"14\/4\/2008","format":false,"excerpt":"Compiling and installing a User Defined Function for MySQL on Mac OS X seems tricky. There are installation notes, but they seem to be sparse on OS X (the comments are clues, though). I was looking through the tutorial materials for Roland's talk, and came up with what I think\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":666,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/11\/16\/mysql-on-leopard-os-x-105","url_meta":{"origin":781,"position":1},"title":"MySQL on Leopard (OS X 10.5)","date":"16\/11\/2007","format":false,"excerpt":"Use MySQL? On Leopard\/OS X 10.5? Yes, the current available packages from dev.mysql.com don't work very well. I track \"mysql\" on Twitter, and boy, are there heaps of complaints.So its nice to see, Dan Benjamin, a member of the MySQL community, stepping up, and creating the amazing Installing MySQL on\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":855,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/14\/mysql-5126-rc-released-and-developer-resources-thoughts","url_meta":{"origin":781,"position":2},"title":"MySQL 5.1.26-rc released, and developer resources thoughts","date":"14\/7\/2008","format":false,"excerpt":"Good news, MySQL 5.1.26-rc has been released. From the release notes: \"MySQL 5.1.26-rc is slated to be the last release candidate before we declare MySQL 5.1 as \"production ready\" (GA).\" If I were you, I'd start testing it out in environments that you're planning to run MySQL in, or upgrade\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":764,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/06\/mysql-on-leopard-os-x-105-prefpane-fixed","url_meta":{"origin":781,"position":3},"title":"MySQL on Leopard OS X 10.5 PrefPane fixed!","date":"6\/4\/2008","format":false,"excerpt":"A few months ago, I wrote about the issues you will face with installing MySQL on OS X 10.5, Leopard. I am pleased to inform everyone, that this problem has been fixed!The bug in question, mysql#28854, clearly stated that the problem was with the PrefPane. On Valentine's Day 2008, Alfredo\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":927,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/08\/08\/howto-mysql-connectorc-on-mac-os-x","url_meta":{"origin":781,"position":4},"title":"HOWTO: MySQL Connector\/C++ on Mac OS X","date":"8\/8\/2008","format":false,"excerpt":"Excited with the release of the MySQL Connector\/C++, I thought I'd get it going on Mac OS X. You'll first hit the problem that Mac OS X doesn't come with CMake. So you'll have to download it from the site - there's a warning there that the .dmg installer only\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2743,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/06\/11\/homebrew-mac-os-x-and-mariadb-10-0-series","url_meta":{"origin":781,"position":5},"title":"Homebrew (Mac OS X) and MariaDB 10.0 series","date":"11\/6\/2013","format":false,"excerpt":"Today I performed a brew update. I noticed that MariaDB now exists as stable (5.5.30) and devel (10.0.2). Brew formulas also exist for MySQL (5.6.10) and Percona Server (5.5.30-30.2) now. 10.0.3 is around the corner but I wanted to run 10.0.2 now. This is how I did it: brew unlink\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/781"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=781"}],"version-history":[{"count":0,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/781\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}