--- In ib-support@y..., "Claudio Valderrama C." <cvalde@u...> wrote:

> The check is made at compile time, do you understand that? The

engine needs

> to know in advance if it has enough legal buffer to answer and this

is the

> maximum possible value. This is the second time I write about the

largest

> possible value at COMPILATION TIME.

Claudio, why not to use maximum possible size of buffer at
compilation time if sum of data declarations exceed it? And check
overflow on execution time by real data size? Note that FB allows to
have in table chars in size more than declared (after alter column to
less size). If concentrate on declarations only, what will occure on
execution time? Will such a table became unusable? And what about

create table t (a varchar(10), b varchar(20))

insert into t (a,b) values ('1234567890', '0987654321')

update t set a = b

shouldn't it work? Declaration of B is greater than declaration of A.

Best reagrds, Alexander V.Nevsky.