I can reproduce it right now in trunk, TESTING and STABLE demo servers of phpmyadmin. Go to MySQL > information_schema > COLUMNS, and input in the SQL this one:
SELECT *
FROM `COLUMNS`
WHERE `COLUMN_NAME` > 'a'
You get "showing registers 0 - 29 ( 30 total" and in trunk there is also no data below until I press Refresh (Actualizar in spanish), but I think that may be a different issue.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is caused by 4a50055d52cb1d6ba125b743b0eb422d5549b9c9, however I fail to see how it can break it right now.
Fixed in QA_2_11, QA_3_3 and master.
I guess that we should aim for a quick 2.11.11.
Same would apply to 3.3.7. Not sure if this is so big issue that we should hurry these releases.
I cannot reproduce this in 3.3.6.
3.3.6 behaves slightly differently in this case, it shows "Showing rows 0 - 29 (30 total)" no matter how many results did the original query had.
3.3.6 is ok according to my tests.
What results do you get for following query?
SELECT *
FROM `mysql`.`help_relation`
WHERE `help_topic_id` >10
In MAINT_3_3_6, I get: Showing rows 0 - 29 (30 total)
In QA_3_3 (where the fix is commited) I get: Showing rows 0 - 29 (809 total)
I get the same results as you. For another of my tables it ran fine, I don't know why.
In conclusion we should release 2.11.11 at the same time that we release 3.3.7 ?
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
I can reproduce it right now in trunk, TESTING and STABLE demo servers of phpmyadmin. Go to MySQL > information_schema > COLUMNS, and input in the SQL this one:
SELECT *
FROM `COLUMNS`
WHERE `COLUMN_NAME` > 'a'
You get "showing registers 0 - 29 ( 30 total" and in trunk there is also no data below until I press Refresh (Actualizar in spanish), but I think that may be a different issue.
I'd rather wait some a little more to see if these security fixes did not cause something as well. This does not sound like critical issue.