Oracle SQL table filter shows duplicates #107192
Description
Environment
SaaS (https://sentry.io/)
Steps to Reproduce
User reported the following:
- Oracle database with schema-qualified table names (e.g., VUTIDM.AUTH_SERVER_LOG)
- INSERT queries with RETURNING ... INTO clause and UPDATE queries targeting the same table
- Table filter dropdown in Backend > Queries shows duplicates
Expected Result
Each table should appear once in the filter, regardless of query type.
Actual Result
The same table appears twice in the filter:
- auth_server_log (from UPDATE queries)
- vutidm.auth_server_log (from INSERT queries)
User must select both entries to see all queries for the same table.
My theory is that this is In Relay, the regex fallback path for table extraction doesn't strip schema prefixes like the AST path does. INSERT queries with Oracle's RETURNING ... INTO syntax fail to parse, triggering the regex fallback which preserves the schema prefix.
Product Area
Insights
Link
No response
DSN
No response
Version
No response