Bug #96339 MySQL Workbench Unexpected Error on simple query: Index was out of range
Submitted: 26 Jul 2019 9:56 Modified: 27 Jul 2019 17:01
Reporter: Martin Snowden Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.4 OS:Windows (Windows 10 Home)
Assigned to: CPU Architecture:x86 (Intel Core i7)
Tags: Index out of range, workbench

[26 Jul 2019 9:56] Martin Snowden
Description:
Performing a simple query on a large table in MySQL Workbench:

SELECT * FROM openpayments.`physician general payees` where `Certified CME Faculty or Speaker Payments` is not null;

After a long wait (several minutes), a pop up error message window appeared: 

Title: MySQL Workbench unexpected error.

Body: MySQL Workbench has encountered a problem
Index was out of range. Must be non-negative and less than the size of the collection.

We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below. 

Please make sure to include a detailed description of your actions that lead to this problem.

How to repeat:
Repeat query.

Suggested fix:
Don't know.
[26 Jul 2019 13:52] MySQL Verification Team
Thank you for the bug report. Which are exactly version of WorkBench and server are you using?.
[27 Jul 2019 16:40] Martin Snowden
Versions:

MySQL Workbench Community (GPL) for Windows: version 6.3.4  revision 0 build 828 (64 bit)

MySQL Community Server (GPL): version 5.7.8-rc-log
Compiled For: Win64 (x86_64)
[27 Jul 2019 16:42] Martin Snowden
Added Workbench version (6.3.4)
[27 Jul 2019 17:01] MySQL Verification Team
Thank you for the feedback. Both are quite older, current version of WorkBench: 8.0.17 current version of server: 5.7.27. Please upgrade.