We're updating the issue view to help you get more done. 

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

Status

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

5.2.2
5.2.0
5.2.6
5.2.3
5.2.7
5.2.4
5.2.5
5.2.1

Priority

Minor