Even Rouault-2 wrote > I think that Spatialite's validateRowid() fuction should be patched to > check if the rowid > column is not of type INTEGER PRIMARY KEY, if so that's acceptable, > instead of just checking > for rowid. CC'ing Sandro.
Let's see what Sandro says but I do not believe it is acceptable. The r-tree spatial index is returning rowids to be used as keys to real data and if the main table has an ordinary attribute named as ROWID you can guess what will happen. System works fine if you do not utilize spatial index. If you use it you use you will get crazy results. I remember I had quite a headache because of that some years ago https://groups.google.com/forum/#!searchin/spatialite-users/rowid%7Csort:relevance/spatialite-users/QwRdCiWoVKw/sXqCNZ5wn34J. -Jukka Rahkonen- -- View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-sqlite-spatialite-rowid-tp5311181p5311212.html Sent from the GDAL - Dev mailing list archive at Nabble.com. _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
