Icon View Incident Report

Serious Serious
Reported By: Dorian Ciocan
Reported On: 9/6/2004
For: Version 4.10 Build 1
# 1840 NULL Comparisons On Target Of Outer->Inner Joins in SQL SELECT WHERE Clause Cause Incorrect Results

Please run the following sql. This sql return wrong results.

SELECT date.data, plancontabil.nr_cont
FROM date_det RIGHT JOIN plancontabil on
date_det.nr_cont = plancontabil.nr_cont
INNER JOIN date on date_det.id_date = date.id_date
WHERE date.data is not null

Resolution Resolution
Fixed Problem on 9/12/2004 in version 4.11 build 1