> SQL> select cast(0 as char(32000)) || cast(1 as char(32000))
> || cast(1 as
> char(4000)) from rdb$database;
> ================
> ²²²²²²²²²²²²²²²²
> [snip]
> ²²²²²²²²²²²²²²²²
> Statement failed, SQLCODE = -901
> connection lost to database
>
> Oh [red face], my example was extreme, I broke the engine! Do you want
> another item for the bug tracker, Sean? <g>

_Gee, just for me? Thanks Claudio!_

Any suggestions for a description for the problem?

> What I wanted to demonstrate what this:
>
> SQL> create table cc(a char(30000));
> SQL> select a,a from cc; => 60000, ok
> SQL> select a,a,a from cc; => see this, it is 90000.
> Statement failed, SQLCODE = -104
>
> invalid request BLR at offset 38
> -Implementation limit exceeded
> -block size exceeds implementation restriction

Very interesting!

I'll log both to the bug tracker.

One question though, why does returning 68,000 break the engine but
returning 90,000 result in an error (without breaking the engine).


Sean