Bug report #14955

Layer name completion in Virtual Layer query window fails on whitespace

Added by Johannes Kroeger over 7 years ago. Updated almost 5 years ago.

Category:DB Manager
Affected QGIS version:3.6.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:22904


I have a layer named "natural_earth_vector ne_10m_admin_0_countries" from opening the NE sqlite file and selecting that.

If I type the beginning of its name in the "Create a virtual layer" Query window, QGIS will suggest to autocomplete to that name properly but on hitting Enter will only enter "natural_earth_vector". This will result in the query failing as there is no such layer.

QGIS should instead enter the whole name, enclosed in double quotes.


#1 Updated by Giovanni Manghi almost 7 years ago

  • Regression? set to No
  • Easy fix? set to No

#2 Updated by Jürgen Fischer over 6 years ago

  • Category set to Unknown

#3 Updated by Giovanni Manghi almost 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

#4 Updated by Johannes Kroeger almost 5 years ago

  • Description updated (diff)
  • Resolution deleted (end of life)
  • Status changed from Closed to Reopened

Still happening in 3.6.0-Noosa.

#5 Updated by Giovanni Manghi almost 5 years ago

  • Affected QGIS version changed from master to 3.6.0
  • Category changed from Unknown to DB Manager
  • Status changed from Reopened to Open

Also available in: Atom PDF