View Incident Report

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap