search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.83k stars 852 forks source link

show_chunks() segfaults on hypertables with closed primary dimension #6979

Closed svenklemm closed 2 weeks ago

svenklemm commented 1 month ago

To reproduce:

CREATE TABLE test_by_hash(id BIGINT, value float8);
SELECT create_hypertable('test_by_hash', by_hash('id', 8));
INSERT INTO test_by_hash VALUES (1, 1.0), (2, 2.0), (3, 3.0);
SELECT show_chunks('test_by_hash');
nikkhils commented 2 weeks ago

We now disallow hash for primary partitioning in create table. So this won't happen. Closing.