Bug report #17167

Tables with boolean data types can't be saved

Added by Andreas Neumann almost 3 years ago. Updated about 2 years ago.

Status:Closed
Priority:High
Assignee:Denis Rouzaud
Category:Attribute table
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:Yes Copied to github as #:25066

Description

Attribute tables that contain columns with Boolean data types can't be saved with Python and also not in Processing (output saved via OGR).

When saved via Python one receives the error message "unsupported type for field xxx"

When saved via Processing all columns starting from the boolean field seems to vanish when save.

History

#1 Updated by Giovanni Manghi almost 3 years ago

  • Status changed from Open to Feedback

Hi Andreas, what tool in Processing?

#2 Updated by Andreas Neumann almost 3 years ago

Any tool in processing that saves a vector layer that contains boolean data types.

This is all related to the new introduction of the boolean data type in QGIS master where many of the tools are note aware of this data type.

#3 Updated by Giovanni Manghi almost 3 years ago

  • Crashes QGIS or corrupts data changed from No to Yes

Andreas Neumann wrote:

Any tool in processing that saves a vector layer that contains boolean data types.

This is all related to the new introduction of the boolean data type in QGIS master where many of the tools are note aware of this data type.

Ok, so I think is better to open a separate ticket to address the problem in Processing. Agree?

#4 Updated by Andreas Neumann almost 3 years ago

oh - sorry.

The "save problem" of data with boolean data types is pretty much everywhere (Python, Processing, probably more places I am not aware of)

Perhaps there is a central solution to all of the different places where it fails? I don't know.

#5 Updated by Denis Rouzaud over 2 years ago

Hi Andreas,
Are you able to share some demo/data project?
Or ideally Python and/or processing code?

Does it happen on any source type (PG vs others)?
On any destination or OGR only?

Thanks

#6 Updated by Denis Rouzaud over 2 years ago

  • Assignee changed from Matthias Kuhn to Denis Rouzaud

#7 Updated by Denis Rouzaud over 2 years ago

Andreas, any chance to provide some demo data/script?

#8 Updated by Andreas Neumann over 2 years ago

Denis Rouzaud wrote:

Andreas, any chance to provide some demo data/script?

I will have a look at it early next week. I am on holidays and my wife doesn't appreciate me spending time online.

However, there is a good chance that meanwhile the issue was fixed already. I need to test it again.

#9 Updated by Nyall Dawson over 2 years ago

I'm fairly certain that this was already fixed by cb566178914933d864fad45cf359c6845961dc06

#10 Updated by Denis Rouzaud about 2 years ago

  • Status changed from Feedback to Closed

Also available in: Atom PDF