It's possible to insert bigger data to table field than it's defined size. --------------------------------------------------------------------------
Key: CORE-3669 URL: http://tracker.firebirdsql.org/browse/CORE-3669 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.1 Reporter: Attila Molnár Hi! It's possible to insert bigger data to table field than it's defined size. The bigger data is readed back correctly, not truncated. CREATE TABLE test ( NAME VARCHAR(30) NOT NULL ) --30 character : works, this is expected (OK) INSERT INTO test (NAME) VALUES ('012345678901234567890123456789'); --31 character : works (!), error expected (NO) INSERT INTO test (NAME) VALUES ('0123456789012345678901234567890'); --32 character : error, error expected (OK) INSERT INTO test (NAME) VALUES ('01234567890123456789012345678901'); -- 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 ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel