use super::*;
struct Catalog(Vec<String>);
impl StoredColumnCatalog for Catalog {
fn stored_relation_column_names(&self, name: &str) -> Result<Option<Vec<String>>, SQLError> {
Ok((name == "public.inputs").then(|| self.0.clone()))
}
}
impl crate::routines::merge_columns::StoredMergeColumnCatalog for Catalog {
fn stored_merge_target_definitions(&self, _: &str) -> Option<Vec<crate::ast::ColumnDef>> {
None
}
}
impl Catalog {
fn context(&self) -> StoredColumnBindingContext<'_> {
StoredColumnBindingContext {
sources: self,
merge: self,
}
}
}
#[test]
fn stored_values_bind_parameters_and_preserve_column_identity_across_rename() {
let original = Catalog(vec!["original".into(), "unused".into()]);
let relation = RelationIdentity::from_legacy_name("public.inputs").unwrap();
for sql in [
"VALUES ((SELECT original FROM public.inputs), argument)",
"VALUES ((SELECT i.selected FROM public.inputs AS i(selected, other)), argument)",
"VALUES ((SELECT original FROM public.inputs), argument) ORDER BY 1",
] {
let mut statement = crate::compile(sql).unwrap().remove(0);
bind_stored_statement_source_columns(&mut statement, |name| {
original.stored_relation_column_names(name)
})
.unwrap();
let reference = stored_statement_references(original.context(), &statement).unwrap();
assert_eq!(
reference.unresolved,
vec![(None, "argument".into())],
"{sql}"
);
assert_eq!(
reference.dependencies,
BTreeSet::from([RuleColumnDependency {
relation: relation.clone(),
column: "original".into(),
}]),
"{sql}",
);
let renamed = Catalog(vec!["renamed".into(), "unused".into()]);
assert!(rewrite_stored_statement_column(
renamed.context(),
&mut statement,
&relation,
"original",
"renamed",
)
.unwrap());
let encoded = serde_json::to_string(&statement).unwrap();
let restored: Statement = serde_json::from_str(&encoded).unwrap();
let reference = stored_statement_references(renamed.context(), &restored).unwrap();
assert_eq!(
reference.unresolved,
vec![(None, "argument".into())],
"{sql}"
);
assert_eq!(
reference.dependencies,
BTreeSet::from([RuleColumnDependency {
relation: relation.clone(),
column: "renamed".into(),
}]),
"{sql}",
);
}
}