Truthound · All articles · 16/24
Evidence-led Truthound Core guidance on data contracts, check inputs and operational limits.
480 articles
Establish the authority of Doris DETAIL before images
Reconcile a DETAIL changelog's before value with independent historical evidence before using it for retractions. Retain history settings and the update path without presenting source analysis as an observed execution.
Use an independent rounding reference for Doris DECIMAL casts
Build a decimal-cast reference with an independent parser reading directly into the target type. An intermediate DOUBLE or a shortened display can conceal a second rounding step on the FLOAT path.
Preserve OFFSET semantics through a wrapped Doris correlated subquery
Reconcile parent keys for the correlated OFFSET case using the reachable wrapper and exact build. An analyzer rejection of the top-level query is not a reproduction of an incorrect result.
Include newly cloned Doris replicas in a binlog TTL transition
After extending binlog retention, check whether replicas cloned during the transition received the new TTL. Record the policy generation alongside current serving membership to find replicas outside the original completion responses.
Require an explicit Doris auto-partition RPC status
Do not fill an absent wire status with default OK in an automatic-partition response. Check for an explicit response and then visible keys in the new partition as separate completion boundaries.
Align the Doris ANALYZE count and load-counter baseline
Align the COUNT snapshot and load-counter generation before adding a load delta to ANALYZE statistics. A race in the estimate does not establish duplicated stored rows.
Inspect nullable and comment metadata when Delta inventory schemas are rejected
Investigate a VACUUM inventory rejection by separating dtype mismatches from field metadata differences such as nullability and comments. Preserve the original schema and keep DRY RUN review separate from deletion approval.
Follow the corrected Unity Catalog URI contract for literal percent paths
Check percent-bearing locations by distinguishing URI text from the storage key it represents. Follow the correction toward UC's input and output boundary instead of repeating the withdrawn Delta fix as a remedy.
Avoid counting a Delta AddFile re-add as storage growth
For metadata-only re-adds, reconcile CRC values against active state that preserves file identity rather than counting actions.
Preserve mixed-case Hadoop option keys through Delta DataFrame maps
Link each case-sensitive Hadoop option key to its effective Configuration lookup. A forwarded string alone cannot establish that the I/O setting took effect; keep credential values out of the record.
Use full physical paths when protecting Delta clustering fields
Do not treat matching leaf names in different structs as the same clustering column. Resolve the deletion target's full physical path and field ID to investigate a false rejection while preserving the column that actually needs protection.
Check Delta checkpoint actions even when Parquet parses
A readable Parquet file can still be the output of a failed checkpoint write. Check actual protocol and metaData actions against the source log range before approving the candidate.
Keep Delta partition-filter casts consistent with scan values under ANSI
Apply the same parsing policy to malformed partition strings in full-scan and filtered paths. Preserve raw values and ANSI settings so a cast error stays distinct from a valid empty result.
Check UTC rendering separately from ClickHouse view timestamp identity
Check the text contract of a UTC view separately from epoch preservation. Recording the actual session timezone with output text tests the consumer requirement without mistaking a display difference for a shifted instant.
Reject invalid unsigned nested input before ClickHouse defaults hide it
Type compatibility cannot approve a nested unsigned array when negative input was replaced by an empty array. Link raw input to the rejection policy and retain the scope of any lost valid siblings.
Preserve session temporary-table binding when ClickHouse restores a view
Recheck the actual namespace binding of a view referencing a temporary table in a new session after restart. Prior-session success cannot approve the restored reference; value and isolation checks remain subsequent steps.
Test ClickHouse result limits against queries without FROM
Compare actual result rows with the approved cap even when a query omits FROM. This delivery check detects oversized results but cannot undo resources already consumed or replace server-side enforcement.
Preserve untargeted Nested siblings during ClickHouse TTL mutation
After a Nested-field TTL, reconcile sibling arrays outside the intended mutation scope. Check that required business values survived separately from CHECK TABLE success before allowing further mutations.
Preserve the kind of nonfinite value after ClickHouse rounding
A finite check cannot distinguish NaN from infinity after rounding. Retain input and output class tags to preserve the difference between an indeterminate calculation and an infinite magnitude.
Preserve JSON object boundaries when checking ClickHouse distinct results
Use structural controls to check whether distinct merges JSON documents with different object boundaries. If comparison tokens stand in for documents, define key ordering and NULL semantics before accepting the count.
