Bug report #8366: DB Manager error with retrieve columns from SQL Window - QGIS Application - QGIS Issue Tracking

Bug report #8366

DB Manager error with retrieve columns from SQL Window

Added by Pedro Venâncio over 10 years ago. Updated over 10 years ago.

Status:	Closed
Priority:	Severe/Regression
Assignee:	-
Category:	DB Manager
Affected QGIS version:	master	Regression?:	No
Operating System:		Easy fix?:	No
Pull Request or Patch supplied:	No	Resolution:
Crashes QGIS or corrupts data:	No	Copied to github as #:	17143

Description

The execution of the query works well, as well as the "load the new layer" when choosing the "id" and "geometry" fields manually. Making "retrieve columns", it throws this error:

An error has occured while executing Python code:

Traceback (most recent call last):
  File "/usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py", line 229, in fillColumnCombos
    if not query.contains( QRegExp(escaped, Qt.CaseInsensitive) ):
AttributeError: 'unicode' object has no attribute 'contains'

Python version:
2.7.3 (default, Apr 10 2013, 06:03:17) 
[GCC 4.6.3]

QGIS version:
1.9.0-Master Master, exported