set_config() doesn't accept parameters in the extended mode

[neverchanje]

Describe the bug

set_config ( setting_name text, new_value text, is_local boolean ) → text

When set_config accepts literals as its parameters, everything runs normally.

set_config('setting_name', 'abc', false);

Howerver, when handling a parameterized query, it does not work:

Query(
  "SELECT set_config('setting_name', $1, false);",
  'abc'
)

This is because the implementation of set_config only accepts string literals:

https://github.com/risingwavelabs/risingwave/blob/d488f65/src/frontend/src/binder/expr/function.rs#L1291-L1298

if let ExprImpl::Literal(literal) = &inputs[0] && let Some(ScalarImpl::Utf8(input)) = literal.get_data()

Error message/log

Only string literal is supported in `setting_name`

To Reproduce

	db, err := sql.Open(DriverName, "postgres://root@localhost:4566/dev?sslmode=disable")
	assert.Nil(t, err)

	_, err = db.QueryContext(context.Background(), "SELECT set_config('search_path', $1, false)", "'$user'")
	assert.Nil(t, err)

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄