[FLEX-19282] flash.errors.SQLError in unexpected state

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Adobe Flex SDK 3.3 (Release)
• Component/s: Events
• Environment: Affected OS(s): Windows; Affected OS(s): ; Browser: Firefox 3.x; Language Found: English
• Assignee: Unassigned
• Reporter: Adobe JIRA
• Created: 16/May/09 13:38
• Updated: 16/May/09 13:45

Description

Steps to reproduce:
1. Run a SQL insert statement that will cause a constraint violation (e.g., insert a duplicate 'name' column value where the 'name' column is set to be unique).
2. Immediately run a SQL select statement for a specific row in the same table involved in step #1 above. Perhaps the original row that has the given 'name' value.

Actual Results:

SQLError.detailID will have a value of -1, from the SQL insert statement in step #1 above.

Expected Results:

SQLError.detailID should have a value of 2206 (column value not unique).

Workaround (if any):

The developer can still rely on SQLError.errorID, which is the correct value of 3131 (constraint violation).