Well, with full disclosure, the ONLY thing you can do without changing the code is to modify the table.
However, if you modify it, any of the "large int" (BIGINT? large int is not a value in MySQL) values will be truncated to the largest int value (4294967295). Caveat emptor! -Sheeri On 2/6/06, C.F. Scheidecker Antunes <[EMAIL PROTECTED]> wrote: > The problem is that I do not have access to the code. It is an old Delphi > 5.0 app. > The code expects an Integer but receives a large int. So it throws an > exception. > > > > sheeri kritzer wrote: > Can you show us the results of > > SHOW CREATE TABLE tbl_nada; > > preferably for the system as it was before, if you have backups from > then, and for how it is now. I would guess that your table type > changed, or perhaps indexing did. > > What do you mean by "crashes"? What's the error message from the > application? > > How did you upgrade? did you put it on a new machine? recompile the > source code? use a packaged binary? > > -Sheeri > > On 2/5/06, C.F. Scheidecker Antunes <[EMAIL PROTECTED]> wrote: > > > Hello all, > > 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? > > It is a Fecora Core 4 Linux box with MySQL 4.1.16 > > I have two options: going back to a 4.0.20 server or fixing 4.1.16 somehow. > > Any better suggestions on how to address this issue? > > Thanks, > > C.F. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
