Skip to content

Instantly share code, notes, and snippets.

@ptahchiev
Created February 20, 2019 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ptahchiev/4d0563d3c1ef7863c1ba06577ef4d627 to your computer and use it in GitHub Desktop.
Save ptahchiev/4d0563d3c1ef7863c1ba06577ef4d627 to your computer and use it in GitHub Desktop.
msp.description contains
Hibernate:
/* select
messageSourcePropertyEntity
from
message_source_property messageSourcePropertyEntity
left join
messageSourcePropertyEntity.description as messageSourcePropertyEntity_description_0 with key(messageSourcePropertyEntity_description_0) = ?1
where
locate(?2,messageSourcePropertyEntity_description_0.value)-1 >= ?3 */ select
messagesou0_.id as id1_119_,
messagesou0_.code as code2_119_,
messagesou0_.created_by as created_by3_119_,
messagesou0_.created_date as created_date4_119_,
messagesou0_.last_modified_by as last_modified_by5_119_,
messagesou0_.last_modified_date as last_modified_date6_119_
from
message_source_property messagesou0_
left outer join
message_source_property_description_lv descriptio1_
on messagesou0_.id=descriptio1_.message_source_property_id
and (
descriptio1_.locale=?
)
where
instr(descriptio1_.val,?)-1>=? fetch first ? rows only
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Hibernate:
select
descriptio0_.message_source_property_id as message_source_pro1_120_0_,
descriptio0_.val as val2_120_0_,
descriptio0_.locale as locale3_0_
from
message_source_property_description_lv descriptio0_
where
descriptio0_.message_source_property_id=?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment