search

paradedb / pg_analytics

DuckDB-powered analytics for Postgres
https://paradedb.com
PostgreSQL License
197 stars 13 forks source link

fix: Json & JsonB cast support #33

Closed evanxg852000 closed 1 month ago

evanxg852000 commented 2 months ago

Ticket(s) Closed

What

As reported by the issue, queries involving JSON & JSONB conversion are not supported.

SELECT "varchar_column"::JSON FROM predictions;

Why

The DataType::Utf8 and DataType::LargeUtf8 were not handled for JSONBOID and JSONOID.

How

Modified supabase-wrappers to have separate cell types for Json and JsonB. Then mapped them in cell.rs.

Tests

Added a basic test See tests in tests/json.rs

CLAassistant commented 2 months ago

CLA assistant check
All committers have signed the CLA.

philippemnoel commented 2 months ago

Drafting until someone picks it up