[fdo-trac] #588: ODBC: Connection fails for mySQL 5.1

[FDO]

#588: ODBC: Connection fails for mySQL 5.1
------------------------------+---------------------------------------------
   Reporter:  gavincramer     |       Owner:  gregboone
       Type:  defect          |      Status:  new      
   Priority:  major           |   Milestone:  3.5.0    
  Component:  MySQL Provider  |     Version:  3.4.0    
   Severity:  2               |    Keywords:           
External_id:                  |  
------------------------------+---------------------------------------------
 Using the ODBC Provider to connect to a MySQL 5.1 database (using the
 MySQL 5.1.5. Connector) always fails when describing schema.  In
 particular, if the database contains FDO metaschema (as created by the FDO
 MySQL Provider), it will wrongly try to interpret that metaschema and
 produce an error with the following text...

 "You have an error in your SQL syntax: check the manual that corresponds
 to your MySQL server version for the syntax to user near '"f_options
 "f_options' at line 1"

 I have a fix available, which addresses the metaschema handling as well as
 a change of the Connector DLL's name with MySQL 5.1.  However, due to
 MySQL defect 41796 (see http://bugs.mysql.com/bug.php?id=41796), I will
 not be able to update the unit test's automatic creation of a DSN.  The
 unit test will have to be left runnable only using MySQL 5.0 for the time
 being.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/588>
FDO <http://fdo.osgeo.org/>
Feature Data Objects