Opened 18 years ago
Last modified 18 years ago
#1122 closed defect (fixed)
MySQL ovf broken in GDAL CVS
Reported by: | Owned by: | hobu | |
---|---|---|---|
Priority: | high | Milestone: | |
Component: | OGR_SF | Version: | unspecified |
Severity: | normal | Keywords: | |
Cc: |
Description
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.
Attachments (1)
Change History (6)
by , 18 years ago
Attachment: | calamaris 20060301 0854.sql added |
---|
comment:1 by , 18 years ago
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
comment:2 by , 18 years ago
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
comment:4 by , 18 years ago
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 :(
comment:5 by , 18 years ago
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
Note:
See TracTickets
for help on using tickets.
sql file for database