union-subclass + SetLockMode does not work on all dialects

Description

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

Environment

None

Activity

Show:

Oskar Berggren 
March 10, 2013 at 10:08 AM

Was fixed for MS SQL Server in https://nhibernate.jira.com/browse/NH-2408#icft=NH-2408 but on at least Oracle and PostgreSQL there are still exceptions.

Roger 
February 28, 2013 at 9:53 AM

FYI, now when https://nhibernate.jira.com/browse/NH-2408#icft=NH-2408 is fixed, this ticket's committed test passes.

You can set this issue to resolved and removed the test's ignore attribute.

Julian Maughan 
March 4, 2012 at 3:46 AM

The test is committed - thanks Roger.

Roger 
February 28, 2012 at 10:32 AM

Failing test created as a pull request here
https://github.com/nhibernate/nhibernate-core/pull/87

Also, I noticed that this issue is a duplicate of NH-2408.

Details

Assignee

Reporter

Labels

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created February 27, 2012 at 11:17 PM
Updated September 9, 2014 at 12:57 PM
Who's Looking?

Flag notifications