Bug report #18713

Virtual layer with spaces in layer name not created

Added by Nikolay Lebedev about 5 years ago. Updated almost 5 years ago.

Category:Virtual Layers
Affected QGIS version:3.0.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 #:26600


If you try to create a virtual layer from existing project layer that has spaces in layer name (like “My layer”) you'll receive an error when pressing `Check` button in ‘Creating of Virtual layer’ dialog. Layer won't be created. Dropping spaces gives positive result.

Screenshot 2018-04-19 02.08.50.png (6.77 KB) Nikolay Lebedev, 2018-04-19 01:13 AM


#1 Updated by Nyall Dawson about 5 years ago

  • Status changed from Open to Feedback

No error here - are you enclosing the table name in double quotes? Can you post more info?

#2 Updated by Nikolay Lebedev about 5 years ago

Virtual layer is being chosen from layer list and doesn't have quotes by default. Check button returns an error (see screenshot). Adding double quotes does help, but it's not an obvious solution.

#3 Updated by Giovanni Manghi almost 5 years ago

  • Status changed from Feedback to Open

Also available in: Atom PDF