Bug #61779 Unexpected problem makes Workbench close
Submitted: 6 Jul 2011 21:44 Modified: 7 Aug 2011 3:13
Reporter: Vicente Camarillo Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.x OS:Windows
Assigned to: CPU Architecture:Any
Tags: join, query

[6 Jul 2011 21:44] Vicente Camarillo
Description:
Workbench reports something like "the index is out of range: it must be non-negative and inside the range" (the error text gets lost when closing the window.

How to repeat:
Create a new view out of the following query:

SELECT * from sat1 LEFT JOIN (sat2, sat3, sat4)
ON  (sat2.s2_timestamp = sat1.s1_timestamp AND sat3.s3_timestamp = sat1.s1_timestamp AND sat4.s4_timestamp = sat1.s1_timestamp)
WHERE
    sat1.s1_timestamp BETWEEN '2011-06-19 00:00:00' AND '2011-06-26 00:00:00'
    ORDER BY sat1.s1_timestamp

This should yield a resultset of about 20k rows.
[7 Jul 2011 3:13] MySQL Verification Team
If you are able to get a back trace please see if it is similar of the bug: http://bugs.mysql.com/bug.php?id=61279. Thanks in advance.
[7 Aug 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".