Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Case Sensitivity issue in sp_BlitzCache #3368

Closed
markkeyworth opened this issue Oct 4, 2023 · 3 comments
Closed

Case Sensitivity issue in sp_BlitzCache #3368

markkeyworth opened this issue Oct 4, 2023 · 3 comments

Comments

@markkeyworth
Copy link

markkeyworth commented Oct 4, 2023

Version of the script
Version: 8.16 VersionDate:20230820

What is the current behavior?
Error on creation:
Msg 137, Level 15, State 1, Procedure sp_BlitzCache, Line 615 [Batch Start Line 239]
Must declare the scalar variable "@minimumExecutionCount".

If the current behavior is a bug, please provide the steps to reproduce.
Have a database which requires case sensitivity (in my case Latin1_General_BIN) and try and execute the script

What is the expected behavior?
The script should allow you to create the sp_BlitzCache. Requires @minimumExecutionCount changing to @MinimumExecutionCount

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
N/A

@markkeyworth
Copy link
Author

Has been caused by a change in #3345. Its actually line 854 of the script which causes the issue.

Montro1981 added a commit to Montro1981/SQL-Server-First-Responder-Kit that referenced this issue Oct 5, 2023
@Montro1981
Copy link
Contributor

There were some more case mismatches for this parameter, fixed them and opened PR #3369

BrentOzar added a commit that referenced this issue Oct 10, 2023
…it_3368

#3368 Case issue with @MinimumExecutionCount
@BrentOzar
Copy link
Member

Thanks for the pull request. Looks good, merging into the dev branch, will be in the next release with credit to you in the release notes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants