Comments (3)
I am kind of confused why you have this filter in the subquery since you have the exact same filter in the top query
AND kendat.kind = 179
Removing that resolves the issue, does that give you the expected results? I tried this on your repro case and get no rows returned.
from timescaledb.
You are right, this filter is useless and can be omitted. Query is successful without this filter, thank you.
Still, it is unexpected that timescaledb results in an error here with valid SQL syntax where PostgreSQL does not. Therefore I consider this as a bug.
from timescaledb.
I'd agree, will put it on the backlog.
Thanks you for your report!
from timescaledb.
Related Issues (20)
- [Bug]: pg_dump generates truncate only for hypertables which fails during pg_restore HOT 8
- [Enhancement]: Refactor decompress_batches functions
- [Bug]: Could not create hypertable with the same name for more than one schema HOT 2
- [Bug]: Unable to use docker image with CloudNativePG HOT 1
- [Feature]: reset c_agg watermark for tests
- [Feature]: support interpolated_average in continuous aggregates
- [Bug]: ERROR: unrecognized parameter namespace "timescaledb" when executing example code HOT 3
- Refactor to use full include path
- [Bug]: pg_restore failed with No function matches the given name and argument types. You might need to add explicit type casts. HOT 4
- [Enhancement]: Improve messages when picking default compression settings
- [Bug]: Error loading shared library libssl.so.1.1 with timescale/timescaledb:2.15.3-pg14 HOT 3
- [Bug]: querying data in large compressed chunks blows up disk usage HOT 2
- [Bug]: The timezone is incorrect. HOT 1
- [Bug]: `drop_chunk()` fails when there is an FK referencing a hypertable
- [Bug]: Creating a foreign key referencing a tiered hypertable causes assertion failure
- [Bug]: `migrate_data` option does not create indexes on initial chunks HOT 2
- [Enhancement]: Clarify 2.15.0+ release notes requirement HOT 1
- [Bug]: Error loading shared library libssl.so.1.1 HOT 1
- [Bug]: Timescale license presents itself as apache version even if timescale version is activaded
- [Feature]: Sliding window cagg aggregation
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from timescaledb.