Oninit cdi / Archive
Talk to an expert →

Re: IDS 9.40 FC3 string concatenation

Posted in 2004

Topics: Stored Procedures & SPL, Data Types & Schema Design, Platform-Specific Issues, Versions, Editions & End-of-Life

Jonathan Leffler — — source: Usenet: comp.databases.informix

Leonid Belov wrote: > there is a problem with string concatenation in Informix 9.40FC3 (SRARC Solaris 9) > > 1. SELECT '*' || 'string' || '-' FROM systables where tabid = 100; > > Result: '*string-' > > > 2. SELECT '*' || ('string' || '-') FROM systables where tabid = 100; > > Result: '*string-' > > > 3. CREATE PROCEDURE nvalue() > RETURNING VARCHAR(20); > RETURN 'string'; > END PROCEDURE; > > SELECT '*' || nvalue() || '-' FROM systables where tabid = 100; > > Result: '*string-' > > 4. SELECT '*' || (nvalue() || '-') FROM systables where tabid = 100; > > Result: 'string-*' > > Is it a bug? Yes - and pervasive, it would seem. Please report it to Tech Support because bug reports with a customer suffering get a higher priority than bugs I enter. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
David Williams — — source: Usenet: comp.databases.informix

"Jonathan Leffler" <jleffler@earthlink.net> wrote in message news:4xjmc.8962$V97.3918@newsread1.news.pas.earthlink.net... > Leonid Belov wrote: > > there is a problem with string concatenation in Informix 9.40FC3 (SRARC Solaris 9) > > > > 1. SELECT '*' || 'string' || '-' FROM systables where tabid = 100; > > > > Result: '*string-' > > > > > > 2. SELECT '*' || ('string' || '-') FROM systables where tabid = 100; > > > > Result: '*string-' > > > > > > 3. CREATE PROCEDURE nvalue() > > RETURNING VARCHAR(20); > > RETURN 'string'; > > END PROCEDURE; > > > > SELECT '*' || nvalue() || '-' FROM systables where tabid = 100; > > > > Result: '*string-' > > > > 4. SELECT '*' || (nvalue() || '-') FROM systables where tabid = 100; > > > > Result: 'string-*' > > > > Is it a bug? > > > Yes - and pervasive, it would seem. Please report it to Tech Support > because bug reports with a customer suffering get a higher priority > than bugs I enter. > I have reproduced it on HP-UX 11.11 so it is not a platform specific issue. I have asked for a call to be raised! > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ >

↪ replying to David Williams
Jonathan Leffler — — source: Usenet: comp.databases.informix

David Williams wrote: > "Jonathan Leffler" <jleffler@earthlink.net> wrote: >>Leonid Belov wrote: >> >>>there is a problem with string concatenation in Informix 9.40FC3 (SRARC > > Solaris 9) > >>> >>>3. CREATE PROCEDURE nvalue() >>> RETURNING VARCHAR(20); >>> RETURN 'string'; >>> END PROCEDURE; >>> >>> SELECT '*' || nvalue() || '-' FROM systables where tabid = 100; >>> >>> Result: '*string-' >>> >>>4. SELECT '*' || (nvalue() || '-') FROM systables where tabid = 100; >>> >>> Result: 'string-*' >>> >>>Is it a bug? >> >> >>Yes - and pervasive, it would seem. Please report it to Tech Support >>because bug reports with a customer suffering get a higher priority >>than bugs I enter. >> > > > I have reproduced it on HP-UX 11.11 so it is not a platform specific > issue. I have asked for a call to be raised! It's bug B167593. It still needs your customer case(s) to get it the appropriate priority. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Glossary