with as select insert - queries use incorrect sequence

[cimerren]

Hi, we are using citus in schema based sharding and are experiencing strange behavior when running the following query:

set citus.enable_schema_based_sharding to on;

create schema citus_test;

SET search_path = citus_test, public;
create table version (
	id bigserial not null,
	description varchar(255),
	primary key (id)
);

insert into version (description) values ('Version 1');

with v as (
	select * from version where description = 'Version 1'
)
insert into 
version (description) 
select description
from v;

select * from citus_test.version;

Expected:

id	description
1	Version 1
2	Version 1

Actual:

id	description
1	Version 1
562949953421313	Version 1

I found the following issue: 6798, and from the values it looks like it could be related.