Issue 118894 - Create table failed use wizard if we change some value in setting
Summary: Create table failed use wizard if we change some value in setting
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-10 02:52 UTC by Terry Yang
Modified: 2013-01-29 21:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Terry Yang 2012-02-10 02:52:30 UTC
If we create table use wizard, in the wizard we change some value to invalid, then change them back to correct one, it will failed due to the invalid value

Step:
1. Create a DB
2. Click "Use Wizard to Create Table" to create table
3. Select Personal and add sample tables "Accounts" all fields then next
4. in AutoValue dropdown list select "Yes", and set Auto-Increment statement to value "1". Click next
5 Select "Use an existing field as primary key" select "AccountID" as Fieldname, and check the Auto value. 
6. Goback to step 4 change the value to default on.
7. Click next, next,finish

Result:
A unexpect error display 
SQL Status: 37000
Error code: -11

Unexpected token: 1 in statement [CREATE TABLE "Accounts" ("AccountID" INTEGER NOT NULL 1]

If we close this Wizard and redo all steps except step 4 and step 6, it wil create the tab successfully