Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
[spatialite] Fix broken extent filter feature request against a spati…
…alite view
  • Loading branch information
nirvn authored and github-actions[bot] committed Nov 5, 2021
1 parent e858c9f commit 6544cfd
Showing 1 changed file with 2 additions and 2 deletions.
4 changes: 2 additions & 2 deletions src/providers/spatialite/qgsspatialitefeatureiterator.cpp
Expand Up @@ -455,7 +455,7 @@ QString QgsSpatiaLiteFeatureIterator::whereClauseRect()
mbrFilter += QStringLiteral( "ymax >= %1" ).arg( qgsDoubleToString( mFilterRect.yMinimum() ) );
QString idxName = QStringLiteral( "idx_%1_%2" ).arg( mSource->mIndexTable, mSource->mIndexGeometry );
whereClause += QStringLiteral( "%1 IN (SELECT pkid FROM %2 WHERE %3)" )
.arg( QStringLiteral( "ROWID" ),
.arg( mSource->mViewBased ? quotedPrimaryKey() : QStringLiteral( "ROWID" ),
QgsSqliteUtils::quotedIdentifier( idxName ),
mbrFilter );
}
Expand All @@ -464,7 +464,7 @@ QString QgsSpatiaLiteFeatureIterator::whereClauseRect()
// using the MbrCache spatial index
QString idxName = QStringLiteral( "cache_%1_%2" ).arg( mSource->mIndexTable, mSource->mIndexGeometry );
whereClause += QStringLiteral( "%1 IN (SELECT rowid FROM %2 WHERE mbr = FilterMbrIntersects(%3))" )
.arg( QStringLiteral( "ROWID" ),
.arg( mSource->mViewBased ? quotedPrimaryKey() : QStringLiteral( "ROWID" ),
QgsSqliteUtils::quotedIdentifier( idxName ),
mbr( mFilterRect ) );
}
Expand Down

0 comments on commit 6544cfd

Please sign in to comment.