Incorrect search behavior with option MatchWholeWord = ON

SyntaxEditor for Windows Forms Forum

Posted 10 years ago by ivanaivana
Version: 4.0.0281
Avatar
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.

Comments (1)

Posted 10 years ago by Actipro Software Support - Cleveland, OH, USA
Avatar
Thanks we're updated our whole word pattern to work in this scenario. This will be in the next maintenance release.


Actipro Software Support

The latest build of this product (v2018.1 build 0342) was released 11 days ago, which was after the last post in this thread.

Add Comment

Please log in to a validated account to post comments.