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 6, 2021
1 parent ec467dd commit 479f0f3
Showing 1 changed file with 2 additions and 2 deletions.
4 changes: 2 additions & 2 deletions src/providers/spatialite/qgsspatialitefeatureiterator.cpp
Expand Up @@ -441,7 +441,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 @@ -450,7 +450,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 479f0f3

Please sign in to comment.