Hi, > I was running a legacy app on a MySQL 4.0.20 server. > The app queried the server like this "SELECT count(total) as total from > tbl_nada" > > For 4.0.20 the result of this query was an integer. > > Running the same query on 4.1.16 returns a much larger Integer and the > app crashes. > > Problem is that I CANNOT change the app. > > Is there any configuration that you can do to this server so that it > treats the query as it was before?
And then what? If the value itself is larger than an Integer, what are you expecting to get? Silently truncate the value to fit inside an integer? How would that make your app any better? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
