Bug #94393 In shell, when MySQL errors occur, the pager shows up empty
Submitted: 19 Feb 14:00 Modified: 26 Feb 11:52
Reporter: Kristian Hole Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Shell General / Core Client Severity:S3 (Non-critical)
Version:8.0.15 OS:Ubuntu
Assigned to: CPU Architecture:x86 (x86_64)
Tags: error, pager, shell

[19 Feb 14:00] Kristian Hole
Description:
In MySQL shell when using a pager, such as "less", MySQL errors are hidden by the pager displaying an empty page. When quitting the pager the error message becomes visible.

How to repeat:
1. Open connection to MySQL instance using MySQL shell in SQL mode:
    mysqlsh --uri root@localhost --port 13000 --sql
2. Execute a query targeting a table (without selecting a database)
    SELECT * FROM P;
3. Empty pager pops up, and error can be seen only by quitting the pager.

Suggested fix:
- Either display the error message in the pager itself
- or don't invoke the pager at all, and simply display the error like it's done now.
[26 Feb 11:52] Bogdan Kecman
Hi,
Thanks for the report. Verified as described.

all best
Bogdan