Deveel.Data.Sql.Query.LeftOuterJoinNode Class Reference

A branch node for a left outer join. More...

Inheritance diagram for Deveel.Data.Sql.Query.LeftOuterJoinNode:

Public Member Functions
	LeftOuterJoinNode (IQueryPlanNode child, string markerName)
override ITable	Evaluate (IRequest context)

Protected Member Functions
override void	GetData (SerializeData data)
Protected Member Functions inherited from Deveel.Data.Sql.Query.SingleQueryPlanNode
	SingleQueryPlanNode (IQueryPlanNode child)
	SingleQueryPlanNode (ObjectData data)

Properties
string	MarkerName [get, private set]
Properties inherited from Deveel.Data.Sql.Query.SingleQueryPlanNode
IQueryPlanNode	Child [get, private set]
	Gets the single child node of the plan. More...

Private Member Functions
	LeftOuterJoinNode (ObjectData data)

Detailed Description

A branch node for a left outer join.

Using this node is a little non-intuitive. This node will only work when used in conjuction with MarkerNode.

To use - first the complete left table in the join must be marked with a name. Then the on expression is evaluated to a single plan node. Then this plan node must be added to result in a left outer join. A tree for a left outer join may look as follows:

   LeftOuterJoinNode
           |
       Join a = b
       /         \
   Marker      GetTable T2
     |
GetTable T1

Definition at line 48 of file LeftOuterJoinNode.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Query.LeftOuterJoinNode.LeftOuterJoinNode ( IQueryPlanNode  child, string  markerName  )

inline

Definition at line 49 of file LeftOuterJoinNode.cs.

            : base(child) {
            MarkerName = markerName;
        }

Deveel.Data.Sql.Query.LeftOuterJoinNode.LeftOuterJoinNode ( ObjectData  data )

inlineprivate

Definition at line 54 of file LeftOuterJoinNode.cs.

            : base(data) {
            MarkerName = data.GetString("Marker");
        }

Member Function Documentation

override ITable Deveel.Data.Sql.Query.LeftOuterJoinNode.Evaluate ( IRequest  context )

inlinevirtual

Implements Deveel.Data.Sql.Query.SingleQueryPlanNode.

Definition at line 61 of file LeftOuterJoinNode.cs.

                                                          {
            // Evaluate the child branch,
            var result = Child.Evaluate(context);
            // Get the table of the complete mark name,
            var completeLeft = context.Query.GetCachedTable(MarkerName);

            // The rows in 'complete_left' that are outside (not in) the rows in the
            // left result.
            var outside = completeLeft.OuterJoin(result);

            // Create an OuterTable
            var outerTable = OuterTable.Create(result);
            outerTable.MergeIn(outside);

            // Return the outer table
            return outerTable;
        }

override void Deveel.Data.Sql.Query.LeftOuterJoinNode.GetData ( SerializeData  data )

inlineprotectedvirtual

Reimplemented from Deveel.Data.Sql.Query.SingleQueryPlanNode.

Definition at line 79 of file LeftOuterJoinNode.cs.

                                                            {
            data.SetValue("Marker", MarkerName);
        }

Property Documentation

string Deveel.Data.Sql.Query.LeftOuterJoinNode.MarkerName

getprivate set

Definition at line 59 of file LeftOuterJoinNode.cs.

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Query/LeftOuterJoinNode.cs