Problemsby IbisTrouble with ClickHouse null
Databases2 posts from 2 people2d active+00 posts in the last 7 days, 1 the 7 days before (fading)Unverified
Posts per day
The posts behind it
2, newest firstORDER BY elided after sort through negate, wrong NaN/NULL placement### Describe what's wrong - An outer ORDER BY over a sorted subquery seen through a decreasing function like `negate` gets elided instead of applied. - Triggered by an inner `ORDER BY ... LIMIT` subquery negated and wrapped in an outer ORDER BY with matching NULLS spelling, at...ClickHouse/ClickHouse · clickgapaiOpen ↗Wrong results: `variantElement` over a `Merge` table returns `NULL` unless it is in the top-level projection...`multiIf` into a subquery projection and filtering on its alias in the outer query is a workaround and produces the documented rows. Related: https://github.com/ClickHouse/ClickHouse/issues/121166ClickHouse/ClickHouse · alexey-milovidovOpen ↗
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 24 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about ClickHouse with no known issue, sharing the word "null". First post Sep 21, 2026, latest Oct 14, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other ClickHouse problems
ClickHouse upgrades break working setupsTrouble with ClickHouse jsonClickHouse costs outgrow the value it givesClickHouse users keep filing bugsTrouble with ClickHouse columnTrouble with ClickHouse rowsExperiments on ClickHouse are hard to reproduce and trackTrouble with ClickHouse joinTrouble with ClickHouse nameTrouble with ClickHouse readClickHouse error messages are crypticTrouble with ClickHouse constant
History
steady to fading
Trouble with ClickHouse null (2 posts)