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: [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]
