MySQL Bugs: #36655: Array index is out of range

Bug #36655	Array index is out of range
Submitted:	12 May 2008 1:38	Modified:	20 Aug 2009 10:18
Reporter:	Reiner Rodriguez	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:		OS:	Linux (UBuntu)
Assigned to:		CPU Architecture:	Any
Tags:	Array index is out of range

Description:
I use a code like this in windows ...it work ok...but when I go to linux ubuntu 
it fail and I get the error Array index is out of range.. 
I put the select in Mysql Query Browser and it work very well (linux and Windows) 

 string sqlstr = "SELECT.. ..... very large...... 
 MySqlConnection cnn = new MySqlConnection(strcnn);

 MySqlDataAdapter da = new MySqlDataAdapter(sqlstr, cnn);

 DataSet ds = new DataSet();

 da.Fill(ds);

******  At this poitn I get the error Array index is out of range. 

When I try tu use a very large select...big select, many table join... I get then error  Array index is out of range. But if a use a simple select it work ok.

Thank for your help 
Reiner

How to repeat:
In linux ubuntu 

Use a code like this ....remenber very large SELECT 

 string sqlstr = "SELECT.. ..... very large...... 
 MySqlConnection cnn = new MySqlConnection(strcnn);
 MySqlDataAdapter da = new MySqlDataAdapter(sqlstr, cnn);
 DataSet ds = new DataSet();
 da.Fill(ds);

Reiner and Tonci,
I having the same problem, but found that it can be a "duplicate field" exception catched and throw as "not the right" exception.

My issue was very similar to:
=============================================
select 
        TblEmployee.Name as X, 
        TblEmployee.Surname as X 
from 
        TblEmployee
=============================================
and very difficult to recognize because the size of the query (really big).

I have found the right exception when trying to copy the big query as a new view in the database. 
The GUI interface throw the right exception: duplicate field.

Hope this can help.
Aldo.

Reiner, Aldo, anyone willing to attach complete test case demonstrating this error? Along with DDL/DML statements used to reproduce.

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".