Skip to main content

uqa_sql/semantics/join_using/production/
predicate.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Positional USING equality retains each coercion and scalar constructor independently.
8
9use crate::{
10    ast::BinaryOp, plan::OwnedScalarExpr, production::Buffer, ColumnType, RowSchema, SQLError,
11    ScalarExpr,
12};
13use uqa_core::memory::ProductionControl;
14
15pub fn join_using_predicate_owned(
16    using: &super::ResolvedJoinUsing,
17    left: &RowSchema,
18    right: &RowSchema,
19    control: &ProductionControl<'_>,
20) -> Result<Option<OwnedScalarExpr>, SQLError> {
21    control.check()?;
22    let mut predicates = Buffer::new(control);
23    for column in &using.columns {
24        let lhs = column_expression(
25            column.left,
26            left.column_type(column.left),
27            column.comparison_type.as_ref(),
28            control,
29        )?;
30        let rhs = column_expression(
31            left.len() + column.right,
32            right.column_type(column.right),
33            column.comparison_type.as_ref(),
34            control,
35        )?;
36        predicates.push(
37            OwnedScalarExpr::binary(BinaryOp::Equal, lhs, rhs, control)?,
38            control,
39        )?;
40    }
41    Ok(match predicates.len() {
42        0 => None,
43        1 => predicates.pop(),
44        _ => Some(OwnedScalarExpr::boolean(
45            predicates.into_iter(),
46            true,
47            control,
48        )?),
49    })
50}
51
52fn column_expression(
53    position: usize,
54    source: Option<&ColumnType>,
55    target: Option<&ColumnType>,
56    control: &ProductionControl<'_>,
57) -> Result<OwnedScalarExpr, SQLError> {
58    let expression = ScalarExpr::Position(position).copy_for_rewrite(control)?;
59    match (source, target) {
60        (Some(source), Some(target)) if source != target => Ok(OwnedScalarExpr::cast(
61            expression,
62            target.catalog_name_with_control(control)?,
63            true,
64            control,
65        )?),
66        _ => Ok(expression),
67    }
68}