FindAllCoopSharesTransactions

4

tests

0

failures

0

ignored

5.648s

duration

100%

successful

Tests

Test Duration Result
globalAdmin_canViewAllCoopSharesTransactions() 1.381s passed
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuid() 1.472s passed
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuidAndValueDateRange() 1.380s passed
normalUser_canViewOnlyRelatedCoopSharesTransactions() 1.415s passed

Standard output

2026-08-10T15:04:59.143Z  INFO 373 --- [    Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.coopshares.HsOfficeCoopSharesTransactionRepositoryIntegrationTest$FindAllCoopSharesTransactions]: FindAllCoopSharesTransactions does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T15:04:59.149Z  INFO 373 --- [    Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.coopshares.HsOfficeCoopSharesTransactionRepositoryIntegrationTest$FindAllCoopSharesTransactions
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuid(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 join hs_office.partner p1_0 on p1_0.uuid=home1_0.partneruuid where (?=p1_0.partnernumber) and (home1_0.membernumbersuffix=?) order by home1_0.membernumbersuffix
Hibernate: select hocste1_0.uuid,hocste1_0.comment,hocste1_0.membershipuuid,hocste1_0.reference,hocste1_0.revertedsharetxuuid,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid where (cast(? as varchar) is null or hocste1_0.membershipuuid=?) and (cast(? as date) is null or (hocste1_0.valuedate>=?)) and (cast(? as date) is null or (hocste1_0.valuedate<=?)) order by m1_0.membernumbersuffix,hocste1_0.valuedate
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuid(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdmin_canViewAllCoopSharesTransactions(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hocste1_0.uuid,hocste1_0.comment,hocste1_0.membershipuuid,hocste1_0.reference,hocste1_0.revertedsharetxuuid,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid where (cast(? as varchar) is null or hocste1_0.membershipuuid=?) and (cast(? as date) is null or (hocste1_0.valuedate>=?)) and (cast(? as date) is null or (hocste1_0.valuedate<=?)) order by m1_0.membernumbersuffix,hocste1_0.valuedate
Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 where home1_0.uuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 where home1_0.uuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 where home1_0.uuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdmin_canViewAllCoopSharesTransactions(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuidAndValueDateRange(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 join hs_office.partner p1_0 on p1_0.uuid=home1_0.partneruuid where (?=p1_0.partnernumber) and (home1_0.membernumbersuffix=?) order by home1_0.membernumbersuffix
Hibernate: select hocste1_0.uuid,hocste1_0.comment,hocste1_0.membershipuuid,hocste1_0.reference,hocste1_0.revertedsharetxuuid,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid where (cast(? as varchar) is null or hocste1_0.membershipuuid=?) and (cast(? as date) is null or (hocste1_0.valuedate>=?)) and (cast(? as date) is null or (hocste1_0.valuedate<=?)) order by m1_0.membernumbersuffix,hocste1_0.valuedate
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdmin_canViewCoopSharesTransactions_filteredByMembershipUuidAndValueDateRange(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
normalUser_canViewOnlyRelatedCoopSharesTransactions(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select hocste1_0.uuid,hocste1_0.comment,hocste1_0.membershipuuid,hocste1_0.reference,hocste1_0.revertedsharetxuuid,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid where (cast(? as varchar) is null or hocste1_0.membershipuuid=?) and (cast(? as date) is null or (hocste1_0.valuedate>=?)) and (cast(? as date) is null or (hocste1_0.valuedate<=?)) order by m1_0.membernumbersuffix,hocste1_0.valuedate
Hibernate: select home1_0.uuid,home1_0.membernumbersuffix,home1_0.membershipfeebillable,home1_0.partneruuid,home1_0.status,home1_0.validity,home1_0.version from hs_office.membership_rv home1_0 where home1_0.uuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hocste1_0.uuid,hocste1_0.comment,m1_0.uuid,m1_0.membernumbersuffix,m1_0.membershipfeebillable,m1_0.partneruuid,m1_0.status,m1_0.validity,m1_0.version,hocste1_0.reference,rst1_0.uuid,rst1_0.comment,m2_0.uuid,m2_0.membernumbersuffix,m2_0.membershipfeebillable,m2_0.partneruuid,m2_0.status,m2_0.validity,m2_0.version,rst1_0.reference,rst1_0.sharecount,rst1_0.transactiontype,rst1_0.valuedate,rst1_0.version,rst2_0.uuid,rst2_0.comment,m3_0.uuid,m3_0.membernumbersuffix,m3_0.membershipfeebillable,m3_0.partneruuid,m3_0.status,m3_0.validity,m3_0.version,rst2_0.reference,rst2_0.revertedsharetxuuid,rst2_0.sharecount,rst2_0.transactiontype,rst2_0.valuedate,rst2_0.version,hocste1_0.sharecount,hocste1_0.transactiontype,hocste1_0.valuedate,hocste1_0.version from hs_office.coopsharetx_rv hocste1_0 left join hs_office.membership_rv m1_0 on m1_0.uuid=hocste1_0.membershipuuid left join hs_office.coopsharetx_rv rst1_0 on hocste1_0.uuid=rst1_0.revertedsharetxuuid left join hs_office.membership_rv m2_0 on m2_0.uuid=rst1_0.membershipuuid left join hs_office.coopsharetx_rv rst2_0 on rst2_0.uuid=hocste1_0.revertedsharetxuuid left join hs_office.membership_rv m3_0 on m3_0.uuid=rst2_0.membershipuuid where hocste1_0.revertedsharetxuuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.detailsuuid,hopre1_0.partnernumber,hopre1_0.partnerreluuid,hopre1_0.version from hs_office.partner hopre1_0 where hopre1_0.uuid=?
Hibernate: select hopde1_0.uuid,hopde1_0.birthname,hopde1_0.birthplace,hopde1_0.birthday,hopde1_0.dateofdeath,hopde1_0.registrationnumber,hopde1_0.registrationoffice,hopde1_0.version from hs_office.partner_details_rv hopde1_0 where hopde1_0.uuid=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
normalUser_canViewOnlyRelatedCoopSharesTransactions(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0