[fdo-trac] #238: Modify MySQL Provider to work with MySQL 5.1.22

[FDO]

#238: Modify MySQL Provider to work with MySQL 5.1.22
-----------------------------+----------------------------------------------
   Reporter:  brentrobinson  |       Owner:  brentrobinson               
       Type:  defect         |      Status:  new                         
   Priority:  major          |   Milestone:  3.3.0                       
  Component:  FDO API        |     Version:  3.3.0                       
   Severity:  2              |    Keywords:  MySQL 5.1.22 data truncation
External_id:                 |  
-----------------------------+----------------------------------------------
 In MySQL versions higher than 5.1.22, if the following is in a select
 list:

 When 'bit' THEN CONVERT(
 MID(column_type,INSTR(column_type,'(')+1,INSTR(column_type,')')-INSTR(column_type,'(')-1),
 UNSIGNED)

 then a "data truncation error" occurs when fetching rows. The above clause
 is in the FdoSmPhRdMySQLColumnReader. There seems to be some MySQL
 regression regarding the above combination of string manipulation
 functions.

 This problem can be worked around by taking this string manipulation out
 of the select statement and doing it programmatically.

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