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() { NDOQueryq = 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 ...