Searching Paginated Data

[kigathi-chege]

Describe the bug
My table contains 493 rows, with a limit of 50 rows per result. The problem is, when I search within a column, vscode-sqltools only searches within the 50 returned records, not within the 493 records that make up the table.

To Reproduce
Steps to reproduce the behavior:

1. Go to SQLTools sidebar menu.
2. Select your connection and your database.
3. Choose a table with more than 50 records, or more than the SQLTools Result Limit you have set.
4. Click on 'Show Table Records'
5. In the results page, each column has a 'Filter' search input, type the text to search here, ensure that the text you type is valid and that a record matching that query exists, and that the record is not within the limit (is in another page).
6. See error

Expected behavior
I expect to search within a column and see a true result for the entire table. For example, user id 493 is called "Jason", but when I am on the first page and search "Jason", that user does not appear in the result. I expect that when I search, that user should be found.

Screenshots

• Before searching (Page 1)
  
• After searching (Page 1)
  
• After navigating to Page 9
  

Desktop (please complete the following information):

• SQLTools Version: v0.28.1
• VS Code Version: 1.84.2
• OS: Linux
• Driver:
  • MySQL/MariaDB
• Database version: mysql Ver 8.0.35-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))