uqa_sql/semantics/
period.rs1use 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}