I have just created 2 little test-databases, one with 4K pagesize and one with
8K and the error is reproducable. If someone is interested, I will send you the
db's.


Guido

"Claudio Valderrama C." wrote:

> <guido.klapperich@...> wrote in message
> news:3C7D1DA6.B93DD636@......
> > I'm using IB 6.02 on W2K, I have a db and I run the following query
> > select S.SAID from SALESAREAS S,DOS_CONSTANTS D where D.NAME=S.SANAME
> > and D.SHORTCUT=80
> > and I get the result SAID=6
>
> Are SALESAREAS and DOS_CONSTANTS views?
> Is there any difference if you try the other syntax?
>
> select S.SAID from SALESAREAS S
> JOIN DOS_CONSTANTS D ON D.NAME=S.SANAME
> WHERE D.SHORTCUT=80
>
> > The db has the pagesize 4K.
> > Now I backup the db and restore it with 8K pagesize. I run the SAME
> > query as above and I get
> > Overflow occurred during data type conversion
>
> Hmm, you are finding too much bugs, someone should take care of you.
> :-)
>
> > Conversion error from string "".
>
> This is a flawed message. First, it means
> Conversion error to string ""
> The engine is trying to squeeze some value that you can't see into a field
> whose value is a constant string of length one, defined statically for all
> threads. This field is a placeholder to indicate special conditions inside
> the engine, like a null flag indicator or a dummy field in an outer join. By
> the time you get that message, the engine is trashed and this variable no
> longer serves its purpose, because it has a value different from the
> original one-blank character. (And if this is a null indicator, it will be
> considered as if the field to which it applies is always null). The only way
> to clear memory is to restart the engine. I didn't noticed the danger until
> I stepped with the debugger. I changed the message to be
> Conversion error from <source_string>
> At least you know which is the value that couldn't be copied for lack of
> space.
>
> What is the definition of S.SAID? If SALESAREA is a view, is the field
> indexed in the base table?
>
> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase® WebRing
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/