At 12:47 PM 11-10-01 +0000, Martin Lunt wrote:
[...]

>The problem may well have been there in earlier versions
>of Interbase but with generator values being 32bit the limit was
>higher. If the database page size is 1024 this seems to imply a
>generator limit of a little over 100. A larger page size helps but
>is not the ideal solution. Firebird release 0.9.4 seems to have this
>problem fixed.

Martin,
Thanks for reminding me, I need to include that bug fix in the FB release notes...and also Ann Harrison's table that shows the page size you need to set according to your likely requirement for generators.

fwiw, thanks to our clever Claudio, the latest (and future) Firebird builds won't let you have queries with ambiguous join, group by or order by criteria. In the past, InterBase has let you be sloppy about this, with unexpected (or worse, undetected) wrong results in output.

If you are planning to upgrade from Borland Interbase to World Firebird, it would be a good idea to clean up your SQL on the way. IBConsole and IBAdmin have apparently already fallen prey to this, with ambiguous SQL showing up in system table queries...

(If you want to know what bugs to expect in InterBase, it's always worth a visit to the Firebird bug list.)

:)

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________