Database Schema Name is not properly applied to SQL statements

Description

I have Activiti tables deployed in H2 database with specified schema named 'ENGINE'. I am not using additional table prefix. Engine configuration has property set "databaseSchema" = "ENGINE" accordingly.

When deploying a process I get SQL exception indicating table cannot be found, because he internal SQL statement does not reflect the schema name.
SQL statement: select * from ACT_GE_PROPERTY where NAME_ = ? [42102-189]

As a work-around we set additional property "databaseTablePrefix" = "ENGINE." to force schema name be applied to all tables, but still get SQL exception in inner joins.

Please make sure schema name is applied to ALL sql statements. This should be independent from table-prefix setting, so all table names are resolved to {schema}.{prefix}table

Environment

H2 in-memory database, but possibly affects other databases too.

Status

Assignee

Joram Barrez

Reporter

Andrey Nikolov

Labels

None

Components

Affects versions

5.18
5.20

Priority

High
Configure