TablePro MySQL Query Sorting Exception Issue Submission Template

[duanbaihong]

What happened?

Steps to reproduce

• MySQL Server Version: ____ 8.0.36_____ (e.g., 8.0.36, 5.7.44)
• MySQL Connection Method: Local / Remote / SSH Tunnel
• Client Operating System: Windows / MacOS / Linux (specify version if possible, e.g., Windows 11, MacOS Sonoma 14.5)
• Database Engine: InnoDB / MyISAM / Other
• Table Data Volume: __________ (e.g., 100+ rows, 10,000+ rows, 1M+ rows)
• TablePro Connection Configuration: Default / Custom (e.g., custom timeout, character set)
  II. Issue Description
  Phenomenon

1. Successfully connect to MySQL database via TablePro without any connection errors or warnings.
2. Execute SQL queries without ORDER BY clause, and the full matched data is returned normally in the result table.
3. Add only the ORDER BY field [ASC/DESC] clause to the same query statement, and execute it— the result area is blank, with no data returned at all.
4. No obvious error prompts, syntax exceptions, or warning messages are displayed in TablePro's console, execution log, or pop-up windows; the only abnormal situation is an empty result set.
   Expected Behavior
   SQL statements with ORDER BY clause should sort the matched data according to the specified field(s) and return the complete result set normally, consistent with the execution result in other MySQL clients.
   III. Reproduction Steps
5. Create a new MySQL data source in TablePro, fill in the database address, username, password, and database name, then complete the connection test successfully.
6. Enter a basic query SQL statement (without sorting) and execute it— data is displayed normally:
   -- Example of normal SQL (without ORDER BY)
   SELECT * FROM test_table WHERE create_time >= '2026-01-01';
7. Add the ORDER BY clause to the end of the above SQL statement:
   -- SQL with ORDER BY (no data returned)
   SELECT * FROM test_table WHERE create_time >= '2026-01-01' ORDER BY id DESC;
8. Click the "Execute" button— the table area in TablePro is blank, and no query results are displayed.
   IV. Supplementary Test Information (for Troubleshooting)
9. Does the same SQL with ORDER BY clause execute normally in other MySQL clients (Navicat/DBeaver/MySQL Command Line)? □ Normal □ Abnormal
10. Data type of the sorted field: Int / Varchar / Datetime / Decimal / Other (specify)
11. Is pagination enabled in TablePro? □ Yes □ No (if yes, specify the page size)
12. Is sorting done using column aliases? □ Yes □ No (provide the SQL with alias if yes)
13. Sort type: Single-field sorting / Multi-field combined sorting (provide the combined sorting SQL if applicable)
14. Is there a LIMIT clause in the query? □ Yes □ No (specify the LIMIT value if yes)
15. Have you tried sorting with different fields (e.g., primary key, non-primary key)? □ Yes (describe the result) □ No
    V. Logs / Error Information
    Paste all logs from TablePro's bottom console, pop-up windows, or network request returns when executing the problematic SQL (if any):

Paste log content here (e.g., execution logs, error traces, network response)

Example:

2026-07-16 14:30:00 - Execute SQL: SELECT * FROM test_table WHERE create_time >= '2026-01-01' ORDER BY id DESC;

2026-07-16 14:30:01 - Execution completed, 0 rows returned.

VI. Temporary Workarounds (if any)

1. Remove the ORDER BY clause from the query— data can be returned normally, but sorting is not available.
2. Other feasible temporary solutions (e.g., use other clients for sorted queries, export data and sort locally): __________
   VII. Additional Screenshots
   Please attach the following screenshots to help locate the issue:
3. Screenshot of normal query results (without ORDER BY clause)
4. Screenshot of blank results (with ORDER BY clause)
5. Screenshot of the SQL statement entered in TablePro
6. Screenshot of TablePro's connection configuration (if applicable)
   VIII. Additional Notes
   Add any other information that may help troubleshoot the issue (e.g., recent changes to the database, TablePro update history, special table structure): __________

Expected behavior

No response

Database type

MySQL / MariaDB

TablePro version

0.57.1

macOS version & chip

No response

Screenshots / Logs

No response