monetb: what does bind function does with access argument?

Question

I am looking into the MAL code of an execution plan for a query. Can anyone explain what the bind function does in detail?

Specifically, what does the following MAL statements actually do?

X_6:bat[:oid,:int]  := sql.bind(X_2,"sys","region","r_regionkey",0);
(X_9,r1_9) := sql.bind(X_2,"sys","region","r_regionkey",2);
X_12:bat[:oid,:int]  := sql.bind(X_2,"sys","region","r_regionkey",1);

My DB has a table region with r_regionkey as an attribute. The query I used was:

select * from region;

score 0 · Answer 1 · answered Jul 19 '16 at 09:35

0

MonetDB supports optimistic concurrency control, keeping the deltas around until a convenient moment arises to merge them into the tables.

answered Jul 19 '16 at 09:35

mkersten

694
3
7

... and the three `bind`s correspond to the original table and the delta's of deletions and additions. – einpoklum Aug 07 '16 at 08:25

monetb: what does bind function does with access argument?

1 Answers1