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-b...@kde.org
          Reporter: stan...@kde.org
                CC: a...@piggz.co.uk, in...@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 watching all bug changes.

Reply via email to