Re: [Firebird-devel] unsuccessful metadata update...

[Helen B. <he...@tp...>]

At 04:02 PM 10-10-02 +0200, Arno Brinkman wrote:
>Hi,
>
>The problem i had before with creating constraints doesn't exists anymore
>after a complete new tree checkout. I have no idea what was the problem :(.
>
>Another unsuccessful metadata update issue :
>I hope this is reproducable for others.
>
>
>Create DATABASE, page size 4096, characterset ISO8859_1
>
>
>CREATE TABLE LICENSES (
>   ID CHAR(8) NOT NULL PRIMARY KEY,
>   DESCRIPTION VARCHAR(30)
>)
>
>Try to alter the column DESCRIPTION :
>
>ALTER TABLE LICENSES
>   ALTER DESCRIPTION TYPE VarChar(50)
>
>Error result :
>unsuccessful metadata update New size specified for column DESCRIPTION must
>be at least 30 characters.

It looks like two bugs, not one.
First, it's wrongly assuming ISO8859_1 is multi-byte and then it is 
offering the wrong advice on the supposed error.  Surely the error text 
should say "...at least <number> bytes", depending on the number of bytes 
it wants, not the number of characters?

Of course, the first assumption could be all wrong:  could be just a 
variable not getting initialised or set, evaluating NULL against <number> 
and coming up with false (=wrong number of characters).

Helen