Skip to main content

uqa_sql/expr/
diagnostics.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! `PostgreSQL`-compatible scalar type and routine diagnostics.
8
9use uqa_core::{TemporalValue, Value};
10
11use crate::error::SQLError;
12
13pub fn value_type_name(v: &Value) -> &'static str {
14    match v {
15        Value::Null => "unknown",
16        Value::Void => "void",
17        Value::Bool(_) => "boolean",
18        Value::Int(_) => "integer",
19        Value::Float(_) => "double precision",
20        Value::Str(_) => "text",
21        Value::FixedChar(_) => "character",
22        Value::Bytes(_) => "bytea",
23        Value::BitString(_) => "bit",
24        Value::Temporal(TemporalValue::Interval { .. }) => "interval",
25        Value::Temporal(_) => "timestamp",
26        Value::Decimal(_) => "numeric",
27        Value::Json(_) => "json",
28        Value::JsonB(_) => "jsonb",
29        Value::Array(_) => "anyarray",
30        Value::LegacyVector(vector) => vector.kind().type_name(),
31        Value::List(_) => "anyarray",
32        Value::Row(_) | Value::Record(_) => "record",
33        Value::Map(_) => "jsonb",
34        // Runtime carriers name their type class, as arrays use `anyarray`; bound expressions report declared names.
35        Value::Enum(_) => "anyenum",
36        Value::Datum(value) => super::datums::type_name(value),
37    }
38}
39
40/// `function name(arg types) does not exist` - the error `PostgreSQL`
41/// raises when call resolution fails (SQLSTATE 42883).
42pub fn unknown_function_error(name: &str, args: &[(Option<String>, Value)]) -> SQLError {
43    let types = args
44        .iter()
45        .map(|(arg_name, value)| match arg_name {
46            Some(arg_name) => format!("{arg_name} => {}", value_type_name(value)),
47            None => value_type_name(value).to_string(),
48        })
49        .collect::<Vec<_>>()
50        .join(", ");
51    SQLError::undefined_function_call(&format!("{name}({types})"))
52}