citus
citus copied to clipboard
Bug with implicit type casting
create table usertable (id bigserial primary key, value text not null);
-- CREATE TABLE
update usertable set value = 'row' || id;
-- UPDATE 0
select create_distributed_table('usertable', 'id', shard_count := 2);
update usertable set value = 'row' || id;
-- ERROR: STABLE functions used in UPDATE queries cannot be called with column references
update usertable set value = 'row' || id::text;
-- UPDATE 0
select citus_version();
-- Citus 12.1.1 on x86_64-pc-linux-gnu