This is an automated email from the ASF dual-hosted git repository.
iffyio pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion-sqlparser-rs.git
The following commit(s) were added to refs/heads/main by this push:
new eacf00d2 Add support for parameter default values in SQL Server (#1866)
eacf00d2 is described below
commit eacf00d269bf3d1323100c33a18f139d6921adb5
Author: Andrew Harper <andrew.har...@veracross.com>
AuthorDate: Thu May 29 05:49:28 2025 -0400
Add support for parameter default values in SQL Server (#1866)
---
src/parser/mod.rs | 8 +++++++-
tests/sqlparser_mssql.rs | 40 ++++++++++++++++++++++++++++++++++++++++
2 files changed, 47 insertions(+), 1 deletion(-)
diff --git a/src/parser/mod.rs b/src/parser/mod.rs
index fcd07aa4..c1be8764 100644
--- a/src/parser/mod.rs
+++ b/src/parser/mod.rs
@@ -5289,11 +5289,17 @@ impl<'a> Parser<'a> {
|parser: &mut Parser| -> Result<OperateFunctionArg, ParserError> {
let name = parser.parse_identifier()?;
let data_type = parser.parse_data_type()?;
+ let default_expr = if parser.consume_token(&Token::Eq) {
+ Some(parser.parse_expr()?)
+ } else {
+ None
+ };
+
Ok(OperateFunctionArg {
mode: None,
name: Some(name),
data_type,
- default_expr: None,
+ default_expr,
})
};
self.expect_token(&Token::LParen)?;
diff --git a/tests/sqlparser_mssql.rs b/tests/sqlparser_mssql.rs
index 32388c44..2a314502 100644
--- a/tests/sqlparser_mssql.rs
+++ b/tests/sqlparser_mssql.rs
@@ -377,6 +377,46 @@ fn parse_create_function() {
);
}
+#[test]
+fn parse_create_function_parameter_default_values() {
+ let single_default_sql =
+ "CREATE FUNCTION test_func(@param1 INT = 42) RETURNS INT AS BEGIN
RETURN @param1; END";
+ assert_eq!(
+ ms().verified_stmt(single_default_sql),
+ Statement::CreateFunction(CreateFunction {
+ or_alter: false,
+ or_replace: false,
+ temporary: false,
+ if_not_exists: false,
+ name: ObjectName::from(vec![Ident::new("test_func")]),
+ args: Some(vec![OperateFunctionArg {
+ mode: None,
+ name: Some(Ident::new("@param1")),
+ data_type: DataType::Int(None),
+ default_expr:
Some(Expr::Value((number("42")).with_empty_span())),
+ },]),
+ return_type: Some(DataType::Int(None)),
+ function_body:
Some(CreateFunctionBody::AsBeginEnd(BeginEndStatements {
+ begin_token: AttachedToken::empty(),
+ statements: vec![Statement::Return(ReturnStatement {
+ value:
Some(ReturnStatementValue::Expr(Expr::Identifier(Ident::new(
+ "@param1"
+ )))),
+ })],
+ end_token: AttachedToken::empty(),
+ })),
+ behavior: None,
+ called_on_null: None,
+ parallel: None,
+ using: None,
+ language: None,
+ determinism_specifier: None,
+ options: None,
+ remote_connection: None,
+ }),
+ );
+}
+
#[test]
fn parse_mssql_apply_join() {
let _ = ms_and_generic().verified_only_select(
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
