MySQL Bugs: #116485: Index was out of range. Must be non-negative and less than the size ...

Bug #116485	Index was out of range. Must be non-negative and less than the size ...
Submitted:	27 Oct 2024 15:29	Modified:	28 Oct 2024 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

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.

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