Test with JOIN, oid and IS NOT NULL fails

Number:1970
Tracker:Fehler
Author:Mirko Matytschak
Version:NDO 4.0
Assigned to: Mirko Matytschak
Status: Neu

[Test]
public void TestIfQueryForNonNullOidsWorks()
{
    NDOQuery q = new NDOQuery( pm, "dieReisen.dieLaender.oid IS NOT NULL" );
    Assert.AreEqual( $"SELECT {this.mitarbeiterJoinFields} FROM [Mitarbeiter] INNER JOIN [Reise] ON [Mitarbeiter].[ID] = [Reise].[IDMitarbeiter] INNER JOIN [relLandReise] ON [Reise].[ID] = [relLandReise].[IDReise] INNER JOIN [Land] ON [Land].[ID] = [relLandReise].[IDLand] WHERE [Land].[ID] IS NOT NULL", q.GeneratedQuery );
}


Mirko Matytschak - 25.03.2019 17:36:03

Query string is missing INNER JOIN [Land] ON ...

<<  previous   next  >>
Back to the Overview