Errors in fulltext query using SQL Server 2008

When doing some fulltext queries with SQL Server 2008, the SQL Server may crash with:

Error: 17310, Severity: 20, State: 1. 
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 
A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 

Two types of queries have been found to cause this error:

1. a query containing a fulltext match mixed with another field, for instance:

  SELECT * FROM Document WHERE ecm:fulltext = 'test' AND dc:title = 'doc' 

2. a request where the FROM clause contains a non-herited document type mixed with a fulltext match, for instance:

  SELECT * FROM File WHERE ecm:fulltext = 'test' 

The query:

  SELECT * FROM Folder WHERE ecm:fulltext = 'test'

does not crash, as Folder is inherited by several document types.

These queries seem to fail because of a bug in SQL Server 2008 due to the UNION ALL and a parallel execution plan.
Adding a:

  ... AND ecm:isProxy = 0

to the queries makes them work as the UNION ALL does not exist in this case.

Note that when we execute the generated queries directly in the SQL Server interface there is no error. This may be due to the fact that Nuxeo uses cursors to fetch the results.

This is a bug in SQL Server 2008 for which we have no fix at this time.