Before reporting an issue

[X] I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

Area

storage

Describe the bug

I install with a custom schema on an oracle database. Our keycloak.conf is as follows:

db=oracle
db-username=xcare
db-password=*
db-url=jdbc:oracle:thin:@//database1:1521/dzxdvipp
db-schema=NXS_SSO

> note the exta property db-schema <

The error we get:

2024-12-10 16:22:58,054 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (WrapperJarAppMain) ERROR: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-oracle::hmlnarik@redhat.com:

The line where it fails in <install>/lib/lib/main/org.keycloak.keycloak-model-jpa-26.0.7.redhat-00001.jar/META-INF/jpa-changelog-2.5.0.xml is:
<sql>UPDATE COMPONENT_CONFIG SET VALUE_NEW = VALUE, VALUE = NULL</sql>

if I patch this line as follows, the upgrade succeeds.

<sql>UPDATE ${database.defaultSchemaName}.COMPONENT_CONFIG SET VALUE_NEW = VALUE, VALUE = NULL</sql>

Version

26.0.7

Regression

[X] The issue is a regression

Expected behavior

Database is build up correctly, no errors are thrown

Actual behavior

an error is thrown

ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (WrapperJarAppMain) ERROR: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-oracle::hmlnarik@redhat.com:

How to Reproduce?

install keycloak in a different schema then the default and declare this schema in the keycloak.conf with the property db-schema

Anything else?

No response