Repository: duckdb/duckdb (language: python)

Issue:
Two settings named 'http_proxy'
### What happens?

There are two settings named 'http_proxy' : 

|        name         |         value         |                                       description                                        |
|---------------------|-----------------------|------------------------------------------------------------------------------------------|
| http_proxy          | 127.0.0.1:8999 | HTTP proxy host                                                                          |
| http_proxy_username |                       | Username for HTTP proxy                                                                  |
| http_proxy          |                       | Password for HTTP proxy                                                                  |
| http_logging_output |                       | The file to which HTTP logging output should be saved, or empty to print to the terminal |


### To Reproduce

```
D select name, value, description from duckdb_settings() where name like 'http%';
|        name         | value |                                       description                                        |
|---------------------|-------|------------------------------------------------------------------------------------------|
| http_proxy          |       | HTTP proxy host                                                                          |
| http_proxy_username |       | Username for HTTP proxy                                                                  |
| http_proxy          |       | Password for HTTP proxy                                                                  |
| http_logging_output |       | The file to which HTTP logging output should be saved, or empty to print to the terminal |
D set http_proxy to '127.0.0.1:8999' ;
D select name, value, description from duckdb_settings() where name like 'http%';
|        name         |         value         |                                       description                                        |
|---------------------|-----------------------|------------------------------------------------------------------------------------------|
| http_proxy          | 127.0.0.1:8999        | HTTP proxy host                                                                          |
| http_proxy_username |                       | Username for HTTP proxy                                                                  |
| http_proxy          |                       | Password for HTTP proxy                                                                  |
| http_logging_output |                       | The file to which HTTP logging output should be saved, or empty to print to the terminal |
```

### OS:

Windows 10 x86_64

### DuckDB Version:

v1.1.0 fa5c2fe15f

### DuckDB Client:

CLI

### Hardware:

_No response_

### Full Name:

Phil Leach

### Affiliation:

Bloomberg

### What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a nightly build

### Did you include all relevant data sets for reproducing the issue?

Yes

### Did you include all code required to reproduce the issue?

- [X] Yes, I have

### Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

- [X] Yes, I have
Two settings named 'http_proxy'
### What happens?

There are two settings named 'http_proxy' : 

|        name         |         value         |                                       description                                        |
|---------------------|-----------------------|------------------------------------------------------------------------------------------|
| http_proxy          | 127.0.0.1:8999 | HTTP proxy host                                                                          |
| http_proxy_username |                       | Username for HTTP proxy                                                                  |
| http_proxy          |                       | Password for HTTP proxy                                                                  |
| http_logging_output |                       | The file to which HTTP logging output should be saved, or empty to print to the terminal |


### To Reproduce

```
D select name, value, description from duckdb_settings() where name like 'http%';
|        name         | value |                                       description                                        |
|---------------------|-------|------------------------------------------------------------------------------------------|
| http_proxy          |       | HTTP proxy host                                                                          |
| http_proxy_username |       | Username for HTTP proxy                                                                  |
| http_proxy          |       | Password for HTTP proxy                                                                  |
| http_logging_output |       | The file to which HTTP logging output should be saved, or empty to print to the terminal |
D set http_proxy to '127.0.0.1:8999' ;
D select name, value, description from duckdb_settings() where name like 'http%';
|        name         |         value         |                                       description                                        |
|---------------------|-----------------------|------------------------------------------------------------------------------------------|
| http_proxy          | 127.0.0.1:8999        | HTTP proxy host                                                                          |
| http_proxy_username |                       | Username for HTTP proxy                                                                  |
| http_proxy          |                       | Password for HTTP proxy                                                                  |
| http_logging_output |                       | The file to which HTTP logging output should be saved, or empty to print to the terminal |
```

### OS:

Windows 10 x86_64

### DuckDB Version:

v1.1.0 fa5c2fe15f

### DuckDB Client:

CLI

### Hardware:

_No response_

### Full Name:

Phil Leach

### Affiliation:

Bloomberg

### What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a nightly build

### Did you include all relevant data sets for reproducing the issue?

Yes

### Did you include all code required to reproduce the issue?

- [X] Yes, I have

### Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

- [X] Yes, I have


Discussion / hints:

Fix patch:
diff --git a/src/include/duckdb/main/settings.hpp b/src/include/duckdb/main/settings.hpp
index 538a75b85e4f..05c87e6084d0 100644
--- a/src/include/duckdb/main/settings.hpp
+++ b/src/include/duckdb/main/settings.hpp
@@ -506,7 +506,7 @@ struct HTTPProxyUsername {
 };
 
 struct HTTPProxyPassword {
-	static constexpr const char *Name = "http_proxy";
+	static constexpr const char *Name = "http_proxy_password";
 	static constexpr const char *Description = "Password for HTTP proxy";
 	static constexpr const LogicalTypeId InputType = LogicalTypeId::VARCHAR;
 	static void SetGlobal(DatabaseInstance *db, DBConfig &config, const Value &parameter);


Test patch:
diff --git a/test/sql/copy/s3/http_proxy.test b/test/sql/copy/s3/http_proxy.test
index c8458762b1d5..aece0a9e16c6 100644
--- a/test/sql/copy/s3/http_proxy.test
+++ b/test/sql/copy/s3/http_proxy.test
@@ -38,6 +38,12 @@ value-1
 statement ok
 set http_proxy='blabla:1337'
 
+statement ok
+set http_proxy_username='xxx'
+
+statement ok
+set http_proxy_password='yyy'
+
 statement error
 FROM 's3://test-bucket/proxy-test/test.parquet'
 ----
@@ -47,6 +53,12 @@ Could not establish connection
 statement ok
 set http_proxy='${HTTP_PROXY_PUBLIC}'
 
+statement ok
+RESET http_proxy_username
+
+statement ok
+RESET http_proxy_password
+
 query I
 FROM 's3://test-bucket/proxy-test/test.parquet'
 ----