Bug report #16939

Join attributes by location gives error when mssql-layer is a view, not a table

Added by Filip Mahieu almost 3 years ago. Updated almost 2 years ago.

Status:Closed
Priority:Normal
Assignee:Victor Olaya
Category:Processing/Core
Affected QGIS version:2.18.9 Regression?:No
Operating System:W7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:not reproducable
Crashes QGIS or corrupts data:No Copied to github as #:24838

Description

When I use a mssql (2016)-layer that is a view (not a table) in the underlying database, to use the vector-datamanagement-tool 'Join attributes by location', and let it join the attributes on whatever layer (shapefile), it throws the error '__len__() should return >= 0 See log for more details'.
When I do the same thing, but with the same layer converted to a table in the same MSSQL-database as a shapefile, it does work.

I have examined this with pointlayers and line-layers, and both throw that error. No problem with tables or shapefiles. But always a problem with whatever view it is..

History

#1 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Open to Feedback

Please test with 3.0 and confirm whether this is still an issue

#2 Updated by Giovanni Manghi almost 2 years ago

  • Resolution set to not reproducable
  • Status changed from Feedback to Closed

Closing for lack of feedback.

Also available in: Atom PDF