Submitted by: Attila Molnár (e_pluribus_unum)

Duplicates CORE3373

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');