Home » Performance » MySQL » mysql 5.0.24 returns long instead of integer
mysql 5.0.24 returns long instead of integer [message #531] Thu, 04 January 2007 00:28 Go to next message
prdpjohn  is currently offline prdpjohn
Messages: 5
Registered: November 2006
Junior Member
we are upgrading our database from mysql 4.0.18 to mysql 5.0.24.
everything went smoothly except some reports gives class cast exception. we have tomcat 4.1 installed on mandriva 2007. it's observed that some resultsets which normaly returns Integer returns Long now and hence the complication.

we tried with connector mysql-connector-java-5.0.4-bin.jar but no improvment.

cany some body help pls.

thanks in advance.

Pradeep John.

Re: mysql 5.0.24 returns long instead of integer [message #532 is a reply to message #531 ] Thu, 04 January 2007 04:38 Go to previous message
Peter  is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
I would suggest you to

1) come up with repeatable test case which shows the different result in 5.0 vs 4.1

2) It may help to report it as a bug on bugs.mysql.com - if it is considered the bug it will be fixed, if not Mark will likely explain you why it is not.


Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Previous Topic:MySQL Replication
Next Topic:Sphinx and Mysql, Join problems!
Goto Forum:
  


Current Time: Fri Jul 10 01:42:48 EDT 2009

Total time taken to generate the page: 0.01176 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.