Discovered 9 months ago
Source: static code analysis
Category: SQL Injection
Confidence level: Medium

Problem

Possible SQL injection

Location

app/models/namespace/traversal_hierarchy.rb:47

Namespace.joins("INNER JOIN (#{recursive_traversal_ids}) as cte ON namespaces.id = cte.id")

Category description: SQL injection is when a user is able to manipulate a value which is used unsafely inside a SQL query.

Solution: fix the issue in app/models/namespace/traversal_hierarchy.rb or mark it as false positive.