Skip to content

Fix QuestDB ingress errors for Python conversions without converted_type#2849

Merged
ryanmelt merged 1 commit intomainfrom
tsdb_errors
Feb 19, 2026
Merged

Fix QuestDB ingress errors for Python conversions without converted_type#2849
ryanmelt merged 1 commit intomainfrom
tsdb_errors

Conversation

@jmthomas
Copy link
Copy Markdown
Member

Three bugs fixed:

  • __C columns from read_conversions with no converted_type (e.g. user Python conversions) were created as VARCHAR but not tracked in json_columns, causing INTEGER-to-VARCHAR cast errors on every row
  • Table reconciliation on plugin reload issued unnecessary ALTER for DECIMAL columns due to whitespace mismatch ("DECIMAL(20, 0)" vs "DECIMAL(20,0)")
  • handle_ingress_error cast values for VARCHAR columns but didn't persist the tracking, so the same error fired on every subsequent row

Replaced QUESTDB_TYPE_MAP dict with _canonical_type() that normalizes via uppercase + whitespace stripping, preserving parameterized type identity.

Three bugs fixed:
- __C columns from read_conversions with no converted_type (e.g. user Python
  conversions) were created as VARCHAR but not tracked in json_columns, causing
  INTEGER-to-VARCHAR cast errors on every row
- Table reconciliation on plugin reload issued unnecessary ALTER for DECIMAL
  columns due to whitespace mismatch ("DECIMAL(20, 0)" vs "DECIMAL(20,0)")
- handle_ingress_error cast values for VARCHAR columns but didn't persist the
  tracking, so the same error fired on every subsequent row

Replaced QUESTDB_TYPE_MAP dict with _canonical_type() that normalizes via
uppercase + whitespace stripping, preserving parameterized type identity.

Co-Authored-By: Claude Opus 4.6 <[email protected]>
@codecov
Copy link
Copy Markdown

codecov bot commented Feb 18, 2026

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 78.69%. Comparing base (a06e0c1) to head (670871d).
⚠️ Report is 30 commits behind head on main.

Additional details and impacted files
@@            Coverage Diff             @@
##             main    #2849      +/-   ##
==========================================
+ Coverage   78.66%   78.69%   +0.03%     
==========================================
  Files         667      667              
  Lines       54458    54465       +7     
  Branches      731      731              
==========================================
+ Hits        42837    42859      +22     
+ Misses      11541    11526      -15     
  Partials       80       80              
Flag Coverage Δ
python 80.66% <ø> (+0.08%) ⬆️
ruby-api 80.22% <ø> (-0.05%) ⬇️
ruby-backend 82.00% <ø> (+<0.01%) ⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

@sonarqubecloud
Copy link
Copy Markdown

Quality Gate Failed Quality Gate failed

Failed conditions
1 New issue
14.2% Duplication on New Code (required ≤ 3%)

See analysis details on SonarQube Cloud

Catch issues before they fail your Quality Gate with our IDE extension SonarQube for IDE

@ryanmelt ryanmelt merged commit d2cf097 into main Feb 19, 2026
31 of 33 checks passed
@ryanmelt ryanmelt deleted the tsdb_errors branch February 19, 2026 05:01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants