MySQL Bugs: #96604: import Data from MySQL ist limited to 100 rows

Bug #96604	import Data from MySQL ist limited to 100 rows
Submitted:	21 Aug 2019 15:32	Modified:	7 Nov 2019 5:45
Reporter:	Hans-Georg Rutz	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.8	OS:	Windows (Windows 10)
Assigned to:		CPU Architecture:	Any (Excel 2016)
Tags:	Excel, import data, limit search results, max 100 rows, windows

Description:
History: The installation of the "MySQL for Excel" Add-on with MYSQL Installer succeeded without any problems or comments. Connection to MySQL database with valid credentials works fine. After selecting a table and clicking the "Import MySQL Data" command, the "Import Data from MySQL" window opened, as expected.

Than I wanted to import 10'000 rows, beginning with row 700'000, using the "Limit" options. The entry "Limit: 10'000" was reset to 100. "100" ist the maximum of previewed rows, set in the "Advanced options" dialog -> "Use the first X rows to preview".

The tablesize, displayed as the "Row Count" value over the record preview frame, is 100, not approx. 754'000 as expected (in my example).

How to repeat:
Open a database connection and open the "Import Data from MySQL" window. Than set a number into the "Limit" field greater than 100. 

Change the value for "rows to preview" in the Advanced options to something unusual, e.g. 55. The "Row Count" value has changed to 55. Also the value "Limit:" has change to 55. 

It looks like the "Limit Y rows" value is linked, or identical to the "Use the first X rows" value.

Indeed, after pressing the import button, I only get the first 55 rows of the table. 

Suggested fix:
I suggest to check the variable names and/or the field names for the "Use the first X rows" value and the "Limit Y rows and Start with Row Z" values.

Postscriptum: The problem is a new bug with"MySQL for Excel" Add-On Version 1.3.8. There was no problem with the predecessor Version 1.3.7 in the same envirment (Windows 10, Excel 2016 etc.)

Hello Hans-Georg Rutz,

Thank you for the bug report.
verified as described.

Regards,
Ashwini Patil

1.3.8 test results

Attachment: 96604_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 255.86 KiB.

Product under sustaining support