Subject | Max length of SQL statement |
---|---|
Author | Stephen Boyd |
Post date | 2007-06-19T20:30:30Z |
Is there a maximum length for an SQL statement inherent in Firebird?
I am working on something right now where I generate a SELECT
statement of the form:
SELECT * FROM SOME_TABLE WHERE THE_KEY IN (...)
where the IN clause can conceivably contain a rather long list of
primary keys to be retrieved.
I am wondering if I am eventually going to run into some limit that
will bite me on the butt using this approach.
I am working on something right now where I generate a SELECT
statement of the form:
SELECT * FROM SOME_TABLE WHERE THE_KEY IN (...)
where the IN clause can conceivably contain a rather long list of
primary keys to be retrieved.
I am wondering if I am eventually going to run into some limit that
will bite me on the butt using this approach.