Bug report #6511

Error when creating new Spatialite tables in DB Manager

Added by Giovanni Manghi almost 7 years ago. Updated almost 7 years ago.

Status:Closed
Priority:High
Assignee:Giovanni Manghi
Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed
Crashes QGIS or corrupts data:No Copied to github as #:15728

Description

tested on qgis 1.8 on Windows.

When I try to create a new SL table I get

near "n": syntax error

message.

It results that when adding varchar fields it uses a "varchar (n)" field type.

If the "(n)" is removed then it works fine.

I didn't tested with PostGIS.

Associated revisions

History

#1 Updated by Giuseppe Sucameli almost 7 years ago

I agree that a new item varchar without limit should be added

The one with N as limit could be kept but replacing the N with a valid default value (e.g. 255) so the user can change it with a more appropriate value if needed.

#2 Updated by Giuseppe Sucameli almost 7 years ago

  • Status changed from Open to Closed

#3 Updated by Giuseppe Sucameli almost 7 years ago

  • Resolution set to fixed

Also available in: Atom PDF