API tools faq
paste
Advertisement
Guest User

MAL script

a guest
Oct 3rd, 2014
218
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.74 KB | None | 0 0
raw download clone embed print report
  1. function user.s0_11{autoCommit=true}(A0:int,A1:str,A2:str,A3:str):void;
  2. sql.init();
  3. sql.start();
  4. X_6 := sql.mvc();
  5. X_7:bat[:oid,:oid] := sql.tid(X_6,"sys","partsupp");
  6. X_10 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",0);
  7. (X_13,r1_13) := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",2);
  8. X_16 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",1);
  9. X_18 := sql.projectdelta(X_7,X_10,X_13,r1_13,X_16);
  10. X_21 := sql.bind(X_6,"sys","part","p_type",0);
  11. X_27 := sql.bind(X_6,"sys","part","p_size",0);
  12. X_19:bat[:oid,:oid] := sql.tid(X_6,"sys","part");
  13. X_391 := algebra.subselect(X_27,X_19,A0,A0,true,true,false);
  14. (X_29,r1_41) := sql.bind(X_6,"sys","part","p_size",2);
  15. X_392 := algebra.subselect(r1_41,A0,A0,true,true,false);
  16. X_32 := sql.bind(X_6,"sys","part","p_size",1);
  17. X_393 := algebra.subselect(X_32,X_19,A0,A0,true,true,false);
  18. X_33 := sql.subdelta(X_391,X_19,X_29,X_392,X_393);
  19. X_394 := algebra.likesubselect(X_21,X_33,A1,"",false);
  20. (X_23,r1_29) := sql.bind(X_6,"sys","part","p_type",2);
  21. X_395 := algebra.likesubselect(r1_29,A1,"",false);
  22. X_25 := sql.bind(X_6,"sys","part","p_type",1);
  23. X_396 := algebra.likesubselect(X_25,X_33,A1,"",false);
  24. X_36 := sql.subdelta(X_394,X_33,X_23,X_395,X_396);
  25. X_37 := X_36;
  26. (X_38,r1_60) := algebra.join(X_18,X_37);
  27. X_40 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",0);
  28. (X_44,r1_66) := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",2);
  29. X_47 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",1);
  30. X_49 := sql.projectdelta(X_7,X_40,X_44,r1_66,X_47);
  31. X_50 := algebra.leftfetchjoin(X_38,X_49);
  32. X_51:bat[:oid,:oid] := sql.tid(X_6,"sys","supplier");
  33. (X_54,r1_88) := algebra.join(X_50,X_51);
  34. X_56 := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",0);
  35. (X_58,r1_92) := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",2);
  36. X_60 := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",1);
  37. X_61 := sql.projectdelta(X_51,X_56,X_58,r1_92,X_60);
  38. X_62 := algebra.leftfetchjoin(r1_88,X_61);
  39. X_63:bat[:oid,:oid] := sql.tid(X_6,"sys","nation");
  40. (X_65,r1_112) := algebra.join(X_62,X_63);
  41. X_67 := sql.bind(X_6,"sys","nation","n_regionkey",0);
  42. (X_71,r1_118) := sql.bind(X_6,"sys","nation","n_regionkey",2);
  43. X_74 := sql.bind(X_6,"sys","nation","n_regionkey",1);
  44. X_76 := sql.projectdelta(X_63,X_67,X_71,r1_118,X_74);
  45. X_77 := algebra.leftfetchjoin(r1_112,X_76);
  46. X_80 := sql.bind(X_6,"sys","region","r_name",0);
  47. X_78:bat[:oid,:oid] := sql.tid(X_6,"sys","region");
  48. X_397 := algebra.subselect(X_80,X_78,A2,A2,true,true,false);
  49. (X_82,r1_134) := sql.bind(X_6,"sys","region","r_name",2);
  50. X_398 := algebra.subselect(r1_134,A2,A2,true,true,false);
  51. X_84 := sql.bind(X_6,"sys","region","r_name",1);
  52. X_399 := algebra.subselect(X_84,X_78,A2,A2,true,true,false);
  53. X_85 := sql.subdelta(X_397,X_78,X_82,X_398,X_399);
  54. X_88 := sql.bind(X_6,"sys","region","r_regionkey",0);
  55. (X_90,r1_147) := sql.bind(X_6,"sys","region","r_regionkey",2);
  56. X_93 := sql.bind(X_6,"sys","region","r_regionkey",1);
  57. X_94 := sql.projectdelta(X_85,X_88,X_90,r1_147,X_93);
  58. (X_95,r1_156) := algebra.join(X_77,X_94);
  59. X_403 := algebra.leftfetchjoin(X_95,X_65);
  60. X_97 := sql.bind(X_6,"sys","part","p_partkey",0);
  61. (X_101,r1_162) := sql.bind(X_6,"sys","part","p_partkey",2);
  62. X_104 := sql.bind(X_6,"sys","part","p_partkey",1);
  63. X_106 := sql.projectdelta(X_36,X_97,X_101,r1_162,X_104);
  64. X_107:bat[:oid,:int] := algebra.leftfetchjoinPath(X_403,X_54,r1_60,X_106);
  65. X_108:bat[:oid,:wrd] := batcalc.hash(X_107);
  66. X_110 := sql.bind(X_6,"sys","partsupp","ps_supplycost",0);
  67. (X_114,r1_193) := sql.bind(X_6,"sys","partsupp","ps_supplycost",2);
  68. X_116 := sql.bind(X_6,"sys","partsupp","ps_supplycost",1);
  69. X_117 := sql.projectdelta(X_7,X_110,X_114,r1_193,X_116);
  70. X_118:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_403,X_54,X_38,X_117);
  71. X_119:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_108,22,X_118);
  72. X_121 := sql.bind_idxbat(X_6,"sys","nation","nation_n_regionkey_fkey",0);
  73. (X_124,r1_218) := sql.bind_idxbat(X_6,"sys","nation","nation_n_regionkey_fkey",2);
  74. X_127 := sql.bind_idxbat(X_6,"sys","nation","nation_n_regionkey_fkey",1);
  75. X_129 := sql.projectdelta(X_63,X_121,X_124,r1_218,X_127);
  76. X_400 := algebra.subselect(X_80,X_78,A3,A3,true,true,false);
  77. X_401 := algebra.subselect(r1_134,A3,A3,true,true,false);
  78. X_402 := algebra.subselect(X_84,X_78,A3,A3,true,true,false);
  79. X_131 := sql.subdelta(X_400,X_78,X_82,X_401,X_402);
  80. X_134 := X_131;
  81. (X_135,r1_252) := algebra.join(X_129,X_134);
  82. X_137 := algebra.leftfetchjoin(X_135,X_63);
  83. X_138:bat[:oid,:oid] := sql.tid(X_6,"sys","supplier");
  84. X_140 := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",0);
  85. (X_144,r1_268) := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",2);
  86. X_147 := sql.bind_idxbat(X_6,"sys","supplier","supplier_s_nationkey_fkey",1);
  87. X_149 := sql.projectdelta(X_138,X_140,X_144,r1_268,X_147);
  88. (X_150,r1_280) := algebra.join(X_137,X_149);
  89. X_152 := algebra.leftfetchjoin(r1_280,X_138);
  90. X_153:bat[:oid,:oid] := sql.tid(X_6,"sys","partsupp");
  91. X_155 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",0);
  92. (X_157,r1_294) := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",2);
  93. X_159 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",1);
  94. X_160 := sql.projectdelta(X_153,X_155,X_157,r1_294,X_159);
  95. (X_161,r1_304) := algebra.join(X_152,X_160);
  96. X_404 := algebra.leftfetchjoin(X_150,X_135);
  97. X_163 := sql.bind(X_6,"sys","nation","n_nationkey",0);
  98. (X_168,r1_311) := sql.bind(X_6,"sys","nation","n_nationkey",2);
  99. X_171 := sql.bind(X_6,"sys","nation","n_nationkey",1);
  100. X_173 := sql.projectdelta(X_63,X_163,X_168,r1_311,X_171);
  101. X_174:bat[:oid,:int] := algebra.leftfetchjoinPath(X_161,X_404,X_173);
  102. X_175 := bat.mirror(X_174);
  103. X_176 := sql.bind(X_6,"sys","partsupp","ps_partkey",0);
  104. (X_179,r1_333) := sql.bind(X_6,"sys","partsupp","ps_partkey",2);
  105. X_181 := sql.bind(X_6,"sys","partsupp","ps_partkey",1);
  106. X_182 := sql.projectdelta(X_153,X_176,X_179,r1_333,X_181);
  107. X_183 := algebra.leftfetchjoin(r1_304,X_182);
  108. (X_184,r1_343) := algebra.join(X_183,X_107);
  109. X_186 := algebra.tinter(X_175,X_184);
  110. X_187 := algebra.leftfetchjoin(X_186,X_183);
  111. (X_188,r1_349,r2_349) := group.subgroupdone(X_187);
  112. X_191 := algebra.leftfetchjoin(r1_349,X_187);
  113. X_194 := sql.projectdelta(X_153,X_110,X_114,r1_193,X_116);
  114. X_195:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_186,r1_304,X_194);
  115. X_196:bat[:oid,:lng] := aggr.submin(X_195,X_188,r1_349,true);
  116. X_192:bat[:oid,:wrd] := batcalc.hash(X_191);
  117. X_198:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_192,22,X_196);
  118. (X_199,r1_389) := algebra.join(X_119,X_198);
  119. X_201 := algebra.leftfetchjoin(X_199,X_107);
  120. X_202 := algebra.leftfetchjoin(r1_389,X_191);
  121. X_203:bat[:oid,:bit] := batcalc.==(X_201,X_202);
  122. X_204 := algebra.subselect(X_203,true,true,true,true,false);
  123. X_206 := algebra.leftfetchjoin(X_204,X_199);
  124. X_207 := algebra.leftfetchjoin(X_206,X_118);
  125. X_208:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_204,r1_389,X_196);
  126. X_209:bat[:oid,:bit] := batcalc.==(X_207,X_208);
  127. X_210 := algebra.subselect(X_209,true,true,true,true,false);
  128. X_211 := algebra.leftfetchjoin(X_210,X_206);
  129. X_405 := algebra.leftfetchjoin(X_211,X_95);
  130. X_212 := sql.bind(X_6,"sys","supplier","s_acctbal",0);
  131. (X_217,r1_412) := sql.bind(X_6,"sys","supplier","s_acctbal",2);
  132. X_220 := sql.bind(X_6,"sys","supplier","s_acctbal",1);
  133. X_222 := sql.projectdelta(X_51,X_212,X_217,r1_412,X_220);
  134. X_223:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_405,X_65,r1_88,X_222);
  135. X_224 := pqueue.utopn_min(X_223,100:wrd);
  136. X_225 := bat.mirror(X_224);
  137. X_226 := sql.bind(X_6,"sys","nation","n_name",0);
  138. (X_231,r1_449) := sql.bind(X_6,"sys","nation","n_name",2);
  139. X_234 := sql.bind(X_6,"sys","nation","n_name",1);
  140. X_236 := sql.projectdelta(X_63,X_226,X_231,r1_449,X_234);
  141. X_237:bat[:oid,:str] := algebra.leftfetchjoinPath(X_405,r1_112,X_236);
  142. X_238 := algebra.leftfetchjoin(X_225,X_237);
  143. X_239 := pqueue.utopn_max(X_224,X_238,100:wrd);
  144. X_240 := bat.mirror(X_239);
  145. X_241 := sql.bind(X_6,"sys","supplier","s_name",0);
  146. (X_246,r1_482) := sql.bind(X_6,"sys","supplier","s_name",2);
  147. X_249 := sql.bind(X_6,"sys","supplier","s_name",1);
  148. X_251 := sql.projectdelta(X_51,X_241,X_246,r1_482,X_249);
  149. X_252:bat[:oid,:str] := algebra.leftfetchjoinPath(X_405,X_65,r1_88,X_251);
  150. X_253 := algebra.leftfetchjoin(X_240,X_252);
  151. X_255 := pqueue.utopn_max(X_239,X_253,100:wrd);
  152. X_256 := bat.mirror(X_255);
  153. X_257 := algebra.leftfetchjoin(X_211,X_107);
  154. X_258 := algebra.leftfetchjoin(X_256,X_257);
  155. X_259 := pqueue.topn_max(X_255,X_258,100:wrd);
  156. X_260 := algebra.subslice(X_259,0:wrd,99:wrd);
  157. X_261 := algebra.leftfetchjoin(X_260,X_223);
  158. X_262 := algebra.subslice(X_261,0:wrd,99:wrd);
  159. X_263 := algebra.leftfetchjoin(X_262,X_261);
  160. X_406 := algebra.leftfetchjoin(X_262,X_260);
  161. X_303 := sql.bind(X_6,"sys","supplier","s_comment",0);
  162. (X_308,r1_674) := sql.bind(X_6,"sys","supplier","s_comment",2);
  163. X_311 := sql.bind(X_6,"sys","supplier","s_comment",1);
  164. X_313 := sql.projectdelta(X_51,X_303,X_308,r1_674,X_311);
  165. X_314:bat[:oid,:str] := algebra.leftfetchjoinPath(X_406,X_211,X_95,X_65,r1_88,X_313);
  166. X_291 := sql.bind(X_6,"sys","supplier","s_phone",0);
  167. (X_296,r1_640) := sql.bind(X_6,"sys","supplier","s_phone",2);
  168. X_299 := sql.bind(X_6,"sys","supplier","s_phone",1);
  169. X_301 := sql.projectdelta(X_51,X_291,X_296,r1_640,X_299);
  170. X_302:bat[:oid,:str] := algebra.leftfetchjoinPath(X_406,X_211,X_95,X_65,r1_88,X_301);
  171. X_279 := sql.bind(X_6,"sys","supplier","s_address",0);
  172. (X_284,r1_606) := sql.bind(X_6,"sys","supplier","s_address",2);
  173. X_287 := sql.bind(X_6,"sys","supplier","s_address",1);
  174. X_289 := sql.projectdelta(X_51,X_279,X_284,r1_606,X_287);
  175. X_290:bat[:oid,:str] := algebra.leftfetchjoinPath(X_406,X_211,X_95,X_65,r1_88,X_289);
  176. X_268 := sql.bind(X_6,"sys","part","p_mfgr",0);
  177. (X_272,r1_566) := sql.bind(X_6,"sys","part","p_mfgr",2);
  178. X_275 := sql.bind(X_6,"sys","part","p_mfgr",1);
  179. X_277 := sql.projectdelta(X_36,X_268,X_272,r1_566,X_275);
  180. X_278:bat[:oid,:str] := algebra.leftfetchjoinPath(X_406,X_211,X_95,X_65,X_54,r1_60,X_277);
  181. X_266:bat[:oid,:int] := algebra.leftfetchjoin(X_406,X_257);
  182. X_265:bat[:oid,:str] := algebra.leftfetchjoin(X_406,X_237);
  183. X_264:bat[:oid,:str] := algebra.leftfetchjoin(X_406,X_252);
  184. X_315 := sql.resultSet(8,1,X_263);
  185. sql.rsColumn(X_315,"sys.supplier","s_acctbal","decimal",15,2,X_263);
  186. sql.rsColumn(X_315,"sys.supplier","s_name","varchar",25,0,X_264);
  187. sql.rsColumn(X_315,"sys.nation","n_name","varchar",25,0,X_265);
  188. sql.rsColumn(X_315,"sys.part","p_partkey","int",32,0,X_266);
  189. sql.rsColumn(X_315,"sys.part","p_mfgr","varchar",25,0,X_278);
  190. sql.rsColumn(X_315,"sys.supplier","s_address","varchar",40,0,X_290);
  191. sql.rsColumn(X_315,"sys.supplier","s_phone","varchar",15,0,X_302);
  192. sql.rsColumn(X_315,"sys.supplier","s_comment","varchar",101,0,X_314);
  193. X_346 := io.stdout();
  194. sql.exportResult(X_346,X_315);
  195. end s0_11;
  196.  
  197. mdb.list("user", "s0_11");
  198. user.s0_11();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!