API tools faq
paste
Advertisement
Guest User

TestEntity.log

a guest
Mar 8th, 2021
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 191.90 KB | None | 0 0
raw download clone embed print report
  1. ######### ################################################################################
  2. ######### TEST 100 no graph no fetch printAll
  3. ######### ################################################################################
  4. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  5. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  6. ######### final Path<Long> id = root.get("id");
  7. ######### query.where(builder.equal(id, 100L));
  8. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  9. ######### final TestEntity test = tq.getSingleResult();
  10. Hibernate:
  11. select
  12. testentity0_.id as id1_28_,
  13. testentity0_.link_id as link_id4_28_,
  14. testentity0_.linkJoin_id as linkjoin5_28_,
  15. testentity0_.linkLazy_id as linklazy6_28_,
  16. testentity0_.linkLazyJoin_id as linklazy7_28_,
  17. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_,
  18. testentity0_.linkLazySelect_id as linklaz11_28_,
  19. testentity0_.linkNoProxyJoin_id as linknop13_28_,
  20. testentity0_.linkSelect_id as linksel15_28_,
  21. testentity0_.name as name2_28_,
  22. testentity0_.version as version3_28_
  23. from
  24. loading_test testentity0_
  25. where
  26. testentity0_.id=100
  27. Hibernate:
  28. select
  29. testentity0_.id as id1_28_0_,
  30. testentity0_.link_id as link_id4_28_0_,
  31. testentity0_.linkJoin_id as linkjoin5_28_0_,
  32. testentity0_.linkLazy_id as linklazy6_28_0_,
  33. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  34. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  35. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  36. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  37. testentity0_.linkSelect_id as linksel15_28_0_,
  38. testentity0_.name as name2_28_0_,
  39. testentity0_.version as version3_28_0_,
  40. testentity1_.id as id1_28_1_,
  41. testentity1_.link_id as link_id4_28_1_,
  42. testentity1_.linkJoin_id as linkjoin5_28_1_,
  43. testentity1_.linkLazy_id as linklazy6_28_1_,
  44. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  45. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  46. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  47. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  48. testentity1_.linkSelect_id as linksel15_28_1_,
  49. testentity1_.name as name2_28_1_,
  50. testentity1_.version as version3_28_1_,
  51. testentity2_.id as id1_28_2_,
  52. testentity2_.link_id as link_id4_28_2_,
  53. testentity2_.linkJoin_id as linkjoin5_28_2_,
  54. testentity2_.linkLazy_id as linklazy6_28_2_,
  55. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  56. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  57. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  58. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  59. testentity2_.linkSelect_id as linksel15_28_2_,
  60. testentity2_.name as name2_28_2_,
  61. testentity2_.version as version3_28_2_,
  62. testentity3_.id as id1_28_3_,
  63. testentity3_.link_id as link_id4_28_3_,
  64. testentity3_.linkJoin_id as linkjoin5_28_3_,
  65. testentity3_.linkLazy_id as linklazy6_28_3_,
  66. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  67. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  68. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  69. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  70. testentity3_.linkSelect_id as linksel15_28_3_,
  71. testentity3_.name as name2_28_3_,
  72. testentity3_.version as version3_28_3_,
  73. testentity4_.id as id1_28_4_,
  74. testentity4_.link_id as link_id4_28_4_,
  75. testentity4_.linkJoin_id as linkjoin5_28_4_,
  76. testentity4_.linkLazy_id as linklazy6_28_4_,
  77. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  78. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  79. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  80. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  81. testentity4_.linkSelect_id as linksel15_28_4_,
  82. testentity4_.name as name2_28_4_,
  83. testentity4_.version as version3_28_4_,
  84. testentity5_.id as id1_28_5_,
  85. testentity5_.link_id as link_id4_28_5_,
  86. testentity5_.linkJoin_id as linkjoin5_28_5_,
  87. testentity5_.linkLazy_id as linklazy6_28_5_,
  88. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  89. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  90. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  91. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  92. testentity5_.linkSelect_id as linksel15_28_5_,
  93. testentity5_.name as name2_28_5_,
  94. testentity5_.version as version3_28_5_,
  95. testentity6_.id as id1_28_6_,
  96. testentity6_.link_id as link_id4_28_6_,
  97. testentity6_.linkJoin_id as linkjoin5_28_6_,
  98. testentity6_.linkLazy_id as linklazy6_28_6_,
  99. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  100. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  101. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  102. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  103. testentity6_.linkSelect_id as linksel15_28_6_,
  104. testentity6_.name as name2_28_6_,
  105. testentity6_.version as version3_28_6_
  106. from
  107. loading_test testentity0_
  108. left outer join
  109. loading_test testentity1_
  110. on testentity0_.link_id=testentity1_.id
  111. left outer join
  112. loading_test testentity2_
  113. on testentity1_.linkJoin_id=testentity2_.id
  114. left outer join
  115. loading_test testentity3_
  116. on testentity2_.linkLazyJoin_id=testentity3_.id
  117. left outer join
  118. loading_test testentity4_
  119. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  120. left outer join
  121. loading_test testentity5_
  122. on testentity4_.linkNoProxy_id=testentity5_.id
  123. left outer join
  124. loading_test testentity6_
  125. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  126. where
  127. testentity0_.id in (
  128. ?, ?, ?, ?, ?, ?, ?, ?
  129. )
  130. ######### test.reportInitializationState();
  131. ######### ================================================================================
  132. ######### #100:no-graph Initialization State
  133. ######### --------------------------------------------------------------------------------
  134. ######### link: YES 1/1
  135. ######### linkJoin: YES 1/1
  136. ######### linkLazy: YES 1/1
  137. ######### linkLazyJoin: YES 1/1
  138. ######### linkLazyNoProxy: n/a 0/1
  139. ######### linkLazyNoProxyJoin: YES 1/1
  140. ######### linkLazyNoProxySelect: n/a 0/1
  141. ######### linkLazySelect: YES 1/1
  142. ######### linkNoProxy: n/a 0/1
  143. ######### linkNoProxyJoin: YES 1/1
  144. ######### linkNoProxySelect: n/a 0/1
  145. ######### linkSelect: YES 1/1
  146. ######### --------------------------------------------------------------------------------
  147. ######### #100:no-graph Reflection State
  148. ######### --------------------------------------------------------------------------------
  149. ######### link: HERE 1/1
  150. ######### linkJoin: HERE 1/1
  151. ######### linkLazy: HERE 1/1
  152. ######### linkLazyJoin: HERE 1/1
  153. ######### linkLazyNoProxy: null 0/1
  154. ######### linkLazyNoProxyJoin: HERE 1/1
  155. ######### linkLazyNoProxySelect: null 0/1
  156. ######### linkLazySelect: HERE 1/1
  157. ######### linkNoProxy: null 0/1
  158. ######### linkNoProxyJoin: HERE 1/1
  159. ######### linkNoProxySelect: null 0/1
  160. ######### linkSelect: HERE 1/1
  161. ######### ================================================================================
  162. ######### test.printAll();
  163. ######### ================================================================================
  164. ######### #100:no-graph
  165. ######### --------------------------------------------------------------------------------
  166. ######### link = #1:link
  167. ######### linkSelect = #2:linkSelect
  168. ######### linkJoin = #3:linkJoin
  169. Hibernate:
  170. select
  171. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  172. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  173. testentity_.linkNoProxy_id as linknop12_28_,
  174. testentity_.linkNoProxySelect_id as linknop14_28_
  175. from
  176. loading_test testentity_
  177. where
  178. testentity_.id=?
  179. Hibernate:
  180. select
  181. testentity0_.id as id1_28_0_,
  182. testentity0_.link_id as link_id4_28_0_,
  183. testentity0_.linkJoin_id as linkjoin5_28_0_,
  184. testentity0_.linkLazy_id as linklazy6_28_0_,
  185. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  186. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  187. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  188. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  189. testentity0_.linkSelect_id as linksel15_28_0_,
  190. testentity0_.name as name2_28_0_,
  191. testentity0_.version as version3_28_0_,
  192. testentity1_.id as id1_28_1_,
  193. testentity1_.link_id as link_id4_28_1_,
  194. testentity1_.linkJoin_id as linkjoin5_28_1_,
  195. testentity1_.linkLazy_id as linklazy6_28_1_,
  196. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  197. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  198. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  199. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  200. testentity1_.linkSelect_id as linksel15_28_1_,
  201. testentity1_.name as name2_28_1_,
  202. testentity1_.version as version3_28_1_,
  203. testentity2_.id as id1_28_2_,
  204. testentity2_.link_id as link_id4_28_2_,
  205. testentity2_.linkJoin_id as linkjoin5_28_2_,
  206. testentity2_.linkLazy_id as linklazy6_28_2_,
  207. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  208. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  209. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  210. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  211. testentity2_.linkSelect_id as linksel15_28_2_,
  212. testentity2_.name as name2_28_2_,
  213. testentity2_.version as version3_28_2_,
  214. testentity3_.id as id1_28_3_,
  215. testentity3_.link_id as link_id4_28_3_,
  216. testentity3_.linkJoin_id as linkjoin5_28_3_,
  217. testentity3_.linkLazy_id as linklazy6_28_3_,
  218. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  219. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  220. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  221. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  222. testentity3_.linkSelect_id as linksel15_28_3_,
  223. testentity3_.name as name2_28_3_,
  224. testentity3_.version as version3_28_3_,
  225. testentity4_.id as id1_28_4_,
  226. testentity4_.link_id as link_id4_28_4_,
  227. testentity4_.linkJoin_id as linkjoin5_28_4_,
  228. testentity4_.linkLazy_id as linklazy6_28_4_,
  229. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  230. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  231. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  232. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  233. testentity4_.linkSelect_id as linksel15_28_4_,
  234. testentity4_.name as name2_28_4_,
  235. testentity4_.version as version3_28_4_,
  236. testentity5_.id as id1_28_5_,
  237. testentity5_.link_id as link_id4_28_5_,
  238. testentity5_.linkJoin_id as linkjoin5_28_5_,
  239. testentity5_.linkLazy_id as linklazy6_28_5_,
  240. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  241. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  242. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  243. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  244. testentity5_.linkSelect_id as linksel15_28_5_,
  245. testentity5_.name as name2_28_5_,
  246. testentity5_.version as version3_28_5_,
  247. testentity6_.id as id1_28_6_,
  248. testentity6_.link_id as link_id4_28_6_,
  249. testentity6_.linkJoin_id as linkjoin5_28_6_,
  250. testentity6_.linkLazy_id as linklazy6_28_6_,
  251. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  252. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  253. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  254. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  255. testentity6_.linkSelect_id as linksel15_28_6_,
  256. testentity6_.name as name2_28_6_,
  257. testentity6_.version as version3_28_6_
  258. from
  259. loading_test testentity0_
  260. left outer join
  261. loading_test testentity1_
  262. on testentity0_.link_id=testentity1_.id
  263. left outer join
  264. loading_test testentity2_
  265. on testentity1_.linkJoin_id=testentity2_.id
  266. left outer join
  267. loading_test testentity3_
  268. on testentity2_.linkLazyJoin_id=testentity3_.id
  269. left outer join
  270. loading_test testentity4_
  271. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  272. left outer join
  273. loading_test testentity5_
  274. on testentity4_.linkNoProxy_id=testentity5_.id
  275. left outer join
  276. loading_test testentity6_
  277. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  278. where
  279. testentity0_.id=?
  280. Hibernate:
  281. select
  282. testentity0_.id as id1_28_0_,
  283. testentity0_.link_id as link_id4_28_0_,
  284. testentity0_.linkJoin_id as linkjoin5_28_0_,
  285. testentity0_.linkLazy_id as linklazy6_28_0_,
  286. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  287. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  288. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  289. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  290. testentity0_.linkSelect_id as linksel15_28_0_,
  291. testentity0_.name as name2_28_0_,
  292. testentity0_.version as version3_28_0_,
  293. testentity1_.id as id1_28_1_,
  294. testentity1_.link_id as link_id4_28_1_,
  295. testentity1_.linkJoin_id as linkjoin5_28_1_,
  296. testentity1_.linkLazy_id as linklazy6_28_1_,
  297. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  298. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  299. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  300. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  301. testentity1_.linkSelect_id as linksel15_28_1_,
  302. testentity1_.name as name2_28_1_,
  303. testentity1_.version as version3_28_1_,
  304. testentity2_.id as id1_28_2_,
  305. testentity2_.link_id as link_id4_28_2_,
  306. testentity2_.linkJoin_id as linkjoin5_28_2_,
  307. testentity2_.linkLazy_id as linklazy6_28_2_,
  308. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  309. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  310. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  311. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  312. testentity2_.linkSelect_id as linksel15_28_2_,
  313. testentity2_.name as name2_28_2_,
  314. testentity2_.version as version3_28_2_,
  315. testentity3_.id as id1_28_3_,
  316. testentity3_.link_id as link_id4_28_3_,
  317. testentity3_.linkJoin_id as linkjoin5_28_3_,
  318. testentity3_.linkLazy_id as linklazy6_28_3_,
  319. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  320. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  321. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  322. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  323. testentity3_.linkSelect_id as linksel15_28_3_,
  324. testentity3_.name as name2_28_3_,
  325. testentity3_.version as version3_28_3_,
  326. testentity4_.id as id1_28_4_,
  327. testentity4_.link_id as link_id4_28_4_,
  328. testentity4_.linkJoin_id as linkjoin5_28_4_,
  329. testentity4_.linkLazy_id as linklazy6_28_4_,
  330. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  331. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  332. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  333. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  334. testentity4_.linkSelect_id as linksel15_28_4_,
  335. testentity4_.name as name2_28_4_,
  336. testentity4_.version as version3_28_4_,
  337. testentity5_.id as id1_28_5_,
  338. testentity5_.link_id as link_id4_28_5_,
  339. testentity5_.linkJoin_id as linkjoin5_28_5_,
  340. testentity5_.linkLazy_id as linklazy6_28_5_,
  341. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  342. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  343. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  344. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  345. testentity5_.linkSelect_id as linksel15_28_5_,
  346. testentity5_.name as name2_28_5_,
  347. testentity5_.version as version3_28_5_,
  348. testentity6_.id as id1_28_6_,
  349. testentity6_.link_id as link_id4_28_6_,
  350. testentity6_.linkJoin_id as linkjoin5_28_6_,
  351. testentity6_.linkLazy_id as linklazy6_28_6_,
  352. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  353. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  354. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  355. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  356. testentity6_.linkSelect_id as linksel15_28_6_,
  357. testentity6_.name as name2_28_6_,
  358. testentity6_.version as version3_28_6_
  359. from
  360. loading_test testentity0_
  361. left outer join
  362. loading_test testentity1_
  363. on testentity0_.link_id=testentity1_.id
  364. left outer join
  365. loading_test testentity2_
  366. on testentity1_.linkJoin_id=testentity2_.id
  367. left outer join
  368. loading_test testentity3_
  369. on testentity2_.linkLazyJoin_id=testentity3_.id
  370. left outer join
  371. loading_test testentity4_
  372. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  373. left outer join
  374. loading_test testentity5_
  375. on testentity4_.linkNoProxy_id=testentity5_.id
  376. left outer join
  377. loading_test testentity6_
  378. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  379. where
  380. testentity0_.id=?
  381. Hibernate:
  382. select
  383. testentity0_.id as id1_28_0_,
  384. testentity0_.link_id as link_id4_28_0_,
  385. testentity0_.linkJoin_id as linkjoin5_28_0_,
  386. testentity0_.linkLazy_id as linklazy6_28_0_,
  387. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  388. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  389. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  390. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  391. testentity0_.linkSelect_id as linksel15_28_0_,
  392. testentity0_.name as name2_28_0_,
  393. testentity0_.version as version3_28_0_,
  394. testentity1_.id as id1_28_1_,
  395. testentity1_.link_id as link_id4_28_1_,
  396. testentity1_.linkJoin_id as linkjoin5_28_1_,
  397. testentity1_.linkLazy_id as linklazy6_28_1_,
  398. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  399. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  400. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  401. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  402. testentity1_.linkSelect_id as linksel15_28_1_,
  403. testentity1_.name as name2_28_1_,
  404. testentity1_.version as version3_28_1_,
  405. testentity2_.id as id1_28_2_,
  406. testentity2_.link_id as link_id4_28_2_,
  407. testentity2_.linkJoin_id as linkjoin5_28_2_,
  408. testentity2_.linkLazy_id as linklazy6_28_2_,
  409. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  410. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  411. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  412. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  413. testentity2_.linkSelect_id as linksel15_28_2_,
  414. testentity2_.name as name2_28_2_,
  415. testentity2_.version as version3_28_2_,
  416. testentity3_.id as id1_28_3_,
  417. testentity3_.link_id as link_id4_28_3_,
  418. testentity3_.linkJoin_id as linkjoin5_28_3_,
  419. testentity3_.linkLazy_id as linklazy6_28_3_,
  420. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  421. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  422. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  423. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  424. testentity3_.linkSelect_id as linksel15_28_3_,
  425. testentity3_.name as name2_28_3_,
  426. testentity3_.version as version3_28_3_,
  427. testentity4_.id as id1_28_4_,
  428. testentity4_.link_id as link_id4_28_4_,
  429. testentity4_.linkJoin_id as linkjoin5_28_4_,
  430. testentity4_.linkLazy_id as linklazy6_28_4_,
  431. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  432. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  433. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  434. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  435. testentity4_.linkSelect_id as linksel15_28_4_,
  436. testentity4_.name as name2_28_4_,
  437. testentity4_.version as version3_28_4_,
  438. testentity5_.id as id1_28_5_,
  439. testentity5_.link_id as link_id4_28_5_,
  440. testentity5_.linkJoin_id as linkjoin5_28_5_,
  441. testentity5_.linkLazy_id as linklazy6_28_5_,
  442. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  443. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  444. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  445. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  446. testentity5_.linkSelect_id as linksel15_28_5_,
  447. testentity5_.name as name2_28_5_,
  448. testentity5_.version as version3_28_5_,
  449. testentity6_.id as id1_28_6_,
  450. testentity6_.link_id as link_id4_28_6_,
  451. testentity6_.linkJoin_id as linkjoin5_28_6_,
  452. testentity6_.linkLazy_id as linklazy6_28_6_,
  453. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  454. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  455. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  456. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  457. testentity6_.linkSelect_id as linksel15_28_6_,
  458. testentity6_.name as name2_28_6_,
  459. testentity6_.version as version3_28_6_
  460. from
  461. loading_test testentity0_
  462. left outer join
  463. loading_test testentity1_
  464. on testentity0_.link_id=testentity1_.id
  465. left outer join
  466. loading_test testentity2_
  467. on testentity1_.linkJoin_id=testentity2_.id
  468. left outer join
  469. loading_test testentity3_
  470. on testentity2_.linkLazyJoin_id=testentity3_.id
  471. left outer join
  472. loading_test testentity4_
  473. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  474. left outer join
  475. loading_test testentity5_
  476. on testentity4_.linkNoProxy_id=testentity5_.id
  477. left outer join
  478. loading_test testentity6_
  479. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  480. where
  481. testentity0_.id=?
  482. ######### linkNoProxy = #5:linkNoProxy
  483. ######### linkNoProxySelect = #6:linkNoProxySelect
  484. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  485. ######### linkLazy = #9:linkLazy
  486. ######### linkLazySelect = #10:linkLazySelect
  487. ######### linkLazyJoin = #11:linkLazyJoin
  488. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  489. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  490. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  491. ######### ================================================================================
  492. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  493. ######### ################################################################################
  494. ######### TEST 101 graph=1/javax.persistence.fetchgraph no fetch printAll
  495. ######### ################################################################################
  496. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  497. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  498. ######### final Path<Long> id = root.get("id");
  499. ######### query.where(builder.equal(id, 101L));
  500. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  501. ######### final String graphText = "link, linkSelect, linkJoin, linkNoProxy, linkNoProxySelect, linkNoProxyJoin, linkLazy, linkLazySelect, linkLazyJoin, linkLazyNoProxy, linkLazyNoProxySelect, linkLazyNoProxyJoin";
  502. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  503. ######### tq.setHint("javax.persistence.fetchgraph", entityGraph);
  504. ######### final TestEntity test = tq.getSingleResult();
  505. Hibernate:
  506. select
  507. testentity0_.id as id1_28_0_,
  508. testentity1_.id as id1_28_1_,
  509. testentity2_.id as id1_28_2_,
  510. testentity3_.id as id1_28_3_,
  511. testentity4_.id as id1_28_4_,
  512. testentity5_.id as id1_28_5_,
  513. testentity6_.id as id1_28_6_,
  514. testentity7_.id as id1_28_7_,
  515. testentity8_.id as id1_28_8_,
  516. testentity9_.id as id1_28_9_,
  517. testentity10_.id as id1_28_10_,
  518. testentity11_.id as id1_28_11_,
  519. testentity12_.id as id1_28_12_,
  520. testentity0_.link_id as link_id4_28_0_,
  521. testentity0_.linkJoin_id as linkjoin5_28_0_,
  522. testentity0_.linkLazy_id as linklazy6_28_0_,
  523. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  524. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  525. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  526. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  527. testentity0_.linkSelect_id as linksel15_28_0_,
  528. testentity0_.name as name2_28_0_,
  529. testentity0_.version as version3_28_0_,
  530. testentity1_.link_id as link_id4_28_1_,
  531. testentity1_.linkJoin_id as linkjoin5_28_1_,
  532. testentity1_.linkLazy_id as linklazy6_28_1_,
  533. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  534. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  535. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  536. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  537. testentity1_.linkSelect_id as linksel15_28_1_,
  538. testentity1_.name as name2_28_1_,
  539. testentity1_.version as version3_28_1_,
  540. testentity2_.link_id as link_id4_28_2_,
  541. testentity2_.linkJoin_id as linkjoin5_28_2_,
  542. testentity2_.linkLazy_id as linklazy6_28_2_,
  543. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  544. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  545. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  546. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  547. testentity2_.linkSelect_id as linksel15_28_2_,
  548. testentity2_.name as name2_28_2_,
  549. testentity2_.version as version3_28_2_,
  550. testentity3_.link_id as link_id4_28_3_,
  551. testentity3_.linkJoin_id as linkjoin5_28_3_,
  552. testentity3_.linkLazy_id as linklazy6_28_3_,
  553. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  554. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  555. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  556. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  557. testentity3_.linkSelect_id as linksel15_28_3_,
  558. testentity3_.name as name2_28_3_,
  559. testentity3_.version as version3_28_3_,
  560. testentity4_.link_id as link_id4_28_4_,
  561. testentity4_.linkJoin_id as linkjoin5_28_4_,
  562. testentity4_.linkLazy_id as linklazy6_28_4_,
  563. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  564. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  565. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  566. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  567. testentity4_.linkSelect_id as linksel15_28_4_,
  568. testentity4_.name as name2_28_4_,
  569. testentity4_.version as version3_28_4_,
  570. testentity5_.link_id as link_id4_28_5_,
  571. testentity5_.linkJoin_id as linkjoin5_28_5_,
  572. testentity5_.linkLazy_id as linklazy6_28_5_,
  573. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  574. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  575. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  576. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  577. testentity5_.linkSelect_id as linksel15_28_5_,
  578. testentity5_.name as name2_28_5_,
  579. testentity5_.version as version3_28_5_,
  580. testentity6_.link_id as link_id4_28_6_,
  581. testentity6_.linkJoin_id as linkjoin5_28_6_,
  582. testentity6_.linkLazy_id as linklazy6_28_6_,
  583. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  584. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  585. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  586. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  587. testentity6_.linkSelect_id as linksel15_28_6_,
  588. testentity6_.name as name2_28_6_,
  589. testentity6_.version as version3_28_6_,
  590. testentity7_.link_id as link_id4_28_7_,
  591. testentity7_.linkJoin_id as linkjoin5_28_7_,
  592. testentity7_.linkLazy_id as linklazy6_28_7_,
  593. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  594. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  595. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  596. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  597. testentity7_.linkSelect_id as linksel15_28_7_,
  598. testentity7_.name as name2_28_7_,
  599. testentity7_.version as version3_28_7_,
  600. testentity8_.link_id as link_id4_28_8_,
  601. testentity8_.linkJoin_id as linkjoin5_28_8_,
  602. testentity8_.linkLazy_id as linklazy6_28_8_,
  603. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  604. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  605. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  606. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  607. testentity8_.linkSelect_id as linksel15_28_8_,
  608. testentity8_.name as name2_28_8_,
  609. testentity8_.version as version3_28_8_,
  610. testentity9_.link_id as link_id4_28_9_,
  611. testentity9_.linkJoin_id as linkjoin5_28_9_,
  612. testentity9_.linkLazy_id as linklazy6_28_9_,
  613. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  614. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  615. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  616. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  617. testentity9_.linkSelect_id as linksel15_28_9_,
  618. testentity9_.name as name2_28_9_,
  619. testentity9_.version as version3_28_9_,
  620. testentity10_.link_id as link_id4_28_10_,
  621. testentity10_.linkJoin_id as linkjoin5_28_10_,
  622. testentity10_.linkLazy_id as linklazy6_28_10_,
  623. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  624. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  625. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  626. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  627. testentity10_.linkSelect_id as linksel15_28_10_,
  628. testentity10_.name as name2_28_10_,
  629. testentity10_.version as version3_28_10_,
  630. testentity11_.link_id as link_id4_28_11_,
  631. testentity11_.linkJoin_id as linkjoin5_28_11_,
  632. testentity11_.linkLazy_id as linklazy6_28_11_,
  633. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  634. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  635. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  636. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  637. testentity11_.linkSelect_id as linksel15_28_11_,
  638. testentity11_.name as name2_28_11_,
  639. testentity11_.version as version3_28_11_,
  640. testentity12_.link_id as link_id4_28_12_,
  641. testentity12_.linkJoin_id as linkjoin5_28_12_,
  642. testentity12_.linkLazy_id as linklazy6_28_12_,
  643. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  644. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  645. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  646. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  647. testentity12_.linkSelect_id as linksel15_28_12_,
  648. testentity12_.name as name2_28_12_,
  649. testentity12_.version as version3_28_12_
  650. from
  651. loading_test testentity0_
  652. left outer join
  653. loading_test testentity1_
  654. on testentity0_.link_id=testentity1_.id
  655. left outer join
  656. loading_test testentity2_
  657. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  658. left outer join
  659. loading_test testentity3_
  660. on testentity0_.linkLazyJoin_id=testentity3_.id
  661. left outer join
  662. loading_test testentity4_
  663. on testentity0_.linkSelect_id=testentity4_.id
  664. left outer join
  665. loading_test testentity5_
  666. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  667. left outer join
  668. loading_test testentity6_
  669. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  670. left outer join
  671. loading_test testentity7_
  672. on testentity0_.linkLazySelect_id=testentity7_.id
  673. left outer join
  674. loading_test testentity8_
  675. on testentity0_.linkNoProxy_id=testentity8_.id
  676. left outer join
  677. loading_test testentity9_
  678. on testentity0_.linkLazy_id=testentity9_.id
  679. left outer join
  680. loading_test testentity10_
  681. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  682. left outer join
  683. loading_test testentity11_
  684. on testentity0_.linkJoin_id=testentity11_.id
  685. left outer join
  686. loading_test testentity12_
  687. on testentity0_.linkNoProxySelect_id=testentity12_.id
  688. where
  689. testentity0_.id=101
  690. ######### test.reportInitializationState();
  691. ######### ================================================================================
  692. ######### #101:shallow-graph Initialization State
  693. ######### --------------------------------------------------------------------------------
  694. ######### link: YES 2/2
  695. ######### linkJoin: YES 2/2
  696. ######### linkLazy: YES 2/2
  697. ######### linkLazyJoin: YES 2/2
  698. ######### linkLazyNoProxy: n/a 0/2
  699. ######### linkLazyNoProxyJoin: YES 2/2
  700. ######### linkLazyNoProxySelect: n/a 0/2
  701. ######### linkLazySelect: YES 2/2
  702. ######### linkNoProxy: n/a 0/2
  703. ######### linkNoProxyJoin: YES 2/2
  704. ######### linkNoProxySelect: n/a 0/2
  705. ######### linkSelect: YES 2/2
  706. ######### --------------------------------------------------------------------------------
  707. ######### #101:shallow-graph Reflection State
  708. ######### --------------------------------------------------------------------------------
  709. ######### link: HERE 2/2
  710. ######### linkJoin: HERE 2/2
  711. ######### linkLazy: HERE 2/2
  712. ######### linkLazyJoin: HERE 2/2
  713. ######### linkLazyNoProxy: null 0/2
  714. ######### linkLazyNoProxyJoin: HERE 2/2
  715. ######### linkLazyNoProxySelect: null 0/2
  716. ######### linkLazySelect: HERE 2/2
  717. ######### linkNoProxy: null 0/2
  718. ######### linkNoProxyJoin: HERE 2/2
  719. ######### linkNoProxySelect: null 0/2
  720. ######### linkSelect: HERE 2/2
  721. ######### ================================================================================
  722. ######### test.printAll();
  723. ######### ================================================================================
  724. ######### #101:shallow-graph
  725. ######### --------------------------------------------------------------------------------
  726. ######### link = #1:link
  727. ######### linkSelect = #2:linkSelect
  728. ######### linkJoin = #3:linkJoin
  729. Hibernate:
  730. select
  731. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  732. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  733. testentity_.linkNoProxy_id as linknop12_28_,
  734. testentity_.linkNoProxySelect_id as linknop14_28_
  735. from
  736. loading_test testentity_
  737. where
  738. testentity_.id=?
  739. ######### linkNoProxy = #5:linkNoProxy
  740. ######### linkNoProxySelect = #6:linkNoProxySelect
  741. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  742. ######### linkLazy = #9:linkLazy
  743. ######### linkLazySelect = #10:linkLazySelect
  744. ######### linkLazyJoin = #11:linkLazyJoin
  745. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  746. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  747. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  748. ######### ================================================================================
  749. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  750. ######### ################################################################################
  751. ######### TEST 102 graph=2/javax.persistence.fetchgraph no fetch printAll
  752. ######### ################################################################################
  753. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  754. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  755. ######### final Path<Long> id = root.get("id");
  756. ######### query.where(builder.equal(id, 102L));
  757. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  758. ######### final String graphText = "link(id), linkSelect(id), linkJoin(id), linkNoProxy(id), linkNoProxySelect(id), linkNoProxyJoin(id), linkLazy(id), linkLazySelect(id), linkLazyJoin(id), linkLazyNoProxy(id), linkLazyNoProxySelect(id), linkLazyNoProxyJoin(id)";
  759. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  760. ######### tq.setHint("javax.persistence.fetchgraph", entityGraph);
  761. ######### final TestEntity test = tq.getSingleResult();
  762. Hibernate:
  763. select
  764. testentity0_.id as id1_28_0_,
  765. testentity1_.id as id1_28_1_,
  766. testentity2_.id as id1_28_2_,
  767. testentity3_.id as id1_28_3_,
  768. testentity4_.id as id1_28_4_,
  769. testentity5_.id as id1_28_5_,
  770. testentity6_.id as id1_28_6_,
  771. testentity7_.id as id1_28_7_,
  772. testentity8_.id as id1_28_8_,
  773. testentity9_.id as id1_28_9_,
  774. testentity10_.id as id1_28_10_,
  775. testentity11_.id as id1_28_11_,
  776. testentity12_.id as id1_28_12_,
  777. testentity0_.link_id as link_id4_28_0_,
  778. testentity0_.linkJoin_id as linkjoin5_28_0_,
  779. testentity0_.linkLazy_id as linklazy6_28_0_,
  780. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  781. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  782. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  783. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  784. testentity0_.linkSelect_id as linksel15_28_0_,
  785. testentity0_.name as name2_28_0_,
  786. testentity0_.version as version3_28_0_,
  787. testentity1_.link_id as link_id4_28_1_,
  788. testentity1_.linkJoin_id as linkjoin5_28_1_,
  789. testentity1_.linkLazy_id as linklazy6_28_1_,
  790. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  791. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  792. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  793. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  794. testentity1_.linkSelect_id as linksel15_28_1_,
  795. testentity1_.name as name2_28_1_,
  796. testentity1_.version as version3_28_1_,
  797. testentity2_.link_id as link_id4_28_2_,
  798. testentity2_.linkJoin_id as linkjoin5_28_2_,
  799. testentity2_.linkLazy_id as linklazy6_28_2_,
  800. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  801. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  802. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  803. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  804. testentity2_.linkSelect_id as linksel15_28_2_,
  805. testentity2_.name as name2_28_2_,
  806. testentity2_.version as version3_28_2_,
  807. testentity3_.link_id as link_id4_28_3_,
  808. testentity3_.linkJoin_id as linkjoin5_28_3_,
  809. testentity3_.linkLazy_id as linklazy6_28_3_,
  810. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  811. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  812. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  813. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  814. testentity3_.linkSelect_id as linksel15_28_3_,
  815. testentity3_.name as name2_28_3_,
  816. testentity3_.version as version3_28_3_,
  817. testentity4_.link_id as link_id4_28_4_,
  818. testentity4_.linkJoin_id as linkjoin5_28_4_,
  819. testentity4_.linkLazy_id as linklazy6_28_4_,
  820. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  821. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  822. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  823. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  824. testentity4_.linkSelect_id as linksel15_28_4_,
  825. testentity4_.name as name2_28_4_,
  826. testentity4_.version as version3_28_4_,
  827. testentity5_.link_id as link_id4_28_5_,
  828. testentity5_.linkJoin_id as linkjoin5_28_5_,
  829. testentity5_.linkLazy_id as linklazy6_28_5_,
  830. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  831. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  832. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  833. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  834. testentity5_.linkSelect_id as linksel15_28_5_,
  835. testentity5_.name as name2_28_5_,
  836. testentity5_.version as version3_28_5_,
  837. testentity6_.link_id as link_id4_28_6_,
  838. testentity6_.linkJoin_id as linkjoin5_28_6_,
  839. testentity6_.linkLazy_id as linklazy6_28_6_,
  840. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  841. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  842. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  843. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  844. testentity6_.linkSelect_id as linksel15_28_6_,
  845. testentity6_.name as name2_28_6_,
  846. testentity6_.version as version3_28_6_,
  847. testentity7_.link_id as link_id4_28_7_,
  848. testentity7_.linkJoin_id as linkjoin5_28_7_,
  849. testentity7_.linkLazy_id as linklazy6_28_7_,
  850. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  851. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  852. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  853. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  854. testentity7_.linkSelect_id as linksel15_28_7_,
  855. testentity7_.name as name2_28_7_,
  856. testentity7_.version as version3_28_7_,
  857. testentity8_.link_id as link_id4_28_8_,
  858. testentity8_.linkJoin_id as linkjoin5_28_8_,
  859. testentity8_.linkLazy_id as linklazy6_28_8_,
  860. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  861. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  862. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  863. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  864. testentity8_.linkSelect_id as linksel15_28_8_,
  865. testentity8_.name as name2_28_8_,
  866. testentity8_.version as version3_28_8_,
  867. testentity9_.link_id as link_id4_28_9_,
  868. testentity9_.linkJoin_id as linkjoin5_28_9_,
  869. testentity9_.linkLazy_id as linklazy6_28_9_,
  870. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  871. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  872. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  873. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  874. testentity9_.linkSelect_id as linksel15_28_9_,
  875. testentity9_.name as name2_28_9_,
  876. testentity9_.version as version3_28_9_,
  877. testentity10_.link_id as link_id4_28_10_,
  878. testentity10_.linkJoin_id as linkjoin5_28_10_,
  879. testentity10_.linkLazy_id as linklazy6_28_10_,
  880. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  881. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  882. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  883. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  884. testentity10_.linkSelect_id as linksel15_28_10_,
  885. testentity10_.name as name2_28_10_,
  886. testentity10_.version as version3_28_10_,
  887. testentity11_.link_id as link_id4_28_11_,
  888. testentity11_.linkJoin_id as linkjoin5_28_11_,
  889. testentity11_.linkLazy_id as linklazy6_28_11_,
  890. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  891. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  892. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  893. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  894. testentity11_.linkSelect_id as linksel15_28_11_,
  895. testentity11_.name as name2_28_11_,
  896. testentity11_.version as version3_28_11_,
  897. testentity12_.link_id as link_id4_28_12_,
  898. testentity12_.linkJoin_id as linkjoin5_28_12_,
  899. testentity12_.linkLazy_id as linklazy6_28_12_,
  900. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  901. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  902. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  903. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  904. testentity12_.linkSelect_id as linksel15_28_12_,
  905. testentity12_.name as name2_28_12_,
  906. testentity12_.version as version3_28_12_
  907. from
  908. loading_test testentity0_
  909. left outer join
  910. loading_test testentity1_
  911. on testentity0_.link_id=testentity1_.id
  912. left outer join
  913. loading_test testentity2_
  914. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  915. left outer join
  916. loading_test testentity3_
  917. on testentity0_.linkLazyJoin_id=testentity3_.id
  918. left outer join
  919. loading_test testentity4_
  920. on testentity0_.linkSelect_id=testentity4_.id
  921. left outer join
  922. loading_test testentity5_
  923. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  924. left outer join
  925. loading_test testentity6_
  926. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  927. left outer join
  928. loading_test testentity7_
  929. on testentity0_.linkLazySelect_id=testentity7_.id
  930. left outer join
  931. loading_test testentity8_
  932. on testentity0_.linkNoProxy_id=testentity8_.id
  933. left outer join
  934. loading_test testentity9_
  935. on testentity0_.linkLazy_id=testentity9_.id
  936. left outer join
  937. loading_test testentity10_
  938. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  939. left outer join
  940. loading_test testentity11_
  941. on testentity0_.linkJoin_id=testentity11_.id
  942. left outer join
  943. loading_test testentity12_
  944. on testentity0_.linkNoProxySelect_id=testentity12_.id
  945. where
  946. testentity0_.id=102
  947. ######### test.reportInitializationState();
  948. ######### ================================================================================
  949. ######### #102:id-graph Initialization State
  950. ######### --------------------------------------------------------------------------------
  951. ######### link: YES 3/3
  952. ######### linkJoin: YES 3/3
  953. ######### linkLazy: YES 3/3
  954. ######### linkLazyJoin: YES 3/3
  955. ######### linkLazyNoProxy: n/a 0/3
  956. ######### linkLazyNoProxyJoin: YES 3/3
  957. ######### linkLazyNoProxySelect: n/a 0/3
  958. ######### linkLazySelect: YES 3/3
  959. ######### linkNoProxy: n/a 0/3
  960. ######### linkNoProxyJoin: YES 3/3
  961. ######### linkNoProxySelect: n/a 0/3
  962. ######### linkSelect: YES 3/3
  963. ######### --------------------------------------------------------------------------------
  964. ######### #102:id-graph Reflection State
  965. ######### --------------------------------------------------------------------------------
  966. ######### link: HERE 3/3
  967. ######### linkJoin: HERE 3/3
  968. ######### linkLazy: HERE 3/3
  969. ######### linkLazyJoin: HERE 3/3
  970. ######### linkLazyNoProxy: null 0/3
  971. ######### linkLazyNoProxyJoin: HERE 3/3
  972. ######### linkLazyNoProxySelect: null 0/3
  973. ######### linkLazySelect: HERE 3/3
  974. ######### linkNoProxy: null 0/3
  975. ######### linkNoProxyJoin: HERE 3/3
  976. ######### linkNoProxySelect: null 0/3
  977. ######### linkSelect: HERE 3/3
  978. ######### ================================================================================
  979. ######### test.printAll();
  980. ######### ================================================================================
  981. ######### #102:id-graph
  982. ######### --------------------------------------------------------------------------------
  983. ######### link = #1:link
  984. ######### linkSelect = #2:linkSelect
  985. ######### linkJoin = #3:linkJoin
  986. Hibernate:
  987. select
  988. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  989. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  990. testentity_.linkNoProxy_id as linknop12_28_,
  991. testentity_.linkNoProxySelect_id as linknop14_28_
  992. from
  993. loading_test testentity_
  994. where
  995. testentity_.id=?
  996. ######### linkNoProxy = #5:linkNoProxy
  997. ######### linkNoProxySelect = #6:linkNoProxySelect
  998. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  999. ######### linkLazy = #9:linkLazy
  1000. ######### linkLazySelect = #10:linkLazySelect
  1001. ######### linkLazyJoin = #11:linkLazyJoin
  1002. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  1003. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  1004. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  1005. ######### ================================================================================
  1006. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  1007. ######### ################################################################################
  1008. ######### TEST 103 graph=3/javax.persistence.fetchgraph no fetch printAll
  1009. ######### ################################################################################
  1010. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  1011. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  1012. ######### final Path<Long> id = root.get("id");
  1013. ######### query.where(builder.equal(id, 103L));
  1014. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  1015. ######### final String graphText = "link(id, name), linkSelect(id, name), linkJoin(id, name), linkNoProxy(id, name), linkNoProxySelect(id, name), linkNoProxyJoin(id, name), linkLazy(id, name), linkLazySelect(id, name), linkLazyJoin(id, name), linkLazyNoProxy(id, name), linkLazyNoProxySelect(id, name), linkLazyNoProxyJoin(id, name)";
  1016. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  1017. ######### tq.setHint("javax.persistence.fetchgraph", entityGraph);
  1018. ######### final TestEntity test = tq.getSingleResult();
  1019. Hibernate:
  1020. select
  1021. testentity0_.id as id1_28_0_,
  1022. testentity1_.id as id1_28_1_,
  1023. testentity2_.id as id1_28_2_,
  1024. testentity3_.id as id1_28_3_,
  1025. testentity4_.id as id1_28_4_,
  1026. testentity5_.id as id1_28_5_,
  1027. testentity6_.id as id1_28_6_,
  1028. testentity7_.id as id1_28_7_,
  1029. testentity8_.id as id1_28_8_,
  1030. testentity9_.id as id1_28_9_,
  1031. testentity10_.id as id1_28_10_,
  1032. testentity11_.id as id1_28_11_,
  1033. testentity12_.id as id1_28_12_,
  1034. testentity0_.link_id as link_id4_28_0_,
  1035. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1036. testentity0_.linkLazy_id as linklazy6_28_0_,
  1037. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1038. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1039. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1040. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1041. testentity0_.linkSelect_id as linksel15_28_0_,
  1042. testentity0_.name as name2_28_0_,
  1043. testentity0_.version as version3_28_0_,
  1044. testentity1_.link_id as link_id4_28_1_,
  1045. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1046. testentity1_.linkLazy_id as linklazy6_28_1_,
  1047. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1048. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1049. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1050. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1051. testentity1_.linkSelect_id as linksel15_28_1_,
  1052. testentity1_.name as name2_28_1_,
  1053. testentity1_.version as version3_28_1_,
  1054. testentity2_.link_id as link_id4_28_2_,
  1055. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1056. testentity2_.linkLazy_id as linklazy6_28_2_,
  1057. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1058. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1059. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1060. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1061. testentity2_.linkSelect_id as linksel15_28_2_,
  1062. testentity2_.name as name2_28_2_,
  1063. testentity2_.version as version3_28_2_,
  1064. testentity3_.link_id as link_id4_28_3_,
  1065. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1066. testentity3_.linkLazy_id as linklazy6_28_3_,
  1067. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1068. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1069. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1070. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1071. testentity3_.linkSelect_id as linksel15_28_3_,
  1072. testentity3_.name as name2_28_3_,
  1073. testentity3_.version as version3_28_3_,
  1074. testentity4_.link_id as link_id4_28_4_,
  1075. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1076. testentity4_.linkLazy_id as linklazy6_28_4_,
  1077. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1078. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1079. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1080. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1081. testentity4_.linkSelect_id as linksel15_28_4_,
  1082. testentity4_.name as name2_28_4_,
  1083. testentity4_.version as version3_28_4_,
  1084. testentity5_.link_id as link_id4_28_5_,
  1085. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1086. testentity5_.linkLazy_id as linklazy6_28_5_,
  1087. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1088. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1089. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1090. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1091. testentity5_.linkSelect_id as linksel15_28_5_,
  1092. testentity5_.name as name2_28_5_,
  1093. testentity5_.version as version3_28_5_,
  1094. testentity6_.link_id as link_id4_28_6_,
  1095. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1096. testentity6_.linkLazy_id as linklazy6_28_6_,
  1097. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1098. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1099. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1100. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1101. testentity6_.linkSelect_id as linksel15_28_6_,
  1102. testentity6_.name as name2_28_6_,
  1103. testentity6_.version as version3_28_6_,
  1104. testentity7_.link_id as link_id4_28_7_,
  1105. testentity7_.linkJoin_id as linkjoin5_28_7_,
  1106. testentity7_.linkLazy_id as linklazy6_28_7_,
  1107. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  1108. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  1109. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  1110. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  1111. testentity7_.linkSelect_id as linksel15_28_7_,
  1112. testentity7_.name as name2_28_7_,
  1113. testentity7_.version as version3_28_7_,
  1114. testentity8_.link_id as link_id4_28_8_,
  1115. testentity8_.linkJoin_id as linkjoin5_28_8_,
  1116. testentity8_.linkLazy_id as linklazy6_28_8_,
  1117. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  1118. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  1119. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  1120. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  1121. testentity8_.linkSelect_id as linksel15_28_8_,
  1122. testentity8_.name as name2_28_8_,
  1123. testentity8_.version as version3_28_8_,
  1124. testentity9_.link_id as link_id4_28_9_,
  1125. testentity9_.linkJoin_id as linkjoin5_28_9_,
  1126. testentity9_.linkLazy_id as linklazy6_28_9_,
  1127. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  1128. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  1129. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  1130. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  1131. testentity9_.linkSelect_id as linksel15_28_9_,
  1132. testentity9_.name as name2_28_9_,
  1133. testentity9_.version as version3_28_9_,
  1134. testentity10_.link_id as link_id4_28_10_,
  1135. testentity10_.linkJoin_id as linkjoin5_28_10_,
  1136. testentity10_.linkLazy_id as linklazy6_28_10_,
  1137. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  1138. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  1139. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  1140. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  1141. testentity10_.linkSelect_id as linksel15_28_10_,
  1142. testentity10_.name as name2_28_10_,
  1143. testentity10_.version as version3_28_10_,
  1144. testentity11_.link_id as link_id4_28_11_,
  1145. testentity11_.linkJoin_id as linkjoin5_28_11_,
  1146. testentity11_.linkLazy_id as linklazy6_28_11_,
  1147. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  1148. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  1149. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  1150. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  1151. testentity11_.linkSelect_id as linksel15_28_11_,
  1152. testentity11_.name as name2_28_11_,
  1153. testentity11_.version as version3_28_11_,
  1154. testentity12_.link_id as link_id4_28_12_,
  1155. testentity12_.linkJoin_id as linkjoin5_28_12_,
  1156. testentity12_.linkLazy_id as linklazy6_28_12_,
  1157. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  1158. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  1159. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  1160. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  1161. testentity12_.linkSelect_id as linksel15_28_12_,
  1162. testentity12_.name as name2_28_12_,
  1163. testentity12_.version as version3_28_12_
  1164. from
  1165. loading_test testentity0_
  1166. left outer join
  1167. loading_test testentity1_
  1168. on testentity0_.link_id=testentity1_.id
  1169. left outer join
  1170. loading_test testentity2_
  1171. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  1172. left outer join
  1173. loading_test testentity3_
  1174. on testentity0_.linkLazyJoin_id=testentity3_.id
  1175. left outer join
  1176. loading_test testentity4_
  1177. on testentity0_.linkSelect_id=testentity4_.id
  1178. left outer join
  1179. loading_test testentity5_
  1180. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  1181. left outer join
  1182. loading_test testentity6_
  1183. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  1184. left outer join
  1185. loading_test testentity7_
  1186. on testentity0_.linkLazySelect_id=testentity7_.id
  1187. left outer join
  1188. loading_test testentity8_
  1189. on testentity0_.linkNoProxy_id=testentity8_.id
  1190. left outer join
  1191. loading_test testentity9_
  1192. on testentity0_.linkLazy_id=testentity9_.id
  1193. left outer join
  1194. loading_test testentity10_
  1195. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  1196. left outer join
  1197. loading_test testentity11_
  1198. on testentity0_.linkJoin_id=testentity11_.id
  1199. left outer join
  1200. loading_test testentity12_
  1201. on testentity0_.linkNoProxySelect_id=testentity12_.id
  1202. where
  1203. testentity0_.id=103
  1204. ######### test.reportInitializationState();
  1205. ######### ================================================================================
  1206. ######### #103:id-name-graph Initialization State
  1207. ######### --------------------------------------------------------------------------------
  1208. ######### link: YES 4/4
  1209. ######### linkJoin: YES 4/4
  1210. ######### linkLazy: YES 4/4
  1211. ######### linkLazyJoin: YES 4/4
  1212. ######### linkLazyNoProxy: n/a 0/4
  1213. ######### linkLazyNoProxyJoin: YES 4/4
  1214. ######### linkLazyNoProxySelect: n/a 0/4
  1215. ######### linkLazySelect: YES 4/4
  1216. ######### linkNoProxy: n/a 0/4
  1217. ######### linkNoProxyJoin: YES 4/4
  1218. ######### linkNoProxySelect: n/a 0/4
  1219. ######### linkSelect: YES 4/4
  1220. ######### --------------------------------------------------------------------------------
  1221. ######### #103:id-name-graph Reflection State
  1222. ######### --------------------------------------------------------------------------------
  1223. ######### link: HERE 4/4
  1224. ######### linkJoin: HERE 4/4
  1225. ######### linkLazy: HERE 4/4
  1226. ######### linkLazyJoin: HERE 4/4
  1227. ######### linkLazyNoProxy: null 0/4
  1228. ######### linkLazyNoProxyJoin: HERE 4/4
  1229. ######### linkLazyNoProxySelect: null 0/4
  1230. ######### linkLazySelect: HERE 4/4
  1231. ######### linkNoProxy: null 0/4
  1232. ######### linkNoProxyJoin: HERE 4/4
  1233. ######### linkNoProxySelect: null 0/4
  1234. ######### linkSelect: HERE 4/4
  1235. ######### ================================================================================
  1236. ######### test.printAll();
  1237. ######### ================================================================================
  1238. ######### #103:id-name-graph
  1239. ######### --------------------------------------------------------------------------------
  1240. ######### link = #1:link
  1241. ######### linkSelect = #2:linkSelect
  1242. ######### linkJoin = #3:linkJoin
  1243. Hibernate:
  1244. select
  1245. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  1246. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  1247. testentity_.linkNoProxy_id as linknop12_28_,
  1248. testentity_.linkNoProxySelect_id as linknop14_28_
  1249. from
  1250. loading_test testentity_
  1251. where
  1252. testentity_.id=?
  1253. ######### linkNoProxy = #5:linkNoProxy
  1254. ######### linkNoProxySelect = #6:linkNoProxySelect
  1255. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  1256. ######### linkLazy = #9:linkLazy
  1257. ######### linkLazySelect = #10:linkLazySelect
  1258. ######### linkLazyJoin = #11:linkLazyJoin
  1259. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  1260. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  1261. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  1262. ######### ================================================================================
  1263. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  1264. ######### ################################################################################
  1265. ######### TEST 100 no graph no fetch printAll
  1266. ######### ################################################################################
  1267. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  1268. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  1269. ######### final Path<Long> id = root.get("id");
  1270. ######### query.where(builder.equal(id, 100L));
  1271. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  1272. ######### final TestEntity test = tq.getSingleResult();
  1273. Hibernate:
  1274. select
  1275. testentity0_.id as id1_28_,
  1276. testentity0_.link_id as link_id4_28_,
  1277. testentity0_.linkJoin_id as linkjoin5_28_,
  1278. testentity0_.linkLazy_id as linklazy6_28_,
  1279. testentity0_.linkLazyJoin_id as linklazy7_28_,
  1280. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_,
  1281. testentity0_.linkLazySelect_id as linklaz11_28_,
  1282. testentity0_.linkNoProxyJoin_id as linknop13_28_,
  1283. testentity0_.linkSelect_id as linksel15_28_,
  1284. testentity0_.name as name2_28_,
  1285. testentity0_.version as version3_28_
  1286. from
  1287. loading_test testentity0_
  1288. where
  1289. testentity0_.id=100
  1290. Hibernate:
  1291. select
  1292. testentity0_.id as id1_28_0_,
  1293. testentity0_.link_id as link_id4_28_0_,
  1294. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1295. testentity0_.linkLazy_id as linklazy6_28_0_,
  1296. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1297. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1298. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1299. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1300. testentity0_.linkSelect_id as linksel15_28_0_,
  1301. testentity0_.name as name2_28_0_,
  1302. testentity0_.version as version3_28_0_,
  1303. testentity1_.id as id1_28_1_,
  1304. testentity1_.link_id as link_id4_28_1_,
  1305. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1306. testentity1_.linkLazy_id as linklazy6_28_1_,
  1307. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1308. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1309. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1310. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1311. testentity1_.linkSelect_id as linksel15_28_1_,
  1312. testentity1_.name as name2_28_1_,
  1313. testentity1_.version as version3_28_1_,
  1314. testentity2_.id as id1_28_2_,
  1315. testentity2_.link_id as link_id4_28_2_,
  1316. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1317. testentity2_.linkLazy_id as linklazy6_28_2_,
  1318. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1319. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1320. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1321. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1322. testentity2_.linkSelect_id as linksel15_28_2_,
  1323. testentity2_.name as name2_28_2_,
  1324. testentity2_.version as version3_28_2_,
  1325. testentity3_.id as id1_28_3_,
  1326. testentity3_.link_id as link_id4_28_3_,
  1327. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1328. testentity3_.linkLazy_id as linklazy6_28_3_,
  1329. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1330. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1331. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1332. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1333. testentity3_.linkSelect_id as linksel15_28_3_,
  1334. testentity3_.name as name2_28_3_,
  1335. testentity3_.version as version3_28_3_,
  1336. testentity4_.id as id1_28_4_,
  1337. testentity4_.link_id as link_id4_28_4_,
  1338. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1339. testentity4_.linkLazy_id as linklazy6_28_4_,
  1340. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1341. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1342. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1343. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1344. testentity4_.linkSelect_id as linksel15_28_4_,
  1345. testentity4_.name as name2_28_4_,
  1346. testentity4_.version as version3_28_4_,
  1347. testentity5_.id as id1_28_5_,
  1348. testentity5_.link_id as link_id4_28_5_,
  1349. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1350. testentity5_.linkLazy_id as linklazy6_28_5_,
  1351. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1352. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1353. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1354. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1355. testentity5_.linkSelect_id as linksel15_28_5_,
  1356. testentity5_.name as name2_28_5_,
  1357. testentity5_.version as version3_28_5_,
  1358. testentity6_.id as id1_28_6_,
  1359. testentity6_.link_id as link_id4_28_6_,
  1360. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1361. testentity6_.linkLazy_id as linklazy6_28_6_,
  1362. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1363. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1364. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1365. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1366. testentity6_.linkSelect_id as linksel15_28_6_,
  1367. testentity6_.name as name2_28_6_,
  1368. testentity6_.version as version3_28_6_
  1369. from
  1370. loading_test testentity0_
  1371. left outer join
  1372. loading_test testentity1_
  1373. on testentity0_.link_id=testentity1_.id
  1374. left outer join
  1375. loading_test testentity2_
  1376. on testentity1_.linkJoin_id=testentity2_.id
  1377. left outer join
  1378. loading_test testentity3_
  1379. on testentity2_.linkLazyJoin_id=testentity3_.id
  1380. left outer join
  1381. loading_test testentity4_
  1382. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  1383. left outer join
  1384. loading_test testentity5_
  1385. on testentity4_.linkNoProxy_id=testentity5_.id
  1386. left outer join
  1387. loading_test testentity6_
  1388. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  1389. where
  1390. testentity0_.id in (
  1391. ?, ?, ?, ?, ?, ?, ?, ?
  1392. )
  1393. ######### test.reportInitializationState();
  1394. ######### ================================================================================
  1395. ######### #100:no-graph Initialization State
  1396. ######### --------------------------------------------------------------------------------
  1397. ######### link: YES 5/5
  1398. ######### linkJoin: YES 5/5
  1399. ######### linkLazy: YES 5/5
  1400. ######### linkLazyJoin: YES 5/5
  1401. ######### linkLazyNoProxy: n/a 0/5
  1402. ######### linkLazyNoProxyJoin: YES 5/5
  1403. ######### linkLazyNoProxySelect: n/a 0/5
  1404. ######### linkLazySelect: YES 5/5
  1405. ######### linkNoProxy: n/a 0/5
  1406. ######### linkNoProxyJoin: YES 5/5
  1407. ######### linkNoProxySelect: n/a 0/5
  1408. ######### linkSelect: YES 5/5
  1409. ######### --------------------------------------------------------------------------------
  1410. ######### #100:no-graph Reflection State
  1411. ######### --------------------------------------------------------------------------------
  1412. ######### link: HERE 5/5
  1413. ######### linkJoin: HERE 5/5
  1414. ######### linkLazy: HERE 5/5
  1415. ######### linkLazyJoin: HERE 5/5
  1416. ######### linkLazyNoProxy: null 0/5
  1417. ######### linkLazyNoProxyJoin: HERE 5/5
  1418. ######### linkLazyNoProxySelect: null 0/5
  1419. ######### linkLazySelect: HERE 5/5
  1420. ######### linkNoProxy: null 0/5
  1421. ######### linkNoProxyJoin: HERE 5/5
  1422. ######### linkNoProxySelect: null 0/5
  1423. ######### linkSelect: HERE 5/5
  1424. ######### ================================================================================
  1425. ######### test.printAll();
  1426. ######### ================================================================================
  1427. ######### #100:no-graph
  1428. ######### --------------------------------------------------------------------------------
  1429. ######### link = #1:link
  1430. ######### linkSelect = #2:linkSelect
  1431. ######### linkJoin = #3:linkJoin
  1432. Hibernate:
  1433. select
  1434. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  1435. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  1436. testentity_.linkNoProxy_id as linknop12_28_,
  1437. testentity_.linkNoProxySelect_id as linknop14_28_
  1438. from
  1439. loading_test testentity_
  1440. where
  1441. testentity_.id=?
  1442. Hibernate:
  1443. select
  1444. testentity0_.id as id1_28_0_,
  1445. testentity0_.link_id as link_id4_28_0_,
  1446. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1447. testentity0_.linkLazy_id as linklazy6_28_0_,
  1448. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1449. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1450. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1451. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1452. testentity0_.linkSelect_id as linksel15_28_0_,
  1453. testentity0_.name as name2_28_0_,
  1454. testentity0_.version as version3_28_0_,
  1455. testentity1_.id as id1_28_1_,
  1456. testentity1_.link_id as link_id4_28_1_,
  1457. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1458. testentity1_.linkLazy_id as linklazy6_28_1_,
  1459. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1460. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1461. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1462. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1463. testentity1_.linkSelect_id as linksel15_28_1_,
  1464. testentity1_.name as name2_28_1_,
  1465. testentity1_.version as version3_28_1_,
  1466. testentity2_.id as id1_28_2_,
  1467. testentity2_.link_id as link_id4_28_2_,
  1468. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1469. testentity2_.linkLazy_id as linklazy6_28_2_,
  1470. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1471. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1472. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1473. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1474. testentity2_.linkSelect_id as linksel15_28_2_,
  1475. testentity2_.name as name2_28_2_,
  1476. testentity2_.version as version3_28_2_,
  1477. testentity3_.id as id1_28_3_,
  1478. testentity3_.link_id as link_id4_28_3_,
  1479. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1480. testentity3_.linkLazy_id as linklazy6_28_3_,
  1481. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1482. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1483. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1484. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1485. testentity3_.linkSelect_id as linksel15_28_3_,
  1486. testentity3_.name as name2_28_3_,
  1487. testentity3_.version as version3_28_3_,
  1488. testentity4_.id as id1_28_4_,
  1489. testentity4_.link_id as link_id4_28_4_,
  1490. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1491. testentity4_.linkLazy_id as linklazy6_28_4_,
  1492. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1493. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1494. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1495. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1496. testentity4_.linkSelect_id as linksel15_28_4_,
  1497. testentity4_.name as name2_28_4_,
  1498. testentity4_.version as version3_28_4_,
  1499. testentity5_.id as id1_28_5_,
  1500. testentity5_.link_id as link_id4_28_5_,
  1501. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1502. testentity5_.linkLazy_id as linklazy6_28_5_,
  1503. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1504. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1505. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1506. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1507. testentity5_.linkSelect_id as linksel15_28_5_,
  1508. testentity5_.name as name2_28_5_,
  1509. testentity5_.version as version3_28_5_,
  1510. testentity6_.id as id1_28_6_,
  1511. testentity6_.link_id as link_id4_28_6_,
  1512. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1513. testentity6_.linkLazy_id as linklazy6_28_6_,
  1514. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1515. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1516. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1517. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1518. testentity6_.linkSelect_id as linksel15_28_6_,
  1519. testentity6_.name as name2_28_6_,
  1520. testentity6_.version as version3_28_6_
  1521. from
  1522. loading_test testentity0_
  1523. left outer join
  1524. loading_test testentity1_
  1525. on testentity0_.link_id=testentity1_.id
  1526. left outer join
  1527. loading_test testentity2_
  1528. on testentity1_.linkJoin_id=testentity2_.id
  1529. left outer join
  1530. loading_test testentity3_
  1531. on testentity2_.linkLazyJoin_id=testentity3_.id
  1532. left outer join
  1533. loading_test testentity4_
  1534. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  1535. left outer join
  1536. loading_test testentity5_
  1537. on testentity4_.linkNoProxy_id=testentity5_.id
  1538. left outer join
  1539. loading_test testentity6_
  1540. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  1541. where
  1542. testentity0_.id=?
  1543. Hibernate:
  1544. select
  1545. testentity0_.id as id1_28_0_,
  1546. testentity0_.link_id as link_id4_28_0_,
  1547. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1548. testentity0_.linkLazy_id as linklazy6_28_0_,
  1549. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1550. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1551. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1552. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1553. testentity0_.linkSelect_id as linksel15_28_0_,
  1554. testentity0_.name as name2_28_0_,
  1555. testentity0_.version as version3_28_0_,
  1556. testentity1_.id as id1_28_1_,
  1557. testentity1_.link_id as link_id4_28_1_,
  1558. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1559. testentity1_.linkLazy_id as linklazy6_28_1_,
  1560. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1561. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1562. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1563. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1564. testentity1_.linkSelect_id as linksel15_28_1_,
  1565. testentity1_.name as name2_28_1_,
  1566. testentity1_.version as version3_28_1_,
  1567. testentity2_.id as id1_28_2_,
  1568. testentity2_.link_id as link_id4_28_2_,
  1569. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1570. testentity2_.linkLazy_id as linklazy6_28_2_,
  1571. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1572. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1573. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1574. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1575. testentity2_.linkSelect_id as linksel15_28_2_,
  1576. testentity2_.name as name2_28_2_,
  1577. testentity2_.version as version3_28_2_,
  1578. testentity3_.id as id1_28_3_,
  1579. testentity3_.link_id as link_id4_28_3_,
  1580. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1581. testentity3_.linkLazy_id as linklazy6_28_3_,
  1582. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1583. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1584. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1585. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1586. testentity3_.linkSelect_id as linksel15_28_3_,
  1587. testentity3_.name as name2_28_3_,
  1588. testentity3_.version as version3_28_3_,
  1589. testentity4_.id as id1_28_4_,
  1590. testentity4_.link_id as link_id4_28_4_,
  1591. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1592. testentity4_.linkLazy_id as linklazy6_28_4_,
  1593. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1594. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1595. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1596. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1597. testentity4_.linkSelect_id as linksel15_28_4_,
  1598. testentity4_.name as name2_28_4_,
  1599. testentity4_.version as version3_28_4_,
  1600. testentity5_.id as id1_28_5_,
  1601. testentity5_.link_id as link_id4_28_5_,
  1602. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1603. testentity5_.linkLazy_id as linklazy6_28_5_,
  1604. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1605. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1606. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1607. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1608. testentity5_.linkSelect_id as linksel15_28_5_,
  1609. testentity5_.name as name2_28_5_,
  1610. testentity5_.version as version3_28_5_,
  1611. testentity6_.id as id1_28_6_,
  1612. testentity6_.link_id as link_id4_28_6_,
  1613. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1614. testentity6_.linkLazy_id as linklazy6_28_6_,
  1615. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1616. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1617. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1618. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1619. testentity6_.linkSelect_id as linksel15_28_6_,
  1620. testentity6_.name as name2_28_6_,
  1621. testentity6_.version as version3_28_6_
  1622. from
  1623. loading_test testentity0_
  1624. left outer join
  1625. loading_test testentity1_
  1626. on testentity0_.link_id=testentity1_.id
  1627. left outer join
  1628. loading_test testentity2_
  1629. on testentity1_.linkJoin_id=testentity2_.id
  1630. left outer join
  1631. loading_test testentity3_
  1632. on testentity2_.linkLazyJoin_id=testentity3_.id
  1633. left outer join
  1634. loading_test testentity4_
  1635. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  1636. left outer join
  1637. loading_test testentity5_
  1638. on testentity4_.linkNoProxy_id=testentity5_.id
  1639. left outer join
  1640. loading_test testentity6_
  1641. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  1642. where
  1643. testentity0_.id=?
  1644. Hibernate:
  1645. select
  1646. testentity0_.id as id1_28_0_,
  1647. testentity0_.link_id as link_id4_28_0_,
  1648. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1649. testentity0_.linkLazy_id as linklazy6_28_0_,
  1650. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1651. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1652. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1653. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1654. testentity0_.linkSelect_id as linksel15_28_0_,
  1655. testentity0_.name as name2_28_0_,
  1656. testentity0_.version as version3_28_0_,
  1657. testentity1_.id as id1_28_1_,
  1658. testentity1_.link_id as link_id4_28_1_,
  1659. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1660. testentity1_.linkLazy_id as linklazy6_28_1_,
  1661. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1662. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1663. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1664. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1665. testentity1_.linkSelect_id as linksel15_28_1_,
  1666. testentity1_.name as name2_28_1_,
  1667. testentity1_.version as version3_28_1_,
  1668. testentity2_.id as id1_28_2_,
  1669. testentity2_.link_id as link_id4_28_2_,
  1670. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1671. testentity2_.linkLazy_id as linklazy6_28_2_,
  1672. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1673. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1674. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1675. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1676. testentity2_.linkSelect_id as linksel15_28_2_,
  1677. testentity2_.name as name2_28_2_,
  1678. testentity2_.version as version3_28_2_,
  1679. testentity3_.id as id1_28_3_,
  1680. testentity3_.link_id as link_id4_28_3_,
  1681. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1682. testentity3_.linkLazy_id as linklazy6_28_3_,
  1683. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1684. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1685. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1686. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1687. testentity3_.linkSelect_id as linksel15_28_3_,
  1688. testentity3_.name as name2_28_3_,
  1689. testentity3_.version as version3_28_3_,
  1690. testentity4_.id as id1_28_4_,
  1691. testentity4_.link_id as link_id4_28_4_,
  1692. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1693. testentity4_.linkLazy_id as linklazy6_28_4_,
  1694. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1695. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1696. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1697. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1698. testentity4_.linkSelect_id as linksel15_28_4_,
  1699. testentity4_.name as name2_28_4_,
  1700. testentity4_.version as version3_28_4_,
  1701. testentity5_.id as id1_28_5_,
  1702. testentity5_.link_id as link_id4_28_5_,
  1703. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1704. testentity5_.linkLazy_id as linklazy6_28_5_,
  1705. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1706. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1707. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1708. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1709. testentity5_.linkSelect_id as linksel15_28_5_,
  1710. testentity5_.name as name2_28_5_,
  1711. testentity5_.version as version3_28_5_,
  1712. testentity6_.id as id1_28_6_,
  1713. testentity6_.link_id as link_id4_28_6_,
  1714. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1715. testentity6_.linkLazy_id as linklazy6_28_6_,
  1716. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1717. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1718. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1719. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1720. testentity6_.linkSelect_id as linksel15_28_6_,
  1721. testentity6_.name as name2_28_6_,
  1722. testentity6_.version as version3_28_6_
  1723. from
  1724. loading_test testentity0_
  1725. left outer join
  1726. loading_test testentity1_
  1727. on testentity0_.link_id=testentity1_.id
  1728. left outer join
  1729. loading_test testentity2_
  1730. on testentity1_.linkJoin_id=testentity2_.id
  1731. left outer join
  1732. loading_test testentity3_
  1733. on testentity2_.linkLazyJoin_id=testentity3_.id
  1734. left outer join
  1735. loading_test testentity4_
  1736. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  1737. left outer join
  1738. loading_test testentity5_
  1739. on testentity4_.linkNoProxy_id=testentity5_.id
  1740. left outer join
  1741. loading_test testentity6_
  1742. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  1743. where
  1744. testentity0_.id=?
  1745. ######### linkNoProxy = #5:linkNoProxy
  1746. ######### linkNoProxySelect = #6:linkNoProxySelect
  1747. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  1748. ######### linkLazy = #9:linkLazy
  1749. ######### linkLazySelect = #10:linkLazySelect
  1750. ######### linkLazyJoin = #11:linkLazyJoin
  1751. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  1752. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  1753. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  1754. ######### ================================================================================
  1755. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  1756. ######### ################################################################################
  1757. ######### TEST 101 graph=1/javax.persistence.loadgraph no fetch printAll
  1758. ######### ################################################################################
  1759. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  1760. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  1761. ######### final Path<Long> id = root.get("id");
  1762. ######### query.where(builder.equal(id, 101L));
  1763. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  1764. ######### final String graphText = "link, linkSelect, linkJoin, linkNoProxy, linkNoProxySelect, linkNoProxyJoin, linkLazy, linkLazySelect, linkLazyJoin, linkLazyNoProxy, linkLazyNoProxySelect, linkLazyNoProxyJoin";
  1765. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  1766. ######### tq.setHint("javax.persistence.loadgraph", entityGraph);
  1767. ######### final TestEntity test = tq.getSingleResult();
  1768. Hibernate:
  1769. select
  1770. testentity0_.id as id1_28_0_,
  1771. testentity1_.id as id1_28_1_,
  1772. testentity2_.id as id1_28_2_,
  1773. testentity3_.id as id1_28_3_,
  1774. testentity4_.id as id1_28_4_,
  1775. testentity5_.id as id1_28_5_,
  1776. testentity6_.id as id1_28_6_,
  1777. testentity7_.id as id1_28_7_,
  1778. testentity8_.id as id1_28_8_,
  1779. testentity9_.id as id1_28_9_,
  1780. testentity10_.id as id1_28_10_,
  1781. testentity11_.id as id1_28_11_,
  1782. testentity12_.id as id1_28_12_,
  1783. testentity0_.link_id as link_id4_28_0_,
  1784. testentity0_.linkJoin_id as linkjoin5_28_0_,
  1785. testentity0_.linkLazy_id as linklazy6_28_0_,
  1786. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  1787. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  1788. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  1789. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  1790. testentity0_.linkSelect_id as linksel15_28_0_,
  1791. testentity0_.name as name2_28_0_,
  1792. testentity0_.version as version3_28_0_,
  1793. testentity1_.link_id as link_id4_28_1_,
  1794. testentity1_.linkJoin_id as linkjoin5_28_1_,
  1795. testentity1_.linkLazy_id as linklazy6_28_1_,
  1796. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  1797. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  1798. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  1799. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  1800. testentity1_.linkSelect_id as linksel15_28_1_,
  1801. testentity1_.name as name2_28_1_,
  1802. testentity1_.version as version3_28_1_,
  1803. testentity2_.link_id as link_id4_28_2_,
  1804. testentity2_.linkJoin_id as linkjoin5_28_2_,
  1805. testentity2_.linkLazy_id as linklazy6_28_2_,
  1806. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  1807. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  1808. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  1809. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  1810. testentity2_.linkSelect_id as linksel15_28_2_,
  1811. testentity2_.name as name2_28_2_,
  1812. testentity2_.version as version3_28_2_,
  1813. testentity3_.link_id as link_id4_28_3_,
  1814. testentity3_.linkJoin_id as linkjoin5_28_3_,
  1815. testentity3_.linkLazy_id as linklazy6_28_3_,
  1816. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  1817. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  1818. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  1819. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  1820. testentity3_.linkSelect_id as linksel15_28_3_,
  1821. testentity3_.name as name2_28_3_,
  1822. testentity3_.version as version3_28_3_,
  1823. testentity4_.link_id as link_id4_28_4_,
  1824. testentity4_.linkJoin_id as linkjoin5_28_4_,
  1825. testentity4_.linkLazy_id as linklazy6_28_4_,
  1826. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  1827. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  1828. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  1829. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  1830. testentity4_.linkSelect_id as linksel15_28_4_,
  1831. testentity4_.name as name2_28_4_,
  1832. testentity4_.version as version3_28_4_,
  1833. testentity5_.link_id as link_id4_28_5_,
  1834. testentity5_.linkJoin_id as linkjoin5_28_5_,
  1835. testentity5_.linkLazy_id as linklazy6_28_5_,
  1836. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  1837. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  1838. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  1839. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  1840. testentity5_.linkSelect_id as linksel15_28_5_,
  1841. testentity5_.name as name2_28_5_,
  1842. testentity5_.version as version3_28_5_,
  1843. testentity6_.link_id as link_id4_28_6_,
  1844. testentity6_.linkJoin_id as linkjoin5_28_6_,
  1845. testentity6_.linkLazy_id as linklazy6_28_6_,
  1846. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  1847. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  1848. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  1849. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  1850. testentity6_.linkSelect_id as linksel15_28_6_,
  1851. testentity6_.name as name2_28_6_,
  1852. testentity6_.version as version3_28_6_,
  1853. testentity7_.link_id as link_id4_28_7_,
  1854. testentity7_.linkJoin_id as linkjoin5_28_7_,
  1855. testentity7_.linkLazy_id as linklazy6_28_7_,
  1856. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  1857. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  1858. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  1859. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  1860. testentity7_.linkSelect_id as linksel15_28_7_,
  1861. testentity7_.name as name2_28_7_,
  1862. testentity7_.version as version3_28_7_,
  1863. testentity8_.link_id as link_id4_28_8_,
  1864. testentity8_.linkJoin_id as linkjoin5_28_8_,
  1865. testentity8_.linkLazy_id as linklazy6_28_8_,
  1866. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  1867. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  1868. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  1869. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  1870. testentity8_.linkSelect_id as linksel15_28_8_,
  1871. testentity8_.name as name2_28_8_,
  1872. testentity8_.version as version3_28_8_,
  1873. testentity9_.link_id as link_id4_28_9_,
  1874. testentity9_.linkJoin_id as linkjoin5_28_9_,
  1875. testentity9_.linkLazy_id as linklazy6_28_9_,
  1876. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  1877. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  1878. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  1879. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  1880. testentity9_.linkSelect_id as linksel15_28_9_,
  1881. testentity9_.name as name2_28_9_,
  1882. testentity9_.version as version3_28_9_,
  1883. testentity10_.link_id as link_id4_28_10_,
  1884. testentity10_.linkJoin_id as linkjoin5_28_10_,
  1885. testentity10_.linkLazy_id as linklazy6_28_10_,
  1886. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  1887. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  1888. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  1889. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  1890. testentity10_.linkSelect_id as linksel15_28_10_,
  1891. testentity10_.name as name2_28_10_,
  1892. testentity10_.version as version3_28_10_,
  1893. testentity11_.link_id as link_id4_28_11_,
  1894. testentity11_.linkJoin_id as linkjoin5_28_11_,
  1895. testentity11_.linkLazy_id as linklazy6_28_11_,
  1896. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  1897. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  1898. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  1899. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  1900. testentity11_.linkSelect_id as linksel15_28_11_,
  1901. testentity11_.name as name2_28_11_,
  1902. testentity11_.version as version3_28_11_,
  1903. testentity12_.link_id as link_id4_28_12_,
  1904. testentity12_.linkJoin_id as linkjoin5_28_12_,
  1905. testentity12_.linkLazy_id as linklazy6_28_12_,
  1906. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  1907. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  1908. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  1909. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  1910. testentity12_.linkSelect_id as linksel15_28_12_,
  1911. testentity12_.name as name2_28_12_,
  1912. testentity12_.version as version3_28_12_
  1913. from
  1914. loading_test testentity0_
  1915. left outer join
  1916. loading_test testentity1_
  1917. on testentity0_.link_id=testentity1_.id
  1918. left outer join
  1919. loading_test testentity2_
  1920. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  1921. left outer join
  1922. loading_test testentity3_
  1923. on testentity0_.linkLazyJoin_id=testentity3_.id
  1924. left outer join
  1925. loading_test testentity4_
  1926. on testentity0_.linkSelect_id=testentity4_.id
  1927. left outer join
  1928. loading_test testentity5_
  1929. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  1930. left outer join
  1931. loading_test testentity6_
  1932. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  1933. left outer join
  1934. loading_test testentity7_
  1935. on testentity0_.linkLazySelect_id=testentity7_.id
  1936. left outer join
  1937. loading_test testentity8_
  1938. on testentity0_.linkNoProxy_id=testentity8_.id
  1939. left outer join
  1940. loading_test testentity9_
  1941. on testentity0_.linkLazy_id=testentity9_.id
  1942. left outer join
  1943. loading_test testentity10_
  1944. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  1945. left outer join
  1946. loading_test testentity11_
  1947. on testentity0_.linkJoin_id=testentity11_.id
  1948. left outer join
  1949. loading_test testentity12_
  1950. on testentity0_.linkNoProxySelect_id=testentity12_.id
  1951. where
  1952. testentity0_.id=101
  1953. ######### test.reportInitializationState();
  1954. ######### ================================================================================
  1955. ######### #101:shallow-graph Initialization State
  1956. ######### --------------------------------------------------------------------------------
  1957. ######### link: YES 6/6
  1958. ######### linkJoin: YES 6/6
  1959. ######### linkLazy: YES 6/6
  1960. ######### linkLazyJoin: YES 6/6
  1961. ######### linkLazyNoProxy: n/a 0/6
  1962. ######### linkLazyNoProxyJoin: YES 6/6
  1963. ######### linkLazyNoProxySelect: n/a 0/6
  1964. ######### linkLazySelect: YES 6/6
  1965. ######### linkNoProxy: n/a 0/6
  1966. ######### linkNoProxyJoin: YES 6/6
  1967. ######### linkNoProxySelect: n/a 0/6
  1968. ######### linkSelect: YES 6/6
  1969. ######### --------------------------------------------------------------------------------
  1970. ######### #101:shallow-graph Reflection State
  1971. ######### --------------------------------------------------------------------------------
  1972. ######### link: HERE 6/6
  1973. ######### linkJoin: HERE 6/6
  1974. ######### linkLazy: HERE 6/6
  1975. ######### linkLazyJoin: HERE 6/6
  1976. ######### linkLazyNoProxy: null 0/6
  1977. ######### linkLazyNoProxyJoin: HERE 6/6
  1978. ######### linkLazyNoProxySelect: null 0/6
  1979. ######### linkLazySelect: HERE 6/6
  1980. ######### linkNoProxy: null 0/6
  1981. ######### linkNoProxyJoin: HERE 6/6
  1982. ######### linkNoProxySelect: null 0/6
  1983. ######### linkSelect: HERE 6/6
  1984. ######### ================================================================================
  1985. ######### test.printAll();
  1986. ######### ================================================================================
  1987. ######### #101:shallow-graph
  1988. ######### --------------------------------------------------------------------------------
  1989. ######### link = #1:link
  1990. ######### linkSelect = #2:linkSelect
  1991. ######### linkJoin = #3:linkJoin
  1992. Hibernate:
  1993. select
  1994. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  1995. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  1996. testentity_.linkNoProxy_id as linknop12_28_,
  1997. testentity_.linkNoProxySelect_id as linknop14_28_
  1998. from
  1999. loading_test testentity_
  2000. where
  2001. testentity_.id=?
  2002. ######### linkNoProxy = #5:linkNoProxy
  2003. ######### linkNoProxySelect = #6:linkNoProxySelect
  2004. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  2005. ######### linkLazy = #9:linkLazy
  2006. ######### linkLazySelect = #10:linkLazySelect
  2007. ######### linkLazyJoin = #11:linkLazyJoin
  2008. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  2009. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  2010. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  2011. ######### ================================================================================
  2012. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  2013. ######### ################################################################################
  2014. ######### TEST 102 graph=2/javax.persistence.loadgraph no fetch printAll
  2015. ######### ################################################################################
  2016. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  2017. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  2018. ######### final Path<Long> id = root.get("id");
  2019. ######### query.where(builder.equal(id, 102L));
  2020. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  2021. ######### final String graphText = "link(id), linkSelect(id), linkJoin(id), linkNoProxy(id), linkNoProxySelect(id), linkNoProxyJoin(id), linkLazy(id), linkLazySelect(id), linkLazyJoin(id), linkLazyNoProxy(id), linkLazyNoProxySelect(id), linkLazyNoProxyJoin(id)";
  2022. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  2023. ######### tq.setHint("javax.persistence.loadgraph", entityGraph);
  2024. ######### final TestEntity test = tq.getSingleResult();
  2025. Hibernate:
  2026. select
  2027. testentity0_.id as id1_28_0_,
  2028. testentity1_.id as id1_28_1_,
  2029. testentity2_.id as id1_28_2_,
  2030. testentity3_.id as id1_28_3_,
  2031. testentity4_.id as id1_28_4_,
  2032. testentity5_.id as id1_28_5_,
  2033. testentity6_.id as id1_28_6_,
  2034. testentity7_.id as id1_28_7_,
  2035. testentity8_.id as id1_28_8_,
  2036. testentity9_.id as id1_28_9_,
  2037. testentity10_.id as id1_28_10_,
  2038. testentity11_.id as id1_28_11_,
  2039. testentity12_.id as id1_28_12_,
  2040. testentity0_.link_id as link_id4_28_0_,
  2041. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2042. testentity0_.linkLazy_id as linklazy6_28_0_,
  2043. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2044. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2045. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2046. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2047. testentity0_.linkSelect_id as linksel15_28_0_,
  2048. testentity0_.name as name2_28_0_,
  2049. testentity0_.version as version3_28_0_,
  2050. testentity1_.link_id as link_id4_28_1_,
  2051. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2052. testentity1_.linkLazy_id as linklazy6_28_1_,
  2053. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2054. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2055. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2056. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2057. testentity1_.linkSelect_id as linksel15_28_1_,
  2058. testentity1_.name as name2_28_1_,
  2059. testentity1_.version as version3_28_1_,
  2060. testentity2_.link_id as link_id4_28_2_,
  2061. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2062. testentity2_.linkLazy_id as linklazy6_28_2_,
  2063. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2064. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2065. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2066. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2067. testentity2_.linkSelect_id as linksel15_28_2_,
  2068. testentity2_.name as name2_28_2_,
  2069. testentity2_.version as version3_28_2_,
  2070. testentity3_.link_id as link_id4_28_3_,
  2071. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2072. testentity3_.linkLazy_id as linklazy6_28_3_,
  2073. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2074. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2075. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2076. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2077. testentity3_.linkSelect_id as linksel15_28_3_,
  2078. testentity3_.name as name2_28_3_,
  2079. testentity3_.version as version3_28_3_,
  2080. testentity4_.link_id as link_id4_28_4_,
  2081. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2082. testentity4_.linkLazy_id as linklazy6_28_4_,
  2083. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2084. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2085. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2086. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2087. testentity4_.linkSelect_id as linksel15_28_4_,
  2088. testentity4_.name as name2_28_4_,
  2089. testentity4_.version as version3_28_4_,
  2090. testentity5_.link_id as link_id4_28_5_,
  2091. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2092. testentity5_.linkLazy_id as linklazy6_28_5_,
  2093. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2094. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2095. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2096. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2097. testentity5_.linkSelect_id as linksel15_28_5_,
  2098. testentity5_.name as name2_28_5_,
  2099. testentity5_.version as version3_28_5_,
  2100. testentity6_.link_id as link_id4_28_6_,
  2101. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2102. testentity6_.linkLazy_id as linklazy6_28_6_,
  2103. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2104. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2105. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2106. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2107. testentity6_.linkSelect_id as linksel15_28_6_,
  2108. testentity6_.name as name2_28_6_,
  2109. testentity6_.version as version3_28_6_,
  2110. testentity7_.link_id as link_id4_28_7_,
  2111. testentity7_.linkJoin_id as linkjoin5_28_7_,
  2112. testentity7_.linkLazy_id as linklazy6_28_7_,
  2113. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  2114. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  2115. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  2116. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  2117. testentity7_.linkSelect_id as linksel15_28_7_,
  2118. testentity7_.name as name2_28_7_,
  2119. testentity7_.version as version3_28_7_,
  2120. testentity8_.link_id as link_id4_28_8_,
  2121. testentity8_.linkJoin_id as linkjoin5_28_8_,
  2122. testentity8_.linkLazy_id as linklazy6_28_8_,
  2123. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  2124. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  2125. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  2126. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  2127. testentity8_.linkSelect_id as linksel15_28_8_,
  2128. testentity8_.name as name2_28_8_,
  2129. testentity8_.version as version3_28_8_,
  2130. testentity9_.link_id as link_id4_28_9_,
  2131. testentity9_.linkJoin_id as linkjoin5_28_9_,
  2132. testentity9_.linkLazy_id as linklazy6_28_9_,
  2133. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  2134. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  2135. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  2136. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  2137. testentity9_.linkSelect_id as linksel15_28_9_,
  2138. testentity9_.name as name2_28_9_,
  2139. testentity9_.version as version3_28_9_,
  2140. testentity10_.link_id as link_id4_28_10_,
  2141. testentity10_.linkJoin_id as linkjoin5_28_10_,
  2142. testentity10_.linkLazy_id as linklazy6_28_10_,
  2143. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  2144. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  2145. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  2146. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  2147. testentity10_.linkSelect_id as linksel15_28_10_,
  2148. testentity10_.name as name2_28_10_,
  2149. testentity10_.version as version3_28_10_,
  2150. testentity11_.link_id as link_id4_28_11_,
  2151. testentity11_.linkJoin_id as linkjoin5_28_11_,
  2152. testentity11_.linkLazy_id as linklazy6_28_11_,
  2153. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  2154. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  2155. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  2156. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  2157. testentity11_.linkSelect_id as linksel15_28_11_,
  2158. testentity11_.name as name2_28_11_,
  2159. testentity11_.version as version3_28_11_,
  2160. testentity12_.link_id as link_id4_28_12_,
  2161. testentity12_.linkJoin_id as linkjoin5_28_12_,
  2162. testentity12_.linkLazy_id as linklazy6_28_12_,
  2163. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  2164. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  2165. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  2166. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  2167. testentity12_.linkSelect_id as linksel15_28_12_,
  2168. testentity12_.name as name2_28_12_,
  2169. testentity12_.version as version3_28_12_
  2170. from
  2171. loading_test testentity0_
  2172. left outer join
  2173. loading_test testentity1_
  2174. on testentity0_.link_id=testentity1_.id
  2175. left outer join
  2176. loading_test testentity2_
  2177. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  2178. left outer join
  2179. loading_test testentity3_
  2180. on testentity0_.linkLazyJoin_id=testentity3_.id
  2181. left outer join
  2182. loading_test testentity4_
  2183. on testentity0_.linkSelect_id=testentity4_.id
  2184. left outer join
  2185. loading_test testentity5_
  2186. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  2187. left outer join
  2188. loading_test testentity6_
  2189. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  2190. left outer join
  2191. loading_test testentity7_
  2192. on testentity0_.linkLazySelect_id=testentity7_.id
  2193. left outer join
  2194. loading_test testentity8_
  2195. on testentity0_.linkNoProxy_id=testentity8_.id
  2196. left outer join
  2197. loading_test testentity9_
  2198. on testentity0_.linkLazy_id=testentity9_.id
  2199. left outer join
  2200. loading_test testentity10_
  2201. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  2202. left outer join
  2203. loading_test testentity11_
  2204. on testentity0_.linkJoin_id=testentity11_.id
  2205. left outer join
  2206. loading_test testentity12_
  2207. on testentity0_.linkNoProxySelect_id=testentity12_.id
  2208. where
  2209. testentity0_.id=102
  2210. ######### test.reportInitializationState();
  2211. ######### ================================================================================
  2212. ######### #102:id-graph Initialization State
  2213. ######### --------------------------------------------------------------------------------
  2214. ######### link: YES 7/7
  2215. ######### linkJoin: YES 7/7
  2216. ######### linkLazy: YES 7/7
  2217. ######### linkLazyJoin: YES 7/7
  2218. ######### linkLazyNoProxy: n/a 0/7
  2219. ######### linkLazyNoProxyJoin: YES 7/7
  2220. ######### linkLazyNoProxySelect: n/a 0/7
  2221. ######### linkLazySelect: YES 7/7
  2222. ######### linkNoProxy: n/a 0/7
  2223. ######### linkNoProxyJoin: YES 7/7
  2224. ######### linkNoProxySelect: n/a 0/7
  2225. ######### linkSelect: YES 7/7
  2226. ######### --------------------------------------------------------------------------------
  2227. ######### #102:id-graph Reflection State
  2228. ######### --------------------------------------------------------------------------------
  2229. ######### link: HERE 7/7
  2230. ######### linkJoin: HERE 7/7
  2231. ######### linkLazy: HERE 7/7
  2232. ######### linkLazyJoin: HERE 7/7
  2233. ######### linkLazyNoProxy: null 0/7
  2234. ######### linkLazyNoProxyJoin: HERE 7/7
  2235. ######### linkLazyNoProxySelect: null 0/7
  2236. ######### linkLazySelect: HERE 7/7
  2237. ######### linkNoProxy: null 0/7
  2238. ######### linkNoProxyJoin: HERE 7/7
  2239. ######### linkNoProxySelect: null 0/7
  2240. ######### linkSelect: HERE 7/7
  2241. ######### ================================================================================
  2242. ######### test.printAll();
  2243. ######### ================================================================================
  2244. ######### #102:id-graph
  2245. ######### --------------------------------------------------------------------------------
  2246. ######### link = #1:link
  2247. ######### linkSelect = #2:linkSelect
  2248. ######### linkJoin = #3:linkJoin
  2249. Hibernate:
  2250. select
  2251. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  2252. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  2253. testentity_.linkNoProxy_id as linknop12_28_,
  2254. testentity_.linkNoProxySelect_id as linknop14_28_
  2255. from
  2256. loading_test testentity_
  2257. where
  2258. testentity_.id=?
  2259. ######### linkNoProxy = #5:linkNoProxy
  2260. ######### linkNoProxySelect = #6:linkNoProxySelect
  2261. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  2262. ######### linkLazy = #9:linkLazy
  2263. ######### linkLazySelect = #10:linkLazySelect
  2264. ######### linkLazyJoin = #11:linkLazyJoin
  2265. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  2266. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  2267. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  2268. ######### ================================================================================
  2269. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  2270. ######### ################################################################################
  2271. ######### TEST 103 graph=3/javax.persistence.loadgraph no fetch printAll
  2272. ######### ################################################################################
  2273. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  2274. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  2275. ######### final Path<Long> id = root.get("id");
  2276. ######### query.where(builder.equal(id, 103L));
  2277. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  2278. ######### final String graphText = "link(id, name), linkSelect(id, name), linkJoin(id, name), linkNoProxy(id, name), linkNoProxySelect(id, name), linkNoProxyJoin(id, name), linkLazy(id, name), linkLazySelect(id, name), linkLazyJoin(id, name), linkLazyNoProxy(id, name), linkLazyNoProxySelect(id, name), linkLazyNoProxyJoin(id, name)";
  2279. ######### final RootGraph<TestEntity> entityGraph = GraphParser.parse(TestEntity.class, graphText, session.getEntityManager());
  2280. ######### tq.setHint("javax.persistence.loadgraph", entityGraph);
  2281. ######### final TestEntity test = tq.getSingleResult();
  2282. Hibernate:
  2283. select
  2284. testentity0_.id as id1_28_0_,
  2285. testentity1_.id as id1_28_1_,
  2286. testentity2_.id as id1_28_2_,
  2287. testentity3_.id as id1_28_3_,
  2288. testentity4_.id as id1_28_4_,
  2289. testentity5_.id as id1_28_5_,
  2290. testentity6_.id as id1_28_6_,
  2291. testentity7_.id as id1_28_7_,
  2292. testentity8_.id as id1_28_8_,
  2293. testentity9_.id as id1_28_9_,
  2294. testentity10_.id as id1_28_10_,
  2295. testentity11_.id as id1_28_11_,
  2296. testentity12_.id as id1_28_12_,
  2297. testentity0_.link_id as link_id4_28_0_,
  2298. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2299. testentity0_.linkLazy_id as linklazy6_28_0_,
  2300. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2301. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2302. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2303. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2304. testentity0_.linkSelect_id as linksel15_28_0_,
  2305. testentity0_.name as name2_28_0_,
  2306. testentity0_.version as version3_28_0_,
  2307. testentity1_.link_id as link_id4_28_1_,
  2308. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2309. testentity1_.linkLazy_id as linklazy6_28_1_,
  2310. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2311. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2312. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2313. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2314. testentity1_.linkSelect_id as linksel15_28_1_,
  2315. testentity1_.name as name2_28_1_,
  2316. testentity1_.version as version3_28_1_,
  2317. testentity2_.link_id as link_id4_28_2_,
  2318. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2319. testentity2_.linkLazy_id as linklazy6_28_2_,
  2320. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2321. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2322. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2323. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2324. testentity2_.linkSelect_id as linksel15_28_2_,
  2325. testentity2_.name as name2_28_2_,
  2326. testentity2_.version as version3_28_2_,
  2327. testentity3_.link_id as link_id4_28_3_,
  2328. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2329. testentity3_.linkLazy_id as linklazy6_28_3_,
  2330. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2331. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2332. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2333. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2334. testentity3_.linkSelect_id as linksel15_28_3_,
  2335. testentity3_.name as name2_28_3_,
  2336. testentity3_.version as version3_28_3_,
  2337. testentity4_.link_id as link_id4_28_4_,
  2338. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2339. testentity4_.linkLazy_id as linklazy6_28_4_,
  2340. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2341. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2342. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2343. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2344. testentity4_.linkSelect_id as linksel15_28_4_,
  2345. testentity4_.name as name2_28_4_,
  2346. testentity4_.version as version3_28_4_,
  2347. testentity5_.link_id as link_id4_28_5_,
  2348. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2349. testentity5_.linkLazy_id as linklazy6_28_5_,
  2350. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2351. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2352. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2353. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2354. testentity5_.linkSelect_id as linksel15_28_5_,
  2355. testentity5_.name as name2_28_5_,
  2356. testentity5_.version as version3_28_5_,
  2357. testentity6_.link_id as link_id4_28_6_,
  2358. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2359. testentity6_.linkLazy_id as linklazy6_28_6_,
  2360. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2361. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2362. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2363. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2364. testentity6_.linkSelect_id as linksel15_28_6_,
  2365. testentity6_.name as name2_28_6_,
  2366. testentity6_.version as version3_28_6_,
  2367. testentity7_.link_id as link_id4_28_7_,
  2368. testentity7_.linkJoin_id as linkjoin5_28_7_,
  2369. testentity7_.linkLazy_id as linklazy6_28_7_,
  2370. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  2371. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  2372. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  2373. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  2374. testentity7_.linkSelect_id as linksel15_28_7_,
  2375. testentity7_.name as name2_28_7_,
  2376. testentity7_.version as version3_28_7_,
  2377. testentity8_.link_id as link_id4_28_8_,
  2378. testentity8_.linkJoin_id as linkjoin5_28_8_,
  2379. testentity8_.linkLazy_id as linklazy6_28_8_,
  2380. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  2381. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  2382. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  2383. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  2384. testentity8_.linkSelect_id as linksel15_28_8_,
  2385. testentity8_.name as name2_28_8_,
  2386. testentity8_.version as version3_28_8_,
  2387. testentity9_.link_id as link_id4_28_9_,
  2388. testentity9_.linkJoin_id as linkjoin5_28_9_,
  2389. testentity9_.linkLazy_id as linklazy6_28_9_,
  2390. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  2391. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  2392. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  2393. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  2394. testentity9_.linkSelect_id as linksel15_28_9_,
  2395. testentity9_.name as name2_28_9_,
  2396. testentity9_.version as version3_28_9_,
  2397. testentity10_.link_id as link_id4_28_10_,
  2398. testentity10_.linkJoin_id as linkjoin5_28_10_,
  2399. testentity10_.linkLazy_id as linklazy6_28_10_,
  2400. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  2401. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  2402. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  2403. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  2404. testentity10_.linkSelect_id as linksel15_28_10_,
  2405. testentity10_.name as name2_28_10_,
  2406. testentity10_.version as version3_28_10_,
  2407. testentity11_.link_id as link_id4_28_11_,
  2408. testentity11_.linkJoin_id as linkjoin5_28_11_,
  2409. testentity11_.linkLazy_id as linklazy6_28_11_,
  2410. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  2411. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  2412. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  2413. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  2414. testentity11_.linkSelect_id as linksel15_28_11_,
  2415. testentity11_.name as name2_28_11_,
  2416. testentity11_.version as version3_28_11_,
  2417. testentity12_.link_id as link_id4_28_12_,
  2418. testentity12_.linkJoin_id as linkjoin5_28_12_,
  2419. testentity12_.linkLazy_id as linklazy6_28_12_,
  2420. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  2421. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  2422. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  2423. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  2424. testentity12_.linkSelect_id as linksel15_28_12_,
  2425. testentity12_.name as name2_28_12_,
  2426. testentity12_.version as version3_28_12_
  2427. from
  2428. loading_test testentity0_
  2429. left outer join
  2430. loading_test testentity1_
  2431. on testentity0_.link_id=testentity1_.id
  2432. left outer join
  2433. loading_test testentity2_
  2434. on testentity0_.linkNoProxyJoin_id=testentity2_.id
  2435. left outer join
  2436. loading_test testentity3_
  2437. on testentity0_.linkLazyJoin_id=testentity3_.id
  2438. left outer join
  2439. loading_test testentity4_
  2440. on testentity0_.linkSelect_id=testentity4_.id
  2441. left outer join
  2442. loading_test testentity5_
  2443. on testentity0_.linkLazyNoProxyJoin_id=testentity5_.id
  2444. left outer join
  2445. loading_test testentity6_
  2446. on testentity0_.linkLazyNoProxySelect_id=testentity6_.id
  2447. left outer join
  2448. loading_test testentity7_
  2449. on testentity0_.linkLazySelect_id=testentity7_.id
  2450. left outer join
  2451. loading_test testentity8_
  2452. on testentity0_.linkNoProxy_id=testentity8_.id
  2453. left outer join
  2454. loading_test testentity9_
  2455. on testentity0_.linkLazy_id=testentity9_.id
  2456. left outer join
  2457. loading_test testentity10_
  2458. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  2459. left outer join
  2460. loading_test testentity11_
  2461. on testentity0_.linkJoin_id=testentity11_.id
  2462. left outer join
  2463. loading_test testentity12_
  2464. on testentity0_.linkNoProxySelect_id=testentity12_.id
  2465. where
  2466. testentity0_.id=103
  2467. ######### test.reportInitializationState();
  2468. ######### ================================================================================
  2469. ######### #103:id-name-graph Initialization State
  2470. ######### --------------------------------------------------------------------------------
  2471. ######### link: YES 8/8
  2472. ######### linkJoin: YES 8/8
  2473. ######### linkLazy: YES 8/8
  2474. ######### linkLazyJoin: YES 8/8
  2475. ######### linkLazyNoProxy: n/a 0/8
  2476. ######### linkLazyNoProxyJoin: YES 8/8
  2477. ######### linkLazyNoProxySelect: n/a 0/8
  2478. ######### linkLazySelect: YES 8/8
  2479. ######### linkNoProxy: n/a 0/8
  2480. ######### linkNoProxyJoin: YES 8/8
  2481. ######### linkNoProxySelect: n/a 0/8
  2482. ######### linkSelect: YES 8/8
  2483. ######### --------------------------------------------------------------------------------
  2484. ######### #103:id-name-graph Reflection State
  2485. ######### --------------------------------------------------------------------------------
  2486. ######### link: HERE 8/8
  2487. ######### linkJoin: HERE 8/8
  2488. ######### linkLazy: HERE 8/8
  2489. ######### linkLazyJoin: HERE 8/8
  2490. ######### linkLazyNoProxy: null 0/8
  2491. ######### linkLazyNoProxyJoin: HERE 8/8
  2492. ######### linkLazyNoProxySelect: null 0/8
  2493. ######### linkLazySelect: HERE 8/8
  2494. ######### linkNoProxy: null 0/8
  2495. ######### linkNoProxyJoin: HERE 8/8
  2496. ######### linkNoProxySelect: null 0/8
  2497. ######### linkSelect: HERE 8/8
  2498. ######### ================================================================================
  2499. ######### test.printAll();
  2500. ######### ================================================================================
  2501. ######### #103:id-name-graph
  2502. ######### --------------------------------------------------------------------------------
  2503. ######### link = #1:link
  2504. ######### linkSelect = #2:linkSelect
  2505. ######### linkJoin = #3:linkJoin
  2506. Hibernate:
  2507. select
  2508. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  2509. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  2510. testentity_.linkNoProxy_id as linknop12_28_,
  2511. testentity_.linkNoProxySelect_id as linknop14_28_
  2512. from
  2513. loading_test testentity_
  2514. where
  2515. testentity_.id=?
  2516. ######### linkNoProxy = #5:linkNoProxy
  2517. ######### linkNoProxySelect = #6:linkNoProxySelect
  2518. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  2519. ######### linkLazy = #9:linkLazy
  2520. ######### linkLazySelect = #10:linkLazySelect
  2521. ######### linkLazyJoin = #11:linkLazyJoin
  2522. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  2523. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  2524. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  2525. ######### ================================================================================
  2526. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  2527. ######### ################################################################################
  2528. ######### TEST 200 no graph no fetch printAll
  2529. ######### ################################################################################
  2530. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  2531. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  2532. ######### final Path<Long> id = root.get("id");
  2533. ######### query.where(builder.equal(id, 200L));
  2534. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  2535. ######### final TestEntity test = tq.getSingleResult();
  2536. Hibernate:
  2537. select
  2538. testentity0_.id as id1_28_,
  2539. testentity0_.link_id as link_id4_28_,
  2540. testentity0_.linkJoin_id as linkjoin5_28_,
  2541. testentity0_.linkLazy_id as linklazy6_28_,
  2542. testentity0_.linkLazyJoin_id as linklazy7_28_,
  2543. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_,
  2544. testentity0_.linkLazySelect_id as linklaz11_28_,
  2545. testentity0_.linkNoProxyJoin_id as linknop13_28_,
  2546. testentity0_.linkSelect_id as linksel15_28_,
  2547. testentity0_.name as name2_28_,
  2548. testentity0_.version as version3_28_
  2549. from
  2550. loading_test testentity0_
  2551. where
  2552. testentity0_.id=200
  2553. Hibernate:
  2554. select
  2555. testentity0_.id as id1_28_0_,
  2556. testentity0_.link_id as link_id4_28_0_,
  2557. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2558. testentity0_.linkLazy_id as linklazy6_28_0_,
  2559. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2560. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2561. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2562. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2563. testentity0_.linkSelect_id as linksel15_28_0_,
  2564. testentity0_.name as name2_28_0_,
  2565. testentity0_.version as version3_28_0_,
  2566. testentity1_.id as id1_28_1_,
  2567. testentity1_.link_id as link_id4_28_1_,
  2568. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2569. testentity1_.linkLazy_id as linklazy6_28_1_,
  2570. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2571. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2572. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2573. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2574. testentity1_.linkSelect_id as linksel15_28_1_,
  2575. testentity1_.name as name2_28_1_,
  2576. testentity1_.version as version3_28_1_,
  2577. testentity2_.id as id1_28_2_,
  2578. testentity2_.link_id as link_id4_28_2_,
  2579. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2580. testentity2_.linkLazy_id as linklazy6_28_2_,
  2581. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2582. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2583. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2584. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2585. testentity2_.linkSelect_id as linksel15_28_2_,
  2586. testentity2_.name as name2_28_2_,
  2587. testentity2_.version as version3_28_2_,
  2588. testentity3_.id as id1_28_3_,
  2589. testentity3_.link_id as link_id4_28_3_,
  2590. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2591. testentity3_.linkLazy_id as linklazy6_28_3_,
  2592. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2593. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2594. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2595. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2596. testentity3_.linkSelect_id as linksel15_28_3_,
  2597. testentity3_.name as name2_28_3_,
  2598. testentity3_.version as version3_28_3_,
  2599. testentity4_.id as id1_28_4_,
  2600. testentity4_.link_id as link_id4_28_4_,
  2601. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2602. testentity4_.linkLazy_id as linklazy6_28_4_,
  2603. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2604. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2605. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2606. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2607. testentity4_.linkSelect_id as linksel15_28_4_,
  2608. testentity4_.name as name2_28_4_,
  2609. testentity4_.version as version3_28_4_,
  2610. testentity5_.id as id1_28_5_,
  2611. testentity5_.link_id as link_id4_28_5_,
  2612. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2613. testentity5_.linkLazy_id as linklazy6_28_5_,
  2614. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2615. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2616. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2617. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2618. testentity5_.linkSelect_id as linksel15_28_5_,
  2619. testentity5_.name as name2_28_5_,
  2620. testentity5_.version as version3_28_5_,
  2621. testentity6_.id as id1_28_6_,
  2622. testentity6_.link_id as link_id4_28_6_,
  2623. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2624. testentity6_.linkLazy_id as linklazy6_28_6_,
  2625. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2626. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2627. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2628. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2629. testentity6_.linkSelect_id as linksel15_28_6_,
  2630. testentity6_.name as name2_28_6_,
  2631. testentity6_.version as version3_28_6_
  2632. from
  2633. loading_test testentity0_
  2634. left outer join
  2635. loading_test testentity1_
  2636. on testentity0_.link_id=testentity1_.id
  2637. left outer join
  2638. loading_test testentity2_
  2639. on testentity1_.linkJoin_id=testentity2_.id
  2640. left outer join
  2641. loading_test testentity3_
  2642. on testentity2_.linkLazyJoin_id=testentity3_.id
  2643. left outer join
  2644. loading_test testentity4_
  2645. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  2646. left outer join
  2647. loading_test testentity5_
  2648. on testentity4_.linkNoProxy_id=testentity5_.id
  2649. left outer join
  2650. loading_test testentity6_
  2651. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  2652. where
  2653. testentity0_.id in (
  2654. ?, ?, ?, ?, ?, ?, ?, ?
  2655. )
  2656. ######### test.reportInitializationState();
  2657. ######### ================================================================================
  2658. ######### #200:no-fetch Initialization State
  2659. ######### --------------------------------------------------------------------------------
  2660. ######### link: YES 9/9
  2661. ######### linkJoin: YES 9/9
  2662. ######### linkLazy: YES 9/9
  2663. ######### linkLazyJoin: YES 9/9
  2664. ######### linkLazyNoProxy: n/a 0/9
  2665. ######### linkLazyNoProxyJoin: YES 9/9
  2666. ######### linkLazyNoProxySelect: n/a 0/9
  2667. ######### linkLazySelect: YES 9/9
  2668. ######### linkNoProxy: n/a 0/9
  2669. ######### linkNoProxyJoin: YES 9/9
  2670. ######### linkNoProxySelect: n/a 0/9
  2671. ######### linkSelect: YES 9/9
  2672. ######### --------------------------------------------------------------------------------
  2673. ######### #200:no-fetch Reflection State
  2674. ######### --------------------------------------------------------------------------------
  2675. ######### link: HERE 9/9
  2676. ######### linkJoin: HERE 9/9
  2677. ######### linkLazy: HERE 9/9
  2678. ######### linkLazyJoin: HERE 9/9
  2679. ######### linkLazyNoProxy: null 0/9
  2680. ######### linkLazyNoProxyJoin: HERE 9/9
  2681. ######### linkLazyNoProxySelect: null 0/9
  2682. ######### linkLazySelect: HERE 9/9
  2683. ######### linkNoProxy: null 0/9
  2684. ######### linkNoProxyJoin: HERE 9/9
  2685. ######### linkNoProxySelect: null 0/9
  2686. ######### linkSelect: HERE 9/9
  2687. ######### ================================================================================
  2688. ######### test.printAll();
  2689. ######### ================================================================================
  2690. ######### #200:no-fetch
  2691. ######### --------------------------------------------------------------------------------
  2692. ######### link = #1:link
  2693. ######### linkSelect = #2:linkSelect
  2694. ######### linkJoin = #3:linkJoin
  2695. Hibernate:
  2696. select
  2697. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  2698. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  2699. testentity_.linkNoProxy_id as linknop12_28_,
  2700. testentity_.linkNoProxySelect_id as linknop14_28_
  2701. from
  2702. loading_test testentity_
  2703. where
  2704. testentity_.id=?
  2705. Hibernate:
  2706. select
  2707. testentity0_.id as id1_28_0_,
  2708. testentity0_.link_id as link_id4_28_0_,
  2709. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2710. testentity0_.linkLazy_id as linklazy6_28_0_,
  2711. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2712. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2713. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2714. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2715. testentity0_.linkSelect_id as linksel15_28_0_,
  2716. testentity0_.name as name2_28_0_,
  2717. testentity0_.version as version3_28_0_,
  2718. testentity1_.id as id1_28_1_,
  2719. testentity1_.link_id as link_id4_28_1_,
  2720. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2721. testentity1_.linkLazy_id as linklazy6_28_1_,
  2722. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2723. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2724. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2725. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2726. testentity1_.linkSelect_id as linksel15_28_1_,
  2727. testentity1_.name as name2_28_1_,
  2728. testentity1_.version as version3_28_1_,
  2729. testentity2_.id as id1_28_2_,
  2730. testentity2_.link_id as link_id4_28_2_,
  2731. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2732. testentity2_.linkLazy_id as linklazy6_28_2_,
  2733. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2734. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2735. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2736. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2737. testentity2_.linkSelect_id as linksel15_28_2_,
  2738. testentity2_.name as name2_28_2_,
  2739. testentity2_.version as version3_28_2_,
  2740. testentity3_.id as id1_28_3_,
  2741. testentity3_.link_id as link_id4_28_3_,
  2742. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2743. testentity3_.linkLazy_id as linklazy6_28_3_,
  2744. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2745. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2746. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2747. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2748. testentity3_.linkSelect_id as linksel15_28_3_,
  2749. testentity3_.name as name2_28_3_,
  2750. testentity3_.version as version3_28_3_,
  2751. testentity4_.id as id1_28_4_,
  2752. testentity4_.link_id as link_id4_28_4_,
  2753. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2754. testentity4_.linkLazy_id as linklazy6_28_4_,
  2755. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2756. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2757. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2758. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2759. testentity4_.linkSelect_id as linksel15_28_4_,
  2760. testentity4_.name as name2_28_4_,
  2761. testentity4_.version as version3_28_4_,
  2762. testentity5_.id as id1_28_5_,
  2763. testentity5_.link_id as link_id4_28_5_,
  2764. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2765. testentity5_.linkLazy_id as linklazy6_28_5_,
  2766. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2767. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2768. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2769. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2770. testentity5_.linkSelect_id as linksel15_28_5_,
  2771. testentity5_.name as name2_28_5_,
  2772. testentity5_.version as version3_28_5_,
  2773. testentity6_.id as id1_28_6_,
  2774. testentity6_.link_id as link_id4_28_6_,
  2775. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2776. testentity6_.linkLazy_id as linklazy6_28_6_,
  2777. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2778. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2779. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2780. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2781. testentity6_.linkSelect_id as linksel15_28_6_,
  2782. testentity6_.name as name2_28_6_,
  2783. testentity6_.version as version3_28_6_
  2784. from
  2785. loading_test testentity0_
  2786. left outer join
  2787. loading_test testentity1_
  2788. on testentity0_.link_id=testentity1_.id
  2789. left outer join
  2790. loading_test testentity2_
  2791. on testentity1_.linkJoin_id=testentity2_.id
  2792. left outer join
  2793. loading_test testentity3_
  2794. on testentity2_.linkLazyJoin_id=testentity3_.id
  2795. left outer join
  2796. loading_test testentity4_
  2797. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  2798. left outer join
  2799. loading_test testentity5_
  2800. on testentity4_.linkNoProxy_id=testentity5_.id
  2801. left outer join
  2802. loading_test testentity6_
  2803. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  2804. where
  2805. testentity0_.id=?
  2806. Hibernate:
  2807. select
  2808. testentity0_.id as id1_28_0_,
  2809. testentity0_.link_id as link_id4_28_0_,
  2810. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2811. testentity0_.linkLazy_id as linklazy6_28_0_,
  2812. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2813. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2814. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2815. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2816. testentity0_.linkSelect_id as linksel15_28_0_,
  2817. testentity0_.name as name2_28_0_,
  2818. testentity0_.version as version3_28_0_,
  2819. testentity1_.id as id1_28_1_,
  2820. testentity1_.link_id as link_id4_28_1_,
  2821. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2822. testentity1_.linkLazy_id as linklazy6_28_1_,
  2823. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2824. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2825. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2826. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2827. testentity1_.linkSelect_id as linksel15_28_1_,
  2828. testentity1_.name as name2_28_1_,
  2829. testentity1_.version as version3_28_1_,
  2830. testentity2_.id as id1_28_2_,
  2831. testentity2_.link_id as link_id4_28_2_,
  2832. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2833. testentity2_.linkLazy_id as linklazy6_28_2_,
  2834. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2835. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2836. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2837. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2838. testentity2_.linkSelect_id as linksel15_28_2_,
  2839. testentity2_.name as name2_28_2_,
  2840. testentity2_.version as version3_28_2_,
  2841. testentity3_.id as id1_28_3_,
  2842. testentity3_.link_id as link_id4_28_3_,
  2843. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2844. testentity3_.linkLazy_id as linklazy6_28_3_,
  2845. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2846. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2847. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2848. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2849. testentity3_.linkSelect_id as linksel15_28_3_,
  2850. testentity3_.name as name2_28_3_,
  2851. testentity3_.version as version3_28_3_,
  2852. testentity4_.id as id1_28_4_,
  2853. testentity4_.link_id as link_id4_28_4_,
  2854. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2855. testentity4_.linkLazy_id as linklazy6_28_4_,
  2856. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2857. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2858. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2859. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2860. testentity4_.linkSelect_id as linksel15_28_4_,
  2861. testentity4_.name as name2_28_4_,
  2862. testentity4_.version as version3_28_4_,
  2863. testentity5_.id as id1_28_5_,
  2864. testentity5_.link_id as link_id4_28_5_,
  2865. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2866. testentity5_.linkLazy_id as linklazy6_28_5_,
  2867. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2868. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2869. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2870. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2871. testentity5_.linkSelect_id as linksel15_28_5_,
  2872. testentity5_.name as name2_28_5_,
  2873. testentity5_.version as version3_28_5_,
  2874. testentity6_.id as id1_28_6_,
  2875. testentity6_.link_id as link_id4_28_6_,
  2876. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2877. testentity6_.linkLazy_id as linklazy6_28_6_,
  2878. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2879. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2880. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2881. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2882. testentity6_.linkSelect_id as linksel15_28_6_,
  2883. testentity6_.name as name2_28_6_,
  2884. testentity6_.version as version3_28_6_
  2885. from
  2886. loading_test testentity0_
  2887. left outer join
  2888. loading_test testentity1_
  2889. on testentity0_.link_id=testentity1_.id
  2890. left outer join
  2891. loading_test testentity2_
  2892. on testentity1_.linkJoin_id=testentity2_.id
  2893. left outer join
  2894. loading_test testentity3_
  2895. on testentity2_.linkLazyJoin_id=testentity3_.id
  2896. left outer join
  2897. loading_test testentity4_
  2898. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  2899. left outer join
  2900. loading_test testentity5_
  2901. on testentity4_.linkNoProxy_id=testentity5_.id
  2902. left outer join
  2903. loading_test testentity6_
  2904. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  2905. where
  2906. testentity0_.id=?
  2907. Hibernate:
  2908. select
  2909. testentity0_.id as id1_28_0_,
  2910. testentity0_.link_id as link_id4_28_0_,
  2911. testentity0_.linkJoin_id as linkjoin5_28_0_,
  2912. testentity0_.linkLazy_id as linklazy6_28_0_,
  2913. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  2914. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  2915. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  2916. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  2917. testentity0_.linkSelect_id as linksel15_28_0_,
  2918. testentity0_.name as name2_28_0_,
  2919. testentity0_.version as version3_28_0_,
  2920. testentity1_.id as id1_28_1_,
  2921. testentity1_.link_id as link_id4_28_1_,
  2922. testentity1_.linkJoin_id as linkjoin5_28_1_,
  2923. testentity1_.linkLazy_id as linklazy6_28_1_,
  2924. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  2925. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  2926. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  2927. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  2928. testentity1_.linkSelect_id as linksel15_28_1_,
  2929. testentity1_.name as name2_28_1_,
  2930. testentity1_.version as version3_28_1_,
  2931. testentity2_.id as id1_28_2_,
  2932. testentity2_.link_id as link_id4_28_2_,
  2933. testentity2_.linkJoin_id as linkjoin5_28_2_,
  2934. testentity2_.linkLazy_id as linklazy6_28_2_,
  2935. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  2936. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  2937. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  2938. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  2939. testentity2_.linkSelect_id as linksel15_28_2_,
  2940. testentity2_.name as name2_28_2_,
  2941. testentity2_.version as version3_28_2_,
  2942. testentity3_.id as id1_28_3_,
  2943. testentity3_.link_id as link_id4_28_3_,
  2944. testentity3_.linkJoin_id as linkjoin5_28_3_,
  2945. testentity3_.linkLazy_id as linklazy6_28_3_,
  2946. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  2947. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  2948. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  2949. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  2950. testentity3_.linkSelect_id as linksel15_28_3_,
  2951. testentity3_.name as name2_28_3_,
  2952. testentity3_.version as version3_28_3_,
  2953. testentity4_.id as id1_28_4_,
  2954. testentity4_.link_id as link_id4_28_4_,
  2955. testentity4_.linkJoin_id as linkjoin5_28_4_,
  2956. testentity4_.linkLazy_id as linklazy6_28_4_,
  2957. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  2958. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  2959. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  2960. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  2961. testentity4_.linkSelect_id as linksel15_28_4_,
  2962. testentity4_.name as name2_28_4_,
  2963. testentity4_.version as version3_28_4_,
  2964. testentity5_.id as id1_28_5_,
  2965. testentity5_.link_id as link_id4_28_5_,
  2966. testentity5_.linkJoin_id as linkjoin5_28_5_,
  2967. testentity5_.linkLazy_id as linklazy6_28_5_,
  2968. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  2969. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  2970. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  2971. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  2972. testentity5_.linkSelect_id as linksel15_28_5_,
  2973. testentity5_.name as name2_28_5_,
  2974. testentity5_.version as version3_28_5_,
  2975. testentity6_.id as id1_28_6_,
  2976. testentity6_.link_id as link_id4_28_6_,
  2977. testentity6_.linkJoin_id as linkjoin5_28_6_,
  2978. testentity6_.linkLazy_id as linklazy6_28_6_,
  2979. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  2980. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  2981. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  2982. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  2983. testentity6_.linkSelect_id as linksel15_28_6_,
  2984. testentity6_.name as name2_28_6_,
  2985. testentity6_.version as version3_28_6_
  2986. from
  2987. loading_test testentity0_
  2988. left outer join
  2989. loading_test testentity1_
  2990. on testentity0_.link_id=testentity1_.id
  2991. left outer join
  2992. loading_test testentity2_
  2993. on testentity1_.linkJoin_id=testentity2_.id
  2994. left outer join
  2995. loading_test testentity3_
  2996. on testentity2_.linkLazyJoin_id=testentity3_.id
  2997. left outer join
  2998. loading_test testentity4_
  2999. on testentity3_.linkLazyNoProxyJoin_id=testentity4_.id
  3000. left outer join
  3001. loading_test testentity5_
  3002. on testentity4_.linkNoProxy_id=testentity5_.id
  3003. left outer join
  3004. loading_test testentity6_
  3005. on testentity5_.linkNoProxyJoin_id=testentity6_.id
  3006. where
  3007. testentity0_.id=?
  3008. ######### linkNoProxy = #5:linkNoProxy
  3009. ######### linkNoProxySelect = #6:linkNoProxySelect
  3010. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  3011. ######### linkLazy = #9:linkLazy
  3012. ######### linkLazySelect = #10:linkLazySelect
  3013. ######### linkLazyJoin = #11:linkLazyJoin
  3014. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  3015. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  3016. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  3017. ######### ================================================================================
  3018. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  3019. ######### ################################################################################
  3020. ######### TEST 201 no graph fetch=1 printAll
  3021. ######### ################################################################################
  3022. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  3023. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  3024. ######### final Path<Long> id = root.get("id");
  3025. ######### query.where(builder.equal(id, 201L));
  3026. ######### final Fetch<TestEntity, TestEntity> linkFetch = root.fetch("link");
  3027. ######### final Fetch<TestEntity, TestEntity> linkSelectFetch = root.fetch("linkSelect");
  3028. ######### final Fetch<TestEntity, TestEntity> linkJoinFetch = root.fetch("linkJoin");
  3029. ######### final Fetch<TestEntity, TestEntity> linkNoProxyFetch = root.fetch("linkNoProxy");
  3030. ######### final Fetch<TestEntity, TestEntity> linkNoProxySelectFetch = root.fetch("linkNoProxySelect");
  3031. ######### final Fetch<TestEntity, TestEntity> linkNoProxyJoinFetch = root.fetch("linkNoProxyJoin");
  3032. ######### final Fetch<TestEntity, TestEntity> linkLazyFetch = root.fetch("linkLazy");
  3033. ######### final Fetch<TestEntity, TestEntity> linkLazySelectFetch = root.fetch("linkLazySelect");
  3034. ######### final Fetch<TestEntity, TestEntity> linkLazyJoinFetch = root.fetch("linkLazyJoin");
  3035. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyFetch = root.fetch("linkLazyNoProxy");
  3036. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxySelectFetch = root.fetch("linkLazyNoProxySelect");
  3037. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyJoinFetch = root.fetch("linkLazyNoProxyJoin");
  3038. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  3039. ######### final TestEntity test = tq.getSingleResult();
  3040. Hibernate:
  3041. select
  3042. testentity0_.id as id1_28_0_,
  3043. testentity1_.id as id1_28_1_,
  3044. testentity2_.id as id1_28_2_,
  3045. testentity3_.id as id1_28_3_,
  3046. testentity4_.id as id1_28_4_,
  3047. testentity5_.id as id1_28_5_,
  3048. testentity6_.id as id1_28_6_,
  3049. testentity7_.id as id1_28_7_,
  3050. testentity8_.id as id1_28_8_,
  3051. testentity9_.id as id1_28_9_,
  3052. testentity10_.id as id1_28_10_,
  3053. testentity11_.id as id1_28_11_,
  3054. testentity12_.id as id1_28_12_,
  3055. testentity0_.link_id as link_id4_28_0_,
  3056. testentity0_.linkJoin_id as linkjoin5_28_0_,
  3057. testentity0_.linkLazy_id as linklazy6_28_0_,
  3058. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  3059. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  3060. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  3061. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  3062. testentity0_.linkSelect_id as linksel15_28_0_,
  3063. testentity0_.name as name2_28_0_,
  3064. testentity0_.version as version3_28_0_,
  3065. testentity1_.link_id as link_id4_28_1_,
  3066. testentity1_.linkJoin_id as linkjoin5_28_1_,
  3067. testentity1_.linkLazy_id as linklazy6_28_1_,
  3068. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  3069. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  3070. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  3071. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  3072. testentity1_.linkSelect_id as linksel15_28_1_,
  3073. testentity1_.name as name2_28_1_,
  3074. testentity1_.version as version3_28_1_,
  3075. testentity2_.link_id as link_id4_28_2_,
  3076. testentity2_.linkJoin_id as linkjoin5_28_2_,
  3077. testentity2_.linkLazy_id as linklazy6_28_2_,
  3078. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  3079. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  3080. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  3081. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  3082. testentity2_.linkSelect_id as linksel15_28_2_,
  3083. testentity2_.name as name2_28_2_,
  3084. testentity2_.version as version3_28_2_,
  3085. testentity3_.link_id as link_id4_28_3_,
  3086. testentity3_.linkJoin_id as linkjoin5_28_3_,
  3087. testentity3_.linkLazy_id as linklazy6_28_3_,
  3088. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  3089. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  3090. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  3091. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  3092. testentity3_.linkSelect_id as linksel15_28_3_,
  3093. testentity3_.name as name2_28_3_,
  3094. testentity3_.version as version3_28_3_,
  3095. testentity4_.link_id as link_id4_28_4_,
  3096. testentity4_.linkJoin_id as linkjoin5_28_4_,
  3097. testentity4_.linkLazy_id as linklazy6_28_4_,
  3098. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  3099. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  3100. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  3101. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  3102. testentity4_.linkSelect_id as linksel15_28_4_,
  3103. testentity4_.name as name2_28_4_,
  3104. testentity4_.version as version3_28_4_,
  3105. testentity5_.link_id as link_id4_28_5_,
  3106. testentity5_.linkJoin_id as linkjoin5_28_5_,
  3107. testentity5_.linkLazy_id as linklazy6_28_5_,
  3108. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  3109. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  3110. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  3111. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  3112. testentity5_.linkSelect_id as linksel15_28_5_,
  3113. testentity5_.name as name2_28_5_,
  3114. testentity5_.version as version3_28_5_,
  3115. testentity6_.link_id as link_id4_28_6_,
  3116. testentity6_.linkJoin_id as linkjoin5_28_6_,
  3117. testentity6_.linkLazy_id as linklazy6_28_6_,
  3118. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  3119. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  3120. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  3121. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  3122. testentity6_.linkSelect_id as linksel15_28_6_,
  3123. testentity6_.name as name2_28_6_,
  3124. testentity6_.version as version3_28_6_,
  3125. testentity7_.link_id as link_id4_28_7_,
  3126. testentity7_.linkJoin_id as linkjoin5_28_7_,
  3127. testentity7_.linkLazy_id as linklazy6_28_7_,
  3128. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  3129. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  3130. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  3131. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  3132. testentity7_.linkSelect_id as linksel15_28_7_,
  3133. testentity7_.name as name2_28_7_,
  3134. testentity7_.version as version3_28_7_,
  3135. testentity8_.link_id as link_id4_28_8_,
  3136. testentity8_.linkJoin_id as linkjoin5_28_8_,
  3137. testentity8_.linkLazy_id as linklazy6_28_8_,
  3138. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  3139. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  3140. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  3141. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  3142. testentity8_.linkSelect_id as linksel15_28_8_,
  3143. testentity8_.name as name2_28_8_,
  3144. testentity8_.version as version3_28_8_,
  3145. testentity9_.link_id as link_id4_28_9_,
  3146. testentity9_.linkJoin_id as linkjoin5_28_9_,
  3147. testentity9_.linkLazy_id as linklazy6_28_9_,
  3148. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  3149. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  3150. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  3151. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  3152. testentity9_.linkSelect_id as linksel15_28_9_,
  3153. testentity9_.name as name2_28_9_,
  3154. testentity9_.version as version3_28_9_,
  3155. testentity10_.link_id as link_id4_28_10_,
  3156. testentity10_.linkJoin_id as linkjoin5_28_10_,
  3157. testentity10_.linkLazy_id as linklazy6_28_10_,
  3158. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  3159. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  3160. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  3161. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  3162. testentity10_.linkSelect_id as linksel15_28_10_,
  3163. testentity10_.name as name2_28_10_,
  3164. testentity10_.version as version3_28_10_,
  3165. testentity11_.link_id as link_id4_28_11_,
  3166. testentity11_.linkJoin_id as linkjoin5_28_11_,
  3167. testentity11_.linkLazy_id as linklazy6_28_11_,
  3168. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  3169. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  3170. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  3171. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  3172. testentity11_.linkSelect_id as linksel15_28_11_,
  3173. testentity11_.name as name2_28_11_,
  3174. testentity11_.version as version3_28_11_,
  3175. testentity12_.link_id as link_id4_28_12_,
  3176. testentity12_.linkJoin_id as linkjoin5_28_12_,
  3177. testentity12_.linkLazy_id as linklazy6_28_12_,
  3178. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  3179. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  3180. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  3181. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  3182. testentity12_.linkSelect_id as linksel15_28_12_,
  3183. testentity12_.name as name2_28_12_,
  3184. testentity12_.version as version3_28_12_
  3185. from
  3186. loading_test testentity0_
  3187. inner join
  3188. loading_test testentity1_
  3189. on testentity0_.link_id=testentity1_.id
  3190. inner join
  3191. loading_test testentity2_
  3192. on testentity0_.linkSelect_id=testentity2_.id
  3193. inner join
  3194. loading_test testentity3_
  3195. on testentity0_.linkJoin_id=testentity3_.id
  3196. inner join
  3197. loading_test testentity4_
  3198. on testentity0_.linkNoProxy_id=testentity4_.id
  3199. inner join
  3200. loading_test testentity5_
  3201. on testentity0_.linkNoProxySelect_id=testentity5_.id
  3202. inner join
  3203. loading_test testentity6_
  3204. on testentity0_.linkNoProxyJoin_id=testentity6_.id
  3205. inner join
  3206. loading_test testentity7_
  3207. on testentity0_.linkLazy_id=testentity7_.id
  3208. inner join
  3209. loading_test testentity8_
  3210. on testentity0_.linkLazySelect_id=testentity8_.id
  3211. inner join
  3212. loading_test testentity9_
  3213. on testentity0_.linkLazyJoin_id=testentity9_.id
  3214. inner join
  3215. loading_test testentity10_
  3216. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  3217. inner join
  3218. loading_test testentity11_
  3219. on testentity0_.linkLazyNoProxySelect_id=testentity11_.id
  3220. inner join
  3221. loading_test testentity12_
  3222. on testentity0_.linkLazyNoProxyJoin_id=testentity12_.id
  3223. where
  3224. testentity0_.id=201
  3225. ######### test.reportInitializationState();
  3226. ######### ================================================================================
  3227. ######### #201:shallow-fetch Initialization State
  3228. ######### --------------------------------------------------------------------------------
  3229. ######### link: YES 10/10
  3230. ######### linkJoin: YES 10/10
  3231. ######### linkLazy: YES 10/10
  3232. ######### linkLazyJoin: YES 10/10
  3233. ######### linkLazyNoProxy: n/a 0/10
  3234. ######### linkLazyNoProxyJoin: YES 10/10
  3235. ######### linkLazyNoProxySelect: n/a 0/10
  3236. ######### linkLazySelect: YES 10/10
  3237. ######### linkNoProxy: n/a 0/10
  3238. ######### linkNoProxyJoin: YES 10/10
  3239. ######### linkNoProxySelect: n/a 0/10
  3240. ######### linkSelect: YES 10/10
  3241. ######### --------------------------------------------------------------------------------
  3242. ######### #201:shallow-fetch Reflection State
  3243. ######### --------------------------------------------------------------------------------
  3244. ######### link: HERE 10/10
  3245. ######### linkJoin: HERE 10/10
  3246. ######### linkLazy: HERE 10/10
  3247. ######### linkLazyJoin: HERE 10/10
  3248. ######### linkLazyNoProxy: null 0/10
  3249. ######### linkLazyNoProxyJoin: HERE 10/10
  3250. ######### linkLazyNoProxySelect: null 0/10
  3251. ######### linkLazySelect: HERE 10/10
  3252. ######### linkNoProxy: null 0/10
  3253. ######### linkNoProxyJoin: HERE 10/10
  3254. ######### linkNoProxySelect: null 0/10
  3255. ######### linkSelect: HERE 10/10
  3256. ######### ================================================================================
  3257. ######### test.printAll();
  3258. ######### ================================================================================
  3259. ######### #201:shallow-fetch
  3260. ######### --------------------------------------------------------------------------------
  3261. ######### link = #1:link
  3262. ######### linkSelect = #2:linkSelect
  3263. ######### linkJoin = #3:linkJoin
  3264. Hibernate:
  3265. select
  3266. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  3267. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  3268. testentity_.linkNoProxy_id as linknop12_28_,
  3269. testentity_.linkNoProxySelect_id as linknop14_28_
  3270. from
  3271. loading_test testentity_
  3272. where
  3273. testentity_.id=?
  3274. ######### linkNoProxy = #5:linkNoProxy
  3275. ######### linkNoProxySelect = #6:linkNoProxySelect
  3276. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  3277. ######### linkLazy = #9:linkLazy
  3278. ######### linkLazySelect = #10:linkLazySelect
  3279. ######### linkLazyJoin = #11:linkLazyJoin
  3280. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  3281. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  3282. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  3283. ######### ================================================================================
  3284. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  3285. ######### ################################################################################
  3286. ######### TEST 202 no graph fetch=2 printAll
  3287. ######### ################################################################################
  3288. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  3289. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  3290. ######### final Path<Long> id = root.get("id");
  3291. ######### query.where(builder.equal(id, 202L));
  3292. ######### final Fetch<TestEntity, TestEntity> linkFetch = root.fetch("link");
  3293. ######### final Fetch<TestEntity, TestEntity> linkSelectFetch = root.fetch("linkSelect");
  3294. ######### final Fetch<TestEntity, TestEntity> linkJoinFetch = root.fetch("linkJoin");
  3295. ######### final Fetch<TestEntity, TestEntity> linkNoProxyFetch = root.fetch("linkNoProxy");
  3296. ######### final Fetch<TestEntity, TestEntity> linkNoProxySelectFetch = root.fetch("linkNoProxySelect");
  3297. ######### final Fetch<TestEntity, TestEntity> linkNoProxyJoinFetch = root.fetch("linkNoProxyJoin");
  3298. ######### final Fetch<TestEntity, TestEntity> linkLazyFetch = root.fetch("linkLazy");
  3299. ######### final Fetch<TestEntity, TestEntity> linkLazySelectFetch = root.fetch("linkLazySelect");
  3300. ######### final Fetch<TestEntity, TestEntity> linkLazyJoinFetch = root.fetch("linkLazyJoin");
  3301. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyFetch = root.fetch("linkLazyNoProxy");
  3302. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxySelectFetch = root.fetch("linkLazyNoProxySelect");
  3303. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyJoinFetch = root.fetch("linkLazyNoProxyJoin");
  3304. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  3305. ######### final TestEntity test = tq.getSingleResult();
  3306. Hibernate:
  3307. select
  3308. testentity0_.id as id1_28_0_,
  3309. testentity1_.id as id1_28_1_,
  3310. testentity2_.id as id1_28_2_,
  3311. testentity3_.id as id1_28_3_,
  3312. testentity4_.id as id1_28_4_,
  3313. testentity5_.id as id1_28_5_,
  3314. testentity6_.id as id1_28_6_,
  3315. testentity7_.id as id1_28_7_,
  3316. testentity8_.id as id1_28_8_,
  3317. testentity9_.id as id1_28_9_,
  3318. testentity10_.id as id1_28_10_,
  3319. testentity11_.id as id1_28_11_,
  3320. testentity12_.id as id1_28_12_,
  3321. testentity0_.link_id as link_id4_28_0_,
  3322. testentity0_.linkJoin_id as linkjoin5_28_0_,
  3323. testentity0_.linkLazy_id as linklazy6_28_0_,
  3324. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  3325. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  3326. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  3327. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  3328. testentity0_.linkSelect_id as linksel15_28_0_,
  3329. testentity0_.name as name2_28_0_,
  3330. testentity0_.version as version3_28_0_,
  3331. testentity1_.link_id as link_id4_28_1_,
  3332. testentity1_.linkJoin_id as linkjoin5_28_1_,
  3333. testentity1_.linkLazy_id as linklazy6_28_1_,
  3334. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  3335. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  3336. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  3337. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  3338. testentity1_.linkSelect_id as linksel15_28_1_,
  3339. testentity1_.name as name2_28_1_,
  3340. testentity1_.version as version3_28_1_,
  3341. testentity2_.link_id as link_id4_28_2_,
  3342. testentity2_.linkJoin_id as linkjoin5_28_2_,
  3343. testentity2_.linkLazy_id as linklazy6_28_2_,
  3344. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  3345. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  3346. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  3347. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  3348. testentity2_.linkSelect_id as linksel15_28_2_,
  3349. testentity2_.name as name2_28_2_,
  3350. testentity2_.version as version3_28_2_,
  3351. testentity3_.link_id as link_id4_28_3_,
  3352. testentity3_.linkJoin_id as linkjoin5_28_3_,
  3353. testentity3_.linkLazy_id as linklazy6_28_3_,
  3354. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  3355. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  3356. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  3357. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  3358. testentity3_.linkSelect_id as linksel15_28_3_,
  3359. testentity3_.name as name2_28_3_,
  3360. testentity3_.version as version3_28_3_,
  3361. testentity4_.link_id as link_id4_28_4_,
  3362. testentity4_.linkJoin_id as linkjoin5_28_4_,
  3363. testentity4_.linkLazy_id as linklazy6_28_4_,
  3364. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  3365. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  3366. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  3367. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  3368. testentity4_.linkSelect_id as linksel15_28_4_,
  3369. testentity4_.name as name2_28_4_,
  3370. testentity4_.version as version3_28_4_,
  3371. testentity5_.link_id as link_id4_28_5_,
  3372. testentity5_.linkJoin_id as linkjoin5_28_5_,
  3373. testentity5_.linkLazy_id as linklazy6_28_5_,
  3374. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  3375. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  3376. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  3377. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  3378. testentity5_.linkSelect_id as linksel15_28_5_,
  3379. testentity5_.name as name2_28_5_,
  3380. testentity5_.version as version3_28_5_,
  3381. testentity6_.link_id as link_id4_28_6_,
  3382. testentity6_.linkJoin_id as linkjoin5_28_6_,
  3383. testentity6_.linkLazy_id as linklazy6_28_6_,
  3384. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  3385. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  3386. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  3387. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  3388. testentity6_.linkSelect_id as linksel15_28_6_,
  3389. testentity6_.name as name2_28_6_,
  3390. testentity6_.version as version3_28_6_,
  3391. testentity7_.link_id as link_id4_28_7_,
  3392. testentity7_.linkJoin_id as linkjoin5_28_7_,
  3393. testentity7_.linkLazy_id as linklazy6_28_7_,
  3394. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  3395. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  3396. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  3397. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  3398. testentity7_.linkSelect_id as linksel15_28_7_,
  3399. testentity7_.name as name2_28_7_,
  3400. testentity7_.version as version3_28_7_,
  3401. testentity8_.link_id as link_id4_28_8_,
  3402. testentity8_.linkJoin_id as linkjoin5_28_8_,
  3403. testentity8_.linkLazy_id as linklazy6_28_8_,
  3404. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  3405. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  3406. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  3407. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  3408. testentity8_.linkSelect_id as linksel15_28_8_,
  3409. testentity8_.name as name2_28_8_,
  3410. testentity8_.version as version3_28_8_,
  3411. testentity9_.link_id as link_id4_28_9_,
  3412. testentity9_.linkJoin_id as linkjoin5_28_9_,
  3413. testentity9_.linkLazy_id as linklazy6_28_9_,
  3414. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  3415. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  3416. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  3417. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  3418. testentity9_.linkSelect_id as linksel15_28_9_,
  3419. testentity9_.name as name2_28_9_,
  3420. testentity9_.version as version3_28_9_,
  3421. testentity10_.link_id as link_id4_28_10_,
  3422. testentity10_.linkJoin_id as linkjoin5_28_10_,
  3423. testentity10_.linkLazy_id as linklazy6_28_10_,
  3424. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  3425. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  3426. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  3427. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  3428. testentity10_.linkSelect_id as linksel15_28_10_,
  3429. testentity10_.name as name2_28_10_,
  3430. testentity10_.version as version3_28_10_,
  3431. testentity11_.link_id as link_id4_28_11_,
  3432. testentity11_.linkJoin_id as linkjoin5_28_11_,
  3433. testentity11_.linkLazy_id as linklazy6_28_11_,
  3434. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  3435. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  3436. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  3437. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  3438. testentity11_.linkSelect_id as linksel15_28_11_,
  3439. testentity11_.name as name2_28_11_,
  3440. testentity11_.version as version3_28_11_,
  3441. testentity12_.link_id as link_id4_28_12_,
  3442. testentity12_.linkJoin_id as linkjoin5_28_12_,
  3443. testentity12_.linkLazy_id as linklazy6_28_12_,
  3444. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  3445. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  3446. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  3447. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  3448. testentity12_.linkSelect_id as linksel15_28_12_,
  3449. testentity12_.name as name2_28_12_,
  3450. testentity12_.version as version3_28_12_
  3451. from
  3452. loading_test testentity0_
  3453. inner join
  3454. loading_test testentity1_
  3455. on testentity0_.link_id=testentity1_.id
  3456. inner join
  3457. loading_test testentity2_
  3458. on testentity0_.linkSelect_id=testentity2_.id
  3459. inner join
  3460. loading_test testentity3_
  3461. on testentity0_.linkJoin_id=testentity3_.id
  3462. inner join
  3463. loading_test testentity4_
  3464. on testentity0_.linkNoProxy_id=testentity4_.id
  3465. inner join
  3466. loading_test testentity5_
  3467. on testentity0_.linkNoProxySelect_id=testentity5_.id
  3468. inner join
  3469. loading_test testentity6_
  3470. on testentity0_.linkNoProxyJoin_id=testentity6_.id
  3471. inner join
  3472. loading_test testentity7_
  3473. on testentity0_.linkLazy_id=testentity7_.id
  3474. inner join
  3475. loading_test testentity8_
  3476. on testentity0_.linkLazySelect_id=testentity8_.id
  3477. inner join
  3478. loading_test testentity9_
  3479. on testentity0_.linkLazyJoin_id=testentity9_.id
  3480. inner join
  3481. loading_test testentity10_
  3482. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  3483. inner join
  3484. loading_test testentity11_
  3485. on testentity0_.linkLazyNoProxySelect_id=testentity11_.id
  3486. inner join
  3487. loading_test testentity12_
  3488. on testentity0_.linkLazyNoProxyJoin_id=testentity12_.id
  3489. where
  3490. testentity0_.id=202
  3491. ######### test.reportInitializationState();
  3492. ######### ================================================================================
  3493. ######### #202:id-fetch Initialization State
  3494. ######### --------------------------------------------------------------------------------
  3495. ######### link: YES 11/11
  3496. ######### linkJoin: YES 11/11
  3497. ######### linkLazy: YES 11/11
  3498. ######### linkLazyJoin: YES 11/11
  3499. ######### linkLazyNoProxy: n/a 0/11
  3500. ######### linkLazyNoProxyJoin: YES 11/11
  3501. ######### linkLazyNoProxySelect: n/a 0/11
  3502. ######### linkLazySelect: YES 11/11
  3503. ######### linkNoProxy: n/a 0/11
  3504. ######### linkNoProxyJoin: YES 11/11
  3505. ######### linkNoProxySelect: n/a 0/11
  3506. ######### linkSelect: YES 11/11
  3507. ######### --------------------------------------------------------------------------------
  3508. ######### #202:id-fetch Reflection State
  3509. ######### --------------------------------------------------------------------------------
  3510. ######### link: HERE 11/11
  3511. ######### linkJoin: HERE 11/11
  3512. ######### linkLazy: HERE 11/11
  3513. ######### linkLazyJoin: HERE 11/11
  3514. ######### linkLazyNoProxy: null 0/11
  3515. ######### linkLazyNoProxyJoin: HERE 11/11
  3516. ######### linkLazyNoProxySelect: null 0/11
  3517. ######### linkLazySelect: HERE 11/11
  3518. ######### linkNoProxy: null 0/11
  3519. ######### linkNoProxyJoin: HERE 11/11
  3520. ######### linkNoProxySelect: null 0/11
  3521. ######### linkSelect: HERE 11/11
  3522. ######### ================================================================================
  3523. ######### test.printAll();
  3524. ######### ================================================================================
  3525. ######### #202:id-fetch
  3526. ######### --------------------------------------------------------------------------------
  3527. ######### link = #1:link
  3528. ######### linkSelect = #2:linkSelect
  3529. ######### linkJoin = #3:linkJoin
  3530. Hibernate:
  3531. select
  3532. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  3533. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  3534. testentity_.linkNoProxy_id as linknop12_28_,
  3535. testentity_.linkNoProxySelect_id as linknop14_28_
  3536. from
  3537. loading_test testentity_
  3538. where
  3539. testentity_.id=?
  3540. ######### linkNoProxy = #5:linkNoProxy
  3541. ######### linkNoProxySelect = #6:linkNoProxySelect
  3542. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  3543. ######### linkLazy = #9:linkLazy
  3544. ######### linkLazySelect = #10:linkLazySelect
  3545. ######### linkLazyJoin = #11:linkLazyJoin
  3546. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  3547. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  3548. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  3549. ######### ================================================================================
  3550. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  3551. ######### ################################################################################
  3552. ######### TEST 203 no graph fetch=3 printAll
  3553. ######### ################################################################################
  3554. ######### final CriteriaQuery<TestEntity> query = builder.createQuery(TestEntity.class);
  3555. ######### final Root<TestEntity> root = query.from(TestEntity.class);
  3556. ######### final Path<Long> id = root.get("id");
  3557. ######### query.where(builder.equal(id, 203L));
  3558. ######### final Fetch<TestEntity, TestEntity> linkFetch = root.fetch("link");
  3559. ######### final Fetch<TestEntity, TestEntity> linkSelectFetch = root.fetch("linkSelect");
  3560. ######### final Fetch<TestEntity, TestEntity> linkJoinFetch = root.fetch("linkJoin");
  3561. ######### final Fetch<TestEntity, TestEntity> linkNoProxyFetch = root.fetch("linkNoProxy");
  3562. ######### final Fetch<TestEntity, TestEntity> linkNoProxySelectFetch = root.fetch("linkNoProxySelect");
  3563. ######### final Fetch<TestEntity, TestEntity> linkNoProxyJoinFetch = root.fetch("linkNoProxyJoin");
  3564. ######### final Fetch<TestEntity, TestEntity> linkLazyFetch = root.fetch("linkLazy");
  3565. ######### final Fetch<TestEntity, TestEntity> linkLazySelectFetch = root.fetch("linkLazySelect");
  3566. ######### final Fetch<TestEntity, TestEntity> linkLazyJoinFetch = root.fetch("linkLazyJoin");
  3567. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyFetch = root.fetch("linkLazyNoProxy");
  3568. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxySelectFetch = root.fetch("linkLazyNoProxySelect");
  3569. ######### final Fetch<TestEntity, TestEntity> linkLazyNoProxyJoinFetch = root.fetch("linkLazyNoProxyJoin");
  3570. ######### final TypedQuery<TestEntity> tq = session.createQuery(query);
  3571. ######### final TestEntity test = tq.getSingleResult();
  3572. Hibernate:
  3573. select
  3574. testentity0_.id as id1_28_0_,
  3575. testentity1_.id as id1_28_1_,
  3576. testentity2_.id as id1_28_2_,
  3577. testentity3_.id as id1_28_3_,
  3578. testentity4_.id as id1_28_4_,
  3579. testentity5_.id as id1_28_5_,
  3580. testentity6_.id as id1_28_6_,
  3581. testentity7_.id as id1_28_7_,
  3582. testentity8_.id as id1_28_8_,
  3583. testentity9_.id as id1_28_9_,
  3584. testentity10_.id as id1_28_10_,
  3585. testentity11_.id as id1_28_11_,
  3586. testentity12_.id as id1_28_12_,
  3587. testentity0_.link_id as link_id4_28_0_,
  3588. testentity0_.linkJoin_id as linkjoin5_28_0_,
  3589. testentity0_.linkLazy_id as linklazy6_28_0_,
  3590. testentity0_.linkLazyJoin_id as linklazy7_28_0_,
  3591. testentity0_.linkLazyNoProxyJoin_id as linklazy9_28_0_,
  3592. testentity0_.linkLazySelect_id as linklaz11_28_0_,
  3593. testentity0_.linkNoProxyJoin_id as linknop13_28_0_,
  3594. testentity0_.linkSelect_id as linksel15_28_0_,
  3595. testentity0_.name as name2_28_0_,
  3596. testentity0_.version as version3_28_0_,
  3597. testentity1_.link_id as link_id4_28_1_,
  3598. testentity1_.linkJoin_id as linkjoin5_28_1_,
  3599. testentity1_.linkLazy_id as linklazy6_28_1_,
  3600. testentity1_.linkLazyJoin_id as linklazy7_28_1_,
  3601. testentity1_.linkLazyNoProxyJoin_id as linklazy9_28_1_,
  3602. testentity1_.linkLazySelect_id as linklaz11_28_1_,
  3603. testentity1_.linkNoProxyJoin_id as linknop13_28_1_,
  3604. testentity1_.linkSelect_id as linksel15_28_1_,
  3605. testentity1_.name as name2_28_1_,
  3606. testentity1_.version as version3_28_1_,
  3607. testentity2_.link_id as link_id4_28_2_,
  3608. testentity2_.linkJoin_id as linkjoin5_28_2_,
  3609. testentity2_.linkLazy_id as linklazy6_28_2_,
  3610. testentity2_.linkLazyJoin_id as linklazy7_28_2_,
  3611. testentity2_.linkLazyNoProxyJoin_id as linklazy9_28_2_,
  3612. testentity2_.linkLazySelect_id as linklaz11_28_2_,
  3613. testentity2_.linkNoProxyJoin_id as linknop13_28_2_,
  3614. testentity2_.linkSelect_id as linksel15_28_2_,
  3615. testentity2_.name as name2_28_2_,
  3616. testentity2_.version as version3_28_2_,
  3617. testentity3_.link_id as link_id4_28_3_,
  3618. testentity3_.linkJoin_id as linkjoin5_28_3_,
  3619. testentity3_.linkLazy_id as linklazy6_28_3_,
  3620. testentity3_.linkLazyJoin_id as linklazy7_28_3_,
  3621. testentity3_.linkLazyNoProxyJoin_id as linklazy9_28_3_,
  3622. testentity3_.linkLazySelect_id as linklaz11_28_3_,
  3623. testentity3_.linkNoProxyJoin_id as linknop13_28_3_,
  3624. testentity3_.linkSelect_id as linksel15_28_3_,
  3625. testentity3_.name as name2_28_3_,
  3626. testentity3_.version as version3_28_3_,
  3627. testentity4_.link_id as link_id4_28_4_,
  3628. testentity4_.linkJoin_id as linkjoin5_28_4_,
  3629. testentity4_.linkLazy_id as linklazy6_28_4_,
  3630. testentity4_.linkLazyJoin_id as linklazy7_28_4_,
  3631. testentity4_.linkLazyNoProxyJoin_id as linklazy9_28_4_,
  3632. testentity4_.linkLazySelect_id as linklaz11_28_4_,
  3633. testentity4_.linkNoProxyJoin_id as linknop13_28_4_,
  3634. testentity4_.linkSelect_id as linksel15_28_4_,
  3635. testentity4_.name as name2_28_4_,
  3636. testentity4_.version as version3_28_4_,
  3637. testentity5_.link_id as link_id4_28_5_,
  3638. testentity5_.linkJoin_id as linkjoin5_28_5_,
  3639. testentity5_.linkLazy_id as linklazy6_28_5_,
  3640. testentity5_.linkLazyJoin_id as linklazy7_28_5_,
  3641. testentity5_.linkLazyNoProxyJoin_id as linklazy9_28_5_,
  3642. testentity5_.linkLazySelect_id as linklaz11_28_5_,
  3643. testentity5_.linkNoProxyJoin_id as linknop13_28_5_,
  3644. testentity5_.linkSelect_id as linksel15_28_5_,
  3645. testentity5_.name as name2_28_5_,
  3646. testentity5_.version as version3_28_5_,
  3647. testentity6_.link_id as link_id4_28_6_,
  3648. testentity6_.linkJoin_id as linkjoin5_28_6_,
  3649. testentity6_.linkLazy_id as linklazy6_28_6_,
  3650. testentity6_.linkLazyJoin_id as linklazy7_28_6_,
  3651. testentity6_.linkLazyNoProxyJoin_id as linklazy9_28_6_,
  3652. testentity6_.linkLazySelect_id as linklaz11_28_6_,
  3653. testentity6_.linkNoProxyJoin_id as linknop13_28_6_,
  3654. testentity6_.linkSelect_id as linksel15_28_6_,
  3655. testentity6_.name as name2_28_6_,
  3656. testentity6_.version as version3_28_6_,
  3657. testentity7_.link_id as link_id4_28_7_,
  3658. testentity7_.linkJoin_id as linkjoin5_28_7_,
  3659. testentity7_.linkLazy_id as linklazy6_28_7_,
  3660. testentity7_.linkLazyJoin_id as linklazy7_28_7_,
  3661. testentity7_.linkLazyNoProxyJoin_id as linklazy9_28_7_,
  3662. testentity7_.linkLazySelect_id as linklaz11_28_7_,
  3663. testentity7_.linkNoProxyJoin_id as linknop13_28_7_,
  3664. testentity7_.linkSelect_id as linksel15_28_7_,
  3665. testentity7_.name as name2_28_7_,
  3666. testentity7_.version as version3_28_7_,
  3667. testentity8_.link_id as link_id4_28_8_,
  3668. testentity8_.linkJoin_id as linkjoin5_28_8_,
  3669. testentity8_.linkLazy_id as linklazy6_28_8_,
  3670. testentity8_.linkLazyJoin_id as linklazy7_28_8_,
  3671. testentity8_.linkLazyNoProxyJoin_id as linklazy9_28_8_,
  3672. testentity8_.linkLazySelect_id as linklaz11_28_8_,
  3673. testentity8_.linkNoProxyJoin_id as linknop13_28_8_,
  3674. testentity8_.linkSelect_id as linksel15_28_8_,
  3675. testentity8_.name as name2_28_8_,
  3676. testentity8_.version as version3_28_8_,
  3677. testentity9_.link_id as link_id4_28_9_,
  3678. testentity9_.linkJoin_id as linkjoin5_28_9_,
  3679. testentity9_.linkLazy_id as linklazy6_28_9_,
  3680. testentity9_.linkLazyJoin_id as linklazy7_28_9_,
  3681. testentity9_.linkLazyNoProxyJoin_id as linklazy9_28_9_,
  3682. testentity9_.linkLazySelect_id as linklaz11_28_9_,
  3683. testentity9_.linkNoProxyJoin_id as linknop13_28_9_,
  3684. testentity9_.linkSelect_id as linksel15_28_9_,
  3685. testentity9_.name as name2_28_9_,
  3686. testentity9_.version as version3_28_9_,
  3687. testentity10_.link_id as link_id4_28_10_,
  3688. testentity10_.linkJoin_id as linkjoin5_28_10_,
  3689. testentity10_.linkLazy_id as linklazy6_28_10_,
  3690. testentity10_.linkLazyJoin_id as linklazy7_28_10_,
  3691. testentity10_.linkLazyNoProxyJoin_id as linklazy9_28_10_,
  3692. testentity10_.linkLazySelect_id as linklaz11_28_10_,
  3693. testentity10_.linkNoProxyJoin_id as linknop13_28_10_,
  3694. testentity10_.linkSelect_id as linksel15_28_10_,
  3695. testentity10_.name as name2_28_10_,
  3696. testentity10_.version as version3_28_10_,
  3697. testentity11_.link_id as link_id4_28_11_,
  3698. testentity11_.linkJoin_id as linkjoin5_28_11_,
  3699. testentity11_.linkLazy_id as linklazy6_28_11_,
  3700. testentity11_.linkLazyJoin_id as linklazy7_28_11_,
  3701. testentity11_.linkLazyNoProxyJoin_id as linklazy9_28_11_,
  3702. testentity11_.linkLazySelect_id as linklaz11_28_11_,
  3703. testentity11_.linkNoProxyJoin_id as linknop13_28_11_,
  3704. testentity11_.linkSelect_id as linksel15_28_11_,
  3705. testentity11_.name as name2_28_11_,
  3706. testentity11_.version as version3_28_11_,
  3707. testentity12_.link_id as link_id4_28_12_,
  3708. testentity12_.linkJoin_id as linkjoin5_28_12_,
  3709. testentity12_.linkLazy_id as linklazy6_28_12_,
  3710. testentity12_.linkLazyJoin_id as linklazy7_28_12_,
  3711. testentity12_.linkLazyNoProxyJoin_id as linklazy9_28_12_,
  3712. testentity12_.linkLazySelect_id as linklaz11_28_12_,
  3713. testentity12_.linkNoProxyJoin_id as linknop13_28_12_,
  3714. testentity12_.linkSelect_id as linksel15_28_12_,
  3715. testentity12_.name as name2_28_12_,
  3716. testentity12_.version as version3_28_12_
  3717. from
  3718. loading_test testentity0_
  3719. inner join
  3720. loading_test testentity1_
  3721. on testentity0_.link_id=testentity1_.id
  3722. inner join
  3723. loading_test testentity2_
  3724. on testentity0_.linkSelect_id=testentity2_.id
  3725. inner join
  3726. loading_test testentity3_
  3727. on testentity0_.linkJoin_id=testentity3_.id
  3728. inner join
  3729. loading_test testentity4_
  3730. on testentity0_.linkNoProxy_id=testentity4_.id
  3731. inner join
  3732. loading_test testentity5_
  3733. on testentity0_.linkNoProxySelect_id=testentity5_.id
  3734. inner join
  3735. loading_test testentity6_
  3736. on testentity0_.linkNoProxyJoin_id=testentity6_.id
  3737. inner join
  3738. loading_test testentity7_
  3739. on testentity0_.linkLazy_id=testentity7_.id
  3740. inner join
  3741. loading_test testentity8_
  3742. on testentity0_.linkLazySelect_id=testentity8_.id
  3743. inner join
  3744. loading_test testentity9_
  3745. on testentity0_.linkLazyJoin_id=testentity9_.id
  3746. inner join
  3747. loading_test testentity10_
  3748. on testentity0_.linkLazyNoProxy_id=testentity10_.id
  3749. inner join
  3750. loading_test testentity11_
  3751. on testentity0_.linkLazyNoProxySelect_id=testentity11_.id
  3752. inner join
  3753. loading_test testentity12_
  3754. on testentity0_.linkLazyNoProxyJoin_id=testentity12_.id
  3755. where
  3756. testentity0_.id=203
  3757. ######### test.reportInitializationState();
  3758. ######### ================================================================================
  3759. ######### #203:id-name-fetch Initialization State
  3760. ######### --------------------------------------------------------------------------------
  3761. ######### link: YES 12/12
  3762. ######### linkJoin: YES 12/12
  3763. ######### linkLazy: YES 12/12
  3764. ######### linkLazyJoin: YES 12/12
  3765. ######### linkLazyNoProxy: n/a 0/12
  3766. ######### linkLazyNoProxyJoin: YES 12/12
  3767. ######### linkLazyNoProxySelect: n/a 0/12
  3768. ######### linkLazySelect: YES 12/12
  3769. ######### linkNoProxy: n/a 0/12
  3770. ######### linkNoProxyJoin: YES 12/12
  3771. ######### linkNoProxySelect: n/a 0/12
  3772. ######### linkSelect: YES 12/12
  3773. ######### --------------------------------------------------------------------------------
  3774. ######### #203:id-name-fetch Reflection State
  3775. ######### --------------------------------------------------------------------------------
  3776. ######### link: HERE 12/12
  3777. ######### linkJoin: HERE 12/12
  3778. ######### linkLazy: HERE 12/12
  3779. ######### linkLazyJoin: HERE 12/12
  3780. ######### linkLazyNoProxy: null 0/12
  3781. ######### linkLazyNoProxyJoin: HERE 12/12
  3782. ######### linkLazyNoProxySelect: null 0/12
  3783. ######### linkLazySelect: HERE 12/12
  3784. ######### linkNoProxy: null 0/12
  3785. ######### linkNoProxyJoin: HERE 12/12
  3786. ######### linkNoProxySelect: null 0/12
  3787. ######### linkSelect: HERE 12/12
  3788. ######### ================================================================================
  3789. ######### test.printAll();
  3790. ######### ================================================================================
  3791. ######### #203:id-name-fetch
  3792. ######### --------------------------------------------------------------------------------
  3793. ######### link = #1:link
  3794. ######### linkSelect = #2:linkSelect
  3795. ######### linkJoin = #3:linkJoin
  3796. Hibernate:
  3797. select
  3798. testentity_.linkLazyNoProxy_id as linklazy8_28_,
  3799. testentity_.linkLazyNoProxySelect_id as linklaz10_28_,
  3800. testentity_.linkNoProxy_id as linknop12_28_,
  3801. testentity_.linkNoProxySelect_id as linknop14_28_
  3802. from
  3803. loading_test testentity_
  3804. where
  3805. testentity_.id=?
  3806. ######### linkNoProxy = #5:linkNoProxy
  3807. ######### linkNoProxySelect = #6:linkNoProxySelect
  3808. ######### linkNoProxyJoin = #7:linkNoProxyJoin
  3809. ######### linkLazy = #9:linkLazy
  3810. ######### linkLazySelect = #10:linkLazySelect
  3811. ######### linkLazyJoin = #11:linkLazyJoin
  3812. ######### linkLazyNoProxy = #13:linkLazyNoProxy
  3813. ######### linkLazyNoProxySelect = #14:linkLazyNoProxySelect
  3814. ######### linkLazyNoProxyJoin = #15:linkLazyNoProxyJoin
  3815. ######### ================================================================================
  3816. ######### ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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!