Opened 17 years ago
Closed 17 years ago
#238 closed defect (fixed)
Modify MySQL Provider to work with MySQL 5.1.22
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | 3.3.0 |
| Component: | FDO API | Version: | 3.3.0 |
| Severity: | 2 | Keywords: | MySQL 5.1.22 data truncation |
| Cc: | External ID: |
Description
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.
Change History (3)
comment:1 by , 17 years ago
| Status: | new → assigned |
|---|
comment:2 by , 17 years ago
comment:3 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Revision: 3731 Author: brentrobinson Date: 3:54:16 PM, Wednesday, January 23, 2008 Message: Ticket#238: Modified column reader to parse number of bits, for bit columns, programmatically instead of using MySQL string functions. The particular combination of string functions used quit working after MySQL 5.0.27.
Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Rd/ColumnReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Rd/ColumnReader.h