Bug 212873 - Mysql wrong sql generation
Summary: Mysql wrong sql generation
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: 1.5.2   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: future   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords: helpwanted
Depends on:
Blocks:
 
Reported: 2007-12-13 09:10 EST by Eden Klein CLA
Modified: 2007-12-23 03:20 EST (History)
1 user (show)

See Also:

Attachments
This patch fixes the problem (1.11 KB, patch)
2007-12-13 09:11 EST, Eden Klein CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eden Klein CLA 2007-12-13 09:10:33 EST 
sometimes the SQL auto generated from wizards is wrong.
The reason is that the SQL is composed based on an unordered set of options.
The attached patch fixes the problem
Comment 1 Eden Klein CLA 2007-12-13 09:11:48 EST 
Created attachment 85173 [details]
This patch fixes the problem
Comment 2 Eden Klein CLA 2007-12-23 03:20:10 EST 
More details about the bug:
When the user creates a table using the wizard, at times he gets erroneous sql.
The reason for the inconsistency is that the sql is composed according to the different elements and options available in the wizard, but the order of the sql statements generated depends on a non ordered predefined Set of options. The patch actually modifies the Set to be an ordered Set so that the result is consistent and the SQL generated is correct.
It is rather annoying for the user, getting an execution error while running an SQL that is auto-generated for him by the wizard.