Truthound · Schema and type contracts · 4/6
Preserve field names, types and key semantics across versions.
119 articles
Declare timestamp precision before a DuckDB Parquet glob chooses it
Compare actual timestamp values when changing the first file in a glob. An output dtype alone can make already-rounded timestamps appear acceptable.
Compare DuckDB DESCRIBE aliases with actual output headers
For a quoted alias, compare DESCRIBE names with execution headers while preserving case. Lowercasing during extraction can erase a schema discrepancy that changes the consumer contract.
Choose the survivor before relying on DuckDB INSERT OR IGNORE
For a batch with intersecting UNIQUE constraints, successful insertion leaves the winner question open. Define the survivor policy first, then approve INSERT OR IGNORE against the selected key set.
Restore expression objects before accepting a DuckDB export as recoverable
Restore schemas containing COLLATE and subscripts into a separate database. Distinguishing export completion, SQL parse success, and restored values identifies the first failing recovery boundary.
Check Doris VARIANT field presence when UTC Z parsing depends on aliases
After loading a Zulu timestamp, check presence and non-null state at the typed VARIANT path even if the row succeeded. Record the BE conversion context without treating later host state or a compaction observation as proof of cause.
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.
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.
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.
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.
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.
After a Trino Iceberg type promotion, is an unfiltered SELECT enough?
Schema-transition readiness requires both the unfiltered read and the filter paths actually used by consumers.
Two active SCD rows in Trino? Inspect non-key statistics in the delete file
Pruning an equality-delete file using payload-field statistics can leave an old version active beside its replacement.
RisingWave materialized-view NULL updates: compare missingness states explicitly
Changing a value to NULL is a state transition to preserve, not the absence of an update.
RisingWave CDC name collisions: verify live routing separately from backfill
A topic name normalized from special characters may not uniquely identify its original source table.
Polars strict struct casts: check field sets and order instead of success alone
Do not assume strict rejects the same schema changes on every path. Compare the actual nested structure.
Polars row-oriented Boolean conversion: should raw 2 become false?
Validate the allowed raw integers and conversion policy, not just the final Boolean dtype.
