risingwave_expr_impl/scalar/
jsonb_info.rs

1// Copyright 2025 RisingWave Labs
2//
3// Licensed under the Apache License, Version 2.0 (the "License");
4// you may not use this file except in compliance with the License.
5// You may obtain a copy of the License at
6//
7//     http://www.apache.org/licenses/LICENSE-2.0
8//
9// Unless required by applicable law or agreed to in writing, software
10// distributed under the License is distributed on an "AS IS" BASIS,
11// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12// See the License for the specific language governing permissions and
13// limitations under the License.
14
15use std::fmt::Write;
16
17use risingwave_common::types::JsonbRef;
18use risingwave_expr::{ExprError, Result, function};
19
20#[function("jsonb_typeof(jsonb) -> varchar")]
21pub fn jsonb_typeof(v: JsonbRef<'_>, writer: &mut impl Write) {
22    writer.write_str(v.type_name()).unwrap()
23}
24
25#[function("jsonb_array_length(jsonb) -> int4")]
26pub fn jsonb_array_length(v: JsonbRef<'_>) -> Result<i32> {
27    v.array_len()
28        .map(|n| n as i32)
29        .map_err(|e| ExprError::InvalidParam {
30            name: "",
31            reason: e.into(),
32        })
33}
34
35#[function("is_json(varchar) -> boolean")]
36pub fn is_json_value(s: &str) -> bool {
37    serde_json::from_str::<serde::de::IgnoredAny>(s).is_ok()
38}
39
40#[function("is_json(varchar, varchar) -> boolean")]
41pub fn is_json_type(s: &str, t: &str) -> bool {
42    serde_json::from_str::<serde::de::IgnoredAny>(s).is_ok_and(|_| {
43        let s = s.trim_start();
44        match t {
45            "ARRAY" => s.starts_with('['),
46            "OBJECT" => s.starts_with('{'),
47            "SCALAR" => !s.starts_with('[') && !s.starts_with('{'),
48            // forward compatible in case we always pass the default later
49            "VALUE" => true,
50            // After #11134, validate during expr build and pass enum to avoid this
51            _ => unreachable!(),
52        }
53    })
54}
55
56/// Converts the given JSON value to pretty-printed, indented text.
57///
58/// # Examples
59// TODO: enable docslt after sqllogictest supports multiline output
60/// ```text
61/// query T
62/// select jsonb_pretty('[{"f1":1,"f2":null}, 2]');
63/// ----
64/// [
65///     {
66///         "f1": 1,
67///         "f2": null
68///     },
69///     2
70/// ]
71/// ```
72#[function("jsonb_pretty(jsonb) -> varchar")]
73pub fn jsonb_pretty(v: JsonbRef<'_>, writer: &mut impl Write) {
74    v.pretty(writer).unwrap()
75}
risingwave_expr_impl/scalar/jsonb_info.rs

risingwave_expr_impl/scalar/
jsonb_info.rs
