API tools faq
paste
Advertisement
Guest User

explain query

a guest
Jul 11th, 2013
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 414.14 KB | None | 0 0
raw download clone embed print report
  1. sql>explain select temps_mois.rfoperyea as c0, temps_mois.rfoperdmo as c1, rfovsn.rfovsnide as c2, rfoadv_1.rfoadvsup as c3, rsaaev_2.rsaaevsup as c4, sum((case when dwhinv.dwhinv___rfodomide = 'CLINIQUE' and dwhinv.dwhinv___rfoindide = 'cli_nb_entrees_mco' then dwhinv.dwhinvqte else 0 end)) as m0, sum((case when dwhinv.dwhinv___rfodomide = 'CLINIQUE' and dwhinv.dwhinv___rfoindide = '16' then dwhinv.dwhinvqte else 0 end)) as m1 from rfoper_temps_mois as temps_mois, dwhinv as dwhinv, rfovsn as rfovsn, rfoadv as rfoadv_1, rsaaev as rsaaev_2 where (temps_mois.rfoper___rforefide = 'CHUL') and (dwhinv.dwhinv___rforefide = 'CHUL' and (
  2. more>(dwhinv.dwhinv___rfodomide = 'CLINIQUE' and dwhinv.dwhinv___rfoindide = 'cli_nb_entrees_mco') or
  3. more>(dwhinv.dwhinv___rfodomide = 'CLINIQUE' and dwhinv.dwhinv___rfoindide = '16'))) and dwhinv.dwhinvdtd = temps_mois.rfoperdtd and temps_mois.rfoperyea in ('2011', '2012') and temps_mois.rfoperdmo in ('01', '02') and (rfovsn___rforefide = 'CHUL') and dwhinv.dwhinv___rfovsnide = rfovsn.rfovsnide and rfovsn.rfovsnide = '201204_reel' and (rfoadv_1.rfoadv___rfovdeide='MCO' AND rfoadv_1.rfoadvrvs=1 AND rfoadv_1.rfoadv___rforefide= 'CHUL') and dwhinv.dwhinv_d2rfodstide = rfoadv_1.rfoadvinf and rfoadv_1.rfoadvsup in ('CHIR', 'MED', 'OBS') and (rsaaev_2.rsaaev___rsavedide='PRISE_EN_CHARGE' AND rsaaev_2.rsaaevrvs=1 AND rsaaev_2.rsaaev___rforefide= 'CHUL') and dwhinv.dwhinv___rsaedtide = rsaaev_2.rsaaevinf and rsaaev_2.rsaaevsup = 'REG_HOSPI_SEANCE' group by temps_mois.rfoperyea, temps_mois.rfoperdmo, rfovsn.rfovsnide, rfoadv_1.rfoadvsup, rsaaev_2.rsaaevsup;
  4. +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | mal |
  6. +===============================================================================================================================================================================+
  7. | function user.s1_1{autoCommit=true}(A0:str,A1:str,A2:bte,A3:str,A4:str,A5:bte,A6:str,A7:str,A8:str,A9:str,A10:str,A11:str,A12:str,A13:str,A14:str,A15:str,A16:str,A17:str,A18 |
  8. : :str,A19:int,A20:str,A21:str,A22:str,A23:str,A24:str,A25:int,A26:str,A27:str):void; :
  9. | X_303 := nil:bat[:oid,:str]; |
  10. | X_304 := nil:bat[:oid,:str]; |
  11. | X_305 := nil:bat[:oid,:str]; |
  12. | X_306 := nil:bat[:oid,:str]; |
  13. | X_307 := nil:bat[:oid,:str]; |
  14. | X_320:bat[:oid,:lng] := nil:bat[:oid,:lng]; |
  15. | X_324:bat[:oid,:lng] := nil:bat[:oid,:lng]; |
  16. | barrier X_2564 := language.dataflow(); |
  17. | X_30 := sql.mvc(); |
  18. | X_481:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,0,8); |
  19. | X_507:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,0,8); |
  20. | X_540:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,0,8); |
  21. | X_466:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",0,8); |
  22. | X_752 := algebra.subselect(X_540,X_466,A7,A7,true,true,false); |
  23. | (X_555:bat[:oid,:oid] ,X_556:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,0,8); |
  24. | X_761 := algebra.subselect(X_556,A7,A7,true,true,false); |
  25. | X_769 := sql.subdelta(X_752,X_466,X_555,X_761); |
  26. | X_777 := algebra.subselect(X_507,X_769,A8,A8,true,true,false); |
  27. | (X_522:bat[:oid,:oid] ,X_523:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,0,8); |
  28. | X_792 := algebra.subselect(X_523,A8,A8,true,true,false); |
  29. | X_801 := sql.subdelta(X_777,X_769,X_522,X_792); |
  30. | X_809 := algebra.subselect(X_481,X_801,A9,A9,true,true,false); |
  31. | (X_489:bat[:oid,:oid] ,X_490:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,0,8); |
  32. | X_817 := algebra.subselect(X_490,A9,A9,true,true,false); |
  33. | X_832 := sql.subdelta(X_809,X_801,X_489,X_817); |
  34. | X_841 := algebra.subselect(X_507,X_769,A10,A10,true,true,false); |
  35. | X_849 := algebra.subselect(X_523,A10,A10,true,true,false); |
  36. | X_857 := sql.subdelta(X_841,X_769,X_522,X_849); |
  37. | X_872 := algebra.subselect(X_481,X_857,A11,A11,true,true,false); |
  38. | X_881 := algebra.subselect(X_490,A11,A11,true,true,false); |
  39. | X_889 := sql.subdelta(X_872,X_857,X_489,X_881); |
  40. | X_897 := bat.mergecand(X_832,X_889); |
  41. | X_912 := algebra.subselect(X_507,X_897,A8,A8,true,true,false); |
  42. | X_921 := algebra.subselect(X_523,A8,A8,true,true,false); |
  43. | X_929 := sql.subdelta(X_912,X_897,X_522,X_921); |
  44. | X_937 := algebra.subselect(X_507,X_897,A10,A10,true,true,false); |
  45. | X_952 := algebra.subselect(X_523,A10,A10,true,true,false); |
  46. | X_961 := sql.subdelta(X_937,X_897,X_522,X_952); |
  47. | X_969 := bat.mergecand(X_929,X_961); |
  48. | X_977 := algebra.subselect(X_481,X_969,A9,A9,true,true,false); |
  49. | X_992 := algebra.subselect(X_490,A9,A9,true,true,false); |
  50. | X_1001 := sql.subdelta(X_977,X_969,X_489,X_992); |
  51. | X_1009 := algebra.subselect(X_481,X_969,A11,A11,true,true,false); |
  52. | X_1017 := algebra.subselect(X_490,A11,A11,true,true,false); |
  53. | X_1032 := sql.subdelta(X_1009,X_969,X_489,X_1017); |
  54. | X_1041 := bat.mergecand(X_1001,X_1032); |
  55. | X_573:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,0,8); |
  56. | (X_588:bat[:oid,:oid] ,X_589:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,0,8); |
  57. | X_1056 := sql.projectdelta(X_1041,X_573,X_588,X_589); |
  58. | X_53 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdmo",0); |
  59. | X_58 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperyea",0); |
  60. | X_63 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoper___rforefide",0); |
  61. | X_51:bat[:oid,:oid] := sql.tid(X_30,"axabas","rfoper_temps_mois"); |
  62. | X_413 := algebra.subselect(X_63,X_51,A6,A6,true,true,false); |
  63. | (X_67,r1_130) := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoper___rforefide",2); |
  64. | X_414 := algebra.subselect(r1_130,A6,A6,true,true,false); |
  65. | X_70 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoper___rforefide",1); |
  66. | X_415 := algebra.subselect(X_70,X_51,A6,A6,true,true,false); |
  67. | X_72 := sql.subdelta(X_413,X_51,X_67,X_414,X_415); |
  68. | X_416 := algebra.subselect(X_58,X_72,A12,A12,true,true,false); |
  69. | (X_60,r1_118) := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperyea",2); |
  70. | X_417 := algebra.subselect(r1_118,A12,A12,true,true,false); |
  71. | X_62 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperyea",1); |
  72. | X_418 := algebra.subselect(X_62,X_72,A12,A12,true,true,false); |
  73. | X_75 := sql.subdelta(X_416,X_72,X_60,X_417,X_418); |
  74. | X_419 := algebra.subselect(X_58,X_72,A13,A13,true,true,false); |
  75. | X_420 := algebra.subselect(r1_118,A13,A13,true,true,false); |
  76. | X_421 := algebra.subselect(X_62,X_72,A13,A13,true,true,false); |
  77. | X_76 := sql.subdelta(X_419,X_72,X_60,X_420,X_421); |
  78. | X_77 := bat.mergecand(X_75,X_76); |
  79. | X_422 := algebra.subselect(X_53,X_77,A14,A14,true,true,false); |
  80. | (X_55,r1_107) := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdmo",2); |
  81. | X_423 := algebra.subselect(r1_107,A14,A14,true,true,false); |
  82. | X_57 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdmo",1); |
  83. | X_424 := algebra.subselect(X_57,X_77,A14,A14,true,true,false); |
  84. | X_78 := sql.subdelta(X_422,X_77,X_55,X_423,X_424); |
  85. | X_425 := algebra.subselect(X_53,X_77,A15,A15,true,true,false); |
  86. | X_426 := algebra.subselect(r1_107,A15,A15,true,true,false); |
  87. | X_427 := algebra.subselect(X_57,X_77,A15,A15,true,true,false); |
  88. | X_79 := sql.subdelta(X_425,X_77,X_55,X_426,X_427); |
  89. | X_80 := bat.mergecand(X_78,X_79); |
  90. | X_81 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdtd",0); |
  91. | (X_84,r1_154) := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdtd",2); |
  92. | X_86 := sql.bind(X_30,"axabas","rfoper_temps_mois","rfoperdtd",1); |
  93. | X_87 := sql.projectdelta(X_80,X_81,X_84,r1_154,X_86); |
  94. | (X_1065,X_1066) := algebra.join(X_1056,X_87); |
  95. | X_606:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,0,8); |
  96. | (X_621:bat[:oid,:oid] ,X_622:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,0,8); |
  97. | X_1089 := sql.projectdelta(X_1041,X_606,X_621,X_622); |
  98. | X_1097 := algebra.leftfetchjoin(X_1065,X_1089); |
  99. | X_97 := sql.bind(X_30,"axabas","rfovsn","rfovsnide",0); |
  100. | X_102 := sql.bind(X_30,"axabas","rfovsn","rfovsn___rforefide",0); |
  101. | X_95:bat[:oid,:oid] := sql.tid(X_30,"axabas","rfovsn"); |
  102. | X_428 := algebra.subselect(X_102,X_95,A16,A16,true,true,false); |
  103. | (X_104,r1_197) := sql.bind(X_30,"axabas","rfovsn","rfovsn___rforefide",2); |
  104. | X_429 := algebra.subselect(r1_197,A16,A16,true,true,false); |
  105. | X_107 := sql.bind(X_30,"axabas","rfovsn","rfovsn___rforefide",1); |
  106. | X_430 := algebra.subselect(X_107,X_95,A16,A16,true,true,false); |
  107. | X_108 := sql.subdelta(X_428,X_95,X_104,X_429,X_430); |
  108. | X_431 := algebra.subselect(X_97,X_108,A17,A17,true,true,false); |
  109. | (X_99,r1_187) := sql.bind(X_30,"axabas","rfovsn","rfovsnide",2); |
  110. | X_432 := algebra.subselect(r1_187,A17,A17,true,true,false); |
  111. | X_101 := sql.bind(X_30,"axabas","rfovsn","rfovsnide",1); |
  112. | X_433 := algebra.subselect(X_101,X_108,A17,A17,true,true,false); |
  113. | X_111 := sql.subdelta(X_431,X_108,X_99,X_432,X_433); |
  114. | X_112 := sql.projectdelta(X_111,X_97,X_99,r1_187,X_101); |
  115. | (X_1112,X_1113) := algebra.join(X_1097,X_112); |
  116. | X_2458 := algebra.leftfetchjoin(X_1112,X_1065); |
  117. | X_639:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,0,8); |
  118. | (X_654:bat[:oid,:oid] ,X_655:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,0,8); |
  119. | X_1136 := sql.projectdelta(X_1041,X_639,X_654,X_655); |
  120. | X_1145:bat[:oid,:str] := algebra.leftfetchjoin(X_2458,X_1136); |
  121. | X_119:bat[:oid,:oid] := sql.tid(X_30,"axabas","rfoade"); |
  122. | X_122 := sql.bind(X_30,"axabas","rfoade","rfoade_i_rfodstide",0); |
  123. | (X_124,r1_238) := sql.bind(X_30,"axabas","rfoade","rfoade_i_rfodstide",2); |
  124. | X_126 := sql.bind(X_30,"axabas","rfoade","rfoade_i_rfodstide",1); |
  125. | X_127 := sql.projectdelta(X_119,X_122,X_124,r1_238,X_126); |
  126. | (X_1153,X_1154) := algebra.join(X_1145,X_127); |
  127. | X_128 := sql.bind(X_30,"axabas","rfoade","rfoade___rforefide",0); |
  128. | (X_131,r1_251) := sql.bind(X_30,"axabas","rfoade","rfoade___rforefide",2); |
  129. | X_134 := sql.bind(X_30,"axabas","rfoade","rfoade___rforefide",1); |
  130. | X_136 := sql.projectdelta(X_119,X_128,X_131,r1_251,X_134); |
  131. | X_1176 := algebra.leftfetchjoin(X_1154,X_136); |
  132. | X_1185 := batcalc.hash(X_1176); |
  133. | X_138 := sql.bind(X_30,"axabas","rfoade","rfoade___rfovdeide",0); |
  134. | (X_142,r1_272) := sql.bind(X_30,"axabas","rfoade","rfoade___rfovdeide",2); |
  135. | X_144 := sql.bind(X_30,"axabas","rfoade","rfoade___rfovdeide",1); |
  136. | X_145 := sql.projectdelta(X_119,X_138,X_142,r1_272,X_144); |
  137. | X_1193 := algebra.leftfetchjoin(X_1154,X_145); |
  138. | X_1208 := mkey.bulk_rotate_xor_hash(X_1185,16,X_1193); |
  139. | X_146 := sql.bind(X_30,"axabas","rfoade","rfoadervs",0); |
  140. | (X_149,r1_287) := sql.bind(X_30,"axabas","rfoade","rfoadervs",2); |
  141. | X_152 := sql.bind(X_30,"axabas","rfoade","rfoadervs",1); |
  142. | X_154 := sql.projectdelta(X_119,X_146,X_149,r1_287,X_152); |
  143. | X_1216 := algebra.leftfetchjoin(X_1154,X_154); |
  144. | X_1225 := mkey.bulk_rotate_xor_hash(X_1208,16,X_1216); |
  145. | X_434 := algebra.subselect(X_146,X_119,A19,A19,true,true,false); |
  146. | X_435 := algebra.subselect(r1_287,A19,A19,true,true,false); |
  147. | X_436 := algebra.subselect(X_152,X_119,A19,A19,true,true,false); |
  148. | X_155 := sql.subdelta(X_434,X_119,X_149,X_435,X_436); |
  149. | X_437 := algebra.subselect(X_138,X_155,A18,A18,true,true,false); |
  150. | X_438 := algebra.subselect(r1_272,A18,A18,true,true,false); |
  151. | X_439 := algebra.subselect(X_144,X_155,A18,A18,true,true,false); |
  152. | X_158 := sql.subdelta(X_437,X_155,X_142,X_438,X_439); |
  153. | X_440 := algebra.subselect(X_128,X_158,A20,A20,true,true,false); |
  154. | X_441 := algebra.subselect(r1_251,A20,A20,true,true,false); |
  155. | X_442 := algebra.subselect(X_134,X_158,A20,A20,true,true,false); |
  156. | X_159 := sql.subdelta(X_440,X_158,X_131,X_441,X_442); |
  157. | X_443 := algebra.subselect(X_122,X_159,A21,A21,true,true,false); |
  158. | X_444 := algebra.subselect(r1_238,A21,A21,true,true,false); |
  159. | X_445 := algebra.subselect(X_126,X_159,A21,A21,true,true,false); |
  160. | X_160 := sql.subdelta(X_443,X_159,X_124,X_444,X_445); |
  161. | X_446 := algebra.subselect(X_122,X_159,A22,A22,true,true,false); |
  162. | X_447 := algebra.subselect(r1_238,A22,A22,true,true,false); |
  163. | X_448 := algebra.subselect(X_126,X_159,A22,A22,true,true,false); |
  164. | X_161 := sql.subdelta(X_446,X_159,X_124,X_447,X_448); |
  165. | X_162 := bat.mergecand(X_160,X_161); |
  166. | X_449 := algebra.subselect(X_122,X_159,A23,A23,true,true,false); |
  167. | X_450 := algebra.subselect(r1_238,A23,A23,true,true,false); |
  168. | X_451 := algebra.subselect(X_126,X_159,A23,A23,true,true,false); |
  169. | X_163 := sql.subdelta(X_449,X_159,X_124,X_450,X_451); |
  170. | X_164 := bat.mergecand(X_162,X_163); |
  171. | X_165 := sql.projectdelta(X_164,X_128,X_131,r1_251,X_134); |
  172. | X_166:bat[:oid,:wrd] := batcalc.hash(X_165); |
  173. | X_168 := sql.projectdelta(X_164,X_138,X_142,r1_272,X_144); |
  174. | X_169:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_166,16,X_168); |
  175. | X_170 := sql.projectdelta(X_164,X_146,X_149,r1_287,X_152); |
  176. | X_171:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_169,16,X_170); |
  177. | (X_1233,X_1234) := algebra.join(X_1225,X_171); |
  178. | X_1256 := algebra.leftfetchjoin(X_1233,X_1176); |
  179. | X_1265 := algebra.leftfetchjoin(X_1234,X_165); |
  180. | X_1273 := batcalc.==(X_1256,X_1265); |
  181. | X_1288 := algebra.subselect(X_1273,true,true,true,true,false); |
  182. | X_1296 := algebra.leftfetchjoin(X_1288,X_1233); |
  183. | X_1305 := algebra.leftfetchjoin(X_1296,X_1193); |
  184. | X_1313 := algebra.leftfetchjoin(X_1288,X_1234); |
  185. | X_1328 := algebra.leftfetchjoin(X_1313,X_168); |
  186. | X_1336 := batcalc.==(X_1305,X_1328); |
  187. | X_1345 := algebra.subselect(X_1336,true,true,true,true,false); |
  188. | X_1353 := algebra.leftfetchjoin(X_1345,X_1296); |
  189. | X_1368 := algebra.leftfetchjoin(X_1353,X_1216); |
  190. | X_1376 := algebra.leftfetchjoin(X_1345,X_1313); |
  191. | X_1385 := algebra.leftfetchjoin(X_1376,X_170); |
  192. | X_1393 := batcalc.==(X_1368,X_1385); |
  193. | X_1408 := algebra.subselect(X_1393,true,true,true,true,false); |
  194. | X_1416 := algebra.leftfetchjoin(X_1408,X_1353); |
  195. | X_2466 := algebra.leftfetchjoin(X_1416,X_1154); |
  196. | X_174 := sql.bind(X_30,"axabas","rfoade","rfoadedrt",0); |
  197. | (X_179,r1_402) := sql.bind(X_30,"axabas","rfoade","rfoadedrt",2); |
  198. | X_182 := sql.bind(X_30,"axabas","rfoade","rfoadedrt",1); |
  199. | X_184 := sql.projectdelta(X_119,X_174,X_179,r1_402,X_182); |
  200. | X_1425:bat[:oid,:str] := algebra.leftfetchjoin(X_2466,X_184); |
  201. | X_1440 := algebra.leftfetchjoin(X_1408,X_1376); |
  202. | X_185 := sql.projectdelta(X_164,X_174,X_179,r1_402,X_182); |
  203. | X_1448 := algebra.leftfetchjoin(X_1440,X_185); |
  204. | X_1497 := batcalc.<=(X_1425,X_1448); |
  205. | X_186 := sql.bind(X_30,"axabas","rfoade","rfoadegch",0); |
  206. | (X_191,r1_437) := sql.bind(X_30,"axabas","rfoade","rfoadegch",2); |
  207. | X_194 := sql.bind(X_30,"axabas","rfoade","rfoadegch",1); |
  208. | X_196 := sql.projectdelta(X_119,X_186,X_191,r1_437,X_194); |
  209. | X_1457:bat[:oid,:str] := algebra.leftfetchjoin(X_2466,X_196); |
  210. | X_197 := sql.projectdelta(X_164,X_186,X_191,r1_437,X_194); |
  211. | X_1472 := algebra.leftfetchjoin(X_1440,X_197); |
  212. | X_1480 := batcalc.>=(X_1457,X_1472); |
  213. | X_1489 := algebra.subselect(X_1480,true,true,true,true,false); |
  214. | X_1512 := algebra.subselect(X_1497,X_1489,true,true,true,true,false); |
  215. | X_1520 := algebra.leftfetchjoin(X_1512,X_1416); |
  216. | X_2474 := algebra.leftfetchjoin(X_1520,X_1153); |
  217. | X_672:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,0,8); |
  218. | (X_687:bat[:oid,:oid] ,X_688:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,0,8); |
  219. | X_1536 := sql.projectdelta(X_1041,X_672,X_687,X_688); |
  220. | X_1552:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2474,X_1112,X_1065,X_1536); |
  221. | X_207:bat[:oid,:oid] := sql.tid(X_30,"axabas","rsaaed"); |
  222. | X_209 := sql.bind(X_30,"axabas","rsaaed","rsaaed_i_rsaedtide",0); |
  223. | (X_211,r1_507) := sql.bind(X_30,"axabas","rsaaed","rsaaed_i_rsaedtide",2); |
  224. | X_213 := sql.bind(X_30,"axabas","rsaaed","rsaaed_i_rsaedtide",1); |
  225. | X_215 := sql.projectdelta(X_207,X_209,X_211,r1_507,X_213); |
  226. | (X_1560,X_1561) := algebra.join(X_1552,X_215); |
  227. | X_216 := sql.bind(X_30,"axabas","rsaaed","rsaaed___rforefide",0); |
  228. | (X_219,r1_521) := sql.bind(X_30,"axabas","rsaaed","rsaaed___rforefide",2); |
  229. | X_222 := sql.bind(X_30,"axabas","rsaaed","rsaaed___rforefide",1); |
  230. | X_224 := sql.projectdelta(X_207,X_216,X_219,r1_521,X_222); |
  231. | X_1577 := algebra.leftfetchjoin(X_1561,X_224); |
  232. | X_1592 := batcalc.hash(X_1577); |
  233. | X_226 := sql.bind(X_30,"axabas","rsaaed","rsaaed___rsavedide",0); |
  234. | (X_229,r1_541) := sql.bind(X_30,"axabas","rsaaed","rsaaed___rsavedide",2); |
  235. | X_232 := sql.bind(X_30,"axabas","rsaaed","rsaaed___rsavedide",1); |
  236. | X_233 := sql.projectdelta(X_207,X_226,X_229,r1_541,X_232); |
  237. | X_1600 := algebra.leftfetchjoin(X_1561,X_233); |
  238. | X_1608 := mkey.bulk_rotate_xor_hash(X_1592,16,X_1600); |
  239. | X_234 := sql.bind(X_30,"axabas","rsaaed","rsaaedrvs",0); |
  240. | (X_237,r1_557) := sql.bind(X_30,"axabas","rsaaed","rsaaedrvs",2); |
  241. | X_240 := sql.bind(X_30,"axabas","rsaaed","rsaaedrvs",1); |
  242. | X_242 := sql.projectdelta(X_207,X_234,X_237,r1_557,X_240); |
  243. | X_1617 := algebra.leftfetchjoin(X_1561,X_242); |
  244. | X_1632 := mkey.bulk_rotate_xor_hash(X_1608,16,X_1617); |
  245. | X_452 := algebra.subselect(X_234,X_207,A25,A25,true,true,false); |
  246. | X_453 := algebra.subselect(r1_557,A25,A25,true,true,false); |
  247. | X_454 := algebra.subselect(X_240,X_207,A25,A25,true,true,false); |
  248. | X_243 := sql.subdelta(X_452,X_207,X_237,X_453,X_454); |
  249. | X_455 := algebra.subselect(X_216,X_243,A26,A26,true,true,false); |
  250. | X_456 := algebra.subselect(r1_521,A26,A26,true,true,false); |
  251. | X_457 := algebra.subselect(X_222,X_243,A26,A26,true,true,false); |
  252. | X_246 := sql.subdelta(X_455,X_243,X_219,X_456,X_457); |
  253. | X_458 := algebra.subselect(X_226,X_246,A24,A24,true,true,false); |
  254. | X_459 := algebra.subselect(r1_541,A24,A24,true,true,false); |
  255. | X_460 := algebra.subselect(X_232,X_246,A24,A24,true,true,false); |
  256. | X_247 := sql.subdelta(X_458,X_246,X_229,X_459,X_460); |
  257. | X_461 := algebra.subselect(X_209,X_247,A27,A27,true,true,false); |
  258. | X_462 := algebra.subselect(r1_507,A27,A27,true,true,false); |
  259. | X_463 := algebra.subselect(X_213,X_247,A27,A27,true,true,false); |
  260. | X_248 := sql.subdelta(X_461,X_247,X_211,X_462,X_463); |
  261. | X_249 := sql.projectdelta(X_248,X_216,X_219,r1_521,X_222); |
  262. | X_250:bat[:oid,:wrd] := batcalc.hash(X_249); |
  263. | X_252 := sql.projectdelta(X_248,X_226,X_229,r1_541,X_232); |
  264. | X_253:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_250,16,X_252); |
  265. | X_254 := sql.projectdelta(X_248,X_234,X_237,r1_557,X_240); |
  266. | X_255:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_253,16,X_254); |
  267. | (X_1640,X_1641) := algebra.join(X_1632,X_255); |
  268. | X_1657 := algebra.leftfetchjoin(X_1640,X_1577); |
  269. | X_1672 := algebra.leftfetchjoin(X_1641,X_249); |
  270. | X_1680 := batcalc.==(X_1657,X_1672); |
  271. | X_1688 := algebra.subselect(X_1680,true,true,true,true,false); |
  272. | X_1697 := algebra.leftfetchjoin(X_1688,X_1640); |
  273. | X_1712 := algebra.leftfetchjoin(X_1697,X_1600); |
  274. | X_1720 := algebra.leftfetchjoin(X_1688,X_1641); |
  275. | X_1728 := algebra.leftfetchjoin(X_1720,X_252); |
  276. | X_1737 := batcalc.==(X_1712,X_1728); |
  277. | X_1752 := algebra.subselect(X_1737,true,true,true,true,false); |
  278. | X_1760 := algebra.leftfetchjoin(X_1752,X_1697); |
  279. | X_1768 := algebra.leftfetchjoin(X_1760,X_1617); |
  280. | X_1777 := algebra.leftfetchjoin(X_1752,X_1720); |
  281. | X_1792 := algebra.leftfetchjoin(X_1777,X_254); |
  282. | X_1800 := batcalc.==(X_1768,X_1792); |
  283. | X_1808 := algebra.subselect(X_1800,true,true,true,true,false); |
  284. | X_1817 := algebra.leftfetchjoin(X_1808,X_1760); |
  285. | X_2482 := algebra.leftfetchjoin(X_1817,X_1561); |
  286. | X_258 := sql.bind(X_30,"axabas","rsaaed","rsaaeddrt",0); |
  287. | (X_263,r1_666) := sql.bind(X_30,"axabas","rsaaed","rsaaeddrt",2); |
  288. | X_266 := sql.bind(X_30,"axabas","rsaaed","rsaaeddrt",1); |
  289. | X_268 := sql.projectdelta(X_207,X_258,X_263,r1_666,X_266); |
  290. | X_1832:bat[:oid,:str] := algebra.leftfetchjoin(X_2482,X_268); |
  291. | X_1840 := algebra.leftfetchjoin(X_1808,X_1777); |
  292. | X_269 := sql.projectdelta(X_248,X_258,X_263,r1_666,X_266); |
  293. | X_1849 := algebra.leftfetchjoin(X_1840,X_269); |
  294. | X_1904 := batcalc.<=(X_1832,X_1849); |
  295. | X_270 := sql.bind(X_30,"axabas","rsaaed","rsaaedgch",0); |
  296. | (X_275,r1_701) := sql.bind(X_30,"axabas","rsaaed","rsaaedgch",2); |
  297. | X_278 := sql.bind(X_30,"axabas","rsaaed","rsaaedgch",1); |
  298. | X_280 := sql.projectdelta(X_207,X_270,X_275,r1_701,X_278); |
  299. | X_1864:bat[:oid,:str] := algebra.leftfetchjoin(X_2482,X_280); |
  300. | X_281 := sql.projectdelta(X_248,X_270,X_275,r1_701,X_278); |
  301. | X_1872 := algebra.leftfetchjoin(X_1840,X_281); |
  302. | X_1881 := batcalc.>=(X_1864,X_1872); |
  303. | X_1896 := algebra.subselect(X_1881,true,true,true,true,false); |
  304. | X_1912 := algebra.subselect(X_1904,X_1896,true,true,true,true,false); |
  305. | X_284 := sql.projectdelta(X_248,X_209,X_211,r1_507,X_213); |
  306. | X_1928:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1912,X_1840,X_284); |
  307. | X_1936 := algebra.leftfetchjoin(X_1912,X_1817); |
  308. | X_2490 := algebra.leftfetchjoin(X_1936,X_1560); |
  309. | X_286 := sql.projectdelta(X_164,X_122,X_124,r1_238,X_126); |
  310. | X_1952:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1512,X_1440,X_286); |
  311. | X_1968:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1113,X_112); |
  312. | X_289 := sql.projectdelta(X_80,X_53,X_55,r1_107,X_57); |
  313. | X_1992:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1112,X_1066,X_289); |
  314. | X_291 := sql.projectdelta(X_80,X_58,X_60,r1_118,X_62); |
  315. | X_2008:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1112,X_1066,X_291); |
  316. | (X_2017,X_2018,X_2019) := group.subgroup(X_2008); |
  317. | (X_2041,X_2042,X_2043) := group.subgroup(X_1992,X_2017); |
  318. | (X_2065,X_2066,X_2067) := group.subgroup(X_1968,X_2041); |
  319. | X_2089 := algebra.leftfetchjoin(X_2066,X_2041); |
  320. | (X_2097,X_2098,X_2099) := group.subgroup(X_1952,X_2065); |
  321. | X_2121 := algebra.leftfetchjoin(X_2098,X_2065); |
  322. | (X_2129,X_2130,X_2131) := group.subgroupdone(X_1928,X_2097); |
  323. | X_2132 := algebra.leftfetchjoin(X_2130,X_1928); |
  324. | X_2161 := algebra.leftfetchjoin(X_2130,X_2097); |
  325. | X_2206 := sql.projectdelta(X_1041,X_507,X_522,X_523); |
  326. | X_2230:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1112,X_1065,X_2206); |
  327. | X_2238 := batcalc.==(X_2230,A0); |
  328. | X_2246 := sql.projectdelta(X_1041,X_481,X_489,X_490); |
  329. | X_2270:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1112,X_1065,X_2246); |
  330. | X_2278 := batcalc.==(X_2270,A1); |
  331. | X_2286 := batcalc.and(X_2238,X_2278); |
  332. | X_2302 := batcalc.isnil(X_2286); |
  333. | X_2318 := batcalc.ifthenelse(X_2302,false,X_2286); |
  334. | X_705:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,0,8); |
  335. | (X_720:bat[:oid,:oid] ,X_721:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,0,8); |
  336. | X_2326 := sql.projectdelta(X_1041,X_705,X_720,X_721); |
  337. | X_2350:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2490,X_1520,X_1153,X_1112,X_1065,X_2326); |
  338. | X_317 := calc.lng(A2,18,6); |
  339. | X_2358 := batcalc.ifthenelse(X_2318,X_2350,X_317); |
  340. | X_2367 := aggr.subsum(X_2358,X_2129,X_2130,true,true); |
  341. | X_2376 := batcalc.==(X_2230,A3); |
  342. | X_2392 := batcalc.==(X_2270,A4); |
  343. | X_2400 := batcalc.and(X_2376,X_2392); |
  344. | X_2408 := batcalc.isnil(X_2400); |
  345. | X_2424 := batcalc.ifthenelse(X_2408,false,X_2400); |
  346. | X_323 := calc.lng(A5,18,6); |
  347. | X_2432 := batcalc.ifthenelse(X_2424,X_2350,X_323); |
  348. | X_2449 := aggr.subsum(X_2432,X_2129,X_2130,true,true); |
  349. | X_2162:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2161,X_2098,X_1952); |
  350. | X_2498 := algebra.leftfetchjoin(X_2161,X_2121); |
  351. | X_2177:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2498,X_2066,X_1968); |
  352. | X_2185:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2498,X_2089,X_2042,X_1992); |
  353. | X_2193:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2498,X_2089,X_2042,X_2017,X_2018,X_2008); |
  354. | X_482:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,1,8); |
  355. | X_509:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,1,8); |
  356. | X_542:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,1,8); |
  357. | X_468:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",1,8); |
  358. | X_753 := algebra.subselect(X_542,X_468,A7,A7,true,true,false); |
  359. | (X_557:bat[:oid,:oid] ,X_558:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,1,8); |
  360. | X_762 := algebra.subselect(X_558,A7,A7,true,true,false); |
  361. | X_770 := sql.subdelta(X_753,X_468,X_557,X_762); |
  362. | X_779 := algebra.subselect(X_509,X_770,A8,A8,true,true,false); |
  363. | (X_524:bat[:oid,:oid] ,X_525:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,1,8); |
  364. | X_793 := algebra.subselect(X_525,A8,A8,true,true,false); |
  365. | X_802 := sql.subdelta(X_779,X_770,X_524,X_793); |
  366. | X_810 := algebra.subselect(X_482,X_802,A9,A9,true,true,false); |
  367. | (X_491:bat[:oid,:oid] ,X_492:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,1,8); |
  368. | X_819 := algebra.subselect(X_492,A9,A9,true,true,false); |
  369. | X_833 := sql.subdelta(X_810,X_802,X_491,X_819); |
  370. | X_842 := algebra.subselect(X_509,X_770,A10,A10,true,true,false); |
  371. | X_850 := algebra.subselect(X_525,A10,A10,true,true,false); |
  372. | X_859 := sql.subdelta(X_842,X_770,X_524,X_850); |
  373. | X_873 := algebra.subselect(X_482,X_859,A11,A11,true,true,false); |
  374. | X_882 := algebra.subselect(X_492,A11,A11,true,true,false); |
  375. | X_890 := sql.subdelta(X_873,X_859,X_491,X_882); |
  376. | X_899 := bat.mergecand(X_833,X_890); |
  377. | X_913 := algebra.subselect(X_509,X_899,A8,A8,true,true,false); |
  378. | X_922 := algebra.subselect(X_525,A8,A8,true,true,false); |
  379. | X_930 := sql.subdelta(X_913,X_899,X_524,X_922); |
  380. | X_939 := algebra.subselect(X_509,X_899,A10,A10,true,true,false); |
  381. | X_953 := algebra.subselect(X_525,A10,A10,true,true,false); |
  382. | X_962 := sql.subdelta(X_939,X_899,X_524,X_953); |
  383. | X_970 := bat.mergecand(X_930,X_962); |
  384. | X_979 := algebra.subselect(X_482,X_970,A9,A9,true,true,false); |
  385. | X_993 := algebra.subselect(X_492,A9,A9,true,true,false); |
  386. | X_1002 := sql.subdelta(X_979,X_970,X_491,X_993); |
  387. | X_1010 := algebra.subselect(X_482,X_970,A11,A11,true,true,false); |
  388. | X_1019 := algebra.subselect(X_492,A11,A11,true,true,false); |
  389. | X_1033 := sql.subdelta(X_1010,X_970,X_491,X_1019); |
  390. | X_1042 := bat.mergecand(X_1002,X_1033); |
  391. | X_575:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,1,8); |
  392. | (X_590:bat[:oid,:oid] ,X_591:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,1,8); |
  393. | X_1057 := sql.projectdelta(X_1042,X_575,X_590,X_591); |
  394. | (X_1067,X_1068) := algebra.join(X_1057,X_87); |
  395. | X_608:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,1,8); |
  396. | (X_623:bat[:oid,:oid] ,X_624:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,1,8); |
  397. | X_1090 := sql.projectdelta(X_1042,X_608,X_623,X_624); |
  398. | X_1099 := algebra.leftfetchjoin(X_1067,X_1090); |
  399. | (X_1114,X_1115) := algebra.join(X_1099,X_112); |
  400. | X_2459 := algebra.leftfetchjoin(X_1114,X_1067); |
  401. | X_641:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,1,8); |
  402. | (X_656:bat[:oid,:oid] ,X_657:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,1,8); |
  403. | X_1137 := sql.projectdelta(X_1042,X_641,X_656,X_657); |
  404. | X_1146:bat[:oid,:str] := algebra.leftfetchjoin(X_2459,X_1137); |
  405. | (X_1156,X_1157) := algebra.join(X_1146,X_127); |
  406. | X_1177 := algebra.leftfetchjoin(X_1157,X_136); |
  407. | X_1186 := batcalc.hash(X_1177); |
  408. | X_1195 := algebra.leftfetchjoin(X_1157,X_145); |
  409. | X_1209 := mkey.bulk_rotate_xor_hash(X_1186,16,X_1195); |
  410. | X_1217 := algebra.leftfetchjoin(X_1157,X_154); |
  411. | X_1226 := mkey.bulk_rotate_xor_hash(X_1209,16,X_1217); |
  412. | (X_1236,X_1237) := algebra.join(X_1226,X_171); |
  413. | X_1257 := algebra.leftfetchjoin(X_1236,X_1177); |
  414. | X_1266 := algebra.leftfetchjoin(X_1237,X_165); |
  415. | X_1275 := batcalc.==(X_1257,X_1266); |
  416. | X_1289 := algebra.subselect(X_1275,true,true,true,true,false); |
  417. | X_1297 := algebra.leftfetchjoin(X_1289,X_1236); |
  418. | X_1306 := algebra.leftfetchjoin(X_1297,X_1195); |
  419. | X_1315 := algebra.leftfetchjoin(X_1289,X_1237); |
  420. | X_1329 := algebra.leftfetchjoin(X_1315,X_168); |
  421. | X_1337 := batcalc.==(X_1306,X_1329); |
  422. | X_1346 := algebra.subselect(X_1337,true,true,true,true,false); |
  423. | X_1355 := algebra.leftfetchjoin(X_1346,X_1297); |
  424. | X_1369 := algebra.leftfetchjoin(X_1355,X_1217); |
  425. | X_1377 := algebra.leftfetchjoin(X_1346,X_1315); |
  426. | X_1386 := algebra.leftfetchjoin(X_1377,X_170); |
  427. | X_1395 := batcalc.==(X_1369,X_1386); |
  428. | X_1409 := algebra.subselect(X_1395,true,true,true,true,false); |
  429. | X_1417 := algebra.leftfetchjoin(X_1409,X_1355); |
  430. | X_2467 := algebra.leftfetchjoin(X_1417,X_1157); |
  431. | X_1427:bat[:oid,:str] := algebra.leftfetchjoin(X_2467,X_184); |
  432. | X_1441 := algebra.leftfetchjoin(X_1409,X_1377); |
  433. | X_1449 := algebra.leftfetchjoin(X_1441,X_185); |
  434. | X_1499 := batcalc.<=(X_1427,X_1449); |
  435. | X_1459:bat[:oid,:str] := algebra.leftfetchjoin(X_2467,X_196); |
  436. | X_1473 := algebra.leftfetchjoin(X_1441,X_197); |
  437. | X_1481 := batcalc.>=(X_1459,X_1473); |
  438. | X_1490 := algebra.subselect(X_1481,true,true,true,true,false); |
  439. | X_1513 := algebra.subselect(X_1499,X_1490,true,true,true,true,false); |
  440. | X_1521 := algebra.leftfetchjoin(X_1513,X_1417); |
  441. | X_2475 := algebra.leftfetchjoin(X_1521,X_1156); |
  442. | X_674:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,1,8); |
  443. | (X_689:bat[:oid,:oid] ,X_690:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,1,8); |
  444. | X_1537 := sql.projectdelta(X_1042,X_674,X_689,X_690); |
  445. | X_1553:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2475,X_1114,X_1067,X_1537); |
  446. | (X_1562,X_1563) := algebra.join(X_1553,X_215); |
  447. | X_1579 := algebra.leftfetchjoin(X_1563,X_224); |
  448. | X_1593 := batcalc.hash(X_1579); |
  449. | X_1601 := algebra.leftfetchjoin(X_1563,X_233); |
  450. | X_1609 := mkey.bulk_rotate_xor_hash(X_1593,16,X_1601); |
  451. | X_1619 := algebra.leftfetchjoin(X_1563,X_242); |
  452. | X_1633 := mkey.bulk_rotate_xor_hash(X_1609,16,X_1619); |
  453. | (X_1642,X_1643) := algebra.join(X_1633,X_255); |
  454. | X_1659 := algebra.leftfetchjoin(X_1642,X_1579); |
  455. | X_1673 := algebra.leftfetchjoin(X_1643,X_249); |
  456. | X_1681 := batcalc.==(X_1659,X_1673); |
  457. | X_1689 := algebra.subselect(X_1681,true,true,true,true,false); |
  458. | X_1699 := algebra.leftfetchjoin(X_1689,X_1642); |
  459. | X_1713 := algebra.leftfetchjoin(X_1699,X_1601); |
  460. | X_1721 := algebra.leftfetchjoin(X_1689,X_1643); |
  461. | X_1729 := algebra.leftfetchjoin(X_1721,X_252); |
  462. | X_1739 := batcalc.==(X_1713,X_1729); |
  463. | X_1753 := algebra.subselect(X_1739,true,true,true,true,false); |
  464. | X_1761 := algebra.leftfetchjoin(X_1753,X_1699); |
  465. | X_1769 := algebra.leftfetchjoin(X_1761,X_1619); |
  466. | X_1779 := algebra.leftfetchjoin(X_1753,X_1721); |
  467. | X_1793 := algebra.leftfetchjoin(X_1779,X_254); |
  468. | X_1801 := batcalc.==(X_1769,X_1793); |
  469. | X_1809 := algebra.subselect(X_1801,true,true,true,true,false); |
  470. | X_1819 := algebra.leftfetchjoin(X_1809,X_1761); |
  471. | X_2483 := algebra.leftfetchjoin(X_1819,X_1563); |
  472. | X_1833:bat[:oid,:str] := algebra.leftfetchjoin(X_2483,X_268); |
  473. | X_1841 := algebra.leftfetchjoin(X_1809,X_1779); |
  474. | X_1851 := algebra.leftfetchjoin(X_1841,X_269); |
  475. | X_1905 := batcalc.<=(X_1833,X_1851); |
  476. | X_1865:bat[:oid,:str] := algebra.leftfetchjoin(X_2483,X_280); |
  477. | X_1873 := algebra.leftfetchjoin(X_1841,X_281); |
  478. | X_1883 := batcalc.>=(X_1865,X_1873); |
  479. | X_1897 := algebra.subselect(X_1883,true,true,true,true,false); |
  480. | X_1913 := algebra.subselect(X_1905,X_1897,true,true,true,true,false); |
  481. | X_1929:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1913,X_1841,X_284); |
  482. | X_1937 := algebra.leftfetchjoin(X_1913,X_1819); |
  483. | X_2491 := algebra.leftfetchjoin(X_1937,X_1562); |
  484. | X_1953:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1513,X_1441,X_286); |
  485. | X_1969:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1115,X_112); |
  486. | X_1993:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1114,X_1068,X_289); |
  487. | X_2009:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1114,X_1068,X_291); |
  488. | (X_2020,X_2021,X_2022) := group.subgroup(X_2009); |
  489. | (X_2044,X_2045,X_2046) := group.subgroup(X_1993,X_2020); |
  490. | (X_2068,X_2069,X_2070) := group.subgroup(X_1969,X_2044); |
  491. | X_2090 := algebra.leftfetchjoin(X_2069,X_2044); |
  492. | (X_2100,X_2101,X_2102) := group.subgroup(X_1953,X_2068); |
  493. | X_2122 := algebra.leftfetchjoin(X_2101,X_2068); |
  494. | (X_2133,X_2134,X_2135) := group.subgroupdone(X_1929,X_2100); |
  495. | X_2136 := algebra.leftfetchjoin(X_2134,X_1929); |
  496. | X_2163 := algebra.leftfetchjoin(X_2134,X_2100); |
  497. | X_2208 := sql.projectdelta(X_1042,X_509,X_524,X_525); |
  498. | X_2231:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1114,X_1067,X_2208); |
  499. | X_2239 := batcalc.==(X_2231,A0); |
  500. | X_2248 := sql.projectdelta(X_1042,X_482,X_491,X_492); |
  501. | X_2271:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1114,X_1067,X_2248); |
  502. | X_2279 := batcalc.==(X_2271,A1); |
  503. | X_2288 := batcalc.and(X_2239,X_2279); |
  504. | X_2303 := batcalc.isnil(X_2288); |
  505. | X_2319 := batcalc.ifthenelse(X_2303,false,X_2288); |
  506. | X_707:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,1,8); |
  507. | (X_722:bat[:oid,:oid] ,X_723:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,1,8); |
  508. | X_2328 := sql.projectdelta(X_1042,X_707,X_722,X_723); |
  509. | X_2351:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2491,X_1521,X_1156,X_1114,X_1067,X_2328); |
  510. | X_2359 := batcalc.ifthenelse(X_2319,X_2351,X_317); |
  511. | X_2368 := aggr.subsum(X_2359,X_2133,X_2134,true,true); |
  512. | X_2378 := batcalc.==(X_2231,A3); |
  513. | X_2393 := batcalc.==(X_2271,A4); |
  514. | X_2401 := batcalc.and(X_2378,X_2393); |
  515. | X_2409 := batcalc.isnil(X_2401); |
  516. | X_2425 := batcalc.ifthenelse(X_2409,false,X_2401); |
  517. | X_2434 := batcalc.ifthenelse(X_2425,X_2351,X_323); |
  518. | X_2450 := aggr.subsum(X_2434,X_2133,X_2134,true,true); |
  519. | X_2164:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2163,X_2101,X_1953); |
  520. | X_2499 := algebra.leftfetchjoin(X_2163,X_2122); |
  521. | X_2178:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2499,X_2069,X_1969); |
  522. | X_2186:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2499,X_2090,X_2045,X_1993); |
  523. | X_2194:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2499,X_2090,X_2045,X_2020,X_2021,X_2009); |
  524. | X_483:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,2,8); |
  525. | X_511:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,2,8); |
  526. | X_544:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,2,8); |
  527. | X_470:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",2,8); |
  528. | X_754 := algebra.subselect(X_544,X_470,A7,A7,true,true,false); |
  529. | (X_559:bat[:oid,:oid] ,X_560:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,2,8); |
  530. | X_763 := algebra.subselect(X_560,A7,A7,true,true,false); |
  531. | X_771 := sql.subdelta(X_754,X_470,X_559,X_763); |
  532. | X_781 := algebra.subselect(X_511,X_771,A8,A8,true,true,false); |
  533. | (X_526:bat[:oid,:oid] ,X_527:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,2,8); |
  534. | X_794 := algebra.subselect(X_527,A8,A8,true,true,false); |
  535. | X_803 := sql.subdelta(X_781,X_771,X_526,X_794); |
  536. | X_811 := algebra.subselect(X_483,X_803,A9,A9,true,true,false); |
  537. | (X_493:bat[:oid,:oid] ,X_494:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,2,8); |
  538. | X_821 := algebra.subselect(X_494,A9,A9,true,true,false); |
  539. | X_834 := sql.subdelta(X_811,X_803,X_493,X_821); |
  540. | X_843 := algebra.subselect(X_511,X_771,A10,A10,true,true,false); |
  541. | X_851 := algebra.subselect(X_527,A10,A10,true,true,false); |
  542. | X_861 := sql.subdelta(X_843,X_771,X_526,X_851); |
  543. | X_874 := algebra.subselect(X_483,X_861,A11,A11,true,true,false); |
  544. | X_883 := algebra.subselect(X_494,A11,A11,true,true,false); |
  545. | X_891 := sql.subdelta(X_874,X_861,X_493,X_883); |
  546. | X_901 := bat.mergecand(X_834,X_891); |
  547. | X_914 := algebra.subselect(X_511,X_901,A8,A8,true,true,false); |
  548. | X_923 := algebra.subselect(X_527,A8,A8,true,true,false); |
  549. | X_931 := sql.subdelta(X_914,X_901,X_526,X_923); |
  550. | X_941 := algebra.subselect(X_511,X_901,A10,A10,true,true,false); |
  551. | X_954 := algebra.subselect(X_527,A10,A10,true,true,false); |
  552. | X_963 := sql.subdelta(X_941,X_901,X_526,X_954); |
  553. | X_971 := bat.mergecand(X_931,X_963); |
  554. | X_981 := algebra.subselect(X_483,X_971,A9,A9,true,true,false); |
  555. | X_994 := algebra.subselect(X_494,A9,A9,true,true,false); |
  556. | X_1003 := sql.subdelta(X_981,X_971,X_493,X_994); |
  557. | X_1011 := algebra.subselect(X_483,X_971,A11,A11,true,true,false); |
  558. | X_1021 := algebra.subselect(X_494,A11,A11,true,true,false); |
  559. | X_1034 := sql.subdelta(X_1011,X_971,X_493,X_1021); |
  560. | X_1043 := bat.mergecand(X_1003,X_1034); |
  561. | X_577:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,2,8); |
  562. | (X_592:bat[:oid,:oid] ,X_593:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,2,8); |
  563. | X_1058 := sql.projectdelta(X_1043,X_577,X_592,X_593); |
  564. | (X_1069,X_1070) := algebra.join(X_1058,X_87); |
  565. | X_610:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,2,8); |
  566. | (X_625:bat[:oid,:oid] ,X_626:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,2,8); |
  567. | X_1091 := sql.projectdelta(X_1043,X_610,X_625,X_626); |
  568. | X_1101 := algebra.leftfetchjoin(X_1069,X_1091); |
  569. | (X_1116,X_1117) := algebra.join(X_1101,X_112); |
  570. | X_2460 := algebra.leftfetchjoin(X_1116,X_1069); |
  571. | X_643:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,2,8); |
  572. | (X_658:bat[:oid,:oid] ,X_659:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,2,8); |
  573. | X_1138 := sql.projectdelta(X_1043,X_643,X_658,X_659); |
  574. | X_1147:bat[:oid,:str] := algebra.leftfetchjoin(X_2460,X_1138); |
  575. | (X_1159,X_1160) := algebra.join(X_1147,X_127); |
  576. | X_1178 := algebra.leftfetchjoin(X_1160,X_136); |
  577. | X_1187 := batcalc.hash(X_1178); |
  578. | X_1197 := algebra.leftfetchjoin(X_1160,X_145); |
  579. | X_1210 := mkey.bulk_rotate_xor_hash(X_1187,16,X_1197); |
  580. | X_1218 := algebra.leftfetchjoin(X_1160,X_154); |
  581. | X_1227 := mkey.bulk_rotate_xor_hash(X_1210,16,X_1218); |
  582. | (X_1239,X_1240) := algebra.join(X_1227,X_171); |
  583. | X_1258 := algebra.leftfetchjoin(X_1239,X_1178); |
  584. | X_1267 := algebra.leftfetchjoin(X_1240,X_165); |
  585. | X_1277 := batcalc.==(X_1258,X_1267); |
  586. | X_1290 := algebra.subselect(X_1277,true,true,true,true,false); |
  587. | X_1298 := algebra.leftfetchjoin(X_1290,X_1239); |
  588. | X_1307 := algebra.leftfetchjoin(X_1298,X_1197); |
  589. | X_1317 := algebra.leftfetchjoin(X_1290,X_1240); |
  590. | X_1330 := algebra.leftfetchjoin(X_1317,X_168); |
  591. | X_1338 := batcalc.==(X_1307,X_1330); |
  592. | X_1347 := algebra.subselect(X_1338,true,true,true,true,false); |
  593. | X_1357 := algebra.leftfetchjoin(X_1347,X_1298); |
  594. | X_1370 := algebra.leftfetchjoin(X_1357,X_1218); |
  595. | X_1378 := algebra.leftfetchjoin(X_1347,X_1317); |
  596. | X_1387 := algebra.leftfetchjoin(X_1378,X_170); |
  597. | X_1397 := batcalc.==(X_1370,X_1387); |
  598. | X_1410 := algebra.subselect(X_1397,true,true,true,true,false); |
  599. | X_1418 := algebra.leftfetchjoin(X_1410,X_1357); |
  600. | X_2468 := algebra.leftfetchjoin(X_1418,X_1160); |
  601. | X_1429:bat[:oid,:str] := algebra.leftfetchjoin(X_2468,X_184); |
  602. | X_1442 := algebra.leftfetchjoin(X_1410,X_1378); |
  603. | X_1450 := algebra.leftfetchjoin(X_1442,X_185); |
  604. | X_1501 := batcalc.<=(X_1429,X_1450); |
  605. | X_1461:bat[:oid,:str] := algebra.leftfetchjoin(X_2468,X_196); |
  606. | X_1474 := algebra.leftfetchjoin(X_1442,X_197); |
  607. | X_1482 := batcalc.>=(X_1461,X_1474); |
  608. | X_1491 := algebra.subselect(X_1482,true,true,true,true,false); |
  609. | X_1514 := algebra.subselect(X_1501,X_1491,true,true,true,true,false); |
  610. | X_1522 := algebra.leftfetchjoin(X_1514,X_1418); |
  611. | X_2476 := algebra.leftfetchjoin(X_1522,X_1159); |
  612. | X_676:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,2,8); |
  613. | (X_691:bat[:oid,:oid] ,X_692:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,2,8); |
  614. | X_1538 := sql.projectdelta(X_1043,X_676,X_691,X_692); |
  615. | X_1554:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2476,X_1116,X_1069,X_1538); |
  616. | (X_1564,X_1565) := algebra.join(X_1554,X_215); |
  617. | X_1581 := algebra.leftfetchjoin(X_1565,X_224); |
  618. | X_1594 := batcalc.hash(X_1581); |
  619. | X_1602 := algebra.leftfetchjoin(X_1565,X_233); |
  620. | X_1610 := mkey.bulk_rotate_xor_hash(X_1594,16,X_1602); |
  621. | X_1621 := algebra.leftfetchjoin(X_1565,X_242); |
  622. | X_1634 := mkey.bulk_rotate_xor_hash(X_1610,16,X_1621); |
  623. | (X_1644,X_1645) := algebra.join(X_1634,X_255); |
  624. | X_1661 := algebra.leftfetchjoin(X_1644,X_1581); |
  625. | X_1674 := algebra.leftfetchjoin(X_1645,X_249); |
  626. | X_1682 := batcalc.==(X_1661,X_1674); |
  627. | X_1690 := algebra.subselect(X_1682,true,true,true,true,false); |
  628. | X_1701 := algebra.leftfetchjoin(X_1690,X_1644); |
  629. | X_1714 := algebra.leftfetchjoin(X_1701,X_1602); |
  630. | X_1722 := algebra.leftfetchjoin(X_1690,X_1645); |
  631. | X_1730 := algebra.leftfetchjoin(X_1722,X_252); |
  632. | X_1741 := batcalc.==(X_1714,X_1730); |
  633. | X_1754 := algebra.subselect(X_1741,true,true,true,true,false); |
  634. | X_1762 := algebra.leftfetchjoin(X_1754,X_1701); |
  635. | X_1770 := algebra.leftfetchjoin(X_1762,X_1621); |
  636. | X_1781 := algebra.leftfetchjoin(X_1754,X_1722); |
  637. | X_1794 := algebra.leftfetchjoin(X_1781,X_254); |
  638. | X_1802 := batcalc.==(X_1770,X_1794); |
  639. | X_1810 := algebra.subselect(X_1802,true,true,true,true,false); |
  640. | X_1821 := algebra.leftfetchjoin(X_1810,X_1762); |
  641. | X_2484 := algebra.leftfetchjoin(X_1821,X_1565); |
  642. | X_1834:bat[:oid,:str] := algebra.leftfetchjoin(X_2484,X_268); |
  643. | X_1842 := algebra.leftfetchjoin(X_1810,X_1781); |
  644. | X_1853 := algebra.leftfetchjoin(X_1842,X_269); |
  645. | X_1906 := batcalc.<=(X_1834,X_1853); |
  646. | X_1866:bat[:oid,:str] := algebra.leftfetchjoin(X_2484,X_280); |
  647. | X_1874 := algebra.leftfetchjoin(X_1842,X_281); |
  648. | X_1885 := batcalc.>=(X_1866,X_1874); |
  649. | X_1898 := algebra.subselect(X_1885,true,true,true,true,false); |
  650. | X_1914 := algebra.subselect(X_1906,X_1898,true,true,true,true,false); |
  651. | X_1930:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1914,X_1842,X_284); |
  652. | X_1938 := algebra.leftfetchjoin(X_1914,X_1821); |
  653. | X_2492 := algebra.leftfetchjoin(X_1938,X_1564); |
  654. | X_1954:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1514,X_1442,X_286); |
  655. | X_1970:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1117,X_112); |
  656. | X_1994:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1116,X_1070,X_289); |
  657. | X_2010:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1116,X_1070,X_291); |
  658. | (X_2023,X_2024,X_2025) := group.subgroup(X_2010); |
  659. | (X_2047,X_2048,X_2049) := group.subgroup(X_1994,X_2023); |
  660. | (X_2071,X_2072,X_2073) := group.subgroup(X_1970,X_2047); |
  661. | X_2091 := algebra.leftfetchjoin(X_2072,X_2047); |
  662. | (X_2103,X_2104,X_2105) := group.subgroup(X_1954,X_2071); |
  663. | X_2123 := algebra.leftfetchjoin(X_2104,X_2071); |
  664. | (X_2137,X_2138,X_2139) := group.subgroupdone(X_1930,X_2103); |
  665. | X_2140 := algebra.leftfetchjoin(X_2138,X_1930); |
  666. | X_2165 := algebra.leftfetchjoin(X_2138,X_2103); |
  667. | X_2210 := sql.projectdelta(X_1043,X_511,X_526,X_527); |
  668. | X_2232:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1116,X_1069,X_2210); |
  669. | X_2240 := batcalc.==(X_2232,A0); |
  670. | X_2250 := sql.projectdelta(X_1043,X_483,X_493,X_494); |
  671. | X_2272:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1116,X_1069,X_2250); |
  672. | X_2280 := batcalc.==(X_2272,A1); |
  673. | X_2290 := batcalc.and(X_2240,X_2280); |
  674. | X_2304 := batcalc.isnil(X_2290); |
  675. | X_2320 := batcalc.ifthenelse(X_2304,false,X_2290); |
  676. | X_709:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,2,8); |
  677. | (X_724:bat[:oid,:oid] ,X_725:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,2,8); |
  678. | X_2330 := sql.projectdelta(X_1043,X_709,X_724,X_725); |
  679. | X_2352:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2492,X_1522,X_1159,X_1116,X_1069,X_2330); |
  680. | X_2360 := batcalc.ifthenelse(X_2320,X_2352,X_317); |
  681. | X_2369 := aggr.subsum(X_2360,X_2137,X_2138,true,true); |
  682. | X_2380 := batcalc.==(X_2232,A3); |
  683. | X_2394 := batcalc.==(X_2272,A4); |
  684. | X_2402 := batcalc.and(X_2380,X_2394); |
  685. | X_2410 := batcalc.isnil(X_2402); |
  686. | X_2426 := batcalc.ifthenelse(X_2410,false,X_2402); |
  687. | X_2436 := batcalc.ifthenelse(X_2426,X_2352,X_323); |
  688. | X_2451 := aggr.subsum(X_2436,X_2137,X_2138,true,true); |
  689. | X_2166:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2165,X_2104,X_1954); |
  690. | X_2500 := algebra.leftfetchjoin(X_2165,X_2123); |
  691. | X_2179:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2500,X_2072,X_1970); |
  692. | X_2187:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2500,X_2091,X_2048,X_1994); |
  693. | X_2195:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2500,X_2091,X_2048,X_2023,X_2024,X_2010); |
  694. | X_484:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,3,8); |
  695. | X_513:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,3,8); |
  696. | X_546:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,3,8); |
  697. | X_472:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",3,8); |
  698. | X_755 := algebra.subselect(X_546,X_472,A7,A7,true,true,false); |
  699. | (X_561:bat[:oid,:oid] ,X_562:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,3,8); |
  700. | X_764 := algebra.subselect(X_562,A7,A7,true,true,false); |
  701. | X_772 := sql.subdelta(X_755,X_472,X_561,X_764); |
  702. | X_783 := algebra.subselect(X_513,X_772,A8,A8,true,true,false); |
  703. | (X_528:bat[:oid,:oid] ,X_529:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,3,8); |
  704. | X_795 := algebra.subselect(X_529,A8,A8,true,true,false); |
  705. | X_804 := sql.subdelta(X_783,X_772,X_528,X_795); |
  706. | X_812 := algebra.subselect(X_484,X_804,A9,A9,true,true,false); |
  707. | (X_495:bat[:oid,:oid] ,X_496:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,3,8); |
  708. | X_823 := algebra.subselect(X_496,A9,A9,true,true,false); |
  709. | X_835 := sql.subdelta(X_812,X_804,X_495,X_823); |
  710. | X_844 := algebra.subselect(X_513,X_772,A10,A10,true,true,false); |
  711. | X_852 := algebra.subselect(X_529,A10,A10,true,true,false); |
  712. | X_863 := sql.subdelta(X_844,X_772,X_528,X_852); |
  713. | X_875 := algebra.subselect(X_484,X_863,A11,A11,true,true,false); |
  714. | X_884 := algebra.subselect(X_496,A11,A11,true,true,false); |
  715. | X_892 := sql.subdelta(X_875,X_863,X_495,X_884); |
  716. | X_903 := bat.mergecand(X_835,X_892); |
  717. | X_915 := algebra.subselect(X_513,X_903,A8,A8,true,true,false); |
  718. | X_924 := algebra.subselect(X_529,A8,A8,true,true,false); |
  719. | X_932 := sql.subdelta(X_915,X_903,X_528,X_924); |
  720. | X_943 := algebra.subselect(X_513,X_903,A10,A10,true,true,false); |
  721. | X_955 := algebra.subselect(X_529,A10,A10,true,true,false); |
  722. | X_964 := sql.subdelta(X_943,X_903,X_528,X_955); |
  723. | X_972 := bat.mergecand(X_932,X_964); |
  724. | X_983 := algebra.subselect(X_484,X_972,A9,A9,true,true,false); |
  725. | X_995 := algebra.subselect(X_496,A9,A9,true,true,false); |
  726. | X_1004 := sql.subdelta(X_983,X_972,X_495,X_995); |
  727. | X_1012 := algebra.subselect(X_484,X_972,A11,A11,true,true,false); |
  728. | X_1023 := algebra.subselect(X_496,A11,A11,true,true,false); |
  729. | X_1035 := sql.subdelta(X_1012,X_972,X_495,X_1023); |
  730. | X_1044 := bat.mergecand(X_1004,X_1035); |
  731. | X_579:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,3,8); |
  732. | (X_594:bat[:oid,:oid] ,X_595:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,3,8); |
  733. | X_1059 := sql.projectdelta(X_1044,X_579,X_594,X_595); |
  734. | (X_1071,X_1072) := algebra.join(X_1059,X_87); |
  735. | X_612:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,3,8); |
  736. | (X_627:bat[:oid,:oid] ,X_628:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,3,8); |
  737. | X_1092 := sql.projectdelta(X_1044,X_612,X_627,X_628); |
  738. | X_1103 := algebra.leftfetchjoin(X_1071,X_1092); |
  739. | (X_1118,X_1119) := algebra.join(X_1103,X_112); |
  740. | X_2461 := algebra.leftfetchjoin(X_1118,X_1071); |
  741. | X_645:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,3,8); |
  742. | (X_660:bat[:oid,:oid] ,X_661:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,3,8); |
  743. | X_1139 := sql.projectdelta(X_1044,X_645,X_660,X_661); |
  744. | X_1148:bat[:oid,:str] := algebra.leftfetchjoin(X_2461,X_1139); |
  745. | (X_1162,X_1163) := algebra.join(X_1148,X_127); |
  746. | X_1179 := algebra.leftfetchjoin(X_1163,X_136); |
  747. | X_1188 := batcalc.hash(X_1179); |
  748. | X_1199 := algebra.leftfetchjoin(X_1163,X_145); |
  749. | X_1211 := mkey.bulk_rotate_xor_hash(X_1188,16,X_1199); |
  750. | X_1219 := algebra.leftfetchjoin(X_1163,X_154); |
  751. | X_1228 := mkey.bulk_rotate_xor_hash(X_1211,16,X_1219); |
  752. | (X_1242,X_1243) := algebra.join(X_1228,X_171); |
  753. | X_1259 := algebra.leftfetchjoin(X_1242,X_1179); |
  754. | X_1268 := algebra.leftfetchjoin(X_1243,X_165); |
  755. | X_1279 := batcalc.==(X_1259,X_1268); |
  756. | X_1291 := algebra.subselect(X_1279,true,true,true,true,false); |
  757. | X_1299 := algebra.leftfetchjoin(X_1291,X_1242); |
  758. | X_1308 := algebra.leftfetchjoin(X_1299,X_1199); |
  759. | X_1319 := algebra.leftfetchjoin(X_1291,X_1243); |
  760. | X_1331 := algebra.leftfetchjoin(X_1319,X_168); |
  761. | X_1339 := batcalc.==(X_1308,X_1331); |
  762. | X_1348 := algebra.subselect(X_1339,true,true,true,true,false); |
  763. | X_1359 := algebra.leftfetchjoin(X_1348,X_1299); |
  764. | X_1371 := algebra.leftfetchjoin(X_1359,X_1219); |
  765. | X_1379 := algebra.leftfetchjoin(X_1348,X_1319); |
  766. | X_1388 := algebra.leftfetchjoin(X_1379,X_170); |
  767. | X_1399 := batcalc.==(X_1371,X_1388); |
  768. | X_1411 := algebra.subselect(X_1399,true,true,true,true,false); |
  769. | X_1419 := algebra.leftfetchjoin(X_1411,X_1359); |
  770. | X_2469 := algebra.leftfetchjoin(X_1419,X_1163); |
  771. | X_1431:bat[:oid,:str] := algebra.leftfetchjoin(X_2469,X_184); |
  772. | X_1443 := algebra.leftfetchjoin(X_1411,X_1379); |
  773. | X_1451 := algebra.leftfetchjoin(X_1443,X_185); |
  774. | X_1503 := batcalc.<=(X_1431,X_1451); |
  775. | X_1463:bat[:oid,:str] := algebra.leftfetchjoin(X_2469,X_196); |
  776. | X_1475 := algebra.leftfetchjoin(X_1443,X_197); |
  777. | X_1483 := batcalc.>=(X_1463,X_1475); |
  778. | X_1492 := algebra.subselect(X_1483,true,true,true,true,false); |
  779. | X_1515 := algebra.subselect(X_1503,X_1492,true,true,true,true,false); |
  780. | X_1523 := algebra.leftfetchjoin(X_1515,X_1419); |
  781. | X_2477 := algebra.leftfetchjoin(X_1523,X_1162); |
  782. | X_678:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,3,8); |
  783. | (X_693:bat[:oid,:oid] ,X_694:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,3,8); |
  784. | X_1539 := sql.projectdelta(X_1044,X_678,X_693,X_694); |
  785. | X_1555:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2477,X_1118,X_1071,X_1539); |
  786. | (X_1566,X_1567) := algebra.join(X_1555,X_215); |
  787. | X_1583 := algebra.leftfetchjoin(X_1567,X_224); |
  788. | X_1595 := batcalc.hash(X_1583); |
  789. | X_1603 := algebra.leftfetchjoin(X_1567,X_233); |
  790. | X_1611 := mkey.bulk_rotate_xor_hash(X_1595,16,X_1603); |
  791. | X_1623 := algebra.leftfetchjoin(X_1567,X_242); |
  792. | X_1635 := mkey.bulk_rotate_xor_hash(X_1611,16,X_1623); |
  793. | (X_1646,X_1647) := algebra.join(X_1635,X_255); |
  794. | X_1663 := algebra.leftfetchjoin(X_1646,X_1583); |
  795. | X_1675 := algebra.leftfetchjoin(X_1647,X_249); |
  796. | X_1683 := batcalc.==(X_1663,X_1675); |
  797. | X_1691 := algebra.subselect(X_1683,true,true,true,true,false); |
  798. | X_1703 := algebra.leftfetchjoin(X_1691,X_1646); |
  799. | X_1715 := algebra.leftfetchjoin(X_1703,X_1603); |
  800. | X_1723 := algebra.leftfetchjoin(X_1691,X_1647); |
  801. | X_1731 := algebra.leftfetchjoin(X_1723,X_252); |
  802. | X_1743 := batcalc.==(X_1715,X_1731); |
  803. | X_1755 := algebra.subselect(X_1743,true,true,true,true,false); |
  804. | X_1763 := algebra.leftfetchjoin(X_1755,X_1703); |
  805. | X_1771 := algebra.leftfetchjoin(X_1763,X_1623); |
  806. | X_1783 := algebra.leftfetchjoin(X_1755,X_1723); |
  807. | X_1795 := algebra.leftfetchjoin(X_1783,X_254); |
  808. | X_1803 := batcalc.==(X_1771,X_1795); |
  809. | X_1811 := algebra.subselect(X_1803,true,true,true,true,false); |
  810. | X_1823 := algebra.leftfetchjoin(X_1811,X_1763); |
  811. | X_2485 := algebra.leftfetchjoin(X_1823,X_1567); |
  812. | X_1835:bat[:oid,:str] := algebra.leftfetchjoin(X_2485,X_268); |
  813. | X_1843 := algebra.leftfetchjoin(X_1811,X_1783); |
  814. | X_1855 := algebra.leftfetchjoin(X_1843,X_269); |
  815. | X_1907 := batcalc.<=(X_1835,X_1855); |
  816. | X_1867:bat[:oid,:str] := algebra.leftfetchjoin(X_2485,X_280); |
  817. | X_1875 := algebra.leftfetchjoin(X_1843,X_281); |
  818. | X_1887 := batcalc.>=(X_1867,X_1875); |
  819. | X_1899 := algebra.subselect(X_1887,true,true,true,true,false); |
  820. | X_1915 := algebra.subselect(X_1907,X_1899,true,true,true,true,false); |
  821. | X_1931:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1915,X_1843,X_284); |
  822. | X_1939 := algebra.leftfetchjoin(X_1915,X_1823); |
  823. | X_2493 := algebra.leftfetchjoin(X_1939,X_1566); |
  824. | X_1955:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1515,X_1443,X_286); |
  825. | X_1971:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1119,X_112); |
  826. | X_1995:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1118,X_1072,X_289); |
  827. | X_2011:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1118,X_1072,X_291); |
  828. | (X_2026,X_2027,X_2028) := group.subgroup(X_2011); |
  829. | (X_2050,X_2051,X_2052) := group.subgroup(X_1995,X_2026); |
  830. | (X_2074,X_2075,X_2076) := group.subgroup(X_1971,X_2050); |
  831. | X_2092 := algebra.leftfetchjoin(X_2075,X_2050); |
  832. | (X_2106,X_2107,X_2108) := group.subgroup(X_1955,X_2074); |
  833. | X_2124 := algebra.leftfetchjoin(X_2107,X_2074); |
  834. | (X_2141,X_2142,X_2143) := group.subgroupdone(X_1931,X_2106); |
  835. | X_2144 := algebra.leftfetchjoin(X_2142,X_1931); |
  836. | X_2167 := algebra.leftfetchjoin(X_2142,X_2106); |
  837. | X_2212 := sql.projectdelta(X_1044,X_513,X_528,X_529); |
  838. | X_2233:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1118,X_1071,X_2212); |
  839. | X_2241 := batcalc.==(X_2233,A0); |
  840. | X_2252 := sql.projectdelta(X_1044,X_484,X_495,X_496); |
  841. | X_2273:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1118,X_1071,X_2252); |
  842. | X_2281 := batcalc.==(X_2273,A1); |
  843. | X_2292 := batcalc.and(X_2241,X_2281); |
  844. | X_2305 := batcalc.isnil(X_2292); |
  845. | X_2321 := batcalc.ifthenelse(X_2305,false,X_2292); |
  846. | X_711:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,3,8); |
  847. | (X_726:bat[:oid,:oid] ,X_727:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,3,8); |
  848. | X_2332 := sql.projectdelta(X_1044,X_711,X_726,X_727); |
  849. | X_2353:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2493,X_1523,X_1162,X_1118,X_1071,X_2332); |
  850. | X_2361 := batcalc.ifthenelse(X_2321,X_2353,X_317); |
  851. | X_2370 := aggr.subsum(X_2361,X_2141,X_2142,true,true); |
  852. | X_2382 := batcalc.==(X_2233,A3); |
  853. | X_2395 := batcalc.==(X_2273,A4); |
  854. | X_2403 := batcalc.and(X_2382,X_2395); |
  855. | X_2411 := batcalc.isnil(X_2403); |
  856. | X_2427 := batcalc.ifthenelse(X_2411,false,X_2403); |
  857. | X_2438 := batcalc.ifthenelse(X_2427,X_2353,X_323); |
  858. | X_2452 := aggr.subsum(X_2438,X_2141,X_2142,true,true); |
  859. | X_2168:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2167,X_2107,X_1955); |
  860. | X_2501 := algebra.leftfetchjoin(X_2167,X_2124); |
  861. | X_2180:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2501,X_2075,X_1971); |
  862. | X_2188:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2501,X_2092,X_2051,X_1995); |
  863. | X_2196:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2501,X_2092,X_2051,X_2026,X_2027,X_2011); |
  864. | X_485:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,4,8); |
  865. | X_515:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,4,8); |
  866. | X_548:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,4,8); |
  867. | X_474:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",4,8); |
  868. | X_756 := algebra.subselect(X_548,X_474,A7,A7,true,true,false); |
  869. | (X_563:bat[:oid,:oid] ,X_564:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,4,8); |
  870. | X_765 := algebra.subselect(X_564,A7,A7,true,true,false); |
  871. | X_773 := sql.subdelta(X_756,X_474,X_563,X_765); |
  872. | X_785 := algebra.subselect(X_515,X_773,A8,A8,true,true,false); |
  873. | (X_530:bat[:oid,:oid] ,X_531:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,4,8); |
  874. | X_796 := algebra.subselect(X_531,A8,A8,true,true,false); |
  875. | X_805 := sql.subdelta(X_785,X_773,X_530,X_796); |
  876. | X_813 := algebra.subselect(X_485,X_805,A9,A9,true,true,false); |
  877. | (X_497:bat[:oid,:oid] ,X_498:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,4,8); |
  878. | X_825 := algebra.subselect(X_498,A9,A9,true,true,false); |
  879. | X_836 := sql.subdelta(X_813,X_805,X_497,X_825); |
  880. | X_845 := algebra.subselect(X_515,X_773,A10,A10,true,true,false); |
  881. | X_853 := algebra.subselect(X_531,A10,A10,true,true,false); |
  882. | X_865 := sql.subdelta(X_845,X_773,X_530,X_853); |
  883. | X_876 := algebra.subselect(X_485,X_865,A11,A11,true,true,false); |
  884. | X_885 := algebra.subselect(X_498,A11,A11,true,true,false); |
  885. | X_893 := sql.subdelta(X_876,X_865,X_497,X_885); |
  886. | X_905 := bat.mergecand(X_836,X_893); |
  887. | X_916 := algebra.subselect(X_515,X_905,A8,A8,true,true,false); |
  888. | X_925 := algebra.subselect(X_531,A8,A8,true,true,false); |
  889. | X_933 := sql.subdelta(X_916,X_905,X_530,X_925); |
  890. | X_945 := algebra.subselect(X_515,X_905,A10,A10,true,true,false); |
  891. | X_956 := algebra.subselect(X_531,A10,A10,true,true,false); |
  892. | X_965 := sql.subdelta(X_945,X_905,X_530,X_956); |
  893. | X_973 := bat.mergecand(X_933,X_965); |
  894. | X_985 := algebra.subselect(X_485,X_973,A9,A9,true,true,false); |
  895. | X_996 := algebra.subselect(X_498,A9,A9,true,true,false); |
  896. | X_1005 := sql.subdelta(X_985,X_973,X_497,X_996); |
  897. | X_1013 := algebra.subselect(X_485,X_973,A11,A11,true,true,false); |
  898. | X_1025 := algebra.subselect(X_498,A11,A11,true,true,false); |
  899. | X_1036 := sql.subdelta(X_1013,X_973,X_497,X_1025); |
  900. | X_1045 := bat.mergecand(X_1005,X_1036); |
  901. | X_581:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,4,8); |
  902. | (X_596:bat[:oid,:oid] ,X_597:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,4,8); |
  903. | X_1060 := sql.projectdelta(X_1045,X_581,X_596,X_597); |
  904. | (X_1073,X_1074) := algebra.join(X_1060,X_87); |
  905. | X_614:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,4,8); |
  906. | (X_629:bat[:oid,:oid] ,X_630:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,4,8); |
  907. | X_1093 := sql.projectdelta(X_1045,X_614,X_629,X_630); |
  908. | X_1105 := algebra.leftfetchjoin(X_1073,X_1093); |
  909. | (X_1120,X_1121) := algebra.join(X_1105,X_112); |
  910. | X_2462 := algebra.leftfetchjoin(X_1120,X_1073); |
  911. | X_647:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,4,8); |
  912. | (X_662:bat[:oid,:oid] ,X_663:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,4,8); |
  913. | X_1140 := sql.projectdelta(X_1045,X_647,X_662,X_663); |
  914. | X_1149:bat[:oid,:str] := algebra.leftfetchjoin(X_2462,X_1140); |
  915. | (X_1165,X_1166) := algebra.join(X_1149,X_127); |
  916. | X_1180 := algebra.leftfetchjoin(X_1166,X_136); |
  917. | X_1189 := batcalc.hash(X_1180); |
  918. | X_1201 := algebra.leftfetchjoin(X_1166,X_145); |
  919. | X_1212 := mkey.bulk_rotate_xor_hash(X_1189,16,X_1201); |
  920. | X_1220 := algebra.leftfetchjoin(X_1166,X_154); |
  921. | X_1229 := mkey.bulk_rotate_xor_hash(X_1212,16,X_1220); |
  922. | (X_1245,X_1246) := algebra.join(X_1229,X_171); |
  923. | X_1260 := algebra.leftfetchjoin(X_1245,X_1180); |
  924. | X_1269 := algebra.leftfetchjoin(X_1246,X_165); |
  925. | X_1281 := batcalc.==(X_1260,X_1269); |
  926. | X_1292 := algebra.subselect(X_1281,true,true,true,true,false); |
  927. | X_1300 := algebra.leftfetchjoin(X_1292,X_1245); |
  928. | X_1309 := algebra.leftfetchjoin(X_1300,X_1201); |
  929. | X_1321 := algebra.leftfetchjoin(X_1292,X_1246); |
  930. | X_1332 := algebra.leftfetchjoin(X_1321,X_168); |
  931. | X_1340 := batcalc.==(X_1309,X_1332); |
  932. | X_1349 := algebra.subselect(X_1340,true,true,true,true,false); |
  933. | X_1361 := algebra.leftfetchjoin(X_1349,X_1300); |
  934. | X_1372 := algebra.leftfetchjoin(X_1361,X_1220); |
  935. | X_1380 := algebra.leftfetchjoin(X_1349,X_1321); |
  936. | X_1389 := algebra.leftfetchjoin(X_1380,X_170); |
  937. | X_1401 := batcalc.==(X_1372,X_1389); |
  938. | X_1412 := algebra.subselect(X_1401,true,true,true,true,false); |
  939. | X_1420 := algebra.leftfetchjoin(X_1412,X_1361); |
  940. | X_2470 := algebra.leftfetchjoin(X_1420,X_1166); |
  941. | X_1433:bat[:oid,:str] := algebra.leftfetchjoin(X_2470,X_184); |
  942. | X_1444 := algebra.leftfetchjoin(X_1412,X_1380); |
  943. | X_1452 := algebra.leftfetchjoin(X_1444,X_185); |
  944. | X_1505 := batcalc.<=(X_1433,X_1452); |
  945. | X_1465:bat[:oid,:str] := algebra.leftfetchjoin(X_2470,X_196); |
  946. | X_1476 := algebra.leftfetchjoin(X_1444,X_197); |
  947. | X_1484 := batcalc.>=(X_1465,X_1476); |
  948. | X_1493 := algebra.subselect(X_1484,true,true,true,true,false); |
  949. | X_1516 := algebra.subselect(X_1505,X_1493,true,true,true,true,false); |
  950. | X_1524 := algebra.leftfetchjoin(X_1516,X_1420); |
  951. | X_2478 := algebra.leftfetchjoin(X_1524,X_1165); |
  952. | X_680:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,4,8); |
  953. | (X_695:bat[:oid,:oid] ,X_696:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,4,8); |
  954. | X_1540 := sql.projectdelta(X_1045,X_680,X_695,X_696); |
  955. | X_1556:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2478,X_1120,X_1073,X_1540); |
  956. | (X_1568,X_1569) := algebra.join(X_1556,X_215); |
  957. | X_1585 := algebra.leftfetchjoin(X_1569,X_224); |
  958. | X_1596 := batcalc.hash(X_1585); |
  959. | X_1604 := algebra.leftfetchjoin(X_1569,X_233); |
  960. | X_1612 := mkey.bulk_rotate_xor_hash(X_1596,16,X_1604); |
  961. | X_1625 := algebra.leftfetchjoin(X_1569,X_242); |
  962. | X_1636 := mkey.bulk_rotate_xor_hash(X_1612,16,X_1625); |
  963. | (X_1648,X_1649) := algebra.join(X_1636,X_255); |
  964. | X_1665 := algebra.leftfetchjoin(X_1648,X_1585); |
  965. | X_1676 := algebra.leftfetchjoin(X_1649,X_249); |
  966. | X_1684 := batcalc.==(X_1665,X_1676); |
  967. | X_1692 := algebra.subselect(X_1684,true,true,true,true,false); |
  968. | X_1705 := algebra.leftfetchjoin(X_1692,X_1648); |
  969. | X_1716 := algebra.leftfetchjoin(X_1705,X_1604); |
  970. | X_1724 := algebra.leftfetchjoin(X_1692,X_1649); |
  971. | X_1732 := algebra.leftfetchjoin(X_1724,X_252); |
  972. | X_1745 := batcalc.==(X_1716,X_1732); |
  973. | X_1756 := algebra.subselect(X_1745,true,true,true,true,false); |
  974. | X_1764 := algebra.leftfetchjoin(X_1756,X_1705); |
  975. | X_1772 := algebra.leftfetchjoin(X_1764,X_1625); |
  976. | X_1785 := algebra.leftfetchjoin(X_1756,X_1724); |
  977. | X_1796 := algebra.leftfetchjoin(X_1785,X_254); |
  978. | X_1804 := batcalc.==(X_1772,X_1796); |
  979. | X_1812 := algebra.subselect(X_1804,true,true,true,true,false); |
  980. | X_1825 := algebra.leftfetchjoin(X_1812,X_1764); |
  981. | X_2486 := algebra.leftfetchjoin(X_1825,X_1569); |
  982. | X_1836:bat[:oid,:str] := algebra.leftfetchjoin(X_2486,X_268); |
  983. | X_1844 := algebra.leftfetchjoin(X_1812,X_1785); |
  984. | X_1857 := algebra.leftfetchjoin(X_1844,X_269); |
  985. | X_1908 := batcalc.<=(X_1836,X_1857); |
  986. | X_1868:bat[:oid,:str] := algebra.leftfetchjoin(X_2486,X_280); |
  987. | X_1876 := algebra.leftfetchjoin(X_1844,X_281); |
  988. | X_1889 := batcalc.>=(X_1868,X_1876); |
  989. | X_1900 := algebra.subselect(X_1889,true,true,true,true,false); |
  990. | X_1916 := algebra.subselect(X_1908,X_1900,true,true,true,true,false); |
  991. | X_1932:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1916,X_1844,X_284); |
  992. | X_1940 := algebra.leftfetchjoin(X_1916,X_1825); |
  993. | X_2494 := algebra.leftfetchjoin(X_1940,X_1568); |
  994. | X_1956:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1516,X_1444,X_286); |
  995. | X_1972:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1121,X_112); |
  996. | X_1996:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1120,X_1074,X_289); |
  997. | X_2012:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1120,X_1074,X_291); |
  998. | (X_2029,X_2030,X_2031) := group.subgroup(X_2012); |
  999. | (X_2053,X_2054,X_2055) := group.subgroup(X_1996,X_2029); |
  1000. | (X_2077,X_2078,X_2079) := group.subgroup(X_1972,X_2053); |
  1001. | X_2093 := algebra.leftfetchjoin(X_2078,X_2053); |
  1002. | (X_2109,X_2110,X_2111) := group.subgroup(X_1956,X_2077); |
  1003. | X_2125 := algebra.leftfetchjoin(X_2110,X_2077); |
  1004. | (X_2145,X_2146,X_2147) := group.subgroupdone(X_1932,X_2109); |
  1005. | X_2148 := algebra.leftfetchjoin(X_2146,X_1932); |
  1006. | X_2169 := algebra.leftfetchjoin(X_2146,X_2109); |
  1007. | X_2214 := sql.projectdelta(X_1045,X_515,X_530,X_531); |
  1008. | X_2234:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1120,X_1073,X_2214); |
  1009. | X_2242 := batcalc.==(X_2234,A0); |
  1010. | X_2254 := sql.projectdelta(X_1045,X_485,X_497,X_498); |
  1011. | X_2274:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1120,X_1073,X_2254); |
  1012. | X_2282 := batcalc.==(X_2274,A1); |
  1013. | X_2294 := batcalc.and(X_2242,X_2282); |
  1014. | X_2306 := batcalc.isnil(X_2294); |
  1015. | X_2322 := batcalc.ifthenelse(X_2306,false,X_2294); |
  1016. | X_713:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,4,8); |
  1017. | (X_728:bat[:oid,:oid] ,X_729:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,4,8); |
  1018. | X_2334 := sql.projectdelta(X_1045,X_713,X_728,X_729); |
  1019. | X_2354:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2494,X_1524,X_1165,X_1120,X_1073,X_2334); |
  1020. | X_2362 := batcalc.ifthenelse(X_2322,X_2354,X_317); |
  1021. | X_2371 := aggr.subsum(X_2362,X_2145,X_2146,true,true); |
  1022. | X_2384 := batcalc.==(X_2234,A3); |
  1023. | X_2396 := batcalc.==(X_2274,A4); |
  1024. | X_2404 := batcalc.and(X_2384,X_2396); |
  1025. | X_2412 := batcalc.isnil(X_2404); |
  1026. | X_2428 := batcalc.ifthenelse(X_2412,false,X_2404); |
  1027. | X_2440 := batcalc.ifthenelse(X_2428,X_2354,X_323); |
  1028. | X_2453 := aggr.subsum(X_2440,X_2145,X_2146,true,true); |
  1029. | X_2170:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2169,X_2110,X_1956); |
  1030. | X_2502 := algebra.leftfetchjoin(X_2169,X_2125); |
  1031. | X_2181:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2502,X_2078,X_1972); |
  1032. | X_2189:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2502,X_2093,X_2054,X_1996); |
  1033. | X_2197:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2502,X_2093,X_2054,X_2029,X_2030,X_2012); |
  1034. | X_486:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,5,8); |
  1035. | X_517:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,5,8); |
  1036. | X_550:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,5,8); |
  1037. | X_476:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",5,8); |
  1038. | X_757 := algebra.subselect(X_550,X_476,A7,A7,true,true,false); |
  1039. | (X_566:bat[:oid,:oid] ,X_567:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,5,8); |
  1040. | X_766 := algebra.subselect(X_567,A7,A7,true,true,false); |
  1041. | X_774 := sql.subdelta(X_757,X_476,X_566,X_766); |
  1042. | X_787 := algebra.subselect(X_517,X_774,A8,A8,true,true,false); |
  1043. | (X_533:bat[:oid,:oid] ,X_534:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,5,8); |
  1044. | X_797 := algebra.subselect(X_534,A8,A8,true,true,false); |
  1045. | X_806 := sql.subdelta(X_787,X_774,X_533,X_797); |
  1046. | X_814 := algebra.subselect(X_486,X_806,A9,A9,true,true,false); |
  1047. | (X_500:bat[:oid,:oid] ,X_501:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,5,8); |
  1048. | X_827 := algebra.subselect(X_501,A9,A9,true,true,false); |
  1049. | X_837 := sql.subdelta(X_814,X_806,X_500,X_827); |
  1050. | X_846 := algebra.subselect(X_517,X_774,A10,A10,true,true,false); |
  1051. | X_854 := algebra.subselect(X_534,A10,A10,true,true,false); |
  1052. | X_867 := sql.subdelta(X_846,X_774,X_533,X_854); |
  1053. | X_877 := algebra.subselect(X_486,X_867,A11,A11,true,true,false); |
  1054. | X_886 := algebra.subselect(X_501,A11,A11,true,true,false); |
  1055. | X_894 := sql.subdelta(X_877,X_867,X_500,X_886); |
  1056. | X_907 := bat.mergecand(X_837,X_894); |
  1057. | X_917 := algebra.subselect(X_517,X_907,A8,A8,true,true,false); |
  1058. | X_926 := algebra.subselect(X_534,A8,A8,true,true,false); |
  1059. | X_934 := sql.subdelta(X_917,X_907,X_533,X_926); |
  1060. | X_947 := algebra.subselect(X_517,X_907,A10,A10,true,true,false); |
  1061. | X_957 := algebra.subselect(X_534,A10,A10,true,true,false); |
  1062. | X_966 := sql.subdelta(X_947,X_907,X_533,X_957); |
  1063. | X_974 := bat.mergecand(X_934,X_966); |
  1064. | X_987 := algebra.subselect(X_486,X_974,A9,A9,true,true,false); |
  1065. | X_997 := algebra.subselect(X_501,A9,A9,true,true,false); |
  1066. | X_1006 := sql.subdelta(X_987,X_974,X_500,X_997); |
  1067. | X_1014 := algebra.subselect(X_486,X_974,A11,A11,true,true,false); |
  1068. | X_1027 := algebra.subselect(X_501,A11,A11,true,true,false); |
  1069. | X_1037 := sql.subdelta(X_1014,X_974,X_500,X_1027); |
  1070. | X_1046 := bat.mergecand(X_1006,X_1037); |
  1071. | X_583:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,5,8); |
  1072. | (X_599:bat[:oid,:oid] ,X_600:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,5,8); |
  1073. | X_1061 := sql.projectdelta(X_1046,X_583,X_599,X_600); |
  1074. | (X_1075,X_1076) := algebra.join(X_1061,X_87); |
  1075. | X_616:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,5,8); |
  1076. | (X_632:bat[:oid,:oid] ,X_633:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,5,8); |
  1077. | X_1094 := sql.projectdelta(X_1046,X_616,X_632,X_633); |
  1078. | X_1107 := algebra.leftfetchjoin(X_1075,X_1094); |
  1079. | (X_1122,X_1123) := algebra.join(X_1107,X_112); |
  1080. | X_2463 := algebra.leftfetchjoin(X_1122,X_1075); |
  1081. | X_649:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,5,8); |
  1082. | (X_665:bat[:oid,:oid] ,X_666:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,5,8); |
  1083. | X_1141 := sql.projectdelta(X_1046,X_649,X_665,X_666); |
  1084. | X_1150:bat[:oid,:str] := algebra.leftfetchjoin(X_2463,X_1141); |
  1085. | (X_1168,X_1169) := algebra.join(X_1150,X_127); |
  1086. | X_1181 := algebra.leftfetchjoin(X_1169,X_136); |
  1087. | X_1190 := batcalc.hash(X_1181); |
  1088. | X_1203 := algebra.leftfetchjoin(X_1169,X_145); |
  1089. | X_1213 := mkey.bulk_rotate_xor_hash(X_1190,16,X_1203); |
  1090. | X_1221 := algebra.leftfetchjoin(X_1169,X_154); |
  1091. | X_1230 := mkey.bulk_rotate_xor_hash(X_1213,16,X_1221); |
  1092. | (X_1248,X_1249) := algebra.join(X_1230,X_171); |
  1093. | X_1261 := algebra.leftfetchjoin(X_1248,X_1181); |
  1094. | X_1270 := algebra.leftfetchjoin(X_1249,X_165); |
  1095. | X_1283 := batcalc.==(X_1261,X_1270); |
  1096. | X_1293 := algebra.subselect(X_1283,true,true,true,true,false); |
  1097. | X_1301 := algebra.leftfetchjoin(X_1293,X_1248); |
  1098. | X_1310 := algebra.leftfetchjoin(X_1301,X_1203); |
  1099. | X_1323 := algebra.leftfetchjoin(X_1293,X_1249); |
  1100. | X_1333 := algebra.leftfetchjoin(X_1323,X_168); |
  1101. | X_1341 := batcalc.==(X_1310,X_1333); |
  1102. | X_1350 := algebra.subselect(X_1341,true,true,true,true,false); |
  1103. | X_1363 := algebra.leftfetchjoin(X_1350,X_1301); |
  1104. | X_1373 := algebra.leftfetchjoin(X_1363,X_1221); |
  1105. | X_1381 := algebra.leftfetchjoin(X_1350,X_1323); |
  1106. | X_1390 := algebra.leftfetchjoin(X_1381,X_170); |
  1107. | X_1403 := batcalc.==(X_1373,X_1390); |
  1108. | X_1413 := algebra.subselect(X_1403,true,true,true,true,false); |
  1109. | X_1421 := algebra.leftfetchjoin(X_1413,X_1363); |
  1110. | X_2471 := algebra.leftfetchjoin(X_1421,X_1169); |
  1111. | X_1435:bat[:oid,:str] := algebra.leftfetchjoin(X_2471,X_184); |
  1112. | X_1445 := algebra.leftfetchjoin(X_1413,X_1381); |
  1113. | X_1453 := algebra.leftfetchjoin(X_1445,X_185); |
  1114. | X_1507 := batcalc.<=(X_1435,X_1453); |
  1115. | X_1467:bat[:oid,:str] := algebra.leftfetchjoin(X_2471,X_196); |
  1116. | X_1477 := algebra.leftfetchjoin(X_1445,X_197); |
  1117. | X_1485 := batcalc.>=(X_1467,X_1477); |
  1118. | X_1494 := algebra.subselect(X_1485,true,true,true,true,false); |
  1119. | X_1517 := algebra.subselect(X_1507,X_1494,true,true,true,true,false); |
  1120. | X_1525 := algebra.leftfetchjoin(X_1517,X_1421); |
  1121. | X_2479 := algebra.leftfetchjoin(X_1525,X_1168); |
  1122. | X_682:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,5,8); |
  1123. | (X_698:bat[:oid,:oid] ,X_699:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,5,8); |
  1124. | X_1541 := sql.projectdelta(X_1046,X_682,X_698,X_699); |
  1125. | X_1557:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2479,X_1122,X_1075,X_1541); |
  1126. | (X_1570,X_1571) := algebra.join(X_1557,X_215); |
  1127. | X_1587 := algebra.leftfetchjoin(X_1571,X_224); |
  1128. | X_1597 := batcalc.hash(X_1587); |
  1129. | X_1605 := algebra.leftfetchjoin(X_1571,X_233); |
  1130. | X_1613 := mkey.bulk_rotate_xor_hash(X_1597,16,X_1605); |
  1131. | X_1627 := algebra.leftfetchjoin(X_1571,X_242); |
  1132. | X_1637 := mkey.bulk_rotate_xor_hash(X_1613,16,X_1627); |
  1133. | (X_1650,X_1651) := algebra.join(X_1637,X_255); |
  1134. | X_1667 := algebra.leftfetchjoin(X_1650,X_1587); |
  1135. | X_1677 := algebra.leftfetchjoin(X_1651,X_249); |
  1136. | X_1685 := batcalc.==(X_1667,X_1677); |
  1137. | X_1693 := algebra.subselect(X_1685,true,true,true,true,false); |
  1138. | X_1707 := algebra.leftfetchjoin(X_1693,X_1650); |
  1139. | X_1717 := algebra.leftfetchjoin(X_1707,X_1605); |
  1140. | X_1725 := algebra.leftfetchjoin(X_1693,X_1651); |
  1141. | X_1733 := algebra.leftfetchjoin(X_1725,X_252); |
  1142. | X_1747 := batcalc.==(X_1717,X_1733); |
  1143. | X_1757 := algebra.subselect(X_1747,true,true,true,true,false); |
  1144. | X_1765 := algebra.leftfetchjoin(X_1757,X_1707); |
  1145. | X_1773 := algebra.leftfetchjoin(X_1765,X_1627); |
  1146. | X_1787 := algebra.leftfetchjoin(X_1757,X_1725); |
  1147. | X_1797 := algebra.leftfetchjoin(X_1787,X_254); |
  1148. | X_1805 := batcalc.==(X_1773,X_1797); |
  1149. | X_1813 := algebra.subselect(X_1805,true,true,true,true,false); |
  1150. | X_1827 := algebra.leftfetchjoin(X_1813,X_1765); |
  1151. | X_2487 := algebra.leftfetchjoin(X_1827,X_1571); |
  1152. | X_1837:bat[:oid,:str] := algebra.leftfetchjoin(X_2487,X_268); |
  1153. | X_1845 := algebra.leftfetchjoin(X_1813,X_1787); |
  1154. | X_1859 := algebra.leftfetchjoin(X_1845,X_269); |
  1155. | X_1909 := batcalc.<=(X_1837,X_1859); |
  1156. | X_1869:bat[:oid,:str] := algebra.leftfetchjoin(X_2487,X_280); |
  1157. | X_1877 := algebra.leftfetchjoin(X_1845,X_281); |
  1158. | X_1891 := batcalc.>=(X_1869,X_1877); |
  1159. | X_1901 := algebra.subselect(X_1891,true,true,true,true,false); |
  1160. | X_1917 := algebra.subselect(X_1909,X_1901,true,true,true,true,false); |
  1161. | X_1933:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1917,X_1845,X_284); |
  1162. | X_1941 := algebra.leftfetchjoin(X_1917,X_1827); |
  1163. | X_2495 := algebra.leftfetchjoin(X_1941,X_1570); |
  1164. | X_1957:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1517,X_1445,X_286); |
  1165. | X_1973:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1123,X_112); |
  1166. | X_1997:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1122,X_1076,X_289); |
  1167. | X_2013:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1122,X_1076,X_291); |
  1168. | (X_2032,X_2033,X_2034) := group.subgroup(X_2013); |
  1169. | (X_2056,X_2057,X_2058) := group.subgroup(X_1997,X_2032); |
  1170. | (X_2080,X_2081,X_2082) := group.subgroup(X_1973,X_2056); |
  1171. | X_2094 := algebra.leftfetchjoin(X_2081,X_2056); |
  1172. | (X_2112,X_2113,X_2114) := group.subgroup(X_1957,X_2080); |
  1173. | X_2126 := algebra.leftfetchjoin(X_2113,X_2080); |
  1174. | (X_2149,X_2150,X_2151) := group.subgroupdone(X_1933,X_2112); |
  1175. | X_2152 := algebra.leftfetchjoin(X_2150,X_1933); |
  1176. | X_2171 := algebra.leftfetchjoin(X_2150,X_2112); |
  1177. | X_2216 := sql.projectdelta(X_1046,X_517,X_533,X_534); |
  1178. | X_2235:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1122,X_1075,X_2216); |
  1179. | X_2243 := batcalc.==(X_2235,A0); |
  1180. | X_2256 := sql.projectdelta(X_1046,X_486,X_500,X_501); |
  1181. | X_2275:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1122,X_1075,X_2256); |
  1182. | X_2283 := batcalc.==(X_2275,A1); |
  1183. | X_2296 := batcalc.and(X_2243,X_2283); |
  1184. | X_2307 := batcalc.isnil(X_2296); |
  1185. | X_2323 := batcalc.ifthenelse(X_2307,false,X_2296); |
  1186. | X_715:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,5,8); |
  1187. | (X_731:bat[:oid,:oid] ,X_732:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,5,8); |
  1188. | X_2336 := sql.projectdelta(X_1046,X_715,X_731,X_732); |
  1189. | X_2355:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2495,X_1525,X_1168,X_1122,X_1075,X_2336); |
  1190. | X_2363 := batcalc.ifthenelse(X_2323,X_2355,X_317); |
  1191. | X_2372 := aggr.subsum(X_2363,X_2149,X_2150,true,true); |
  1192. | X_2386 := batcalc.==(X_2235,A3); |
  1193. | X_2397 := batcalc.==(X_2275,A4); |
  1194. | X_2405 := batcalc.and(X_2386,X_2397); |
  1195. | X_2413 := batcalc.isnil(X_2405); |
  1196. | X_2429 := batcalc.ifthenelse(X_2413,false,X_2405); |
  1197. | X_2442 := batcalc.ifthenelse(X_2429,X_2355,X_323); |
  1198. | X_2454 := aggr.subsum(X_2442,X_2149,X_2150,true,true); |
  1199. | X_2172:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2171,X_2113,X_1957); |
  1200. | X_2503 := algebra.leftfetchjoin(X_2171,X_2126); |
  1201. | X_2182:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2503,X_2081,X_1973); |
  1202. | X_2190:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2503,X_2094,X_2057,X_1997); |
  1203. | X_2198:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2503,X_2094,X_2057,X_2032,X_2033,X_2013); |
  1204. | X_487:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,6,8); |
  1205. | X_519:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,6,8); |
  1206. | X_552:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,6,8); |
  1207. | X_478:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",6,8); |
  1208. | X_758 := algebra.subselect(X_552,X_478,A7,A7,true,true,false); |
  1209. | (X_568:bat[:oid,:oid] ,X_569:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,6,8); |
  1210. | X_767 := algebra.subselect(X_569,A7,A7,true,true,false); |
  1211. | X_775 := sql.subdelta(X_758,X_478,X_568,X_767); |
  1212. | X_789 := algebra.subselect(X_519,X_775,A8,A8,true,true,false); |
  1213. | (X_535:bat[:oid,:oid] ,X_536:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,6,8); |
  1214. | X_798 := algebra.subselect(X_536,A8,A8,true,true,false); |
  1215. | X_807 := sql.subdelta(X_789,X_775,X_535,X_798); |
  1216. | X_815 := algebra.subselect(X_487,X_807,A9,A9,true,true,false); |
  1217. | (X_502:bat[:oid,:oid] ,X_503:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,6,8); |
  1218. | X_829 := algebra.subselect(X_503,A9,A9,true,true,false); |
  1219. | X_838 := sql.subdelta(X_815,X_807,X_502,X_829); |
  1220. | X_847 := algebra.subselect(X_519,X_775,A10,A10,true,true,false); |
  1221. | X_855 := algebra.subselect(X_536,A10,A10,true,true,false); |
  1222. | X_869 := sql.subdelta(X_847,X_775,X_535,X_855); |
  1223. | X_878 := algebra.subselect(X_487,X_869,A11,A11,true,true,false); |
  1224. | X_887 := algebra.subselect(X_503,A11,A11,true,true,false); |
  1225. | X_895 := sql.subdelta(X_878,X_869,X_502,X_887); |
  1226. | X_909 := bat.mergecand(X_838,X_895); |
  1227. | X_918 := algebra.subselect(X_519,X_909,A8,A8,true,true,false); |
  1228. | X_927 := algebra.subselect(X_536,A8,A8,true,true,false); |
  1229. | X_935 := sql.subdelta(X_918,X_909,X_535,X_927); |
  1230. | X_949 := algebra.subselect(X_519,X_909,A10,A10,true,true,false); |
  1231. | X_958 := algebra.subselect(X_536,A10,A10,true,true,false); |
  1232. | X_967 := sql.subdelta(X_949,X_909,X_535,X_958); |
  1233. | X_975 := bat.mergecand(X_935,X_967); |
  1234. | X_989 := algebra.subselect(X_487,X_975,A9,A9,true,true,false); |
  1235. | X_998 := algebra.subselect(X_503,A9,A9,true,true,false); |
  1236. | X_1007 := sql.subdelta(X_989,X_975,X_502,X_998); |
  1237. | X_1015 := algebra.subselect(X_487,X_975,A11,A11,true,true,false); |
  1238. | X_1029 := algebra.subselect(X_503,A11,A11,true,true,false); |
  1239. | X_1038 := sql.subdelta(X_1015,X_975,X_502,X_1029); |
  1240. | X_1047 := bat.mergecand(X_1007,X_1038); |
  1241. | X_585:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,6,8); |
  1242. | (X_601:bat[:oid,:oid] ,X_602:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,6,8); |
  1243. | X_1062 := sql.projectdelta(X_1047,X_585,X_601,X_602); |
  1244. | (X_1077,X_1078) := algebra.join(X_1062,X_87); |
  1245. | X_618:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,6,8); |
  1246. | (X_634:bat[:oid,:oid] ,X_635:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,6,8); |
  1247. | X_1095 := sql.projectdelta(X_1047,X_618,X_634,X_635); |
  1248. | X_1109 := algebra.leftfetchjoin(X_1077,X_1095); |
  1249. | (X_1124,X_1125) := algebra.join(X_1109,X_112); |
  1250. | X_2464 := algebra.leftfetchjoin(X_1124,X_1077); |
  1251. | X_651:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,6,8); |
  1252. | (X_667:bat[:oid,:oid] ,X_668:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,6,8); |
  1253. | X_1142 := sql.projectdelta(X_1047,X_651,X_667,X_668); |
  1254. | X_1151:bat[:oid,:str] := algebra.leftfetchjoin(X_2464,X_1142); |
  1255. | (X_1171,X_1172) := algebra.join(X_1151,X_127); |
  1256. | X_1182 := algebra.leftfetchjoin(X_1172,X_136); |
  1257. | X_1191 := batcalc.hash(X_1182); |
  1258. | X_1205 := algebra.leftfetchjoin(X_1172,X_145); |
  1259. | X_1214 := mkey.bulk_rotate_xor_hash(X_1191,16,X_1205); |
  1260. | X_1222 := algebra.leftfetchjoin(X_1172,X_154); |
  1261. | X_1231 := mkey.bulk_rotate_xor_hash(X_1214,16,X_1222); |
  1262. | (X_1251,X_1252) := algebra.join(X_1231,X_171); |
  1263. | X_1262 := algebra.leftfetchjoin(X_1251,X_1182); |
  1264. | X_1271 := algebra.leftfetchjoin(X_1252,X_165); |
  1265. | X_1285 := batcalc.==(X_1262,X_1271); |
  1266. | X_1294 := algebra.subselect(X_1285,true,true,true,true,false); |
  1267. | X_1302 := algebra.leftfetchjoin(X_1294,X_1251); |
  1268. | X_1311 := algebra.leftfetchjoin(X_1302,X_1205); |
  1269. | X_1325 := algebra.leftfetchjoin(X_1294,X_1252); |
  1270. | X_1334 := algebra.leftfetchjoin(X_1325,X_168); |
  1271. | X_1342 := batcalc.==(X_1311,X_1334); |
  1272. | X_1351 := algebra.subselect(X_1342,true,true,true,true,false); |
  1273. | X_1365 := algebra.leftfetchjoin(X_1351,X_1302); |
  1274. | X_1374 := algebra.leftfetchjoin(X_1365,X_1222); |
  1275. | X_1382 := algebra.leftfetchjoin(X_1351,X_1325); |
  1276. | X_1391 := algebra.leftfetchjoin(X_1382,X_170); |
  1277. | X_1405 := batcalc.==(X_1374,X_1391); |
  1278. | X_1414 := algebra.subselect(X_1405,true,true,true,true,false); |
  1279. | X_1422 := algebra.leftfetchjoin(X_1414,X_1365); |
  1280. | X_2472 := algebra.leftfetchjoin(X_1422,X_1172); |
  1281. | X_1437:bat[:oid,:str] := algebra.leftfetchjoin(X_2472,X_184); |
  1282. | X_1446 := algebra.leftfetchjoin(X_1414,X_1382); |
  1283. | X_1454 := algebra.leftfetchjoin(X_1446,X_185); |
  1284. | X_1509 := batcalc.<=(X_1437,X_1454); |
  1285. | X_1469:bat[:oid,:str] := algebra.leftfetchjoin(X_2472,X_196); |
  1286. | X_1478 := algebra.leftfetchjoin(X_1446,X_197); |
  1287. | X_1486 := batcalc.>=(X_1469,X_1478); |
  1288. | X_1495 := algebra.subselect(X_1486,true,true,true,true,false); |
  1289. | X_1518 := algebra.subselect(X_1509,X_1495,true,true,true,true,false); |
  1290. | X_1526 := algebra.leftfetchjoin(X_1518,X_1422); |
  1291. | X_2480 := algebra.leftfetchjoin(X_1526,X_1171); |
  1292. | X_684:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,6,8); |
  1293. | (X_700:bat[:oid,:oid] ,X_701:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,6,8); |
  1294. | X_1542 := sql.projectdelta(X_1047,X_684,X_700,X_701); |
  1295. | X_1558:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2480,X_1124,X_1077,X_1542); |
  1296. | (X_1572,X_1573) := algebra.join(X_1558,X_215); |
  1297. | X_1589 := algebra.leftfetchjoin(X_1573,X_224); |
  1298. | X_1598 := batcalc.hash(X_1589); |
  1299. | X_1606 := algebra.leftfetchjoin(X_1573,X_233); |
  1300. | X_1614 := mkey.bulk_rotate_xor_hash(X_1598,16,X_1606); |
  1301. | X_1629 := algebra.leftfetchjoin(X_1573,X_242); |
  1302. | X_1638 := mkey.bulk_rotate_xor_hash(X_1614,16,X_1629); |
  1303. | (X_1652,X_1653) := algebra.join(X_1638,X_255); |
  1304. | X_1669 := algebra.leftfetchjoin(X_1652,X_1589); |
  1305. | X_1678 := algebra.leftfetchjoin(X_1653,X_249); |
  1306. | X_1686 := batcalc.==(X_1669,X_1678); |
  1307. | X_1694 := algebra.subselect(X_1686,true,true,true,true,false); |
  1308. | X_1709 := algebra.leftfetchjoin(X_1694,X_1652); |
  1309. | X_1718 := algebra.leftfetchjoin(X_1709,X_1606); |
  1310. | X_1726 := algebra.leftfetchjoin(X_1694,X_1653); |
  1311. | X_1734 := algebra.leftfetchjoin(X_1726,X_252); |
  1312. | X_1749 := batcalc.==(X_1718,X_1734); |
  1313. | X_1758 := algebra.subselect(X_1749,true,true,true,true,false); |
  1314. | X_1766 := algebra.leftfetchjoin(X_1758,X_1709); |
  1315. | X_1774 := algebra.leftfetchjoin(X_1766,X_1629); |
  1316. | X_1789 := algebra.leftfetchjoin(X_1758,X_1726); |
  1317. | X_1798 := algebra.leftfetchjoin(X_1789,X_254); |
  1318. | X_1806 := batcalc.==(X_1774,X_1798); |
  1319. | X_1814 := algebra.subselect(X_1806,true,true,true,true,false); |
  1320. | X_1829 := algebra.leftfetchjoin(X_1814,X_1766); |
  1321. | X_2488 := algebra.leftfetchjoin(X_1829,X_1573); |
  1322. | X_1838:bat[:oid,:str] := algebra.leftfetchjoin(X_2488,X_268); |
  1323. | X_1846 := algebra.leftfetchjoin(X_1814,X_1789); |
  1324. | X_1861 := algebra.leftfetchjoin(X_1846,X_269); |
  1325. | X_1910 := batcalc.<=(X_1838,X_1861); |
  1326. | X_1870:bat[:oid,:str] := algebra.leftfetchjoin(X_2488,X_280); |
  1327. | X_1878 := algebra.leftfetchjoin(X_1846,X_281); |
  1328. | X_1893 := batcalc.>=(X_1870,X_1878); |
  1329. | X_1902 := algebra.subselect(X_1893,true,true,true,true,false); |
  1330. | X_1918 := algebra.subselect(X_1910,X_1902,true,true,true,true,false); |
  1331. | X_1934:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1918,X_1846,X_284); |
  1332. | X_1942 := algebra.leftfetchjoin(X_1918,X_1829); |
  1333. | X_2496 := algebra.leftfetchjoin(X_1942,X_1572); |
  1334. | X_1958:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1518,X_1446,X_286); |
  1335. | X_1974:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1125,X_112); |
  1336. | X_1998:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1124,X_1078,X_289); |
  1337. | X_2014:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1124,X_1078,X_291); |
  1338. | (X_2035,X_2036,X_2037) := group.subgroup(X_2014); |
  1339. | (X_2059,X_2060,X_2061) := group.subgroup(X_1998,X_2035); |
  1340. | (X_2083,X_2084,X_2085) := group.subgroup(X_1974,X_2059); |
  1341. | X_2095 := algebra.leftfetchjoin(X_2084,X_2059); |
  1342. | (X_2115,X_2116,X_2117) := group.subgroup(X_1958,X_2083); |
  1343. | X_2127 := algebra.leftfetchjoin(X_2116,X_2083); |
  1344. | (X_2153,X_2154,X_2155) := group.subgroupdone(X_1934,X_2115); |
  1345. | X_2156 := algebra.leftfetchjoin(X_2154,X_1934); |
  1346. | X_2173 := algebra.leftfetchjoin(X_2154,X_2115); |
  1347. | X_2218 := sql.projectdelta(X_1047,X_519,X_535,X_536); |
  1348. | X_2236:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1124,X_1077,X_2218); |
  1349. | X_2244 := batcalc.==(X_2236,A0); |
  1350. | X_2258 := sql.projectdelta(X_1047,X_487,X_502,X_503); |
  1351. | X_2276:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1124,X_1077,X_2258); |
  1352. | X_2284 := batcalc.==(X_2276,A1); |
  1353. | X_2298 := batcalc.and(X_2244,X_2284); |
  1354. | X_2308 := batcalc.isnil(X_2298); |
  1355. | X_2324 := batcalc.ifthenelse(X_2308,false,X_2298); |
  1356. | X_717:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,6,8); |
  1357. | (X_733:bat[:oid,:oid] ,X_734:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,6,8); |
  1358. | X_2338 := sql.projectdelta(X_1047,X_717,X_733,X_734); |
  1359. | X_2356:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2496,X_1526,X_1171,X_1124,X_1077,X_2338); |
  1360. | X_2364 := batcalc.ifthenelse(X_2324,X_2356,X_317); |
  1361. | X_2373 := aggr.subsum(X_2364,X_2153,X_2154,true,true); |
  1362. | X_2388 := batcalc.==(X_2236,A3); |
  1363. | X_2398 := batcalc.==(X_2276,A4); |
  1364. | X_2406 := batcalc.and(X_2388,X_2398); |
  1365. | X_2414 := batcalc.isnil(X_2406); |
  1366. | X_2430 := batcalc.ifthenelse(X_2414,false,X_2406); |
  1367. | X_2444 := batcalc.ifthenelse(X_2430,X_2356,X_323); |
  1368. | X_2455 := aggr.subsum(X_2444,X_2153,X_2154,true,true); |
  1369. | X_2174:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2173,X_2116,X_1958); |
  1370. | X_2504 := algebra.leftfetchjoin(X_2173,X_2127); |
  1371. | X_2183:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2504,X_2084,X_1974); |
  1372. | X_2191:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2504,X_2095,X_2060,X_1998); |
  1373. | X_2199:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2504,X_2095,X_2060,X_2035,X_2036,X_2014); |
  1374. | X_488:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",0,7,8); |
  1375. | X_521:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",0,7,8); |
  1376. | X_554:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",0,7,8); |
  1377. | X_480:bat[:oid,:oid] := sql.tid(X_30,"axabas","dwhinv",7,8); |
  1378. | X_759 := algebra.subselect(X_554,X_480,A7,A7,true,true,false); |
  1379. | (X_570:bat[:oid,:oid] ,X_571:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",2,7,8); |
  1380. | X_768 := algebra.subselect(X_571,A7,A7,true,true,false); |
  1381. | X_41 := sql.bind(X_30,"axabas","dwhinv","dwhinv___rforefide",1); |
  1382. | X_404 := algebra.subselect(X_41,X_480,A7,A7,true,true,false); |
  1383. | X_776 := sql.subdelta(X_759,X_480,X_570,X_768,X_404); |
  1384. | X_791 := algebra.subselect(X_521,X_776,A8,A8,true,true,false); |
  1385. | (X_537:bat[:oid,:oid] ,X_538:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",2,7,8); |
  1386. | X_799 := algebra.subselect(X_538,A8,A8,true,true,false); |
  1387. | X_39 := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfodomide",1); |
  1388. | X_405 := algebra.subselect(X_39,X_776,A8,A8,true,true,false); |
  1389. | X_808 := sql.subdelta(X_791,X_776,X_537,X_799,X_405); |
  1390. | X_816 := algebra.subselect(X_488,X_808,A9,A9,true,true,false); |
  1391. | (X_504:bat[:oid,:oid] ,X_505:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",2,7,8); |
  1392. | X_831 := algebra.subselect(X_505,A9,A9,true,true,false); |
  1393. | X_36 := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfoindide",1); |
  1394. | X_406 := algebra.subselect(X_36,X_808,A9,A9,true,true,false); |
  1395. | X_839 := sql.subdelta(X_816,X_808,X_504,X_831,X_406); |
  1396. | X_848 := algebra.subselect(X_521,X_776,A10,A10,true,true,false); |
  1397. | X_856 := algebra.subselect(X_538,A10,A10,true,true,false); |
  1398. | X_407 := algebra.subselect(X_39,X_776,A10,A10,true,true,false); |
  1399. | X_871 := sql.subdelta(X_848,X_776,X_537,X_856,X_407); |
  1400. | X_879 := algebra.subselect(X_488,X_871,A11,A11,true,true,false); |
  1401. | X_888 := algebra.subselect(X_505,A11,A11,true,true,false); |
  1402. | X_408 := algebra.subselect(X_36,X_871,A11,A11,true,true,false); |
  1403. | X_896 := sql.subdelta(X_879,X_871,X_504,X_888,X_408); |
  1404. | X_911 := bat.mergecand(X_839,X_896); |
  1405. | X_919 := algebra.subselect(X_521,X_911,A8,A8,true,true,false); |
  1406. | X_928 := algebra.subselect(X_538,A8,A8,true,true,false); |
  1407. | X_409 := algebra.subselect(X_39,X_911,A8,A8,true,true,false); |
  1408. | X_936 := sql.subdelta(X_919,X_911,X_537,X_928,X_409); |
  1409. | X_951 := algebra.subselect(X_521,X_911,A10,A10,true,true,false); |
  1410. | X_959 := algebra.subselect(X_538,A10,A10,true,true,false); |
  1411. | X_410 := algebra.subselect(X_39,X_911,A10,A10,true,true,false); |
  1412. | X_968 := sql.subdelta(X_951,X_911,X_537,X_959,X_410); |
  1413. | X_976 := bat.mergecand(X_936,X_968); |
  1414. | X_991 := algebra.subselect(X_488,X_976,A9,A9,true,true,false); |
  1415. | X_999 := algebra.subselect(X_505,A9,A9,true,true,false); |
  1416. | X_411 := algebra.subselect(X_36,X_976,A9,A9,true,true,false); |
  1417. | X_1008 := sql.subdelta(X_991,X_976,X_504,X_999,X_411); |
  1418. | X_1016 := algebra.subselect(X_488,X_976,A11,A11,true,true,false); |
  1419. | X_1031 := algebra.subselect(X_505,A11,A11,true,true,false); |
  1420. | X_412 := algebra.subselect(X_36,X_976,A11,A11,true,true,false); |
  1421. | X_1039 := sql.subdelta(X_1016,X_976,X_504,X_1031,X_412); |
  1422. | X_1048 := bat.mergecand(X_1008,X_1039); |
  1423. | X_587:bat[:oid,:timestamp] := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",0,7,8); |
  1424. | (X_603:bat[:oid,:oid] ,X_604:bat[:oid,:timestamp] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",2,7,8); |
  1425. | X_49 := sql.bind(X_30,"axabas","dwhinv","dwhinvdtd",1); |
  1426. | X_1063 := sql.projectdelta(X_1048,X_587,X_603,X_604,X_49); |
  1427. | (X_1079,X_1080) := algebra.join(X_1063,X_87); |
  1428. | X_620:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",0,7,8); |
  1429. | (X_636:bat[:oid,:oid] ,X_637:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",2,7,8); |
  1430. | X_93 := sql.bind(X_30,"axabas","dwhinv","dwhinv___rfovsnide",1); |
  1431. | X_1096 := sql.projectdelta(X_1048,X_620,X_636,X_637,X_93); |
  1432. | X_1111 := algebra.leftfetchjoin(X_1079,X_1096); |
  1433. | (X_1126,X_1127) := algebra.join(X_1111,X_112); |
  1434. | X_2465 := algebra.leftfetchjoin(X_1126,X_1079); |
  1435. | X_653:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",0,7,8); |
  1436. | (X_669:bat[:oid,:oid] ,X_670:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",2,7,8); |
  1437. | X_117 := sql.bind(X_30,"axabas","dwhinv","dwhinv_d2rfodstide",1); |
  1438. | X_1143 := sql.projectdelta(X_1048,X_653,X_669,X_670,X_117); |
  1439. | X_1152:bat[:oid,:str] := algebra.leftfetchjoin(X_2465,X_1143); |
  1440. | (X_1174,X_1175) := algebra.join(X_1152,X_127); |
  1441. | X_1183 := algebra.leftfetchjoin(X_1175,X_136); |
  1442. | X_1192 := batcalc.hash(X_1183); |
  1443. | X_1207 := algebra.leftfetchjoin(X_1175,X_145); |
  1444. | X_1215 := mkey.bulk_rotate_xor_hash(X_1192,16,X_1207); |
  1445. | X_1223 := algebra.leftfetchjoin(X_1175,X_154); |
  1446. | X_1232 := mkey.bulk_rotate_xor_hash(X_1215,16,X_1223); |
  1447. | (X_1254,X_1255) := algebra.join(X_1232,X_171); |
  1448. | X_1263 := algebra.leftfetchjoin(X_1254,X_1183); |
  1449. | X_1272 := algebra.leftfetchjoin(X_1255,X_165); |
  1450. | X_1287 := batcalc.==(X_1263,X_1272); |
  1451. | X_1295 := algebra.subselect(X_1287,true,true,true,true,false); |
  1452. | X_1303 := algebra.leftfetchjoin(X_1295,X_1254); |
  1453. | X_1312 := algebra.leftfetchjoin(X_1303,X_1207); |
  1454. | X_1327 := algebra.leftfetchjoin(X_1295,X_1255); |
  1455. | X_1335 := algebra.leftfetchjoin(X_1327,X_168); |
  1456. | X_1343 := batcalc.==(X_1312,X_1335); |
  1457. | X_1352 := algebra.subselect(X_1343,true,true,true,true,false); |
  1458. | X_1367 := algebra.leftfetchjoin(X_1352,X_1303); |
  1459. | X_1375 := algebra.leftfetchjoin(X_1367,X_1223); |
  1460. | X_1383 := algebra.leftfetchjoin(X_1352,X_1327); |
  1461. | X_1392 := algebra.leftfetchjoin(X_1383,X_170); |
  1462. | X_1407 := batcalc.==(X_1375,X_1392); |
  1463. | X_1415 := algebra.subselect(X_1407,true,true,true,true,false); |
  1464. | X_1423 := algebra.leftfetchjoin(X_1415,X_1367); |
  1465. | X_2473 := algebra.leftfetchjoin(X_1423,X_1175); |
  1466. | X_1439:bat[:oid,:str] := algebra.leftfetchjoin(X_2473,X_184); |
  1467. | X_1447 := algebra.leftfetchjoin(X_1415,X_1383); |
  1468. | X_1455 := algebra.leftfetchjoin(X_1447,X_185); |
  1469. | X_1511 := batcalc.<=(X_1439,X_1455); |
  1470. | X_1471:bat[:oid,:str] := algebra.leftfetchjoin(X_2473,X_196); |
  1471. | X_1479 := algebra.leftfetchjoin(X_1447,X_197); |
  1472. | X_1487 := batcalc.>=(X_1471,X_1479); |
  1473. | X_1496 := algebra.subselect(X_1487,true,true,true,true,false); |
  1474. | X_1519 := algebra.subselect(X_1511,X_1496,true,true,true,true,false); |
  1475. | X_1527 := algebra.leftfetchjoin(X_1519,X_1423); |
  1476. | X_2481 := algebra.leftfetchjoin(X_1527,X_1174); |
  1477. | X_686:bat[:oid,:str] := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",0,7,8); |
  1478. | (X_702:bat[:oid,:oid] ,X_703:bat[:oid,:str] ) := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",2,7,8); |
  1479. | X_205 := sql.bind(X_30,"axabas","dwhinv","dwhinv___rsaedtide",1); |
  1480. | X_1543 := sql.projectdelta(X_1048,X_686,X_702,X_703,X_205); |
  1481. | X_1559:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2481,X_1126,X_1079,X_1543); |
  1482. | (X_1574,X_1575) := algebra.join(X_1559,X_215); |
  1483. | X_1591 := algebra.leftfetchjoin(X_1575,X_224); |
  1484. | X_1599 := batcalc.hash(X_1591); |
  1485. | X_1607 := algebra.leftfetchjoin(X_1575,X_233); |
  1486. | X_1615 := mkey.bulk_rotate_xor_hash(X_1599,16,X_1607); |
  1487. | X_1631 := algebra.leftfetchjoin(X_1575,X_242); |
  1488. | X_1639 := mkey.bulk_rotate_xor_hash(X_1615,16,X_1631); |
  1489. | (X_1654,X_1655) := algebra.join(X_1639,X_255); |
  1490. | X_1671 := algebra.leftfetchjoin(X_1654,X_1591); |
  1491. | X_1679 := algebra.leftfetchjoin(X_1655,X_249); |
  1492. | X_1687 := batcalc.==(X_1671,X_1679); |
  1493. | X_1695 := algebra.subselect(X_1687,true,true,true,true,false); |
  1494. | X_1711 := algebra.leftfetchjoin(X_1695,X_1654); |
  1495. | X_1719 := algebra.leftfetchjoin(X_1711,X_1607); |
  1496. | X_1727 := algebra.leftfetchjoin(X_1695,X_1655); |
  1497. | X_1735 := algebra.leftfetchjoin(X_1727,X_252); |
  1498. | X_1751 := batcalc.==(X_1719,X_1735); |
  1499. | X_1759 := algebra.subselect(X_1751,true,true,true,true,false); |
  1500. | X_1767 := algebra.leftfetchjoin(X_1759,X_1711); |
  1501. | X_1775 := algebra.leftfetchjoin(X_1767,X_1631); |
  1502. | X_1791 := algebra.leftfetchjoin(X_1759,X_1727); |
  1503. | X_1799 := algebra.leftfetchjoin(X_1791,X_254); |
  1504. | X_1807 := batcalc.==(X_1775,X_1799); |
  1505. | X_1815 := algebra.subselect(X_1807,true,true,true,true,false); |
  1506. | X_1831 := algebra.leftfetchjoin(X_1815,X_1767); |
  1507. | X_2489 := algebra.leftfetchjoin(X_1831,X_1575); |
  1508. | X_1839:bat[:oid,:str] := algebra.leftfetchjoin(X_2489,X_268); |
  1509. | X_1847 := algebra.leftfetchjoin(X_1815,X_1791); |
  1510. | X_1863 := algebra.leftfetchjoin(X_1847,X_269); |
  1511. | X_1911 := batcalc.<=(X_1839,X_1863); |
  1512. | X_1871:bat[:oid,:str] := algebra.leftfetchjoin(X_2489,X_280); |
  1513. | X_1879 := algebra.leftfetchjoin(X_1847,X_281); |
  1514. | X_1895 := batcalc.>=(X_1871,X_1879); |
  1515. | X_1903 := algebra.subselect(X_1895,true,true,true,true,false); |
  1516. | X_1919 := algebra.subselect(X_1911,X_1903,true,true,true,true,false); |
  1517. | X_1935:bat[:oid,:str] := algebra.leftfetchjoinPath(X_1919,X_1847,X_284); |
  1518. | X_1943 := algebra.leftfetchjoin(X_1919,X_1831); |
  1519. | X_2497 := algebra.leftfetchjoin(X_1943,X_1574); |
  1520. | X_1959:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1519,X_1447,X_286); |
  1521. | X_1975:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1127,X_112); |
  1522. | X_1999:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1126,X_1080,X_289); |
  1523. | X_2015:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1126,X_1080,X_291); |
  1524. | (X_2038,X_2039,X_2040) := group.subgroup(X_2015); |
  1525. | (X_2062,X_2063,X_2064) := group.subgroup(X_1999,X_2038); |
  1526. | (X_2086,X_2087,X_2088) := group.subgroup(X_1975,X_2062); |
  1527. | X_2096 := algebra.leftfetchjoin(X_2087,X_2062); |
  1528. | (X_2118,X_2119,X_2120) := group.subgroup(X_1959,X_2086); |
  1529. | X_2128 := algebra.leftfetchjoin(X_2119,X_2086); |
  1530. | (X_2157,X_2158,X_2159) := group.subgroupdone(X_1935,X_2118); |
  1531. | X_2160 := algebra.leftfetchjoin(X_2158,X_1935); |
  1532. | X_2175 := algebra.leftfetchjoin(X_2158,X_2118); |
  1533. | X_2220 := sql.projectdelta(X_1048,X_521,X_537,X_538,X_39); |
  1534. | X_2237:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1126,X_1079,X_2220); |
  1535. | X_2245 := batcalc.==(X_2237,A0); |
  1536. | X_2260 := sql.projectdelta(X_1048,X_488,X_504,X_505,X_36); |
  1537. | X_2277:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1126,X_1079,X_2260); |
  1538. | X_2285 := batcalc.==(X_2277,A1); |
  1539. | X_2300 := batcalc.and(X_2245,X_2285); |
  1540. | X_2309 := batcalc.isnil(X_2300); |
  1541. | X_2325 := batcalc.ifthenelse(X_2309,false,X_2300); |
  1542. | X_719:bat[:oid,:lng] := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",0,7,8); |
  1543. | (X_735:bat[:oid,:oid] ,X_736:bat[:oid,:lng] ) := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",2,7,8); |
  1544. | X_315 := sql.bind(X_30,"axabas","dwhinv","dwhinvqte",1); |
  1545. | X_2340 := sql.projectdelta(X_1048,X_719,X_735,X_736,X_315); |
  1546. | X_2357:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_2497,X_1527,X_1174,X_1126,X_1079,X_2340); |
  1547. | X_2365 := batcalc.ifthenelse(X_2325,X_2357,X_317); |
  1548. | X_2374 := aggr.subsum(X_2365,X_2157,X_2158,true,true); |
  1549. | X_2390 := batcalc.==(X_2237,A3); |
  1550. | X_2399 := batcalc.==(X_2277,A4); |
  1551. | X_2407 := batcalc.and(X_2390,X_2399); |
  1552. | X_2415 := batcalc.isnil(X_2407); |
  1553. | X_2431 := batcalc.ifthenelse(X_2415,false,X_2407); |
  1554. | X_2446 := batcalc.ifthenelse(X_2431,X_2357,X_323); |
  1555. | X_2456 := aggr.subsum(X_2446,X_2157,X_2158,true,true); |
  1556. | X_2176:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2175,X_2119,X_1959); |
  1557. | X_2505 := algebra.leftfetchjoin(X_2175,X_2128); |
  1558. | X_2184:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2505,X_2087,X_1975); |
  1559. | X_2192:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2505,X_2096,X_2063,X_1999); |
  1560. | X_2200:bat[:oid,:str] := algebra.leftfetchjoinPath(X_2505,X_2096,X_2063,X_2038,X_2039,X_2015); |
  1561. | X_2506 := mat.packIncrement(X_2132,8); |
  1562. | X_2508 := mat.packIncrement(X_2506,X_2136); |
  1563. | X_2509 := mat.packIncrement(X_2508,X_2140); |
  1564. | X_2510 := mat.packIncrement(X_2509,X_2144); |
  1565. | X_2511 := mat.packIncrement(X_2510,X_2148); |
  1566. | X_2512 := mat.packIncrement(X_2511,X_2152); |
  1567. | X_2513 := mat.packIncrement(X_2512,X_2156); |
  1568. | X_285 := mat.packIncrement(X_2513,X_2160); |
  1569. | X_2515 := mat.packIncrement(X_2162,8); |
  1570. | X_2516 := mat.packIncrement(X_2515,X_2164); |
  1571. | X_2517 := mat.packIncrement(X_2516,X_2166); |
  1572. | X_2518 := mat.packIncrement(X_2517,X_2168); |
  1573. | X_2519 := mat.packIncrement(X_2518,X_2170); |
  1574. | X_2520 := mat.packIncrement(X_2519,X_2172); |
  1575. | X_2521 := mat.packIncrement(X_2520,X_2174); |
  1576. | X_287 := mat.packIncrement(X_2521,X_2176); |
  1577. | X_2523 := mat.packIncrement(X_2177,8); |
  1578. | X_2524 := mat.packIncrement(X_2523,X_2178); |
  1579. | X_2525 := mat.packIncrement(X_2524,X_2179); |
  1580. | X_2526 := mat.packIncrement(X_2525,X_2180); |
  1581. | X_2527 := mat.packIncrement(X_2526,X_2181); |
  1582. | X_2528 := mat.packIncrement(X_2527,X_2182); |
  1583. | X_2529 := mat.packIncrement(X_2528,X_2183); |
  1584. | X_288 := mat.packIncrement(X_2529,X_2184); |
  1585. | X_2531 := mat.packIncrement(X_2185,8); |
  1586. | X_2532 := mat.packIncrement(X_2531,X_2186); |
  1587. | X_2533 := mat.packIncrement(X_2532,X_2187); |
  1588. | X_2534 := mat.packIncrement(X_2533,X_2188); |
  1589. | X_2535 := mat.packIncrement(X_2534,X_2189); |
  1590. | X_2536 := mat.packIncrement(X_2535,X_2190); |
  1591. | X_2537 := mat.packIncrement(X_2536,X_2191); |
  1592. | X_290 := mat.packIncrement(X_2537,X_2192); |
  1593. | X_2539 := mat.packIncrement(X_2193,8); |
  1594. | X_2541 := mat.packIncrement(X_2539,X_2194); |
  1595. | X_2542 := mat.packIncrement(X_2541,X_2195); |
  1596. | X_2543 := mat.packIncrement(X_2542,X_2196); |
  1597. | X_2544 := mat.packIncrement(X_2543,X_2197); |
  1598. | X_2545 := mat.packIncrement(X_2544,X_2198); |
  1599. | X_2546 := mat.packIncrement(X_2545,X_2199); |
  1600. | X_292 := mat.packIncrement(X_2546,X_2200); |
  1601. | (X_293,r1_832,X_2201) := group.subgroup(X_292); |
  1602. | (X_295,r1_835,X_2202) := group.subgroup(X_290,X_293); |
  1603. | (X_297,r1_838,X_2203) := group.subgroup(X_288,X_295); |
  1604. | (X_299,r1_841,X_2204) := group.subgroup(X_287,X_297); |
  1605. | (X_301,r1_844,X_2205) := group.subgroupdone(X_285,X_299); |
  1606. | X_303 := algebra.leftfetchjoin(r1_844,X_292); |
  1607. | X_304 := algebra.leftfetchjoin(r1_844,X_290); |
  1608. | X_305 := algebra.leftfetchjoin(r1_844,X_288); |
  1609. | X_306 := algebra.leftfetchjoin(r1_844,X_287); |
  1610. | X_307 := algebra.leftfetchjoin(r1_844,X_285); |
  1611. | X_2548 := mat.packIncrement(X_2367,8); |
  1612. | X_2549 := mat.packIncrement(X_2548,X_2368); |
  1613. | X_2550 := mat.packIncrement(X_2549,X_2369); |
  1614. | X_2551 := mat.packIncrement(X_2550,X_2370); |
  1615. | X_2552 := mat.packIncrement(X_2551,X_2371); |
  1616. | X_2553 := mat.packIncrement(X_2552,X_2372); |
  1617. | X_2554 := mat.packIncrement(X_2553,X_2373); |
  1618. | X_2366 := mat.packIncrement(X_2554,X_2374); |
  1619. | X_320:bat[:oid,:lng] := aggr.subsum(X_2366,X_301,r1_844,true,true); |
  1620. | X_2556 := mat.packIncrement(X_2449,8); |
  1621. | X_2557 := mat.packIncrement(X_2556,X_2450); |
  1622. | X_2558 := mat.packIncrement(X_2557,X_2451); |
  1623. | X_2559 := mat.packIncrement(X_2558,X_2452); |
  1624. | X_2560 := mat.packIncrement(X_2559,X_2453); |
  1625. | X_2561 := mat.packIncrement(X_2560,X_2454); |
  1626. | X_2562 := mat.packIncrement(X_2561,X_2455); |
  1627. | X_2448 := mat.packIncrement(X_2562,X_2456); |
  1628. | X_324:bat[:oid,:lng] := aggr.subsum(X_2448,X_301,r1_844,true,true); |
  1629. | language.pass(X_466); |
  1630. | language.pass(X_801); |
  1631. | language.pass(X_769); |
  1632. | language.pass(X_857); |
  1633. | language.pass(X_897); |
  1634. | language.pass(X_969); |
  1635. | language.pass(X_51); |
  1636. | language.pass(X_72); |
  1637. | language.pass(X_77); |
  1638. | language.pass(X_95); |
  1639. | language.pass(X_108); |
  1640. | language.pass(X_97); |
  1641. | language.pass(X_99); |
  1642. | language.pass(r1_187); |
  1643. | language.pass(X_101); |
  1644. | language.pass(X_155); |
  1645. | language.pass(X_158); |
  1646. | language.pass(X_159); |
  1647. | language.pass(X_128); |
  1648. | language.pass(X_131); |
  1649. | language.pass(r1_251); |
  1650. | language.pass(X_134); |
  1651. | language.pass(X_138); |
  1652. | language.pass(X_142); |
  1653. | language.pass(r1_272); |
  1654. | language.pass(X_144); |
  1655. | language.pass(X_146); |
  1656. | language.pass(X_149); |
  1657. | language.pass(r1_287); |
  1658. | language.pass(X_152); |
  1659. | language.pass(X_1176); |
  1660. | language.pass(X_1233); |
  1661. | language.pass(X_1193); |
  1662. | language.pass(X_1288); |
  1663. | language.pass(X_1234); |
  1664. | language.pass(X_1296); |
  1665. | language.pass(X_1216); |
  1666. | language.pass(X_1345); |
  1667. | language.pass(X_1313); |
  1668. | language.pass(X_1353); |
  1669. | language.pass(X_1154); |
  1670. | language.pass(X_1408); |
  1671. | language.pass(X_1376); |
  1672. | language.pass(X_174); |
  1673. | language.pass(X_179); |
  1674. | language.pass(r1_402); |
  1675. | language.pass(X_182); |
  1676. | language.pass(X_119); |
  1677. | language.pass(X_2466); |
  1678. | language.pass(X_186); |
  1679. | language.pass(X_191); |
  1680. | language.pass(r1_437); |
  1681. | language.pass(X_194); |
  1682. | language.pass(X_1416); |
  1683. | language.pass(X_243); |
  1684. | language.pass(X_246); |
  1685. | language.pass(X_247); |
  1686. | language.pass(X_216); |
  1687. | language.pass(X_219); |
  1688. | language.pass(r1_521); |
  1689. | language.pass(X_222); |
  1690. | language.pass(X_226); |
  1691. | language.pass(X_229); |
  1692. | language.pass(r1_541); |
  1693. | language.pass(X_232); |
  1694. | language.pass(X_234); |
  1695. | language.pass(X_237); |
  1696. | language.pass(r1_557); |
  1697. | language.pass(X_240); |
  1698. | language.pass(X_1577); |
  1699. | language.pass(X_1640); |
  1700. | language.pass(X_1600); |
  1701. | language.pass(X_1688); |
  1702. | language.pass(X_1641); |
  1703. | language.pass(X_1697); |
  1704. | language.pass(X_1617); |
  1705. | language.pass(X_1752); |
  1706. | language.pass(X_1720); |
  1707. | language.pass(X_1760); |
  1708. | language.pass(X_1561); |
  1709. | language.pass(X_1808); |
  1710. | language.pass(X_1777); |
  1711. | language.pass(X_258); |
  1712. | language.pass(X_263); |
  1713. | language.pass(r1_666); |
  1714. | language.pass(X_266); |
  1715. | language.pass(X_207); |
  1716. | language.pass(X_2482); |
  1717. | language.pass(X_270); |
  1718. | language.pass(X_275); |
  1719. | language.pass(r1_701); |
  1720. | language.pass(X_278); |
  1721. | language.pass(X_248); |
  1722. | language.pass(X_209); |
  1723. | language.pass(X_211); |
  1724. | language.pass(r1_507); |
  1725. | language.pass(X_213); |
  1726. | language.pass(X_1840); |
  1727. | language.pass(X_1912); |
  1728. | language.pass(X_1817); |
  1729. | language.pass(X_164); |
  1730. | language.pass(X_122); |
  1731. | language.pass(X_124); |
  1732. | language.pass(r1_238); |
  1733. | language.pass(X_126); |
  1734. | language.pass(X_1512); |
  1735. | language.pass(X_1440); |
  1736. | language.pass(X_53); |
  1737. | language.pass(X_55); |
  1738. | language.pass(r1_107); |
  1739. | language.pass(X_57); |
  1740. | language.pass(X_80); |
  1741. | language.pass(X_58); |
  1742. | language.pass(X_60); |
  1743. | language.pass(r1_118); |
  1744. | language.pass(X_62); |
  1745. | language.pass(X_1066); |
  1746. | language.pass(X_2041); |
  1747. | language.pass(X_2065); |
  1748. | language.pass(X_1928); |
  1749. | language.pass(X_2097); |
  1750. | language.pass(X_507); |
  1751. | language.pass(X_522); |
  1752. | language.pass(X_523); |
  1753. | language.pass(X_481); |
  1754. | language.pass(X_489); |
  1755. | language.pass(X_490); |
  1756. | language.pass(X_2286); |
  1757. | language.pass(X_1041); |
  1758. | language.pass(X_2490); |
  1759. | language.pass(X_1520); |
  1760. | language.pass(X_1153); |
  1761. | language.pass(X_1112); |
  1762. | language.pass(X_1065); |
  1763. | language.pass(X_2230); |
  1764. | language.pass(X_2270); |
  1765. | language.pass(X_2400); |
  1766. | language.pass(X_2350); |
  1767. | language.pass(X_2129); |
  1768. | language.pass(X_2130); |
  1769. | language.pass(X_2098); |
  1770. | language.pass(X_1952); |
  1771. | language.pass(X_2161); |
  1772. | language.pass(X_2066); |
  1773. | language.pass(X_1968); |
  1774. | language.pass(X_1992); |
  1775. | language.pass(X_2498); |
  1776. | language.pass(X_2089); |
  1777. | language.pass(X_2042); |
  1778. | language.pass(X_2017); |
  1779. | language.pass(X_2008); |
  1780. | language.pass(X_468); |
  1781. | language.pass(X_802); |
  1782. | language.pass(X_770); |
  1783. | language.pass(X_859); |
  1784. | language.pass(X_899); |
  1785. | language.pass(X_970); |
  1786. | language.pass(X_1177); |
  1787. | language.pass(X_1236); |
  1788. | language.pass(X_1195); |
  1789. | language.pass(X_1289); |
  1790. | language.pass(X_1237); |
  1791. | language.pass(X_1297); |
  1792. | language.pass(X_1217); |
  1793. | language.pass(X_1346); |
  1794. | language.pass(X_1315); |
  1795. | language.pass(X_1355); |
  1796. | language.pass(X_1157); |
  1797. | language.pass(X_1409); |
  1798. | language.pass(X_1377); |
  1799. | language.pass(X_2467); |
  1800. | language.pass(X_1417); |
  1801. | language.pass(X_1579); |
  1802. | language.pass(X_1642); |
  1803. | language.pass(X_1601); |
  1804. | language.pass(X_1689); |
  1805. | language.pass(X_1643); |
  1806. | language.pass(X_1699); |
  1807. | language.pass(X_1619); |
  1808. | language.pass(X_1753); |
  1809. | language.pass(X_1721); |
  1810. | language.pass(X_1761); |
  1811. | language.pass(X_1563); |
  1812. | language.pass(X_1809); |
  1813. | language.pass(X_1779); |
  1814. | language.pass(X_2483); |
  1815. | language.pass(X_1841); |
  1816. | language.pass(X_1913); |
  1817. | language.pass(X_1819); |
  1818. | language.pass(X_1513); |
  1819. | language.pass(X_1441); |
  1820. | language.pass(X_1068); |
  1821. | language.pass(X_2044); |
  1822. | language.pass(X_2068); |
  1823. | language.pass(X_1929); |
  1824. | language.pass(X_2100); |
  1825. | language.pass(X_509); |
  1826. | language.pass(X_524); |
  1827. | language.pass(X_525); |
  1828. | language.pass(X_482); |
  1829. | language.pass(X_491); |
  1830. | language.pass(X_492); |
  1831. | language.pass(X_2288); |
  1832. | language.pass(X_1042); |
  1833. | language.pass(X_2491); |
  1834. | language.pass(X_1521); |
  1835. | language.pass(X_1156); |
  1836. | language.pass(X_1114); |
  1837. | language.pass(X_1067); |
  1838. | language.pass(X_2231); |
  1839. | language.pass(X_2271); |
  1840. | language.pass(X_2401); |
  1841. | language.pass(X_2351); |
  1842. | language.pass(X_2133); |
  1843. | language.pass(X_2134); |
  1844. | language.pass(X_2101); |
  1845. | language.pass(X_1953); |
  1846. | language.pass(X_2163); |
  1847. | language.pass(X_2069); |
  1848. | language.pass(X_1969); |
  1849. | language.pass(X_1993); |
  1850. | language.pass(X_2499); |
  1851. | language.pass(X_2090); |
  1852. | language.pass(X_2045); |
  1853. | language.pass(X_2020); |
  1854. | language.pass(X_2009); |
  1855. | language.pass(X_470); |
  1856. | language.pass(X_803); |
  1857. | language.pass(X_771); |
  1858. | language.pass(X_861); |
  1859. | language.pass(X_901); |
  1860. | language.pass(X_971); |
  1861. | language.pass(X_1178); |
  1862. | language.pass(X_1239); |
  1863. | language.pass(X_1197); |
  1864. | language.pass(X_1290); |
  1865. | language.pass(X_1240); |
  1866. | language.pass(X_1298); |
  1867. | language.pass(X_1218); |
  1868. | language.pass(X_1347); |
  1869. | language.pass(X_1317); |
  1870. | language.pass(X_1357); |
  1871. | language.pass(X_1160); |
  1872. | language.pass(X_1410); |
  1873. | language.pass(X_1378); |
  1874. | language.pass(X_2468); |
  1875. | language.pass(X_1418); |
  1876. | language.pass(X_1581); |
  1877. | language.pass(X_1644); |
  1878. | language.pass(X_1602); |
  1879. | language.pass(X_1690); |
  1880. | language.pass(X_1645); |
  1881. | language.pass(X_1701); |
  1882. | language.pass(X_1621); |
  1883. | language.pass(X_1754); |
  1884. | language.pass(X_1722); |
  1885. | language.pass(X_1762); |
  1886. | language.pass(X_1565); |
  1887. | language.pass(X_1810); |
  1888. | language.pass(X_1781); |
  1889. | language.pass(X_2484); |
  1890. | language.pass(X_1842); |
  1891. | language.pass(X_1914); |
  1892. | language.pass(X_1821); |
  1893. | language.pass(X_1514); |
  1894. | language.pass(X_1442); |
  1895. | language.pass(X_1070); |
  1896. | language.pass(X_2047); |
  1897. | language.pass(X_2071); |
  1898. | language.pass(X_1930); |
  1899. | language.pass(X_2103); |
  1900. | language.pass(X_511); |
  1901. | language.pass(X_526); |
  1902. | language.pass(X_527); |
  1903. | language.pass(X_483); |
  1904. | language.pass(X_493); |
  1905. | language.pass(X_494); |
  1906. | language.pass(X_2290); |
  1907. | language.pass(X_1043); |
  1908. | language.pass(X_2492); |
  1909. | language.pass(X_1522); |
  1910. | language.pass(X_1159); |
  1911. | language.pass(X_1116); |
  1912. | language.pass(X_1069); |
  1913. | language.pass(X_2232); |
  1914. | language.pass(X_2272); |
  1915. | language.pass(X_2402); |
  1916. | language.pass(X_2352); |
  1917. | language.pass(X_2137); |
  1918. | language.pass(X_2138); |
  1919. | language.pass(X_2104); |
  1920. | language.pass(X_1954); |
  1921. | language.pass(X_2165); |
  1922. | language.pass(X_2072); |
  1923. | language.pass(X_1970); |
  1924. | language.pass(X_1994); |
  1925. | language.pass(X_2500); |
  1926. | language.pass(X_2091); |
  1927. | language.pass(X_2048); |
  1928. | language.pass(X_2023); |
  1929. | language.pass(X_2010); |
  1930. | language.pass(X_472); |
  1931. | language.pass(X_804); |
  1932. | language.pass(X_772); |
  1933. | language.pass(X_863); |
  1934. | language.pass(X_903); |
  1935. | language.pass(X_972); |
  1936. | language.pass(X_1179); |
  1937. | language.pass(X_1242); |
  1938. | language.pass(X_1199); |
  1939. | language.pass(X_1291); |
  1940. | language.pass(X_1243); |
  1941. | language.pass(X_1299); |
  1942. | language.pass(X_1219); |
  1943. | language.pass(X_1348); |
  1944. | language.pass(X_1319); |
  1945. | language.pass(X_1359); |
  1946. | language.pass(X_1163); |
  1947. | language.pass(X_1411); |
  1948. | language.pass(X_1379); |
  1949. | language.pass(X_2469); |
  1950. | language.pass(X_1419); |
  1951. | language.pass(X_1583); |
  1952. | language.pass(X_1646); |
  1953. | language.pass(X_1603); |
  1954. | language.pass(X_1691); |
  1955. | language.pass(X_1647); |
  1956. | language.pass(X_1703); |
  1957. | language.pass(X_1623); |
  1958. | language.pass(X_1755); |
  1959. | language.pass(X_1723); |
  1960. | language.pass(X_1763); |
  1961. | language.pass(X_1567); |
  1962. | language.pass(X_1811); |
  1963. | language.pass(X_1783); |
  1964. | language.pass(X_2485); |
  1965. | language.pass(X_1843); |
  1966. | language.pass(X_1915); |
  1967. | language.pass(X_1823); |
  1968. | language.pass(X_1515); |
  1969. | language.pass(X_1443); |
  1970. | language.pass(X_1072); |
  1971. | language.pass(X_2050); |
  1972. | language.pass(X_2074); |
  1973. | language.pass(X_1931); |
  1974. | language.pass(X_2106); |
  1975. | language.pass(X_513); |
  1976. | language.pass(X_528); |
  1977. | language.pass(X_529); |
  1978. | language.pass(X_484); |
  1979. | language.pass(X_495); |
  1980. | language.pass(X_496); |
  1981. | language.pass(X_2292); |
  1982. | language.pass(X_1044); |
  1983. | language.pass(X_2493); |
  1984. | language.pass(X_1523); |
  1985. | language.pass(X_1162); |
  1986. | language.pass(X_1118); |
  1987. | language.pass(X_1071); |
  1988. | language.pass(X_2233); |
  1989. | language.pass(X_2273); |
  1990. | language.pass(X_2403); |
  1991. | language.pass(X_2353); |
  1992. | language.pass(X_2141); |
  1993. | language.pass(X_2142); |
  1994. | language.pass(X_2107); |
  1995. | language.pass(X_1955); |
  1996. | language.pass(X_2167); |
  1997. | language.pass(X_2075); |
  1998. | language.pass(X_1971); |
  1999. | language.pass(X_1995); |
  2000. | language.pass(X_2501); |
  2001. | language.pass(X_2092); |
  2002. | language.pass(X_2051); |
  2003. | language.pass(X_2026); |
  2004. | language.pass(X_2011); |
  2005. | language.pass(X_474); |
  2006. | language.pass(X_805); |
  2007. | language.pass(X_773); |
  2008. | language.pass(X_865); |
  2009. | language.pass(X_905); |
  2010. | language.pass(X_973); |
  2011. | language.pass(X_1180); |
  2012. | language.pass(X_1245); |
  2013. | language.pass(X_1201); |
  2014. | language.pass(X_1292); |
  2015. | language.pass(X_1246); |
  2016. | language.pass(X_1300); |
  2017. | language.pass(X_1220); |
  2018. | language.pass(X_1349); |
  2019. | language.pass(X_1321); |
  2020. | language.pass(X_1361); |
  2021. | language.pass(X_1166); |
  2022. | language.pass(X_1412); |
  2023. | language.pass(X_1380); |
  2024. | language.pass(X_2470); |
  2025. | language.pass(X_1420); |
  2026. | language.pass(X_1585); |
  2027. | language.pass(X_1648); |
  2028. | language.pass(X_1604); |
  2029. | language.pass(X_1692); |
  2030. | language.pass(X_1649); |
  2031. | language.pass(X_1705); |
  2032. | language.pass(X_1625); |
  2033. | language.pass(X_1756); |
  2034. | language.pass(X_1724); |
  2035. | language.pass(X_1764); |
  2036. | language.pass(X_1569); |
  2037. | language.pass(X_1812); |
  2038. | language.pass(X_1785); |
  2039. | language.pass(X_2486); |
  2040. | language.pass(X_1844); |
  2041. | language.pass(X_1916); |
  2042. | language.pass(X_1825); |
  2043. | language.pass(X_1516); |
  2044. | language.pass(X_1444); |
  2045. | language.pass(X_1074); |
  2046. | language.pass(X_2053); |
  2047. | language.pass(X_2077); |
  2048. | language.pass(X_1932); |
  2049. | language.pass(X_2109); |
  2050. | language.pass(X_515); |
  2051. | language.pass(X_530); |
  2052. | language.pass(X_531); |
  2053. | language.pass(X_485); |
  2054. | language.pass(X_497); |
  2055. | language.pass(X_498); |
  2056. | language.pass(X_2294); |
  2057. | language.pass(X_1045); |
  2058. | language.pass(X_2494); |
  2059. | language.pass(X_1524); |
  2060. | language.pass(X_1165); |
  2061. | language.pass(X_1120); |
  2062. | language.pass(X_1073); |
  2063. | language.pass(X_2234); |
  2064. | language.pass(X_2274); |
  2065. | language.pass(X_2404); |
  2066. | language.pass(X_2354); |
  2067. | language.pass(X_2145); |
  2068. | language.pass(X_2146); |
  2069. | language.pass(X_2110); |
  2070. | language.pass(X_1956); |
  2071. | language.pass(X_2169); |
  2072. | language.pass(X_2078); |
  2073. | language.pass(X_1972); |
  2074. | language.pass(X_1996); |
  2075. | language.pass(X_2502); |
  2076. | language.pass(X_2093); |
  2077. | language.pass(X_2054); |
  2078. | language.pass(X_2029); |
  2079. | language.pass(X_2012); |
  2080. | language.pass(X_476); |
  2081. | language.pass(X_806); |
  2082. | language.pass(X_774); |
  2083. | language.pass(X_867); |
  2084. | language.pass(X_907); |
  2085. | language.pass(X_974); |
  2086. | language.pass(X_1181); |
  2087. | language.pass(X_1248); |
  2088. | language.pass(X_1203); |
  2089. | language.pass(X_1293); |
  2090. | language.pass(X_1249); |
  2091. | language.pass(X_1301); |
  2092. | language.pass(X_1221); |
  2093. | language.pass(X_1350); |
  2094. | language.pass(X_1323); |
  2095. | language.pass(X_1363); |
  2096. | language.pass(X_1169); |
  2097. | language.pass(X_1413); |
  2098. | language.pass(X_1381); |
  2099. | language.pass(X_2471); |
  2100. | language.pass(X_1421); |
  2101. | language.pass(X_1587); |
  2102. | language.pass(X_1650); |
  2103. | language.pass(X_1605); |
  2104. | language.pass(X_1693); |
  2105. | language.pass(X_1651); |
  2106. | language.pass(X_1707); |
  2107. | language.pass(X_1627); |
  2108. | language.pass(X_1757); |
  2109. | language.pass(X_1725); |
  2110. | language.pass(X_1765); |
  2111. | language.pass(X_1571); |
  2112. | language.pass(X_1813); |
  2113. | language.pass(X_1787); |
  2114. | language.pass(X_2487); |
  2115. | language.pass(X_1845); |
  2116. | language.pass(X_1917); |
  2117. | language.pass(X_1827); |
  2118. | language.pass(X_1517); |
  2119. | language.pass(X_1445); |
  2120. | language.pass(X_1076); |
  2121. | language.pass(X_2056); |
  2122. | language.pass(X_2080); |
  2123. | language.pass(X_1933); |
  2124. | language.pass(X_2112); |
  2125. | language.pass(X_517); |
  2126. | language.pass(X_533); |
  2127. | language.pass(X_534); |
  2128. | language.pass(X_486); |
  2129. | language.pass(X_500); |
  2130. | language.pass(X_501); |
  2131. | language.pass(X_2296); |
  2132. | language.pass(X_1046); |
  2133. | language.pass(X_2495); |
  2134. | language.pass(X_1525); |
  2135. | language.pass(X_1168); |
  2136. | language.pass(X_1122); |
  2137. | language.pass(X_1075); |
  2138. | language.pass(X_2235); |
  2139. | language.pass(X_2275); |
  2140. | language.pass(X_2405); |
  2141. | language.pass(X_2355); |
  2142. | language.pass(X_2149); |
  2143. | language.pass(X_2150); |
  2144. | language.pass(X_2113); |
  2145. | language.pass(X_1957); |
  2146. | language.pass(X_2171); |
  2147. | language.pass(X_2081); |
  2148. | language.pass(X_1973); |
  2149. | language.pass(X_1997); |
  2150. | language.pass(X_2503); |
  2151. | language.pass(X_2094); |
  2152. | language.pass(X_2057); |
  2153. | language.pass(X_2032); |
  2154. | language.pass(X_2013); |
  2155. | language.pass(X_478); |
  2156. | language.pass(X_807); |
  2157. | language.pass(X_775); |
  2158. | language.pass(X_869); |
  2159. | language.pass(X_909); |
  2160. | language.pass(X_975); |
  2161. | language.pass(X_1182); |
  2162. | language.pass(X_1251); |
  2163. | language.pass(X_1205); |
  2164. | language.pass(X_1294); |
  2165. | language.pass(X_1252); |
  2166. | language.pass(X_1302); |
  2167. | language.pass(X_1222); |
  2168. | language.pass(X_1351); |
  2169. | language.pass(X_1325); |
  2170. | language.pass(X_1365); |
  2171. | language.pass(X_1172); |
  2172. | language.pass(X_1414); |
  2173. | language.pass(X_1382); |
  2174. | language.pass(X_2472); |
  2175. | language.pass(X_1422); |
  2176. | language.pass(X_1589); |
  2177. | language.pass(X_1652); |
  2178. | language.pass(X_1606); |
  2179. | language.pass(X_1694); |
  2180. | language.pass(X_1653); |
  2181. | language.pass(X_1709); |
  2182. | language.pass(X_1629); |
  2183. | language.pass(X_1758); |
  2184. | language.pass(X_1726); |
  2185. | language.pass(X_1766); |
  2186. | language.pass(X_1573); |
  2187. | language.pass(X_1814); |
  2188. | language.pass(X_1789); |
  2189. | language.pass(X_2488); |
  2190. | language.pass(X_1846); |
  2191. | language.pass(X_1918); |
  2192. | language.pass(X_1829); |
  2193. | language.pass(X_1518); |
  2194. | language.pass(X_1446); |
  2195. | language.pass(X_1078); |
  2196. | language.pass(X_2059); |
  2197. | language.pass(X_2083); |
  2198. | language.pass(X_1934); |
  2199. | language.pass(X_2115); |
  2200. | language.pass(X_519); |
  2201. | language.pass(X_535); |
  2202. | language.pass(X_536); |
  2203. | language.pass(X_487); |
  2204. | language.pass(X_502); |
  2205. | language.pass(X_503); |
  2206. | language.pass(X_2298); |
  2207. | language.pass(X_1047); |
  2208. | language.pass(X_2496); |
  2209. | language.pass(X_1526); |
  2210. | language.pass(X_1171); |
  2211. | language.pass(X_1124); |
  2212. | language.pass(X_1077); |
  2213. | language.pass(X_2236); |
  2214. | language.pass(X_2276); |
  2215. | language.pass(X_2406); |
  2216. | language.pass(X_2356); |
  2217. | language.pass(X_2153); |
  2218. | language.pass(X_2154); |
  2219. | language.pass(X_2116); |
  2220. | language.pass(X_1958); |
  2221. | language.pass(X_2173); |
  2222. | language.pass(X_2084); |
  2223. | language.pass(X_1974); |
  2224. | language.pass(X_1998); |
  2225. | language.pass(X_2504); |
  2226. | language.pass(X_2095); |
  2227. | language.pass(X_2060); |
  2228. | language.pass(X_2035); |
  2229. | language.pass(X_2014); |
  2230. | language.pass(X_480); |
  2231. | language.pass(X_808); |
  2232. | language.pass(X_776); |
  2233. | language.pass(X_871); |
  2234. | language.pass(X_911); |
  2235. | language.pass(X_976); |
  2236. | language.pass(X_87); |
  2237. | language.pass(X_127); |
  2238. | language.pass(X_136); |
  2239. | language.pass(X_145); |
  2240. | language.pass(X_154); |
  2241. | language.pass(X_171); |
  2242. | language.pass(X_1183); |
  2243. | language.pass(X_165); |
  2244. | language.pass(X_1254); |
  2245. | language.pass(X_1207); |
  2246. | language.pass(X_1295); |
  2247. | language.pass(X_1255); |
  2248. | language.pass(X_168); |
  2249. | language.pass(X_1303); |
  2250. | language.pass(X_1223); |
  2251. | language.pass(X_1352); |
  2252. | language.pass(X_1327); |
  2253. | language.pass(X_170); |
  2254. | language.pass(X_1367); |
  2255. | language.pass(X_1175); |
  2256. | language.pass(X_184); |
  2257. | language.pass(X_1415); |
  2258. | language.pass(X_1383); |
  2259. | language.pass(X_185); |
  2260. | language.pass(X_2473); |
  2261. | language.pass(X_196); |
  2262. | language.pass(X_197); |
  2263. | language.pass(X_1423); |
  2264. | language.pass(X_215); |
  2265. | language.pass(X_224); |
  2266. | language.pass(X_233); |
  2267. | language.pass(X_242); |
  2268. | language.pass(X_255); |
  2269. | language.pass(X_1591); |
  2270. | language.pass(X_249); |
  2271. | language.pass(X_1654); |
  2272. | language.pass(X_1607); |
  2273. | language.pass(X_1695); |
  2274. | language.pass(X_1655); |
  2275. | language.pass(X_252); |
  2276. | language.pass(X_1711); |
  2277. | language.pass(X_1631); |
  2278. | language.pass(X_1759); |
  2279. | language.pass(X_1727); |
  2280. | language.pass(X_254); |
  2281. | language.pass(X_1767); |
  2282. | language.pass(X_1575); |
  2283. | language.pass(X_268); |
  2284. | language.pass(X_1815); |
  2285. | language.pass(X_1791); |
  2286. | language.pass(X_269); |
  2287. | language.pass(X_2489); |
  2288. | language.pass(X_280); |
  2289. | language.pass(X_281); |
  2290. | language.pass(X_1847); |
  2291. | language.pass(X_284); |
  2292. | language.pass(X_1919); |
  2293. | language.pass(X_1831); |
  2294. | language.pass(X_1519); |
  2295. | language.pass(X_1447); |
  2296. | language.pass(X_286); |
  2297. | language.pass(X_112); |
  2298. | language.pass(X_289); |
  2299. | language.pass(X_1080); |
  2300. | language.pass(X_291); |
  2301. | language.pass(X_2062); |
  2302. | language.pass(X_2086); |
  2303. | language.pass(X_1935); |
  2304. | language.pass(X_2118); |
  2305. | language.pass(X_521); |
  2306. | language.pass(X_537); |
  2307. | language.pass(X_538); |
  2308. | language.pass(X_39); |
  2309. | language.pass(X_488); |
  2310. | language.pass(X_504); |
  2311. | language.pass(X_505); |
  2312. | language.pass(X_36); |
  2313. | language.pass(X_2300); |
  2314. | language.pass(X_1048); |
  2315. | language.pass(X_2497); |
  2316. | language.pass(X_1527); |
  2317. | language.pass(X_1174); |
  2318. | language.pass(X_1126); |
  2319. | language.pass(X_1079); |
  2320. | language.pass(X_2237); |
  2321. | language.pass(X_2277); |
  2322. | language.pass(X_2407); |
  2323. | language.pass(X_2357); |
  2324. | language.pass(X_2157); |
  2325. | language.pass(X_2158); |
  2326. | language.pass(X_2119); |
  2327. | language.pass(X_1959); |
  2328. | language.pass(X_2175); |
  2329. | language.pass(X_2087); |
  2330. | language.pass(X_1975); |
  2331. | language.pass(X_1999); |
  2332. | language.pass(X_2505); |
  2333. | language.pass(X_2096); |
  2334. | language.pass(X_2063); |
  2335. | language.pass(X_2038); |
  2336. | language.pass(X_2015); |
  2337. | language.pass(X_292); |
  2338. | language.pass(X_290); |
  2339. | language.pass(X_288); |
  2340. | language.pass(X_287); |
  2341. | language.pass(X_285); |
  2342. | language.pass(X_301); |
  2343. | language.pass(r1_844); |
  2344. | exit X_2564; |
  2345. | X_2514:bat[:oid,:str] := nil:bat[:oid,:str]; |
  2346. | X_2522:bat[:oid,:str] := nil:bat[:oid,:str]; |
  2347. | X_2530:bat[:oid,:str] := nil:bat[:oid,:str]; |
  2348. | X_2538:bat[:oid,:str] := nil:bat[:oid,:str]; |
  2349. | X_2547:bat[:oid,:str] := nil:bat[:oid,:str]; |
  2350. | X_2555:bat[:oid,:lng] := nil:bat[:oid,:lng]; |
  2351. | X_2563:bat[:oid,:lng] := nil:bat[:oid,:lng]; |
  2352. | X_326 := sql.resultSet(7,1,X_303); |
  2353. | sql.rsColumn(X_326,"axabas.L","c0","varchar",32,0,X_303); |
  2354. | sql.rsColumn(X_326,"axabas.L","c1","varchar",32,0,X_304); |
  2355. | sql.rsColumn(X_326,"axabas.L","c2","varchar",32,0,X_305); |
  2356. | sql.rsColumn(X_326,"axabas.L","c3","varchar",32,0,X_306); |
  2357. | sql.rsColumn(X_326,"axabas.L","c4","varchar",32,0,X_307); |
  2358. | sql.rsColumn(X_326,"axabas.L1","m0","decimal",18,6,X_320); |
  2359. | sql.rsColumn(X_326,"axabas.L2","m1","decimal",18,6,X_324); |
  2360. | X_351 := io.stdout(); |
  2361. | sql.exportResult(X_351,X_326); |
  2362. | end s1_1; |
  2363. +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  2364. 2355 tuples (25.136ms)
  2365. sql>
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!