Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Risingwave doesn't store postgres citext values #18844

Closed
Bulbashful opened this issue Oct 10, 2024 · 0 comments · Fixed by #19103
Closed

Risingwave doesn't store postgres citext values #18844

Bulbashful opened this issue Oct 10, 2024 · 0 comments · Fixed by #19103
Assignees
Labels
type/bug Something isn't working
Milestone

Comments

@Bulbashful
Copy link

Bulbashful commented Oct 10, 2024

Describe the bug

RisingWave stores empty string instead of varchar when using postgrescitext type

Error message/log

rw-streaming actor{otel.name="Actor 14" actor_id=14 prev_epoch=7295910197198848 curr_epoch=7295910262931456}:executor{otel.name="StreamCdcScan E00002715"}: risingwave_connector::parser::postgres: parse column failed column="text" error=error deserializing column 5: cannot convert between the Rust type `core::option::Option<risingwave_connector::parser::scalar_adapter::ScalarAdapter>` and the Postgres type `citext` suppressed_count=3999

To Reproduce

Just use postgres-cdc tables with citext datatypes

Expected behavior

Values have CHARACTER VARYING type

How did you deploy RisingWave?

No response

The version of RisingWave

PostgreSQL 13.14.0-RisingWave-2.0.1 (0d15632)

Additional context

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
3 participants