Status/Resolution/Reason: Closed/Won't Fix/LowImpact
Reporter/Name(from Bugbase): Devin Holloway / Devin Holloway (Devin Holloway)
Created: 05/26/2012
Components: Flex/Flash
Versions: 10.0
Failure Type: Incorrect w/Workaround
Found In Build/Fixed In Build: Final /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Windows 7 SP1 64-bit
Vote Count: 0
Problem Description: When using offline AIR support, I have a client-side class with a property named "primary". The SQLite table for this class cannot be created because the SQL statement for table generation confuses the word "primary" with the "PRIMARY KEY" keyword.
Steps to Reproduce: Create a client-side class with a property named "primary".
Actual Result:
flash.errors.SQLError
CREATE TABLE IF NOT EXISTS User (name TEXT,email TEXT UNIQUE,trainerId INTEGER,password TEXT,primary INTEGER,userId INTEGER,PRIMARY KEY (userId),FOREIGN KEY (trainerId) REFERENCES User(userId))
Expected Result: Keywords to be escaped
Any Workarounds: Do not name a property "primary"
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3199273
Deployment Phase: Release Candidate
External Customer Info:
External Company:
External Customer Name: Devin Holloway
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: