PostgresArrayIntegrationTest

2026-08-10T16:32:50.945Z  INFO 382 --- [    Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.mapper.PostgresArrayIntegrationTest]: PostgresArrayIntegrationTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T16:32:50.966Z  INFO 382 --- [    Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.mapper.PostgresArrayIntegrationTest

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/

 :: Spring Boot ::                (v3.5.5)

2026-08-10T16:32:51.024Z  INFO 382 --- [    Test worker] n.h.h.m.PostgresArrayIntegrationTest     : Starting PostgresArrayIntegrationTest using Java 21.0.11 with PID 382 (started by root in /home/tallyman/hs.hsadmin.ng/.git/gittally/worktrees/master-fc613b4dfd67)
2026-08-10T16:32:51.024Z  INFO 382 --- [    Test worker] n.h.h.m.PostgresArrayIntegrationTest     : No active profile set, falling back to 1 default profile: "default"
2026-08-10T16:32:51.186Z  INFO 382 --- [    Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-08-10T16:32:51.261Z  INFO 382 --- [    Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 72 ms. Found 35 JPA repository interfaces.
2026-08-10T16:32:51.332Z  INFO 382 --- [    Test worker] com.zaxxer.hikari.HikariDataSource       : HikariPool-4 - Starting...
2026-08-10T16:32:51.358Z  INFO 382 --- [    Test worker] com.zaxxer.hikari.pool.HikariPool        : HikariPool-4 - Added connection org.testcontainers.jdbc.ConnectionWrapper@45fdc77
2026-08-10T16:32:51.358Z  INFO 382 --- [    Test worker] com.zaxxer.hikari.HikariDataSource       : HikariPool-4 - Start completed.
2026-08-10T16:32:51.655Z  WARN 382 --- [    Test worker] liquibase.executor                       : Context defined as: testing currentSubjectUuid, , hsh-fran_superuser, []
2026-08-10T16:32:51.655Z  WARN 382 --- [    Test worker] liquibase.executor                       : Context defined as: testing currentSubjectUuid, , hsh-alex_superuser, []
2026-08-10T16:32:51.698Z  INFO 382 --- [    Test worker] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-08-10T16:32:51.700Z  INFO 382 --- [    Test worker] o.h.c.internal.RegionFactoryInitiator    : HHH000026: Second-level cache disabled
2026-08-10T16:32:51.703Z  INFO 382 --- [    Test worker] org.hibernate.orm.connections.pooling    : HHH10001005: Database info:
	Database JDBC URL [Connecting through datasource 'proxyDataSourceDecorator [net.ttddyy.dsproxy.support.ProxyDataSource] -> dataSource [com.zaxxer.hikari.HikariDataSource]']
	Database driver: undefined/unknown
	Database version: 15.5
	Autocommit mode: undefined/unknown
	Isolation level: undefined/unknown
	Minimum pool size: undefined/unknown
	Maximum pool size: undefined/unknown
2026-08-10T16:32:51.709Z  INFO 382 --- [    Test worker] o.s.o.j.p.SpringPersistenceUnitInfo      : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-08-10T16:32:51.745Z  WARN 382 --- [    Test worker] o.h.boot.model.internal.ToOneBinder      : HHH000491: 'net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity.partner' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:32:51.745Z  WARN 382 --- [    Test worker] o.h.boot.model.internal.ToOneBinder      : HHH000491: 'net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity.refundBankAccount' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:32:51.756Z  WARN 382 --- [    Test worker] o.h.boot.model.internal.ToOneBinder      : HHH000491: 'net.hostsharing.hsadminng.hs.office.partner.HsOfficePartnerRbacEntity.details' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:32:51.758Z  WARN 382 --- [    Test worker] o.h.boot.model.internal.ToOneBinder      : HHH000491: 'net.hostsharing.hsadminng.hs.office.partner.HsOfficePartnerRealEntity.details' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:32:52.094Z  INFO 382 --- [    Test worker] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2026-08-10T16:32:52.095Z  INFO 382 --- [    Test worker] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-08-10T16:32:52.356Z  INFO 382 --- [    Test worker] n.h.h.m.PostgresArrayIntegrationTest     : Started PostgresArrayIntegrationTest in 1.387 seconds (process running for 268.023)
Hibernate: create or replace function returnStringArray()
    returns varchar(63)[]
    stable -- leakproof
    language plpgsql as $$
declare
    text1 text = 'one';
    text2 text = 'two, three';
    text3 text = 'four; five';
    text4 text = 'say "Hello" to me';
begin
    return array[text1, text2, text3, null, text4];
end; $$;

Hibernate: SELECT returnStringArray()
Hibernate: create or replace function returnUuidArray()
    returns uuid[]
    stable -- leakproof
    language plpgsql as $$
declare
    uuid1 UUID = 'f47ac10b-58cc-4372-a567-0e02b2c3d479';
    uuid2 UUID = '6ba7b810-9dad-11d1-80b4-00c04fd430c8';
    uuid3 UUID = '01234567-89ab-cdef-0123-456789abcdef';
begin
    return ARRAY[uuid1, uuid2, null, uuid3];
end; $$;

Hibernate: SELECT returnUuidArray()
Hibernate: create or replace function returnEmptyArray()
    returns text[]
    stable -- leakproof
    language plpgsql as $$
declare
    emptyArray text[] = '{}';
begin
    return emptyArray;
end; $$;

Hibernate: SELECT returnEmptyArray()