This is an automated email from the ASF dual-hosted git repository.
comphead pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new d6e8b07aef Add DESC alias for DESCRIBE command (#16514)
d6e8b07aef is described below
commit d6e8b07aef22e25f87da9af60ae94a4c6dd4c1a1
Author: Lucas Earl <earl.lu...@gmail.com>
AuthorDate: Mon Jun 23 14:49:03 2025 -0600
Add DESC alias for DESCRIBE command (#16514)
- Allow DESC as shorthand for DESCRIBE in SQL parser
- Maintains backward compatibility with existing DESCRIBE syntax
- Adds test coverage for new DESC alias functionality
---
datafusion/sql/src/statement.rs | 2 +-
datafusion/sqllogictest/test_files/describe.slt | 30 +++++++++++++++++++++++++
2 files changed, 31 insertions(+), 1 deletion(-)
diff --git a/datafusion/sql/src/statement.rs b/datafusion/sql/src/statement.rs
index dafb034648..f83cffe47a 100644
--- a/datafusion/sql/src/statement.rs
+++ b/datafusion/sql/src/statement.rs
@@ -215,7 +215,7 @@ impl<S: ContextProvider> SqlToRel<'_, S> {
) -> Result<LogicalPlan> {
match statement {
Statement::ExplainTable {
- describe_alias: DescribeAlias::Describe, // only parse
'DESCRIBE table_name' and not 'EXPLAIN table_name'
+ describe_alias: DescribeAlias::Describe | DescribeAlias::Desc,
// only parse 'DESCRIBE table_name' or 'DESC table_name' and not 'EXPLAIN
table_name'
table_name,
..
} => self.describe_table_to_plan(table_name),
diff --git a/datafusion/sqllogictest/test_files/describe.slt
b/datafusion/sqllogictest/test_files/describe.slt
index e4cb30628e..de5208b548 100644
--- a/datafusion/sqllogictest/test_files/describe.slt
+++ b/datafusion/sqllogictest/test_files/describe.slt
@@ -86,3 +86,33 @@ string_col Utf8View YES
timestamp_col Timestamp(Nanosecond, None) YES
year Int32 YES
month Int32 YES
+
+# Test DESC alias functionality
+statement ok
+CREATE TABLE test_desc_table (id INT, name VARCHAR);
+
+# Test DESC works the same as DESCRIBE
+query TTT
+DESC test_desc_table;
+----
+id Int32 YES
+name Utf8View YES
+
+query TTT
+DESCRIBE test_desc_table;
+----
+id Int32 YES
+name Utf8View YES
+
+# Test with qualified table names
+statement ok
+CREATE TABLE public.test_qualified (col1 INT);
+
+query TTT
+DESC public.test_qualified;
+----
+col1 Int32 YES
+
+# Test error cases
+statement error
+DESC nonexistent_table;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
