> 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).
>
> -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.
Why did you upgrade the server then?
Do you expect applications to continue working while you upgrade
underlying servers?
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
> >
> >
> > 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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
