Weirdness in CHECK?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Weirdness in CHECK?
Дата
Msg-id NEBBIOAJBMEENKACLNPCOEMNCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Weirdness in CHECK?
Список pgsql-hackers
I just ran across this recent example:

If you perform the following, you get a truncated input:

test=# create table example (type char(5) NOT NULL);
CREATE
test=# insert into example VALUES ('VOLUME');
INSERT 156884 1
test=# select * from example;type
-------VOLUM
(1 row)

However, if you add CHECK in that checks for a string that is LONGER than
the CHAR(5), you get this:

test=# create table example(type char(5) NOT NULL CHECK (type IN
('MASS','VOLUME')));
CREATE
test=# insert into example VALUES ('VOLUME');
ERROR:  ExecAppend: rejected due to CHECK constraint example_type

Is this correct behaviour?  Perhaps it is, as CHECK is checking the
truncated value - but I just want to make sure it's not a bug!

Chris



В списке pgsql-hackers по дате отправления: