Form-feed (\f 0x0C) in generated SQL triggers exceptions in Firebird

Description

Firebird has a problem with some of the SQL generated by Hibernate, in some queries Hibernate appends StringHelper.WHITESPACE between conditions (specifically in CollectionBinder.bindFilters(boolean)).

The problem is that StringHelper.WHITESPACE contains a formfeed (\f, 0x0C), and Firebird does not accept a formfeed as whitespace.

It looks like the usage of StringHelper.WHITESPACE is wrong; the other places this constant is used is for splitting/tokenizing strings, and not for adding whitespace.

This was introduced in commit bf9b3f524d271eaf055cfda4f66a7a3acb714c0d for in 5.2.0.

I will create a PR for this shortly

Environment

None

Activity

Show:
Mark Rotteveel
February 7, 2017, 3:53 PM

Assignee

Mark Rotteveel

Reporter

Mark Rotteveel

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Components

Affects versions

Priority

Minor
Configure