uqa_sql/semantics/
insert_values.rs1use super::view_rewrite::context::ViewRewriteContext;
10use crate::ast::AssignmentTarget;
11use crate::catalog::view::StoredViewKind;
12use crate::plan::{
13 AccessPathPlan, ComputePlan, InsertPlan, ProjectionPlan, QueryBlockPlan, QueryPlan,
14 RelationalPlan,
15};
16use crate::{SQLError, ScalarExpr};
17use std::collections::BTreeSet;
18
19pub fn single_row_values_query(
23 routines: &dyn crate::routines::RoutineResolution,
24 insert: &InsertPlan,
25 observed: impl FnOnce() -> Result<Option<BTreeSet<String>>, SQLError>,
26 implicit_columns: impl FnOnce() -> Result<Option<Vec<String>>, SQLError>,
27) -> Result<Option<InsertPlan>, SQLError> {
28 let [row] = insert.rows.as_slice() else {
29 return Ok(None);
30 };
31 let set_valued = row
32 .iter()
33 .map(|value| {
34 crate::semantics::sets::static_setness::expression_may_return_set_statically(
35 routines, value,
36 )
37 })
38 .collect::<Vec<_>>();
39 if !set_valued.contains(&true) {
40 return Ok(None);
41 }
42 let Some(observed) = observed()? else {
43 return Err(crate::semantics::sets::placement::set_valued_call_error());
44 };
45 let defaults = row.iter().any(|value| matches!(value, ScalarExpr::Default));
46 let targets = if !insert.columns.is_empty() {
47 insert.columns.clone()
48 } else if defaults || !observed.is_empty() {
49 let Some(columns) = implicit_columns()? else {
50 return Ok(None);
51 };
52 columns
53 .into_iter()
54 .take(row.len())
55 .map(AssignmentTarget::from)
56 .collect()
57 } else {
58 Vec::new()
59 };
60 let explicit = !insert.columns.is_empty() || defaults;
61 if (explicit || !targets.is_empty()) && targets.len() != row.len() {
62 return Ok(None);
63 }
64 if targets
65 .iter()
66 .zip(&set_valued)
67 .any(|(target, set_valued)| *set_valued && observed.contains(&target.column))
68 {
69 return Err(crate::semantics::sets::placement::set_valued_call_error());
70 }
71 let mut columns = Vec::with_capacity(targets.len());
72 let mut projections = Vec::with_capacity(row.len());
73 for (position, value) in row.iter().enumerate() {
74 if matches!(value, ScalarExpr::Default) {
75 continue;
76 }
77 if explicit {
78 columns.push(targets[position].clone());
79 }
80 projections.push(ProjectionPlan {
81 expr: value.clone(),
82 alias: None,
83 });
84 }
85 let source = QueryPlan {
86 relations_bound: insert.relations_bound,
87 ctes: Vec::new(),
88 root: RelationalPlan::QueryBlock(Box::new(QueryBlockPlan {
89 windows: Vec::new(),
90 projections,
91 privilege_columns: std::collections::BTreeSet::default(),
92 from: None,
93 r#where: None,
94 compute: ComputePlan::Project,
95 group_by: Vec::new(),
96 grouping_sets: Vec::new(),
97 group_distinct: false,
98 having: None,
99 order_by: Vec::new(),
100 limit: None,
101 with_ties: false,
102 offset: None,
103 distinct: false,
104 distinct_on: Vec::new(),
105 subqueries: insert.subqueries.clone(),
106 access: AccessPathPlan::Row,
107 locking: Vec::new(),
108 })),
109 };
110 let mut expanded = insert.clone();
111 expanded.rows = Vec::new();
112 expanded.columns = columns;
113 expanded.source = Some(Box::new(source));
114 Ok(Some(expanded))
115}
116
117pub fn implicit_target_columns(
119 context: ViewRewriteContext<'_>,
120 table: &str,
121) -> Result<Option<Vec<String>>, SQLError> {
122 match context.catalog.target_view_kind(table)? {
123 Some(StoredViewKind::View) => Ok(Some(
124 super::view_mutation::resolve_view_target(context, table)?.columns,
125 )),
126 Some(StoredViewKind::Materialized) => Ok(None),
127 None => context
128 .catalog
129 .try_table_columns(table)
130 .map(Some)
131 .map_err(SQLError::Internal),
132 }
133}
134
135#[cfg(test)]
136mod tests;