Skip to content

Detect and prevent filters on jsonb columns in SQL queries

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

Motivation

Prevent queries like !169094 (merged) from re-occuring. See also #498685 (comment 2182179348), and https://gitlab.com/gitlab-com/gl-infra/scalability/-/issues/3803#note_2176872893 for details

Possible ideas

  1. Use QueryAnalyzer on a sample of queries. Fail if there's more than a number of @> operators in the query.
  2. Something else ?
Edited by 🤖 GitLab Bot 🤖