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:
Go to SQLTools sidebar menu.
Select your connection and your database.
Choose a table with more than 50 records, or more than the SQLTools Result Limit you have set.
Click on 'Show Table Records'
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).
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))
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:
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
Desktop (please complete the following information):