LIST function wrongly concatenates binary blobs
-----------------------------------------------
Key: CORE-3476
URL: http://tracker.firebirdsql.org/browse/CORE-3476
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.4, 2.5.0, 3.0 Initial, 2.1.3, 2.1.2, 2.1.1, 2.1.0
Reporter: Dmitry Yemanov
Test case:
SELECT LIST(F, '')
FROM (
SELECT CAST(ASCII_CHAR(0XFF) AS BLOB SUB_TYPE 0) AS F
FROM RDB$DATABASE
UNION ALL
SELECT CAST(ASCII_CHAR(0XDE) AS BLOB SUB_TYPE 0) AS F
FROM RDB$DATABASE
)
returns 0x2E2E instead of the expected 0xFFDE. Internally the contents is
treated as text and thus gets corrected by the blob filter (non-ASCII
characters are replaced with dots).
The plain concatenation works correctly though:
SELECT CAST(ASCII_CHAR(0XFF) AS BLOB SUB_TYPE 0) || CAST(ASCII_CHAR(0XDE) AS
BLOB SUB_TYPE 0)
FROM RDB$DATABASE
returns 0xFFDE.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
