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

Change the string length in metadata #160

Open
PeterPetrik opened this issue Feb 7, 2022 · 1 comment
Open

Change the string length in metadata #160

PeterPetrik opened this issue Feb 7, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@PeterPetrik
Copy link
Contributor

Note about data types and strings: for geopackage/sqlite the change in the string length is just different value in the metatable, but the actually it both stored same way. Since in reality it is same data type, this metatable difference is ignored by geodiff.

robot@gis:~$ ogrinfo gis/point.gpkg -al -so |grep WorkZone
WorkZone: String (10.0)
robot@gis:~$ ogrinfo other_point.gpkg -al -so |grep WorkZ
WorkZone: String (5.0)
robot@gis:~$ geodiff diff --json point.gpkg other_point.gpkg a-to-b.diff
(returns no diff)

On the contrary, if the type changes to int from string, the difference should be caught by geodiff

It would be good if this particular case the geodiff can change the metadata entry:

If this value is set to a non-zero value, then certain QGIS operations fail such as when the layer is exported. So we now have a situation where, when using Mergin, certain QGIS operations fail due to this not syncing properly

@PeterPetrik PeterPetrik added the bug Something isn't working label Feb 7, 2022
@jmanley
Copy link

jmanley commented Feb 7, 2022

Thank you, @PeterPetrik
For now, I have manually replaced the geopackage file in Mergin (delete it and re-upload) and thus forced a "sync" of the metatable and our immediate problem is resolved. I look forward to a fix that will prevent this situation re-occurring.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants