[virtual layer] Escape column names in query

Hugo Mercier · Hugo Mercier · commit c6fb7b3b0e50 · 2016-06-28T09:51:35.000+02:00
diff --git a/src/providers/virtual/qgsvirtuallayerqueryparser.cpp b/src/providers/virtual/qgsvirtuallayerqueryparser.cpp
@@ -201,7 +201,7 @@ namespace QgsVirtualLayerQueryParser
       QString qs = "SELECT ";
       for ( int i = 0; i < undefinedColumns.size(); i++ )
       {
-        qs += columns[undefinedColumns[i]];
+        qs += "\"" + columns[undefinedColumns[i]] + "\"";
         if ( i != undefinedColumns.size() - 1 )
           qs += ", ";
       }

Original file line number	Diff line number	Diff line change
`@@ -201,7 +201,7 @@ namespace QgsVirtualLayerQueryParser`
`201`	`201`	`QString qs = "SELECT ";`
`202`	`202`	`for ( int i = 0; i < undefinedColumns.size(); i++ )`
`203`	`203`	`{`
`204`		`- qs += columns[undefinedColumns[i]];`
	`204`	`+ qs += "\"" + columns[undefinedColumns[i]] + "\"";`
`205`	`205`	`if ( i != undefinedColumns.size() - 1 )`
`206`	`206`	`qs += ", ";`
`207`	`207`	`}`