uqa-pg-query 0.1.6

PostgreSQL 18 libpg_query parser pin used by UQA Engine
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

//! Regression tests for the pinned PostgreSQL 18 parser fixes.

#[test]
fn preserves_quoted_plpgsql_type_name_identifiers() {
    let result = pg_query::parse_plpgsql(
        r#"
        CREATE FUNCTION quoted_type_names() RETURNS void AS $$
        DECLARE
            column_value "app.dot"."typed.dot"."id.dot"%TYPE;
            row_value "app.dot"."typed.dot"%ROWTYPE;
        BEGIN
            RETURN;
        END;
        $$ LANGUAGE plpgsql;
        "#,
    )
    .unwrap();

    let datums = result[0]["PLpgSQL_function"]["datums"].as_array().unwrap();
    let type_metadata = |refname: &str| {
        &datums
            .iter()
            .find(|datum| datum["PLpgSQL_var"]["refname"] == refname)
            .unwrap()["PLpgSQL_var"]["datatype"]["PLpgSQL_type"]
    };

    assert_eq!(
        type_metadata("column_value")["typname_identifiers"],
        serde_json::json!(["app.dot", "typed.dot", "id.dot"])
    );
    assert_eq!(
        type_metadata("row_value")["typname_identifiers"],
        serde_json::json!(["app.dot", "typed.dot"])
    );
}