BUG #13675: Problem statement “INSERT ON CONFLICT WHERE"
От | nmgjinan@126.com |
---|---|
Тема | BUG #13675: Problem statement “INSERT ON CONFLICT WHERE" |
Дата | |
Msg-id | 20151013014209.2784.48073@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #13675: Problem statement “INSERT ON CONFLICT WHERE"
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 13675 Logged by: nmgjinan Email address: nmgjinan@126.com PostgreSQL version: 9.5beta1 Operating system: CentOS release 5.6 32bit Description: Hi,I'm testing pg9.5 beta1, encounter a problem, detailed description: postgres=# create table distributors(did int primary key,dname varchar,is_active boolean); CREATE TABLE postgres=# insert into distributors values(1,'hyl',false),(2,'aaa',true); INSERT 0 2 postgres=# select * from distributors ; did | dname | is_active -----+-------+----------- 1 | hyl | f 2 | aaa | t (2 rows) postgres=# insert into distributors values (2,'bbb') postgres-# on conflict (did) where is_active do update set dname=EXCLUDED.dname; INSERT 0 1 postgres=# select * from distributors ; did | dname | is_active -----+-------+----------- 1 | hyl | f 2 | bbb | t (2 rows) postgres=# insert into distributors values (1,'hgdb') postgres-# on conflict (did) where is_active do update set dname=EXCLUDED.dname; INSERT 0 1 postgres=# select * from distributors ; did | dname | is_active -----+-------+----------- 2 | bbb | t 1 | hgdb | f (2 rows) postgres=# Why, when the where condition is true or false, the fields are change?
В списке pgsql-bugs по дате отправления: