FindAssets

5

tests

0

failures

0

ignored

6.059s

duration

100%

successful

Tests

Test Method name Duration Result
[1] testCase=REAL globalAdmin_withoutAssumedRole_canViewArbitraryAssetsOfAllDebitors(TestCase)[1] 1.241s passed
[2] testCase=RBAC globalAdmin_withoutAssumedRole_canViewArbitraryAssetsOfAllDebitors(TestCase)[2] 1.221s passed
managedServerAgent_canFindAssetsRelatedToManagedServer() managedServerAgent_canFindAssetsRelatedToManagedServer() 1.187s passed
managedServerAgent_canFindRelatedEmailAddresses() managedServerAgent_canFindRelatedEmailAddresses() 1.188s passed
normalUser_canViewOnlyRelatedAssets() normalUser_canViewOnlyRelatedAssets() 1.222s passed

Standard output

2026-08-10T13:33:39.350Z  INFO 370 --- [    Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.hosting.asset.HsHostingAssetRepositoryIntegrationTest$FindAssets]: FindAssets does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T13:33:39.360Z  INFO 370 --- [    Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.hosting.asset.HsHostingAssetRepositoryIntegrationTest$FindAssets
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
[1] testCase=REAL: 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:     select ha.uuid,
           ha.alarmcontactuuid,
           ha.assignedtoassetuuid,
           ha.bookingitemuuid,
           ha.caption,
           ha.config,
           ha.identifier,
           ha.parentassetuuid,
           ha.type,
           ha.version
        from hs_hosting.asset_rv ha
            left join hs_booking.item bi on bi.uuid = ha.bookingitemuuid
            left join hs_hosting.asset pha on pha.uuid = ha.parentassetuuid
        where (? is null or bi.projectuuid=?)
          and (? is null or pha.uuid=?)
          and (? is null or ?=cast(ha.type as text))

Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
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
[1] testCase=REAL: 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
[2] testCase=RBAC: 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:     select ha.uuid,
           ha.alarmcontactuuid,
           ha.assignedtoassetuuid,
           ha.bookingitemuuid,
           ha.caption,
           ha.config,
           ha.identifier,
           ha.parentassetuuid,
           ha.type,
           ha.version
        from hs_hosting.asset_rv ha
            left join hs_booking.item bi on bi.uuid = ha.bookingitemuuid
            left join hs_hosting.asset pha on pha.uuid = ha.parentassetuuid
        where (? is null or bi.projectuuid=?)
          and (? is null or pha.uuid=?)
          and (? is null or ?=cast(ha.type as text))

Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
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
[2] testCase=RBAC: 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
managedServerAgent_canFindRelatedEmailAddresses(): 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 ha.uuid,
           ha.alarmcontactuuid,
           ha.assignedtoassetuuid,
           ha.bookingitemuuid,
           ha.caption,
           ha.config,
           ha.identifier,
           ha.parentassetuuid,
           ha.type,
           ha.version
        from hs_hosting.asset_rv ha
            left join hs_booking.item bi on bi.uuid = ha.bookingitemuuid
            left join hs_hosting.asset pha on pha.uuid = ha.parentassetuuid
        where (? is null or bi.projectuuid=?)
          and (? is null or pha.uuid=?)
          and (? is null or ?=cast(ha.type as text))

Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
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
managedServerAgent_canFindRelatedEmailAddresses(): 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_canViewOnlyRelatedAssets(): 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: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,hbpre1_0.version from hs_booking.project_rv hbpre1_0 where hbpre1_0.caption=?
Hibernate: select hbde1_0.uuid,hbde1_0.debitornumber,hbde1_0.defaultprefix from hs_booking.debitor_xv hbde1_0 where hbde1_0.uuid=?
Hibernate:     select ha.uuid,
           ha.alarmcontactuuid,
           ha.assignedtoassetuuid,
           ha.bookingitemuuid,
           ha.caption,
           ha.config,
           ha.identifier,
           ha.parentassetuuid,
           ha.type,
           ha.version
        from hs_hosting.asset_rv ha
            left join hs_booking.item bi on bi.uuid = ha.bookingitemuuid
            left join hs_hosting.asset pha on pha.uuid = ha.parentassetuuid
        where (? is null or bi.projectuuid=?)
          and (? is null or pha.uuid=?)
          and (? is null or ?=cast(ha.type as text))

Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
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_canViewOnlyRelatedAssets(): 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
managedServerAgent_canFindAssetsRelatedToManagedServer(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: select hhare1_0.uuid,hhare1_0.alarmcontactuuid,hhare1_0.assignedtoassetuuid,hhare1_0.bookingitemuuid,hhare1_0.caption,hhare1_0.config,hhare1_0.identifier,hhare1_0.parentassetuuid,hhare1_0.type,hhare1_0.version from hs_hosting.asset hhare1_0 where hhare1_0.identifier=?
Hibernate: call base.defineContext(
    cast(? as varchar(127)),
    cast(? as text),
    cast(? as varchar(63)),
    cast(? as text),
    cast(? as text));

Hibernate:     select ha.uuid,
           ha.alarmcontactuuid,
           ha.assignedtoassetuuid,
           ha.bookingitemuuid,
           ha.caption,
           ha.config,
           ha.identifier,
           ha.parentassetuuid,
           ha.type,
           ha.version
        from hs_hosting.asset_rv ha
            left join hs_booking.item bi on bi.uuid = ha.bookingitemuuid
            left join hs_hosting.asset pha on pha.uuid = ha.parentassetuuid
        where (? is null or bi.projectuuid=?)
          and (? is null or pha.uuid=?)
          and (? is null or ?=cast(ha.type as text))

Hibernate: select hbire1_0.uuid,hbire1_0.caption,hbire1_0.parentitemuuid,hbire1_0.projectuuid,hbire1_0.resources,hbire1_0.type,hbire1_0.validity,hbire1_0.version from hs_booking.item hbire1_0 where hbire1_0.uuid=?
Hibernate: select hbpre1_0.uuid,hbpre1_0.caption,hbpre1_0.debitoruuid,d1_0.uuid,d1_0.debitornumber,d1_0.defaultprefix,hbpre1_0.version from hs_booking.project hbpre1_0 join hs_booking.debitor_xv d1_0 on d1_0.uuid=hbpre1_0.debitoruuid where hbpre1_0.uuid=?
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
managedServerAgent_canFindAssetsRelatedToManagedServer(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0