Omega359 opened a new issue, #18384: URL: https://github.com/apache/datafusion/issues/18384
### Is your feature request related to a problem or challenge? Currently there isn't a way that I can see to unset/reset to default a config option that has a type of `Option<xyz>` that has a default of `None`. It would be useful to have this ability. postgresql seems to support multiple ways to do this: ```sql RESET configuration_parameter; SET configuration_parameter TO DEFAULT; ``` https://www.postgresql.org/docs/current/sql-reset.html https://www.postgresql.org/docs/current/sql-set.html Duckdb [uses reset](https://duckdb.org/docs/stable/sql/statements/set#reset) MySQL [uses reset](https://dev.mysql.com/doc/refman/9.5/en/reset.html) I would suggest that DataFusion should add support for a `RESET` sql command. ### Describe the solution you'd like `RESET <config>;` would work to reset the config back to whatever it's default is. ### Describe alternatives you've considered Alternative is to not support this functionality. ### Additional context _No response_ -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
