View Incident Report

Serious

Reported By: Christian Sanggaard
Reported On: 2/17/2004
For: Version 4.03 Build 1

# 1717 Using a BETWEEN Operator in an SQL SELECT JOIN Clause Causes Incorrect Results

I've a strange SQL problem after uddating to dbisam ver. 3.27. The SQL engine doesn't include the "between" command in the "join" clause. In ver. 3.26 both examples works, but after I updated to ver. 3.27, it is only the last example, that gives the correct result.

Example 1:
SELECT term,bonnr,j.lobenr,j.dato FROM entries e
LEFT OUTER JOIN journal j ON e.term=j.term AND e.bonnr BETWEEN j.frabonnr
AND j.TILBONNR;

Example 2:
SELECT term,bonnr,j.lobenr,j.dato FROM entries e
LEFT OUTER JOIN journal j ON e.term=j.term AND e.bonnr>=j.frabonnr AND
e.bonnr<=j.tilbonnr;

Resolution

Fixed Problem on 2/26/2004 in version 4.05 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap