> 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).
> On 2/6/06, C.F. Scheidecker Antunes <nando@stripped> wrote:
> > The problem is that I do not have access to the code. It is an old
> > 5.0 app.
> > The code expects an Integer but receives a large int. So it throws an
> > exception.
Why did you upgrade the server then?
Do you expect applications to continue working while you upgrade
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!
> > 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 <nando@stripped> 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
> > Any better suggestions on how to address this issue?