Opened 14 years ago
Closed 14 years ago
#703 closed defect (fixed)
MySQL: fails to retrieve schema when server is 5.5
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | 3.6.0 |
| Component: | MySQL Provider | Version: | 3.4.0 |
| Severity: | 1 | Keywords: | MySQL 5.5 schema |
| Cc: | External ID: |
Description
Steps:
- Connect to a datastore in a MySQL 5.5 server instance.
- Perform an FdoIDescribeSchema command.
No classes are found.
Note:
See TracTickets
for help on using tickets.
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