[fdo-trac] #703: MySQL: fails to retrieve schema when server is 5.5

FDO trac_fdo at osgeo.org
Wed Sep 29 10:17:19 EDT 2010


#703: MySQL: fails to retrieve schema when server is 5.5
------------------------------+---------------------------------------------
 Reporter:  brentrobinson     |         Owner:  brentrobinson
     Type:  defect            |        Status:  closed       
 Priority:  major             |     Milestone:  3.6.0        
Component:  MySQL Provider    |       Version:  3.4.0        
 Severity:  1                 |    Resolution:  fixed        
 Keywords:  MySQL 5.5 schema  |   External_id:               
------------------------------+---------------------------------------------
Changes (by brentrobinson):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 Revision: 5695
 Author: brentrobinson
 Date: 10:16:21 AM, Wednesday, September 29, 2010
 Message:
 Ticket#703: Submitted on behalf of Cheney Sun.

 In MySQL 5.5, the value of the table_catalog column, in the
 information_schema tables, changed from null to "def". FdoSmPhMySQLOwner
 does a number of selects against information_schema tables with
 "table_catalog = null" in the where clause. This submission adds a check
 for server version. If 5.5.0 or higher, the above subclause is generated
 as "table_catalog = 'def'".
 ----
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Owner.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Owner.h

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/703#comment:1>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list