Result +1 >= bug still here

ben · Post by **ben** » Tue 11 Apr 2006 08:58

I downloaded the 5.0.20 version which corrects the return length bug, but still MYDac says Result + 1 >= MaxDestBytes.

Whats wrong? Maybe its not MYSQL bug after all? Maybe you have to fix sth?

Antaeus · Post by **Antaeus** » Tue 11 Apr 2006 09:52

Please specify some things:
- what is the query you try to execute
- what is the script to create and fill table(s)

ben · Post by **ben** » Tue 11 Apr 2006 11:53

this line is more than enough to reproduce the problem:

SELECT DATE_FORMAT('2006-01-01', '%m %Y')

Antaeus · Post by **Antaeus** » Tue 11 Apr 2006 12:24

> I downloaded the 5.0.20 version
Please let us know where did you download MySQL Server 5.0.20. We can't find this version on the http://dev.mysql.com/downloads/mysql/5.0.html.

> Maybe you have to fix sth?
We will try to avoid this bug for all MySQL server versions in the nearest build.

ben · Post by **ben** » Tue 11 Apr 2006 14:44

Pick a mirror here:

http://dev.mysql.com/get/Downloads/MySQ ... /from/pick

its the full version, ZIP, of the 37mb

Please fix it asap. I just cant release my software without this fix. Other softwares such as Navicat, MySQLFront, PhpAdmin works well with this function. Only MyDAC fails.

GEswin · Post by **GEswin** » Tue 11 Apr 2006 21:07

This version isn't still officially announced. Even when i go to download i still see only 5.0.19 as latest release.

ben · Post by **ben** » Wed 12 Apr 2006 09:12

What does it means? This is the 5.0.20 and this is the changelog:

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-20.html

and the bug fixed:

The FORMAT() function returned an incorrect result when the client's character_set_connection value was utf8. (Bug #16678)

The 5.0.21 is the under-release version.

If you are registered member of MySQL you will would have seen the announcement in the mailing list.

In anycase there are ways to fix the bug even in the old 5.0.19 as other software(s) bypass this error.

GEswin · Post by **GEswin** » Wed 12 Apr 2006 22:42

I received today letter from mysql announcing new version, and also today i see it on their webpage & mirrors.. Yesterday i couldn't see it anywhere (even after refreshing pages from cache).

ben · Post by **ben** » Thu 13 Apr 2006 07:46

Very nice. Now, we all see 5.0.20 official released.
Antaeus, any news?

Antaeus · Post by **Antaeus** » Thu 13 Apr 2006 09:19

We have tested MySQL server 5.0.20. The error you have reported is present in this release of MySQL server too. Please pay attention on "Changes in release 5.0.20":

The FORMAT() function returned an incorrect result when the client's character_set_connection value was utf8. (Bug #16678)

As we can see after our test, in the new server release FORMAT() function works fine but not DATE_FORMAT().
We have found the way to avoid this server bug. This fix will be included in the next MyDAC build.

ben · Post by **ben** » Thu 13 Apr 2006 10:52

can you release it asap? Today or tomorrow? Please!
I cant release my software without this fix. Or please email me the compiled for delphi 7 DCU file via email?

Antaeus · Post by **Antaeus** » Thu 13 Apr 2006 13:23

The new build of MyDAC will be available in the nearest few days. Please watch for announcements at the forum http://crlab.com/forums/viewforum.php?f=7.

GEswin · Post by **GEswin** » Sat 22 Apr 2006 09:08

ben, check out to update to 5.0.20a , 5.0.20 looks like an unintented release and has some leaks.

ben · Post by **ben** » Sun 23 Apr 2006 20:57

thanks