Failed test in ogr_mysql.py

[rouault]

I've added in r14138 an autotest for OGR MySQL driver. This is a copy&paste from ogr_pg.py.

There are 2 tests that I have disabled : ogr_mysql_6 and ogr_mysql_8 as they don't currently pass.

This would be probably good to configure a buildbot to use this autotest too.

[rouault]

ogr_mysql_6 failing could be related to r11522.

ogr_mysql_4 also contains a workaround that didn't exist in ogr_pg_4 test :

    # E. Rouault : the mySQL driver doesn't seem to like adding new features and
    # iterating over a query at the same time.
    # If trying to do so, we get the 'Commands out of sync' error.

[warmerdam]

Chaitanya,

Could you try and review the status of this before 1.7 release, and make needed corrections, possibly in consultation with Even, Howard and myself?

Mateusz,

When you migrate the gdal build slaves to buildtest.osgeo.org might be a good time to add myself to the test mix.

[chaitanya]

Fixed the issue where TEXT type was reported as BLOB. Modified the autotest's ogr_mysql.py accordingly. Unclosed geometries are returned as closed geometries by MySQL driver. Changed ogr_mysql_4() to test this. r18362 in trunk.