Advertisement
Guest User

TestEntity-hibernate.bytecode.allow_enhancement_as_proxy=true.log

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