Skip to content

Commit fe93e62

Browse files
committedJul 6, 2016
[oracle] Fix detection of geometry type when table contains some
empty geometries On behalf of Faunalia, sponsored by ENEL
1 parent f1a15e3 commit fe93e62

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed
 

‎src/providers/oracle/qgsoracleprovider.cpp

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2289,8 +2289,8 @@ bool QgsOracleProvider::getGeometryDetails()
22892289
}
22902290

22912291
if ( exec( qry, QString( mUseEstimatedMetadata
2292-
? "SELECT DISTINCT gtype FROM (SELECT t.%1.sdo_gtype AS gtype FROM %2 t WHERE rownum<1000) WHERE rownum<=2"
2293-
: "SELECT DISTINCT t.%1.sdo_gtype FROM %2 t WHERE rownum<=2" ).arg( quotedIdentifier( geomCol ) ).arg( mQuery ) ) )
2292+
? "SELECT DISTINCT gtype FROM (SELECT t.%1.sdo_gtype AS gtype FROM %2 t WHERE t.%1 IS NOT NULL AND rownum<1000) WHERE rownum<=2"
2293+
: "SELECT DISTINCT t.%1.sdo_gtype FROM %2 t WHERE t.%1 IS NOT NULL AND rownum<=2" ).arg( quotedIdentifier( geomCol ) ).arg( mQuery ) ) )
22942294
{
22952295
if ( qry.next() )
22962296
{

0 commit comments

Comments
 (0)
Please sign in to comment.