[Hibernate]
drop table if exists table_test cascade
[Hibernate]
create table table_test (
type varchar(31) not null,
id bigint not null,
property jsonb,
primary key (id)
)
[INFO] HHH000476: Executing script 'file:/Users/gavin/Downloads/test/untitled/build/resources/main/import.sql'
[Hibernate] INSERT INTO table_test(id, type, property) VALUES('1','A','{"propertyA": "valueA"}'::jsonb)
[Hibernate] INSERT INTO table_test(id, type, property) VALUES('2','B','{"propertyB": "valueB"}'::jsonb)
[Hibernate]
select
e1_0.id,
e1_0.property
from
table_test e1_0
where
e1_0.type='A'
and e1_0.id=?
[Hibernate]
select
e1_0.id,
e1_0.property
from
table_test e1_0
where
e1_0.type='B'
and e1_0.id=?