phpmyadmin / phpmyadmin/phpmyadmin
Paging issue with Stored Procedure Results
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
Describe the bug
When a large number of rows are returned from a Stored Procedure, they are not paged correctly, and all are displayed at once.
To Reproduce
Steps to reproduce the behavior:
- create a stored procedure which selects multiple rows
- In the SQL tab, run call
- Scroll down to result
- See that the results are not paged correctly
Expected behavior
The paging rate would apply to the Stored Procedure Results as well.
Screenshots
Image says 'Showing rows 0-24' but all 300 rows are returned in this page.
Server configuration
Currently on PhpMyAdmin Demo Site
- phpMyAdmin version: 5.2.0
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the issue in the SQL tab on the phpMyAdmin demo site with a stored procedure that returns many rows, then trace how its result set is rendered and paginated. Done means a result showing rows 0-24 displays only that page and subsequent pages contain the remaining rows.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- databases, web-dev
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100