H2Dialect should use CACHED option for temporary table creation

Description

Response from Thomas, answering my question:

I guess I would use 'cached' tables (meaning the data is persisted,
and the indexes are persisted), just to avoid out-of-memory in all
cases. If it turns out to be a performance problem (which I don't
think it will) it could still be changed later on.

should get replaced with

Environment

None

Assignee

Steve Ebersole

Reporter

Steve Ebersole

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure