PRSQL9103034: Table Lock Not Escalated with TEXT Datatype

ID Number: Q70854

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103034

SYMPTOMS

SQL Server does not escalate to a table lock with TEXT datatype in

a query with a LIKE clause. Instead, the server will terminate the

query and inform the user that the maximum number of locks has been

reached.

RESOLUTION

Explicitly force a table lock by executing the SELECT statement

with a HOLDLOCK when executing a query with a LIKE clause and TEXT

datatype.