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
- Use QueryAnalyzer on a sample of queries. Fail if there's more than a number of
@>operators in the query. - Something else ?
Edited by 🤖 GitLab Bot 🤖