Subject Re: [ib-support] Limits of firebird/interbase
Author Paul Reeves
Carlos G.A. wrote:
> Hello:
> I want to know the next limits of firebird/interbase:
> -Max number of columns in a select statement
> -Max number of columns in the order by clausule
> -Max number of columns in the group by clausule
> -Max length of a statment.

I don't know the answer to these questions. There probably are limits
somewhere but they are not documented. In any case, practical limits are
likely to be lower than the real limits. We should probably make some
reasonable guesses.

> -Max length of a caracter literal name

If we are talking about the max size of metadata objects (tablenames,
column names) it is 31.

If you mean aliases for column names in select statements, it is also 31.

BTW, I noticed in IscDBC.h that you have defined MAX_BLOB_LENGTH as 2Gb.
In fact, the length is dependant upon page size. These are the actual

1Kb - 64Mb
2Kb - 512Mb
4Kb - 4Gb
8Kb - 32Gb
16Kb - 256Gb

I doubt if anyone has yet tested the latter. Anyway, we should probably
continue this in firebird-odbc-devel.


Paul Reeves
Supporting users of Firebird and InterBase