RisingWave Community - Does sending invalid JSON to a JSONB column affect all messages in the queue or just the one being sent?

troubleshooting

Does sending invalid JSON to a JSONB column affect all messages in the queue or just the one being sent?

Matan Perelmuter is asking about the impact of sending invalid JSON to a column with JSONB type in a database queue. Tao Wu confirms the behavior and provides additional insights.

Ma

Matan Perelmuter

Asked on Jul 31, 2023

By default, only the message with invalid JSON is skipped when sent to a JSONB column.
The JSONB column in Postgres may still accept the invalid JSON value, treating it as a legal value.
Rust's JSON parser and external JSON viewers may also interpret the invalid JSON as valid.

Jul 31, 2023Edited by