Create table: Column names not properly escaped
Originally reported on Google Code with ID 107 ``` What steps will reproduce the problem? 1. Create a table with two columns "a,b" and "c"
What is the expected output? What do you see instead? The following command is queried: CREATE TABLE test3(a,b INTEGER, c INTEGER) This creates a table with 3 columns (a,b,c) with column a having no type (which is no problem in SQLite because of its dynamic typing).
Expected result: Creation of a table with two columns, one having the name "a,b" and the second "c". This could be done using this SQL query: CREATE TABLE test3('a,b' INTEGER, c INTEGER)
Similar problems occur with column names containing spaces like "a b" which will cause a column "a" of type "a INTEGER" (if INTEGER type was chosen).
This is a concrete example of what was meant in issue #93 .
```
Reported by `crazy4chrissi` on 2012-05-30 15:39:48
Comments (3)
-
reporter -
reporter ``` Fixed this issue in SVN Revision
#209: http://code.google.com/p/phpliteadmin/source/browse/source/1.9.3/phpliteadmin.php ```Reported by `crazy4chrissi` on 2012-05-30 16:11:22 - Status changed: `Started`
-
reporter Reported by `crazy4chrissi` on 2012-06-02 10:54:21 - Status changed: `Fixed`
- Log in to comment
``` Typo above: Similar problems occur with column names containing spaces like "a b" which will cause a column "a" of type "a INTEGER" (if INTEGER type was chosen).
The resulting type is "b INTEGER", not "a INTEGER". ```
Reported by `crazy4chrissi` on 2012-05-30 15:41:46