MySQL Bugs: #92849: MySQL Shell not displaying large results (more than 20 rows) correctly

Bug #92849	MySQL Shell not displaying large results (more than 20 rows) correctly
Submitted:	18 Oct 2018 18:37	Modified:	22 Oct 2018 18:15
Reporter:	David Langston	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Shell General / Core Client	Severity:	S2 (Serious)
Version:	8.0.12	OS:	Windows (win 10)
Assigned to:		CPU Architecture:	Any

Description:
MySQL Shell:
whenever I try to execute a select with result set more than 20 rows it won't display past 20 and anytime after that it displays nothing. if I close the shell reopen it works until I hit 20+ rows again

How to repeat:
1.start MySQL shell, connect and use the world sample schema
2.select name from city;

3. all rows don't display

Thank you for the bug report. You could attach a screenshot using here the Files tab using the private option if you wish.

screen shot

Attachment: bug.JPG (image/jpeg, text), 90.73 KiB.

I uploaded a screen shot. thx

Running on Laptop - issue repeatable

Attachment: 92849.png (image/png, text), 47.66 KiB.

Running on Desktop - issue non repeatable

Attachment: 92849_2.png (image/png, text), 39.28 KiB.

Thank you for the feedback. I was able to repeat the issue on laptop machine with Windows 10 Pro and not able to repeat when testing on Desktop machine running Windows 10 Pro too. So looks the issue is hardware related.

screen shot dell xps

Attachment: dell_xps.JPG (image/jpeg, text), 38.82 KiB.

That's strange. I have fairly new dell xps

what do you suggest? thx

I tried the MySQL command line and it works fine on the same laptop where the shell does not. I will try the shell on my Microsoft surface tonight and see if the shell works correctly. thx!

I don't have any guess of that behavior, the machine where I wasn't able to repeat is a DELL XPS 8700 :) and the laptop an LG:
C:\DBS>wmic computersystem get model,name,manufacturer,systemtype
Manufacturer    Model            Name  SystemType
LG Electronics  15Z970-E.BH91P1  URAL  x64-based PC
So the bug is verified and let us our development to analyze the issue.

hello

just fyi, I downloaded MySQL shell to my Microsoft Surface and it had the same issue of not displaying all rows of data. Looks like it's just not Dell XPS.

thanks
David

Posted by developer:
 
Thank you for your bug report. This issue is already fixed with BUG#28596692 and will be shipped with next MySQL Shell release.

Issue is related to Windows Console, and how it interprets unicode characters encoded in UTF-8 when program print such character byte by byte.
As a workaround you can redirect your output to file.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

FYI, new MySQL Shell version is available https://dev.mysql.com/downloads/shell/
Please upgrade to 8.0.13.

I just confirmed this as fixed. Thank you!