Bug #62096 Index was outside the bounds of the array
Submitted: 5 Aug 2011 15:33 Modified: 5 Sep 2011 15:36
Reporter: David Dews Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.33 OS:Windows
Assigned to: CPU Architecture:Any

[5 Aug 2011 15:33] David Dews
Description:
I had previously created a .qbquery file containing a number of queries including the one below.
 
I copied the following line from an SQL File 1 Tab (containing the .qbquery file) to a Query 1 Tab:

SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='product' ORDER BY COLUMN_NAME;

And pressed the Execute button.

The query worked but, before it did, the "Index was outside the bounds of the array" error was thrown and MySQLWorkbench asked me to fill out this bug report.

The query fetched 208 records. Duration 0.078 secs, fetched in 0.000 sec

How to repeat:
Create a set of randowm queries containing the above query, save the queries into a .qbquery file, copy this file into a script tab, copy one of the lines into an execute tab by dragging the cursor across one of the lines and using Cntrl-C, then paste using Cntrl-V. Then hit the execute button.  

Suggested fix:
Look at pasteing SQL selections from one tab into another ???
[5 Aug 2011 15:35] David Dews
Version 5.2.33 CE revision 7508 on Win7. 64-bit architecture but using a 32 bit version of Win7, 32 bit version of Java and 32-bit version of everything else.
[5 Aug 2011 15:36] Valeriy Kravchuk
What exact version of MySQL Workbench, 5.x.y, do you use? Check Help > About menu item if in doubts.
[5 Aug 2011 15:39] Valeriy Kravchuk
Then, please, check if the same problem still happens with a newer version, 5.2.34.2.
[5 Sep 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".