Bug report #18713
Virtual layer with spaces in layer name not created
|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.
#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
- File Screenshot 2018-04-19 02.08.50.png added
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