Opened 9 years ago

Closed 9 years ago

#45 closed defect (invalid)

Can't get the correct FID from SQLITE and Spatialite DB

Reported by: MCA4213 Owned by: jlarouche@…
Component: GDAL Severity: grave
Keywords: OGR SQLITE FID Cc:

Description

I tested OGR with an SPatialite DB with :

  • my DB has 250 feature;
  • my SQL statement is : "select * from Feature where ogc_fid>240".

But the OGR_F_GetFID is returning an FID that start from 0 to 9 and not my real FID, this cause me a problem in osgEarth selection (this work for me with PostGis);

I find also that : *OGR_L_GetFIDColumn(layer) is returning an empty name, so OGR is not able to get my primary key even with no SQL expression. *OGR is overwriting my ogc_fid in the results layer, I tried with other name (for the pk) but the returned FID is still wrong.

for my configuration, I download my GDAL 1.11 and SQLITE 3.7 and SPATILITE 4.1.1 from OSGeo4W (I work with visual C++ 10).

Any help please?

Change History (1)

comment:1 by jlarouche, 9 years ago

Resolution: invalid
Status: newclosed

Hello

This doesn't seem like a problem related to the Ubuntu Packages. Since you're using OSGeo4W you should probably ask over there : http://trac.osgeo.org/osgeo4w/

Note: See TracTickets for help on using tickets.