
Hello,
I have one question about Search behavior:
Repro steps:
1) Paste in editor code:
USE [AdventureWorks]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSP_OutOfMemory]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TestSP_OutOfMemory]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[TestSP_OutOfMemory]
AS
SET NOCOUNT ON
DECLARE @i int, @RecCount int, @CurrDate datetime
DECLARE @tbl TABLE ( pk int, val int)
SET @RecCount = 1000000
SET @i = 1
WHILE @i <= @RecCount BEGIN
INSERT INTO @tbl VALUES (@i, @i)
SET @i = @i + 1
END
SELECT getdate()
GO
2) Try to find [dbo].[TestSP_OutOfMemory] with "Match whole word" option is ON
3) App will fail to find any occurrence (with appropriate message)
Is this defect? Can I solved it somehow?
Thanks,
Ivana.
I have one question about Search behavior:
Repro steps:
1) Paste in editor code:
USE [AdventureWorks]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSP_OutOfMemory]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TestSP_OutOfMemory]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[TestSP_OutOfMemory]
AS
SET NOCOUNT ON
DECLARE @i int, @RecCount int, @CurrDate datetime
DECLARE @tbl TABLE ( pk int, val int)
SET @RecCount = 1000000
SET @i = 1
WHILE @i <= @RecCount BEGIN
INSERT INTO @tbl VALUES (@i, @i)
SET @i = @i + 1
END
SELECT getdate()
GO
2) Try to find [dbo].[TestSP_OutOfMemory] with "Match whole word" option is ON
3) App will fail to find any occurrence (with appropriate message)
Is this defect? Can I solved it somehow?
Thanks,
Ivana.