Bug #116485 Index was out of range. Must be non-negative and less than the size ...
Submitted: 27 Oct 15:29 Modified: 28 Oct 4:59
Reporter: Mark Switzer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.7 OS:Windows
Assigned to: CPU Architecture:x86

[27 Oct 15:29] Mark Switzer 
Description:
When running a view, I encounter this Index error.   Here is the view definition.

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `rec3` AS
    SELECT 
        YEARWEEK(`t1`.`Signal_Date`, 0) AS `Yearweek`,
        `t1`.`idPortfolio` AS `PortId`,
        `t1`.`Rank` AS `Rank`,
        `t1`.`CSI_ID` AS `CSI_ID`,
        `t2`.`IndustryDescription` AS `IndustryDescription`,
        `t3`.`SectorDescription` AS `SectorDescription`
    FROM
        (((`portfolio` `t1`
        JOIN `equity` `t4` ON ((`t1`.`CSI_ID` = `t4`.`CSI_ID`)))
        JOIN `industry` `t2` ON ((`t4`.`industry_idIndustry` = `t2`.`idIndustry`)))
        JOIN `sector` `t3` ON ((`t4`.`industry_idSector` = `t3`.`idSector`)))
    WHERE
        ((`t1`.`Signal_Date` = (SELECT 
                MAX(`portfolio`.`Signal_Date`)
            FROM
                `portfolio`))
            AND (`t1`.`Rank` < 61))

How to repeat:
It happens everytime.
[28 Oct 4:59] MySQL Verification Team 
Hello Mark Switzer,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #97444, please see Bug #97444	.

If you think your issue is different than Bug #97444	 then I request you to - To investigate further this issue at our end, may I kindly request you
to launch workbench under debug mode (--log-level=debug3) and provide
unaltered workbench log file(more details about log are explained here
-
https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)?

regards,
Umesh