{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11626","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11626/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11626/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11626/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11626","id":114307522,"number":11626,"title":"wrong row count for query results","user":{"login":"karlra","id":14310157,"avatar_url":"https://avatars.githubusercontent.com/u/14310157?v=3","gravatar_id":"","url":"https://api.github.com/users/karlra","html_url":"https://github.com/karlra","followers_url":"https://api.github.com/users/karlra/followers","following_url":"https://api.github.com/users/karlra/following{/other_user}","gists_url":"https://api.github.com/users/karlra/gists{/gist_id}","starred_url":"https://api.github.com/users/karlra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlra/subscriptions","organizations_url":"https://api.github.com/users/karlra/orgs","repos_url":"https://api.github.com/users/karlra/repos","events_url":"https://api.github.com/users/karlra/events{/privacy}","received_events_url":"https://api.github.com/users/karlra/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-30T16:39:07Z","updated_at":"2015-10-31T16:10:08Z","closed_at":null,"body":"Queries with subqueries seem to give incorrect row counts. I'm not talking about the InnoDB concept of inaccurate row counts for tables but for query results.\r\n\r\nFor example, phpmyadmin thinks that the below query returns 20.000 rows but the real number is below 1.500, as verified in the MySQL console. This is on phpMyAdmin version 4.5.1.\r\n\r\n\r\nselect eOuter.userid from subscriptions eOuter\r\ninner join \r\n(\r\n\tselect userid, max(canceldate) as m from subscriptions where istrial = 1 and canceldate is not null group by userid\r\n)\r\neInner on eOuter.userid = eInner.userid and eOuter.subscriptiondate > eInner.m and eOuter.istrial = 0\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/152746198","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11626#issuecomment-152746198","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11626","id":152746198,"user":{"login":"lem9","id":195509,"avatar_url":"https://avatars.githubusercontent.com/u/195509?v=3","gravatar_id":"","url":"https://api.github.com/users/lem9","html_url":"https://github.com/lem9","followers_url":"https://api.github.com/users/lem9/followers","following_url":"https://api.github.com/users/lem9/following{/other_user}","gists_url":"https://api.github.com/users/lem9/gists{/gist_id}","starred_url":"https://api.github.com/users/lem9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lem9/subscriptions","organizations_url":"https://api.github.com/users/lem9/orgs","repos_url":"https://api.github.com/users/lem9/repos","events_url":"https://api.github.com/users/lem9/events{/privacy}","received_events_url":"https://api.github.com/users/lem9/received_events","type":"User","site_admin":false},"created_at":"2015-10-31T16:10:08Z","updated_at":"2015-10-31T16:10:08Z","body":"Thanks for the excellent test case. This worked fine in 4.4.15. Tried to bisect the problem but it's difficult as there are intermediate errors during the bisect. I suspect the new parser."}}