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