PRB: Access Violation Occurs with the Use of OpenXML in a User-Defined Function (279078)

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a user-defined function, as follows:

   CREATE FUNCTION dbo.udfTestOPENXML
      (@iDocID INT, @sXPath NVARCHAR(100))
   RETURNS TABLE
   AS
   RETURN 
     SELECT *
     FROM OPENXML (@iDocID, @sXPath)
       WITH (
         Value1  VARCHAR(10),
         Value2  VARCHAR(10)
       )
   GO
   					

   NOTE: The following steps 2 through 4 must be executed in a single batch rather than individually.
   
   
2. Declare an XML document variable and a text variable to hold the XML text:

   DECLARE @hXMLInsertDoc int, @hXMLInsertDocText varchar(1000)
   
   SET @hXMLInsertDocText ='<Root><test Value1="test1" Value2="test2">This is a test</test></Root>'
   					

3. Prepare the XML document from the text:

   EXEC sp_xml_preparedocument @hXMLInsertDoc OUTPUT, @hXMLInsertDocText
   					

4. Execute the user-defined function with the prepared document:

   SELECT * FROM dbo.udfTestOPENXML(@hXMLInsertDoc,'/Root/test')
   						

   NOTE: This is where the error occurs.

Workaround

CREATE FUNCTION dbo.udfTestOPENXML
   (@iDocID INT, @sXPath VARCHAR(8000))
RETURNS @tbl
    TABLE (
           Value1 VARCHAR(10),
           Value2 VARCHAR(10)
           )
AS
BEGIN
 
   INSERT @tbl
   SELECT *
   FROM OPENXML (@iDocID, @sXPath)
     WITH (
       Value1  VARCHAR(10),
       Value2  VARCHAR(10)
     )

   RETURN
END