Bug #11758 SUBSTRING returns empty string on longtext column
Submitted: 6 Jul 2005 4:25 Modified: 6 Jul 2005 4:43
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.11 OS:Windows (Windows 2003 Standard)
Assigned to: CPU Architecture:Any

[6 Jul 2005 4:25] [ name withheld ] 
Description:
Given a table called item with a LONGTEXT column called Body, and that column contains data.

On version 4.1.7-nt running on Windows XP SP2, this query correctly returns data:

SELECT SUBSTRING(Body,1,100) from item

This query fails to return data (returns an empty string but does not return an error) running on version 4.1.12a-nt on Windows 2003 Standard.

The query fails both from MySQL Query Browser, and from a C# application issuing the same SELECT via Connector/ODBC version 3.51.10.

How to repeat:
Issue a query like this from MySQL Query Browser, using a LONGTEXT column:

SELECT SUBSTRING(Body,1,100) from item
[6 Jul 2005 4:43] [ name withheld ] 
Actually this has to do with MyODBC and with a more complicated query. I'm going to close this until I get a better handle on it. The problem does not occur with 3.51.10.