Create View with Substring, Blob and Special Characters
-------------------------------------------------------
Key: CORE-3955
URL: http://tracker.firebirdsql.org/browse/CORE-3955
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.0
Environment: Linux (LI-V6.3.1.26351 Firebird 2.5)
Reporter: Bastian Hösch
When creating a view with a substring expression on a blob field and special
characters, the CREATE_VIEW statement fails:
Example:
Given a table 'SAMPLE_TABLE' with a BLOB-Field, subtype 1 named 'INFORMATION'
the following statement fails:
CREATE VIEW VIEW_TEST (INFO)
AS
SELECT CAST(SUBSTRING(SAMPLE_TABLE.INFORMATION FROM 1 FOR 10) AS VARCHAR(10))
FROM SAMPLE_TABLE
WHERE COALESCE(CAST(SUBSTRING(SAMPLE_TABLE.INFORMATION FROM 1 FOR 10) AS
VARCHAR(10)), '°^^°') <> '°^^°'
The statement select statement itself runs fine.
If I change the statement to
CREATE VIEW VIEW_TEST (INFO)
AS
SELECT CAST(SUBSTRING(SAMPLE_TABLE.INFORMATION FROM 1 FOR 10) AS VARCHAR(10))
FROM SAMPLE_TABLE
WHERE COALESCE(CAST(SUBSTRING(SAMPLE_TABLE.INFORMATION FROM 1 FOR 10) AS
VARCHAR(10)), '-//-') <> '-//-'
the view can be created without problems
--
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
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
