You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "watford-ep (via GitHub)" <gi...@apache.org> on 2025/10/29 13:10:01 UTC
[I] Add support for Postgres RESET statement [datafusion-sqlparser-rs]
watford-ep opened a new issue, #2078:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2078
The RESET keyword is available, but the statement is not:
```sql
RESET configuration_parameter;
RESET ALL;
```
--
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: github-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Add support for RESET statement [datafusion-sqlparser-rs]
Posted by "iffyio (via GitHub)" <gi...@apache.org>.
iffyio closed issue #2078: Add support for RESET statement
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2078
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Add support for RESET statement [datafusion-sqlparser-rs]
Posted by "watford-ep (via GitHub)" <gi...@apache.org>.
watford-ep commented on issue #2078:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2078#issuecomment-3467832323
Notes:
- Per PR comments added this support to all parsers by default
- ANSI, BigQuery, Clickhouse, Hive, Snowflake, sqlite, and SQL Server do not support RESET in any form
## Databricks
The [RESET](https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-reset) statement resets Databricks SQL [parameters](https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-parameters) at the session level to the global default values if they were changed using the [SET](https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-set) command. When using Databricks Runtime, parameters are known as SQL Conf properties.
```sql
RESET [ parameter_key ]
```
## Duckdb
The [RESET statement](https://duckdb.org/docs/stable/sql/statements/set) changes the given DuckDB configuration option to the default value.
```sql
RESET [ LOCAL | SESSION | GLOBAL ] configuration-option
```
## MySQL
The [RESET](https://dev.mysql.com/doc/refman/8.4/en/reset.html) statement is used to clear the state of various server operations. You must have the RELOAD] privilege to execute RESET.
```sql
RESET reset_option [ , reset_option ] ...
-- reset_option: {
-- BINARY LOGS AND GTIDS
-- | REPLICA
-- }
```
[RESET PERSIST](https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html) removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. For more information about persisting system variables and the mysqld-auto.cnf file, see [Section 7.1.9.3, “Persisted System Variables”](https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html).
```sql
RESET PERSIST [ [ IF EXISTS ] system_var_name ]
```
## Postgres
[RESET](https://www.postgresql.org/docs/current/sql-reset.html) — restore the value of a run-time parameter to the default value.
```sql
RESET { configuration_parameter | ALL }
```
## Redshift
[RESET](https://docs.aws.amazon.com/redshift/latest/dg/r_RESET.html) restores the value of a configuration parameter to its default value.
You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the [SET](https://docs.aws.amazon.com/redshift/latest/dg/r_SET.html) command. To display the current value of a parameter, use the SHOW command.)
```sql
RESET { parameter_name | variable_name | ALL }
```
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Add support for Postgres RESET statement [datafusion-sqlparser-rs]
Posted by "watford-ep (via GitHub)" <gi...@apache.org>.
watford-ep commented on issue #2078:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2078#issuecomment-3461437168
(I've started on this work)
--
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: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org