Bug #92753 Query take too long and get index out of range error
Submitted: 11 Oct 2018 17:26 Modified: 11 Nov 2018 23:18
Reporter: Xiaodi Zhu Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[11 Oct 2018 17:26] Xiaodi Zhu
I try to run an alter table query on a a table with 700K rows, 5 columns, and a primary key column, using "ALTER TABLE xx ADD COLUMN (x INT);", which is a pretty simple task. 

It takes minutes and the "mysql workbench unexpected error" window pop-up. 

It shows "Index was out of range. Must be non-negative and less than the size of collection" and "Parameter name: index". 

I doubt whether it is because the query takes too long, longer than the limitation of query execution. However, since it is not a huge table, I did expect the execution time to be such long. I am not sure whether it is workbench issue or mysql server issue. 

How to repeat:
Run the query again.
[11 Oct 2018 23:18] Miguel Solorzano
Thank you for the bug report. Please provide the dump file ziped (use Files tab for and private if you wish) with create table and insert statements.
[12 Nov 2018 1: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".