citusdata / citusdata/citus

citus_stat_tenants might treat the same numeric value differently

Open
#6,849 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.