Bug report #21100
field calculator doesn't load values for gpkg containing blank spaces or n dash (hypen) in field names
|Affected QGIS version:||3.5(master)||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||Yes||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||28918|
field calculator, expression based filter and query builder don't load values for gpkg containing blank spaces or n dash (hyphen) in field names.
Furthermore the categorized renderer on these fields results in a simple marker renderer (see also #14737)
#3 Updated by Alexis Roy-L over 2 years ago
This also seems to happen with Spatialite (as they are all based on sqlite) and exporting such layers to a MSSQL database toggle the "Import was succesful" message but the layer does not appear in the browser panel after refresh.
Memory layer and shapefiles were ok.
But the databases are in the SQL database itself but are not displayed in the browser after a restart.
This might be related to how SQL are handled by QGIS.
Hope this helps.