Description
Roger created an issue — 27th February 2012, 23:17:42:
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
This does not work for any dialect
Roger added a comment — 28th February 2012, 10:32:24:
Failing test created as a pull request here
#87Also, I noticed that this issue is a duplicate of NH-2408.
Julian Maughan added a comment — 4th March 2012, 3:46:30:
The test is committed - thanks Roger.
Roger added a comment — 28th February 2013, 9:53:58:
FYI, now when NH-2408 is fixed, this ticket's committed test passes.
You can set this issue to resolved and removed the test's ignore attribute.
Oskar Berggren added a comment — 10th March 2013, 10:08:49:
Was fixed for MS SQL Server in NH-2408 but on at least Oracle and PostgreSQL there are still exceptions.