fix MSSQL extent in geometry table (#42684)

qgis · Apr 7, 2021 · 36c3473 · 36c3473
1 parent 1277b17
commit 36c3473
Showing 1 changed file with 5 additions and 2 deletions.
diff --git a/src/providers/mssql/qgsmssqlprovider.cpp b/src/providers/mssql/qgsmssqlprovider.cpp
@@ -2973,8 +2973,11 @@ bool QgsMssqlProvider::getExtentFromGeometryColumns( QgsRectangle &extent ) cons
   QSqlQuery query = createQuery();
   query.setForwardOnly( true );
 
-  QString sql = QStringLiteral( "SELECT qgis_xmin,qgis_xmax,qgis_ymin,qgis_ymax FROM geometry_columns WHERE f_table_name = '%1' AND NOT (qgis_xmin IS NULL OR qgis_xmax IS NULL OR qgis_ymin IS NULL OR qgis_ymax IS NULL)" );
-  QString statement = sql.arg( mTableName );
+  QString sql = QStringLiteral( "SELECT qgis_xmin,qgis_xmax,qgis_ymin,qgis_ymax "
+                                "FROM geometry_columns WHERE f_table_name = %1 AND f_table_schema = %2 "
+                                "AND NOT (qgis_xmin IS NULL OR qgis_xmax IS NULL OR qgis_ymin IS NULL OR qgis_ymax IS NULL)" );
+
+  QString statement = sql.arg( quotedValue( mTableName ), quotedValue( mSchemaName ) );
   if ( query.exec( statement ) && query.isActive() )
   {
     query.next();