When you run a query that uses Adaptive join feature in SQL Server 2017, you will notice that the query fails to run. Additionally, you may receive error messages that resembles the following:
Msg 596, Level 21, State 1, Line LineNumber
Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line LineNumber
A severe error occurred on the current command. The results, if any, should be discarded.
As a workaround for this issue, you may disable the Adaptive Join feature for the query.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.