Issue Details (XML | Word | Printable)

Key: CORE-1436
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

Outer joins don't work properly with the MON$ tables

Created: 31/Aug/07 06:13 AM   Updated: 29/May/15 05:25 PM
Component/s: Engine
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Issue Links:

QA Status: Done successfully
Test Details: Changed code to make it independent of system tables content.

 Description  « Hide
When the join condition evaluates to false, the inner part of the join contains data instead of NULLs.

Test case:

select db.mon$database_name
from mon$attachments att
  left join mon$database db on db.mon$creation_date = att.mon$timestamp

-- should return NULL

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 06/Oct/08 11:21 AM
Q/A tested ok