uqa-sql 0.5.0

PostgreSQL-compatible SQL compiler built on libpg_query
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

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

use super::*;

#[test]
fn numeric_session_offsets_use_sql_signs_and_canonical_names() {
    let definition = super::super::catalog::find_parameter("TimeZone").unwrap();
    for (input, expected) in [
        ("5.5", "<+05:30>-05:30"),
        ("-3.5", "<-03:30>+03:30"),
        ("0", "<+00>-00"),
        ("UTC-09:30", "UTC-09:30"),
        ("asia/seoul", "Asia/Seoul"),
    ] {
        assert_eq!(
            parse_setting(definition, input).unwrap(),
            expected,
            "{input}"
        );
    }
    for input in ["Not/A_Zone", "", "EDT", "UTC+999"] {
        let error = parse_setting(definition, input).unwrap_err();
        assert_eq!(error.sqlstate(), Some("22023"));
        assert_eq!(
            error.to_string(),
            format!("invalid value for parameter \"TimeZone\": \"{input}\"")
        );
        assert_eq!(error.detail(), None);
    }
    assert_eq!(
        parse_setting(definition, "1000").unwrap_err().detail(),
        Some("UTC timezone offset is out of range.")
    );
}