Bug #64182 Index was outside the bounds of the array

• Submitted: 31 Jan 2012 15:45
• Modified: 1 Mar 2012 5:13
• Reporter: Bernie Mamorbor
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.33 CE Revision 7508
• OS: Linux
• CPU Architecture: Any

[31 Jan 2012 15:45] Bernie Mamorbor

Description:
I was excuting this query 

SELECT
`SCC_TWITTER_OUTPUT_MESSAGE`.`STATUS_ID`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PROFILE_ID`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PROFILE_NM`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PROFILE_DESC`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`TWITTER_SCREEN_NM`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`LOCATION_TXT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PERSONAL_URL`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PROFILE_IMAGE_URL`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`PROTECTED_FLG`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`FOLLOWERS_CNT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`FOLLOWING_CNT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`LISTED_CNT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`STATUSES_CNT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`VERIFIED_FLG`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`INFLUENCE_SCORE`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`SENTIMENT_SCORE`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`SENTIMENT_RULE_CD`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`INITIAL_MESSAGE_TYPE_CD`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`ACTUAL_MESSAGE_TXT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`CHANNEL_IDENTIFIER_TYPE_CD`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`LANGUAGE_PREFERENCE_CD`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`UTC_OFFSET_VAL`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`TIME_ZONE_NM`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`CONVERSATION_UTC_DT`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`CONVERSATION_UTC_DTTM`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`SENDERS_LOCAL_DTTM`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`TWITTER_THIRD_PARTY_APP_URL`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`GEORSS_POINT_VAL`,
`SCC_TWITTER_OUTPUT_MESSAGE`.`SEQUENCE_NO`
FROM `scc`.`SCC_TWITTER_OUTPUT_MESSAGE` order by `SCC_TWITTER_OUTPUT_MESSAGE`.`CONVERSATION_UTC_DTTM` desc;

and then the error "Index was outside the bounds of the array" occurs

How to repeat:
Execute same query

Suggested fix:
Uncertain

[31 Jan 2012 16:57] Valeriy Kravchuk

Please, check if the same problem still happens with a newer version, 5.2.37.

[31 Jan 2012 21:36] Bernie Mamorbor

After running a saved query in MySQL Workbench, I got the "Index was outside the bounds of the array".

I have run the saved query everyday, and there have been no changes to that schema, and I ran it again, which worked OK.

[1 Feb 2012 5:13] Valeriy Kravchuk

Had this "Index was outside the bounds of the array" error ever happened with 5.2.37?

[2 Mar 2012 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".