Bug report #14955

Layer name completion in Virtual Layer query window fails on whitespace

Added by Johannes Kroeger about 4 years ago. Updated over 1 year ago.

Status:Open
Priority:Normal
Assignee:-
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

Description

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.

History

#1 Updated by Giovanni Manghi about 3 years ago

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

#2 Updated by Jürgen Fischer almost 3 years ago

  • Category set to Unknown

#3 Updated by Giovanni Manghi over 1 year ago

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

#4 Updated by Johannes Kroeger over 1 year 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 over 1 year 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