citus icon indicating copy to clipboard operation
citus copied to clipboard

Bug with implicit type casting

Open michailtoksovo opened this issue 7 months ago • 0 comments

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

michailtoksovo avatar Apr 28 '25 06:04 michailtoksovo