Bug report #14404
Preview table crashes DB-Manager when using virtual layers
|Affected QGIS version:||2.14.0||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||22385|
To reproduce the bug:
1. Open DB-Manager and select one layer in the "Virtual Layers" section
2. Click on the "Table" panel
3. DB-Manager will freeze
You can see there's some Python error if you manage to close DB-Manager window
#2 Updated by Jérôme Guélat over 5 years ago
Thanks for looking at it... After more testing (using Windows and Mac OS X), I noticed this doesn't happen with layers containing points. But there is definitely a problem with polygons (I didn't test with lines).
The Python error is "list index out of range". The offending code seems to be in the file data_model.py (lines 62, 124)
#3 Updated by Jérôme Guélat over 5 years ago
Well, it also happens with points... Just had a problem when I was browsing the table (same error).
I have the impression the problem appears because of the geometry column... For example my point layer has many fields and DB Manager can show all of them except the geometry. It crashes after trying to show the last column (which is the geometry).