Bug report #11983
pasting features into spatialite layer does not copy attibute values
|Affected QGIS version:||2.14.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||not reproducable|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||20189|
I use Qgis 2.6.1 to paste features from shape or PostGIS database table into a spatialite table. The features (geometry) are copied correctly, but the attribute values in the spatialite are blank (NULL). In QGis 2.4.0, the attribute values are copied as well.
In this case, I have a spatialite db with some features already present. I want to add some new features to this table from shape. Both the spatialite table and the shape have an ID field named 'inp_id' that is of type integer. I select the features from the shape, hit copy then select the spatialite table (that is in edit mode) and hit paste. After I noticed the ID was not filled I tried pasting from a PostGIS database, but the result was the same. When I returned to Qgis 2.4.0 the ID field was filled correctly.
#2 Updated by Giovanni Manghi over 6 years ago
- Category changed from Attribute table to Digitising
- Status changed from Open to Feedback
- Priority changed from Normal to Severe/Regression
- Operating System deleted (
- OS version deleted (
- Affected QGIS version changed from 2.6.1 to master
I cannot replicate it in 2.6.1 compared to 2.4.
In 2.6.1 works ok for me, but does not on master.
Anyway is a regression.
#3 Updated by Seb Radzimski over 6 years ago
- Target version set to Version 2.8
I found something similar in QGIS 2.6.0 and now in 2.6.1 (Windows x64 standalone installation) during copy features between SHAPEfiles or POSTGIS layers (with the same columns). Usually copy/paste works fine, but sometimes in the target table all attributes of copied features are NULL (instead of geometry). QGIS 'says' that copy was successful and new objects are visible on the map (they have geometry) but no others attributes. If I restart QGIS everything works fine ... for a while.
#11 Updated by Almerio Moreira over 5 years ago
- Target version changed from Version 2.8 to Version 2.14
- Status changed from Closed to Reopened
This problem still exists on QGIS version 2.14.1, windows 7 64 bits, using shapefile vector layer.
Sometimes it occurs, so I have to restart QGIS to copy features with attributes even from the same layer.
#13 Updated by Giovanni Manghi over 4 years ago
- Status changed from Reopened to Closed
- Resolution set to not reproducable
I just tested again on 2.18.4 on both Windows and Linux and copy/pasting from shape/postgis to spatialite worked just fine. I assume that if there were still issues those were fixed in recent qgis releases. Please leave feedback if you find that this operation still does not work as expected.