alamb commented on a change in pull request #1449:
URL: https://github.com/apache/arrow-datafusion/pull/1449#discussion_r769990897
##########
File path: datafusion/tests/sql.rs
##########
@@ -5426,6 +5426,67 @@ async fn qualified_table_references() -> Result<()> {
Ok(())
}
+#[tokio::test]
+async fn qualified_table_references_and_fields() -> Result<()> {
+ let mut ctx = ExecutionContext::new();
+
+ let c1: StringArray = vec!["foofoo", "foobar", "foobaz"]
+ .into_iter()
+ .map(Some)
+ .collect();
+ let c2: Int64Array = vec![1, 2, 3].into_iter().map(Some).collect();
+
+ let batch = RecordBatch::try_from_iter(vec![
+ ("f.c1", Arc::new(c1) as ArrayRef),
+ // evil -- use the same name as the table
+ ("test.c2", Arc::new(c2) as ArrayRef),
+ ])?;
+
+ let table = MemTable::try_new(batch.schema(), vec![vec![batch]])?;
+ ctx.register_table("test", Arc::new(table))?;
+
+ // referring to the unquoted column is an error
+ let sql = format!(r#"SELECT f1.c1 from test"#);
Review comment:
will fix
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
