[kexi] [Bug 364810] New: Error while inserting rows into table with schema containing reserved words

[Jarosław Staniek via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=364810

            Bug ID: 364810
           Summary: Error while inserting rows into table with schema
                    containing reserved words
           Product: kexi
           Version: 2.9.11
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: KexiDB
          Assignee: kexi-bugs at kde.org
          Reporter: staniek at kde.org
                CC: adam at piggz.co.uk, inksi at fables.co.za

Error while inserting rows into table with schema containing reserved words,
e.g. table name == "table" or field name "from". 

Solution: escape identifiers in any place where necessary. 


Reproducible: Always

Steps to Reproduce:
1. Create table such as "CREATE TABLE "TABLE" ("FROM" INTEGER)
2. Go to the data view and try to insert one record


Actual Results:  
"Record inserting failed"



In fact records get inserted but retrieving autoincremented values fails.

-- 
You are receiving this mail because:
You are the assignee for the bug.