ID Number: Q78381
1.11 | 1.11 | 1.11
MS-DOS | WINDOWS | OS/2
buglist1.11
Summary:
Problem ID: PRSQL9111006
SYMPTOMS
A query that issues a JOIN between two tables issuing a LIKE clause
on the JOIN key may cause SQL Server to GP-fault with a SYS1943 "A
program caused a protection violation" error.
WORKAROUND
To work around this problem, restructure the query to avoid the
problem. For example:
Original Query Restructured Query
-------------- ------------------
select * select *
from pa, pb from pa, pb
where panum = pbnum where panum=pbnum
and panum like 's317%' and panum in (select panum
from pa
where panum like 's317%')
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. We are researching this problem and will post new information
here as it becomes available.