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.Dialect
Assembly: 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