Skip to main content

uqa_sql/semantics/
period.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Canonical range values used by temporal keys and references.
8use crate::{
9    ast::RangeSubtype,
10    expr::{CanonicalRange, RangeComparisonValue},
11    ColumnType, SQLError,
12};
13use uqa_core::Value;
14
15pub fn period_ranges(
16    value: &Value,
17    column_type: &ColumnType,
18) -> Result<(RangeSubtype, Vec<CanonicalRange>), SQLError> {
19    let subtype = match column_type {
20        ColumnType::Range(subtype) | ColumnType::Multirange(subtype) => *subtype,
21        other => {
22            return Err(SQLError::TypeMismatch(format!(
23                "PERIOD column must be a range or multirange, got {}",
24                other.sql_name()
25            )))
26        }
27    };
28    let control = uqa_core::memory::ProductionControl::uncontrolled();
29    let ranges =
30        match RangeComparisonValue::from_type_with_control(value, column_type, None, &control)? {
31            Some(RangeComparisonValue::Range(range)) => (!range.is_empty())
32                .then(|| range.into_uncontrolled().expect("PERIOD range"))
33                .into_iter()
34                .collect(),
35            Some(RangeComparisonValue::Multirange(ranges)) => ranges.ranges().to_vec(),
36            _ => {
37                return Err(SQLError::TypeMismatch(format!(
38                    "PERIOD value has incompatible runtime carrier {value:?}"
39                )))
40            }
41        };
42    Ok((subtype, ranges))
43}
44
45pub fn period_values_overlap(
46    left: &Value,
47    right: &Value,
48    column_type: &ColumnType,
49) -> Result<bool, SQLError> {
50    let (left_subtype, left) = period_ranges(left, column_type)?;
51    let (right_subtype, right) = period_ranges(right, column_type)?;
52    Ok(left_subtype == right_subtype
53        && left
54            .iter()
55            .any(|left| right.iter().any(|right| left.overlaps(right))))
56}