uqa-planner 0.4.8

Cost model, cardinality, DPccp join enumeration, optimizer rewrites
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
42
43
44
45
46
47

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

use super::*;

#[test]
fn constant_numeric_comparisons_match_postgresql_before_replacing_the_expression() {
    let oracle: serde_json::Value = serde_json::from_str(include_str!(concat!(
        env!("CARGO_MANIFEST_DIR"),
        "/../uqa-sql/src/expr/binary/comparison/pg18.json"
    )))
    .unwrap();
    for case in oracle["cases"].as_array().unwrap() {
        for (index, operator) in oracle["operators"].as_array().unwrap().iter().enumerate() {
            let sql = format!(
                "SELECT ({}) {} ({})",
                case["left"].as_str().unwrap(),
                operator.as_str().unwrap(),
                case["right"].as_str().unwrap()
            );
            let uqa_sql::Statement::Select(mut select) = uqa_sql::compile(&sql).unwrap().remove(0)
            else {
                panic!("SELECT comparison")
            };
            let expression =
                uqa_sql::plan::ExpressionPlan::lower(select.projections.remove(0).expr).scalar;
            let result =
                fold_literal_expression(expression, uqa_execution::scalar::eval_constant_scalar);
            if let Some(expected) = case["sqlstate"].as_str() {
                assert_eq!(result.unwrap_err().sqlstate(), Some(expected), "{sql}");
            } else {
                let folded = result.unwrap();
                let expected = case["values"][index]
                    .as_bool()
                    .map_or(Value::Null, Value::Bool);
                assert_eq!(literal_value(&folded), Some(&expected), "{sql}");
                assert_eq!(
                    scalar_type(&folded, &RowSchema::default(), &[]).unwrap(),
                    Some(ColumnType::Boolean)
                );
            }
        }
    }
}