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