[hibernate-dev] Form-feed (\f 0x0C) in generated SQL

Mark Rotteveel mark at lawinegevaar.nl
Tue Feb 7 10:58:20 EST 2017


Issue: https://hibernate.atlassian.net/browse/HHH-11467
PR: https://github.com/hibernate/hibernate-orm/pull/1781

On 4-2-2017 15:05, Mark Rotteveel wrote:
> 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.
>
> Is there any objection if I replace the usage in
> CollectionBinder.bindFilters(boolean) with a single space (or maybe with
> " \n\t" to produce more similar SQL as previous)?
>
> Mark
>


-- 
Mark Rotteveel


More information about the hibernate-dev mailing list