search

borng / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
1 stars 0 forks source link

SQLite: Space missing in generated SQL when column has DEFAULT & primary key #91

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a table with one column 
2. Give the column a default value (e.g. 42) 
3. Make the column the primary key
4. Generate SQL 

What is the expected output? What do you see instead?
Output looks like the sample below; there's a space missing between "42"
and "PRIMARY":
   CREATE TABLE stuff (
   id INTEGER NOT NULL DEFAULT 42PRIMARY KEY AUTOINCREMENT 
   );

Original issue reported on code.google.com by NikitaTh...@gmail.com on 8 Apr 2010 at 9:06

GoogleCodeExporter commented 9 years ago 
I assume this is relevant to SQLite datatype definition.

Original comment by ondrej.zara on 9 Apr 2010 at 6:17

GoogleCodeExporter commented 9 years ago 
Fixed in r100 :)

Original comment by ondrej.zara on 9 Apr 2010 at 6:22

GoogleCodeExporter commented 9 years ago 
Looks good to me too. Thanks!

Original comment by NikitaTh...@gmail.com on 12 Apr 2010 at 1:05