1970652 - Move SQL comment to beginning of SQL statement so it is not truncated away in Googles Query Insights

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Infrastructure, task)

Description

[David Lawrence [:dkl]]

Currently we add a comment to the SQL statement to help identify search criteria that is causing long running queries when doing bug searches. We also show other information. Due to how Query Insights will truncate SQL statements longer than 4095 characters currently (soon to be 1MB) the comment sometimes is missing as it is added to the end of the query instead of the beginning. Moving it to the beginning will make sure it is always visible.

Comment 1

[BMO Github Automation]

Attachment: [mozilla-bteam/bmo] Bug 1970652 - Move SQL comment to beginning of SQL statement so it is not truncated away in Googles Query Insights (#2453)

Comment 2

[BMO Github Automation]

Authored by https://github.com/dklawren
https://github.com/mozilla-bteam/bmo/commit/f7d6c151180d475cae317d0ff2798de749d503d6
[master] Bug 1970652 - Move SQL comment to beginning of SQL statement so it is not truncated away in Googles Query Insights