Bug report #18713

Virtual layer with spaces in layer name not created

Added by Nikolay Lebedev over 6 years ago. Updated about 6 years ago.

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

Description

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

History

#1 Updated by Nyall Dawson over 6 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 over 6 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 about 6 years ago

  • Status changed from Feedback to Open

Also available in: Atom PDF