BUG #18393: Bad multiple "inplace" insert into domain of complex type

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18393: Bad multiple "inplace" insert into domain of complex type
Дата
Msg-id 18393-65fedb1a0de9260d@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18393: Bad multiple "inplace" insert into domain of complex type
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18393
Logged by:          Pablo Kharo
Email address:      pashaharkov@yandex.ru
PostgreSQL version: 16.2
Operating system:   Mac OS 14.1
Description:

Hi, i have found strange thing when was using domain of complex type.

When i was using insert like this to domain of type:
```
CREATE TYPE user_tp AS (
    uid          TEXT,
    email        text,
    timestamp TIMESTAMP
);

create domain user_domain as public.user_tp;

CREATE TABLE comps_tb (
    id      SERIAL PRIMARY KEY,
    us      user_domain NOT NULL
);

insert into public.comps_tb 
(
    us.uid,
    us.email
)
values 
(
    '213'::TEXT, 
    'email'::TEXT
),
(
    '321'::TEXT, 
    'email2'::TEXT
);

select 
    id,
    (us).uid,
    (us).email 
from 
    public.comps_tb;
```

I have output like this:
id|uid    |email     |
--+-------+----------+
 1|(213,,)|(,email,) |
 2|(321,,)|(,email2,)|

But i expecting 
id|uid    |email     |
--+-------+----------+
 1|213|email |
 2|321|email2|


So, it has created additional brackets in uid and email. BUT if i inserting
into this table only one element, it inserts without additional brackets. 
Also additional brackets are not creating when i am using complex type
itself - not domain,


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

Предыдущее
От: Carl Smith
Дата:
Сообщение: Re: BUG #18392: Can't restore database (using pg_restore) after latest Feb 8 update
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: BUG #18392: Can't restore database (using pg_restore) after latest Feb 8 update