Microsoft KB Archive/110566

FIX: PATINDEX on CONVERT May Cause GP Fault

PSS ID Number: Q110566 Article last modified on 01-24-1995

4.20

WINDOWS

BUG# NT: 581 (4.2)

= SYMPTOMS =

Using the TEXT function PATINDEX with a static string converted to TEXT using the CONVERT function may cause a general protection fault (GP fault) on SQL Server.

= WORKAROUND =

Use an equivalent C or Visual Basic string function if performing DB-Library (DB-Lib) programming.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for Windows NT. This problem was corrected in SQL Server version 4.21. For more information, contact your primary support provider.

= MORE INFORMATION =

The query,

SELECT PATINDEX(“x”, CONVERT(TEXT, “x”))

may terminate the SQL Server for Windows NT client with the error:

Access Violation

Additional reference words: 4.20 kernel GP-Fault KBCategory: kbprg KBSubCategory: SSrvWinNT

=
================================================================

Copyright Microsoft Corporation 1995.