IIF and LF CR bug
-----------------
Key: CORE-4208
URL: http://tracker.firebirdsql.org/browse/CORE-4208
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2
Reporter: Attila Molnár
Priority: Minor
Hi!
SELECT REPLACE('a' || IIF(1 = 1, ' ', ASCII_CHAR(13) || ASCII_CHAR(10)) || 'b',
' ', '*')
FROM rdb$database
returns "a*b", but it shold be "a**b", due to padding to 2.
SELECT REPLACE('a' || IIF(1 = 1, ' ', x'0D0A') || 'b', ' ', '*')
FROM rdb$database
returns "a*", but it shold be "a**b", due to padding to 2. Also in this case
padding char is #0, not #32.
--
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
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
