qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.67k stars 3.02k forks source link

Offline editing (core plugin) doesn't write True value in Boolean field #50654

Open mcingotti opened 2 years ago

mcingotti commented 2 years ago

What is the bug or the crash?

Working in offline mode if you try to modify a boolean field by changing it to true when the project is synchronized the changes will not be recorded. Conversely, if the field is flagged as false, the changes are logged. This is not the case when a new feature is added.

Steps to reproduce the issue

I create a new geopackage, file project inside, and I have set these fields

fields

I start without adding features

Screenshot (50)

I create offline geopackage, in different folder

Screenshot (57)

Screenshot (51)

now I start adding features

Screenshot (52)

first one

Screenshot (53)

second one

Screenshot (54)

I switch to online project to verify features added and as you can see changes are recorded

Screenshot (56)

now I go back to the offline version and make some changes

Screenshot (58)

As you can see here false are recorded in the fields, true not

Screenshot (59)

Versions

QGIS version 3.22.11-Białowieża QGIS code revision 106d33d7 Qt version 5.15.3 Python version 3.9.5 Compiled against GDAL/OGR 3.5.1 Running against GDAL/OGR 3.5.2 PROJ version 9.1.0 EPSG Registry database version v10.074 (2022-08-01) GEOS version 3.10.3-CAPI-1.16.1 Compiled against SQLite 3.38.1 Running against SQLite 3.39.4 PDAL version 2.4.3 PostgreSQL client version 14.3 SpatiaLite version 5.0.1 QWT version 6.1.6 QScintilla2 version 2.13.1 OS version Windows 10 Version 2009

Active Python plugins buffer 0.1 cartogram3 3.1.5 CityJSON-loader 0.8.1 GroupStats 2.2.6 pluginbuilder3 3.2.1 plugin_reloader 0.9.2 qfieldsync v4.2.0 Qgis2threejs 2.7.1 quick_map_services 0.19.29 db_manager 0.1.20 processing 2.12.99

Supported QGIS version

New profile

Additional context

these are the online and offline gpkg

bug_offline_editing.zip

mcingotti commented 2 years ago

I have tried to make some changes with Qfield and once the project is synchronized on qgis the same problem occurs