FIX: PATINDEX on CONVERT May Cause GP Fault
PSS ID Number: Q110566 Article last modified on 01-24-1995
4.20
WINDOWS
The information in this article applies to: |
- Microsoft SQL Server, version 4.2 |
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.