MySQL ovf broken in GDAL CVS

[bartvde@…]

Since january at least the MySQL ovf support is broken. I will attach a sql
script to this bug. I use the following ovf file:

<OGRVRTDataSource>
    <OGRVRTLayer name="calamiteitenactueel">
       
<SrcDataSource>MYSQL:calamaris,user=root,password=Cal12ogf,host=test.rws,port=3306,tables=calamiteiten</SrcDataSource>
        <SrcSQL>SELECT calamiteiten.caltitel, calamiteiten.calx,
calamiteiten.caly, calamiteiten.actueel, calamiteiten.calnaamcoord,
calamiteiten.calaard, calamiteiten.calcode, calamiteiten.calopm,
calamiteiten.caldate FROM calamiteiten WHERE calamiteiten.actueel = 1</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>EPSG:28992</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="calx" y="caly"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

ogrinfo already segfaults on this.

[bartvde@…]

sql file for database

[hobu]

Bart, 

I committed a fix for this (I think).  I was too greedy in trying to set field
widths and was attempting to do it for fields that were type "text".  Text
fields have no width, and the parser was trying to set things to null.

Let me know if this works.

Howard

[bartvde@…]

Hi Howard,

thanks for the quick action. I will only be able to test this in 2 weeks time as
the person who does the compiles here is out for a holiday.

I will let you know.

Bart

[hobu]

Bart,

Did you have a chance to test so I can close this one out?

Howard

[hobu]

Timeouts appear to be mostly a Windows server thing.  The user can set an
environment variable MYSQL_TIMEOUT to increase this connection timeout.  Windows
might not honor it anyway though :(

[bartvde@…]

Hi Howard,

sorry for the late feedback, it's been a bit busy here.

I have verified that your fix works using latest CVS.

Thanks.

Bart