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.
