Wrong numbers in error message for decreasing char/varchar columns
------------------------------------------------------------------
Key: CORE-3894
URL: http://tracker.firebirdsql.org/browse/CORE-3894
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.1
Environment: Firebird 2.5.1.26351 32bit, Windows 7 64bit Ultimate.
Reporter: kdv
Priority: Minor
Alterting char/varchar columns to lower size produces error
New size specified for column fff must be at least NN characters.
where NN is bytes per character, not character size of field/domain itself.
Example to reproduce (employee):
ALTER TABLE EMPLOYEE ADD UTF VARCHAR(100) CHARACTER SET UTF8;
commit;
ALTER TABLE EMPLOYEE ALTER COLUMN UTF8 TYPE VARCHAR(90);
error message says
This operation is not defined for system tables.
unsuccessful metadata update.
New size specified for column UTF must be at least 400 characters.
where, as you see, 400 is rdb$field_length, not rdb$character_length (100).
So, correct error message must be
New size specified for column UTF must be at least 100 characters.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
