Cherry-pick #2887: Fix stored procedure empty cell bug

Copilot · vadeveka · Copilot · commit 4ef54ec5381c · 2026-03-18T00:38:00.000Z
Co-authored-by: vadeveka &lt;52937801+vadeveka@users.noreply.github.com&gt;
diff --git a/src/Service.Tests/SqlTests/GraphQLPaginationTests/GraphQLPaginationTestBase.cs b/src/Service.Tests/SqlTests/GraphQLPaginationTests/GraphQLPaginationTestBase.cs
@@ -175,7 +175,6 @@ public async Task RequestMaxUsingNegativeOne()
                 ""hasNextPage"": false
             }";
 
-            // Note: The max page size is 21 for MsSql and 20 for all other data sources, so when using -1
             // this resultset represents all books in the db.
             JsonElement actual = await ExecuteGraphQLRequestAsync(graphQLQuery, graphQLQueryName, isAuthenticated: false);
 
diff --git a/src/Service.Tests/UnitTests/SqlQueryExecutorUnitTests.cs b/src/Service.Tests/UnitTests/SqlQueryExecutorUnitTests.cs
@@ -628,7 +628,7 @@ public void ValidateStreamingLogicForStoredProcedures(int readDataLoops, bool ex
         /// Makes sure the stream logic handles cells with empty strings correctly.
         /// </summary>
         [DataTestMethod, TestCategory(TestCategory.MSSQL)]
-        public void ValidateStreamingLogicForEmptyCellsAsync()
+        public void ValidateStreamingLogicForEmptyCells()
         {
             TestHelper.SetupDatabaseEnvironment(TestCategory.MSSQL);
             FileSystem fileSystem = new();

Original file line number	Diff line number	Diff line change
`@@ -628,7 +628,7 @@ public void ValidateStreamingLogicForStoredProcedures(int readDataLoops, bool ex`
`628`	`628`	`/// Makes sure the stream logic handles cells with empty strings correctly.`
`629`	`629`	`/// </summary>`
`630`	`630`	`[DataTestMethod, TestCategory(TestCategory.MSSQL)]`
`631`		`- public void ValidateStreamingLogicForEmptyCellsAsync()`
	`631`	`+ public void ValidateStreamingLogicForEmptyCells()`
`632`	`632`	`{`
`633`	`633`	`TestHelper.SetupDatabaseEnvironment(TestCategory.MSSQL);`
`634`	`634`	`FileSystem fileSystem = new();`