Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when synchronizing from QField when an "int" field has been cleared in QField #292

Open
gioman opened this issue Aug 6, 2021 · 1 comment
Labels

Comments

@gioman
Copy link

gioman commented Aug 6, 2021

Qfield Sync:
4.0.0-BETA8
v3.4.4

QField:
2.0.2 Beta3

QGIS:
master
3.20

Take a project with a PostGIS layer with an "int" field (filled), make it offline and port it to QField.

In QField edit an existing feature and clear the "int" field.

Try synchronize basck to PostGIS with QFieldSync, it will fail as it will try to update the feature with something like

UPDATE "schemaname"."tablename" SET "columnname"='' WHERE "i...

instead of something like

UPDATE "schemaname"."tablename" SET "columnname"=NULL WHERE "i...

@suricactus suricactus added the bug label Jan 20, 2022
@paschendale
Copy link

paschendale commented Jan 25, 2022

The same thing happens on numeric and timestamp fields as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants