Does this dialect support referencing the table being mutated in
a subquery. The "table being mutated" is the table referenced in
an UPDATE or a DELETE query. And so can that table then be
referenced in a subquery of said UPDATE/DELETE query.
For example, would the following two syntaxes be supported:
- delete from TABLE_A where ID not in ( select ID from TABLE_A )
- update TABLE_A set NON_ID = 'something' where ID in ( select ID from TABLE_A)
Namespace: NHibernate.DialectAssembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)
Syntax
| C# |
|---|
public virtual bool SupportsSubqueryOnMutatingTable { get; } |
| Visual Basic |
|---|
Public Overridable ReadOnly Property SupportsSubqueryOnMutatingTable As Boolean
Get |
| Visual C++ |
|---|
public:
virtual property bool SupportsSubqueryOnMutatingTable {
bool get ();
} |
Return Value
True if this dialect allows references the mutating table from a subquery.
See Also