Hi all,

It seems that an empty string used in a CASE expression is converted to a
space:

SELECT 'aa' || CASE WHEN (1 = 1) THEN '' ELSE 'x' END || 'bb'
FROM rdb$database

This will result in 'aa bb' with a space between aa and bb. I expect 'aabb'

I use Firebird 1.5 RC9 but the same with RC8.

(* I tried to post this in firebird-develop, but it was not accepted for
some reason *)

Robert