{"action":"created","issue":{"url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/35","labels_url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/35/comments","events_url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/35/events","html_url":"https://github.com/perl5-dbi/DBD-mysql/pull/35","id":60346002,"number":35,"title":"Determine order for the selection to ensure the correct row is returned","user":{"login":"Scimon","id":81134,"avatar_url":"https://avatars.githubusercontent.com/u/81134?v=3","gravatar_id":"","url":"https://api.github.com/users/Scimon","html_url":"https://github.com/Scimon","followers_url":"https://api.github.com/users/Scimon/followers","following_url":"https://api.github.com/users/Scimon/following{/other_user}","gists_url":"https://api.github.com/users/Scimon/gists{/gist_id}","starred_url":"https://api.github.com/users/Scimon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Scimon/subscriptions","organizations_url":"https://api.github.com/users/Scimon/orgs","repos_url":"https://api.github.com/users/Scimon/repos","events_url":"https://api.github.com/users/Scimon/events{/privacy}","received_events_url":"https://api.github.com/users/Scimon/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-09T13:55:22Z","updated_at":"2015-03-10T09:04:16Z","closed_at":"2015-03-09T15:04:21Z","pull_request":{"url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/pulls/35","html_url":"https://github.com/perl5-dbi/DBD-mysql/pull/35","diff_url":"https://github.com/perl5-dbi/DBD-mysql/pull/35.diff","patch_url":"https://github.com/perl5-dbi/DBD-mysql/pull/35.patch"},"body":"We've found this test is failing during our build process as the SELECT is returning the row with id_binary_test == 2.\r\nI wasn't sure if this was intentional though from reading the bug request it didn't seem to be. By adding an ORDER BY clause the id == 1 row is always returned first allowing the test to perform normally."},"comment":{"url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/comments/78017051","html_url":"https://github.com/perl5-dbi/DBD-mysql/pull/35#issuecomment-78017051","issue_url":"https://api.github.com/repos/perl5-dbi/DBD-mysql/issues/35","id":78017051,"user":{"login":"Scimon","id":81134,"avatar_url":"https://avatars.githubusercontent.com/u/81134?v=3","gravatar_id":"","url":"https://api.github.com/users/Scimon","html_url":"https://github.com/Scimon","followers_url":"https://api.github.com/users/Scimon/followers","following_url":"https://api.github.com/users/Scimon/following{/other_user}","gists_url":"https://api.github.com/users/Scimon/gists{/gist_id}","starred_url":"https://api.github.com/users/Scimon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Scimon/subscriptions","organizations_url":"https://api.github.com/users/Scimon/orgs","repos_url":"https://api.github.com/users/Scimon/repos","events_url":"https://api.github.com/users/Scimon/events{/privacy}","received_events_url":"https://api.github.com/users/Scimon/received_events","type":"User","site_admin":false},"created_at":"2015-03-10T09:04:16Z","updated_at":"2015-03-10T09:04:16Z","body":"It's 5.1.73-0ubuntu0.10.04.1 on the server and Ver 14.14 Distrib 5.1.73 on the client. (Updating the the 14.04 LTS is on the roadmap) mysql_config is also showing 5.1.73. "}}