Firebird SQL Script command string limitation

Question

Does anybody know, if there is a command string size limitation in Firebird?

When executing a small "insert" script it works perfectly, but when the script has a lot of lines it returns the following errer: "Unexpected end of command - line X, column Y".

Interessting, the line and column number varies dependanding on the actual script size.

I'm using Firebird 2.5

Here is the executing script:

set term ^ ;
EXECUTE BLOCK AS BEGIN
insert into TABLE (COLUMNA) values (13);
...
insert into TABLE (COLUMNA) values (14);
END^
set term ; ^

why embed them to the block, instead of passing each after another. Logical data granularity should be mantained by transactions and savepoints — Arioch 'The
– Arioch 'The, Commented Jan 22, 2013 at 9:19
Oh ... I think I had some errors in my thoughts. I just changed it. — markus_ja
– markus_ja, Commented Jan 22, 2013 at 10:00

Mark Rotteveel · Accepted Answer · 2017-01-08 08:37:44Z

8

Firebird 2.5 and earlier have a limitation of 64 kilobytes for the query text, for Firebird 3.0 this limit was increased to 10 MB when the new API is used. An EXECUTE BLOCK is one query, so it should not exceed 64 kilobyte.

edited Jan 8, 2017 at 8:37

answered Jan 22, 2013 at 9:26

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Arioch 'The Over a year ago

but he perhaps can overcome it by internal gbak-insert batch command

cincura.net Over a year ago

And the 64kB BLR and 48kB plan, which is mentioned in your link as well.

Collectives™ on Stack Overflow

Firebird SQL Script command string limitation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related