sp_BlitzCache: ai_advice or ai_prompt may be returning nulls #3855
Description
What is the current behavior?
During a very active and enjoyable live stream, we seemed to notice that sometimes we got nulls in the ai_advice, ai_prompt, ai_payload, etc columns of sp_BlitzCache when the @ai parameter was set to 1 or 2.
What is the expected behavior?
If @ai > 0, the ai_prompt column should never be null. It should always have a value based on the prompt and query metrics. If our prompt-building query can't get ONE of the two (query plan or query text), the prompt should say that those objects couldn't be retrieved. If our prompt-building query can't get EITHER of those (both query plan and query text are null), then the ai_prompt column should only say, "Prompt not generated because we can't find the query text or query plan." and not include any metrics or job description stuff.)