Opened 10 years ago
Closed 10 years ago
#45 closed defect (invalid)
Can't get the correct FID from SQLITE and Spatialite DB
Reported by: | MCA4213 | Owned by: | |
---|---|---|---|
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?
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/