Is there some sort of bug in the naming of not null constraints in Vertica? If I create a table with 5 columns making them all not null, the constraint name for each column is the same. I would expect 5 different names.
Code: Select all
dbadmin=> create table tab1 (a int not null, b int not null, c int not null, d int not null, e int not null);
CREATE TABLE
dbadmin=> select column_name, constraint_name, constraint_type from v_catalog.constraint_columns where table_name = 'tab1';
column_name | constraint_name | constraint_type
-------------+-----------------+-----------------
a | C_NOTNULL | n
b | C_NOTNULL | n
c | C_NOTNULL | n
d | C_NOTNULL | n
e | C_NOTNULL | n
(5 rows)