[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