[#91] TestOGRTable.test_Column(s) fail: 'double' != 'int'

http://shapelib.maptools.org/dbf_api.html
Section DBFGetFieldInfo() has a table:

typedef enum {
FTString, /* fixed length string field */
FTInteger, /* numeric field with no decimals */
FTDouble, /* numeric field with decimals */
FTLogical, /* logical field. */
FTInvalid /* not a recognised field type */
} DBFFieldType;

So according to this definition, this is FTInteger
for shapelib. Is Frank Warmerdam contradicting himself?
:) Maybe we need to ask. Or poke in the newer versions of shapelib.

I am a bit unsure, because I think shapelib also handles dbf files and there must be a real spec somewhere
that marks the type of the field.

This would mean not only to fix the testcase, but also to fix the type constant we are using so far. I did not have time to think about the consequences of doing so.
Otherwise: OGR support is pretty new, why not just fix the testcase?

This can be the interesting changelog :

* Revision 1.58 2005/03/14 15:18:54 fwarmerdam
* Treat very wide fields with no decimals as double. This is
* more than 32bit integer fields.

in ogr/ogrs_frmts/shape/dbfopen.c

I have now way of knowing what ogr official version is linked with this.

This is interesting, maybe the old version was wrong,
but thus would mean, if we fix the testcase,
this would fail on older ogr versions.
Best would be to find the fix in the ogr changelog.

ArcGIS 9.1 reports the FNODE_ as a double field (precision 11, scale 0).

This solves the bug. OGR is coherent with ArcGIS 9. My guess is that the type in the test case must be corrected to double and not int.

Do you prefer to have another test with another software or library ?

It think the testcase runs fine in earlier versions.
It might be that ogr reports the wrong type,
this would be consistant with ogrinfo,
but we would need to compare it to the type within the file.

The problem is in the TestCase. It's not a bug.

Using ogrinfo on the roads-line.shp file, we get the following answer :

did@geru-itae:~/projets/python/thuban/thuban/Data/iceland$ ogrinfo -su roads-line.shp roads-line
INFO: Open of `roads-line.shp'
using driver `ESRI Shapefile' successful.

Layer name: roads-line
Geometry: Line String
Feature Count: 839
Extent: (-24.450359, 63.426830) - (-13.556688, 66.520111)
Layer SRS WKT:
(unknown)
FNODE_: Real (11.0)
TNODE_: Real (11.0)
LPOLY_: Real (11.0)
RPOLY_: Real (11.0)
LENGTH: Real (12.3)
RDLINE_: Real (11.0)
RDLINE_ID: Real (11.0)
RDLNTYPE: Integer (2.0)
RDLNSTAT: Integer (2.0)


So the FNODE_ feature is a double and not an int.

Does the test case for the ogr extensions works fine with a previous version of ogr ? I have only tested it with 1.3.x version.

Can someone test it with a gdal 1.1.8 for example ?

The failure was also noticed by Didrik on Windows
with gdal 1.3.1

This failrue could not be observed with gdal 1.2.6,
it might as well be a gdal problem.