📄 tst2560.mal
字号:
#materialized views exampler:= bat.new(:oid,:int);bat.setRole(r,"emp","age");bat.append(r,1);bat.append(r,2);bat.append(r,3);io.print(r);s:= bat.new(:oid,:str);bat.setRole(s,"emp","name");bat.append(s,"A");bat.append(s,"B");bat.append(s,"C");io.print(s);factory view1(l:int,h:int):bat[:oid,:str];a:bat[:oid,:int] := bbp.find("emp","age");b:bat[:oid,:str] := bbp.find("emp","name");barrier always:= true; lOld:= l; hOld:= h; io.print("recalc"); c := algebra.select(a,l,h); d := algebra.semijoin(b,c); barrier available:=true; yield d; leave available:= lOld != l; leave available:= hOld != h; io.print("reuse"); redo available:=true; exit available; redo always;exit always;end view1;e:= user.view1(0,2);io.print(e);e:= user.view1(0,2);io.print(e);e:= user.view1(0,4);io.print(e);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -