Diesel allows users to configure various options for PostgreSQL's COPY FROM and COPY TO statements. These configurations are partially provided as strings or characters.
Diesel did not check if any these user-provided options contain a quote character ', which can lead to the injection of additional options in the current COPY FROM/COPY TO statement.
This vulnerability affects any user of COPY FROM/COPY TO that passes user-provided input to any of the affected functions. It can result in modifications of options in the current statement, but it is not possible inject additional statements.
The preferred mitigation to the outlined problem is to update to Diesel version 2.3.8 or newer, which includes fixes for the problem.
Diesel now correctly escapes any quotes contained in the provided arguments.
{
"license": "CC0-1.0"
}{
"affected_functions": null,
"affects": {
"arch": [],
"functions": [
"diesel::pg::CopyFromQuery::with_default",
"diesel::pg::CopyFromQuery::with_delimiter",
"diesel::pg::CopyFromQuery::with_escape",
"diesel::pg::CopyFromQuery::with_null",
"diesel::pg::CopyFromQuery::with_quote",
"diesel::pg::CopyToQuery::with_delimiter",
"diesel::pg::CopyToQuery::with_escape",
"diesel::pg::CopyToQuery::with_null",
"diesel::pg::CopyToQuery::with_quote"
],
"os": []
}
}