جزئیات آسیب‌پذیری

Hypequery is a TypeScript semantic layer for ClickHouse. Prior to 2.5.1, escapeValue() in packages/clickhouse/src/core/utils.ts did not escape backslashes before single quotes during parameter substitution, allowing attacker controlled query parameters with a trailing backslash to escape the closing quote and inject arbitrary SQL. This issue is fixed in version 2.0.2. Version 2.0.2 fixes string parameters, while version 2.5.1 fixes all known vectors. Upgrading to 2.5.1 or later is the only complete fix. In versions 2.0.2 through 2.5.0, serializing non-scalar parameters with  JSON.stringify()  before passing them is a workaround for the object/array vector only.

• https://github.com/hypequery/hypequery/security/advisories/GHSA-6wcc-39rp-hh9p x_refsource_CONFIRM
• https://github.com/hypequery/hypequery/pull/349 x_refsource_MISC
• https://github.com/hypequery/hypequery/commit/2879161a810fed2c2222f785816ff05510976960 x_refsource_MISC
• https://github.com/hypequery/hypequery/commit/2dc1df7bae x_refsource_MISC
• https://github.com/hypequery/hypequery/commit/4dfa9d77d70a08b970e722268b75ca7d13db0bdf x_refsource_MISC
• https://github.com/hypequery/hypequery/blob/main/packages/clickhouse/CHANGELOG.md#202 x_refsource_MISC
• https://github.com/hypequery/hypequery/releases/tag/@hypequery/clickhouse@2.0.2 x_refsource_MISC
• https://github.com/hypequery/hypequery/releases/tag/@hypequery/clickhouse@2.5.1 x_refsource_MISC