search

dolthub / doltgresql

DoltgreSQL - Version Controlled PostgreSQL
Apache License 2.0
1.12k stars 25 forks source link

Function: `set_config()` #877

Closed fulghum closed 1 month ago

fulghum commented 1 month ago

Adds support for the set_config() function.

Example Usage:

SELECT set_config('mynamespace.foo', 'bar', false);
set_config 
------------
 bar

SELECT current_setting('mynamespace.foo');
 current_setting 
-----------------
 bar

Fixes: https://github.com/dolthub/doltgresql/issues/852

github-actions[bot] commented 1 month ago
Main PR
Total 42090 42090
Successful 12844 12845
Failures 29246 29245
Partial Successes[^1] 4895 4896
Main PR
Successful 30.5156% 30.5179%
Failures 69.4844% 69.4821%

${\color{lightgreen}Progressions}$

namespace

QUERY: SELECT pg_catalog.set_config('search_path', ' ', false);

[^1]: These are tests that we're marking as Successful, however they do not match the expected output in some way. This is due to small differences, such as different wording on the error messages, or the column names being incorrect while the data itself is correct.