HSQLDialect uses invalid select-clause null string for BLOB on HSQLDB 2.0

Description

The union select statement that is generated for multiple subclasses of an entity, when one of the subclasses uses a Lob, contains an invalid cast null on HSQLDB 2.0.

From version 2.0 on HSQLDB supports data type BLOB and no longer forces using longvarbinary for blobs. While the HSQLDialect registers the appropriate column type for LOB now, it uses "cast(null as int)" in its getSelectClauseNullString in the union select described above, which causes HSQLDB error 'incompatible data types in combination'.

Environment

HSQLDB 2.0

Activity

Show:
Fred Toussi
June 27, 2011, 6:33 PM

Patch fixes this issue.

Brett Meyer
March 7, 2014, 5:30 PM

Bulk closing rejected tickets in "resolved" state.

Duplicate

Assignee

Gail Badner

Reporter

Bart Bakker

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major