Skip to content

sp_quickiestore - Incorrect syntax near NULL when using @include_query_hash_totals = 1 #628

@Kysluss

Description

@Kysluss

Version of the script
Look in the stored procedure, and it'll have a version date & number near the top. Put that in here. If it's not the current version (dated in the last month), then upgrade to the current version and test that before reporting a bug - we fix a lot of stuff in each new build. We'll flat out close bug reports for older builds.

5.6

What is the current behavior?

Using @include_query_hash_totals = 1 generates a syntax error Incorrect syntax near NULL

If the current behavior is a bug, please provide the steps to reproduce.

Run the stored procedure with @include_query_hash_totals = 1

EXEC sp_QuickieStore @include_query_hash_totals = 1

What is the expected behavior?

Using @include_query_hash_totals = 1 should not generate a SQL error

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

Currently on SQL 2016. Have not tested on another version.

IMPORTANT: If you're going to contribute code, please read the contributing guide first.
https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingsp_QuickieStoreFor the loving of Query Store

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions