Menu

#1138 Exclude null rows from the query results

new
nobody
query (2)
Core/OQL
Medium
2.1.0
defect
2018-02-19
2015-08-31
No

Some queries may return a null row (see [#1134])

Example:
SELECT l FROM Server AS s JOIN Location AS l ON s.location_id = l.id

Such rows do not make sense. They should be excluded both from the count and from the result set.

Suggested implementation: tweak each and every query (excepted when fetching a unique object); for each selected class, add the criteria "AND <class>.id IS NOT NULL" (currently expressed in OQL as "ISNULL(<class>.id) != 1")

Related

Tickets: #1134

Discussion


Log in to post a comment.