citus_stat_tenants might treat the same numeric value differently
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
```SQL
CREATE TABLE simple_test (a numeric, b numeric);
SELECT create_distributed_table('simple_test', 'a');
SELECT citus_stat_tenants_reset();
-- 2 and 2.0 are actually the same value/tenant
insert into simple_test VALUES (2,2);
insert into simple_test VALUES (2.0,2.0);
SELECT count(*) FROM simple_test WHERE a = 2;
count
-------
2
(1 row)
SELECT count(*) FROM simple_test WHERE a = 2.0;
count
-------
2
(1 row
-- but citus_stat_tenants seems to treat them differently
select nodeid,colocation_id,tenant_attribute,query_count_in_this_period from citus_stat_tenants;
nodeid | colocation_id | tenant_attribute | query_count_in_this_period
--------+---------------+------------------+----------------------------
2 | 1 | 2 | 3
2 | 1 | 2.0 | 2
(2 rows)
```
Contributor guide
Assessment
This issue has not been assessed yet.