Menu

#69 9.5 Beta does not honour ON CONFLICT for replicated tables

Undecided
open
nobody
None
None
None
nobody
2016-03-09
2016-03-09
No

If you create 2 tables

CREATE TABLE control.log_data2 (
log_filename character varying(70) NOT NULL,
idbusiness_entity integer DEFAULT 0 NOT NULL,
loaded character(1) DEFAULT 'n'::bpchar NOT NULL,
row_count integer DEFAULT 0 NOT NULL,
log_date date DEFAULT '1970-01-01'::date NOT NULL,
load_attempts smallint DEFAULT '0'::smallint,
file_size integer DEFAULT 0 NOT NULL,
PRIMARY KEY (log_filename)
)
DISTRIBUTE BY REPLICATION;

CREATE TABLE control.log_data3 (
log_filename character varying(70) NOT NULL,
idbusiness_entity integer DEFAULT 0 NOT NULL,
loaded character(1) DEFAULT 'n'::bpchar NOT NULL,
row_count integer DEFAULT 0 NOT NULL,
log_date date DEFAULT '1970-01-01'::date NOT NULL,
load_attempts smallint DEFAULT '0'::smallint,
file_size integer DEFAULT 0 NOT NULL,
PRIMARY KEY (log_filename)
)
DISTRIBUTE BY HASH(log_filename);

INSERT INTO control.log_data2 (log_filename) VALUES ('test') ON CONFLICT DO NOTHING;

INSERT INTO control.log_data3 (log_filename) VALUES ('test') ON CONFLICT DO NOTHING;

On the first table you never get any rows ??
The second table works fine, surly this should not happen?
Running 9.5rc on Centos 7

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.