Hi Quentin, The error is saying you are trying to concat and integer when a strings is expected, thus the integer should be cast as varchar for it to work:
create procedure
DB.q.testBug() returns varchar
{
declare str varchar;
declare intIn int;
intIn := cast (4 as varchar);
str := intIn;
return concat('test:',str,'.');
}
You could argue that concat could implicitly perform the cast I suppose, but it
is strictly enforcing the type it would seem ...
In what way is this a problem for you ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 13 Nov 2012, at 01:53, Quentin wrote:
> Is this a bug? It doesn't seem desirable behaviour.
>
> =============================
> create procedure
> DB.q.testBug() returns varchar
> {
> declare str varchar;
> declare intIn int;
>
> intIn := 4;
> str := intIn;
>
> return concat('test:',str,'.');
> }
> =============================
>
> In isql:
> =============================
> select DB.q.testBug();
> =============================
> Query result:
> testBug
> VARCHAR
> SQLState: 22023
> Message: SR007: Function concat needs a string or UNAME or NULL as argument
> 2, not an arg of type INTEGER (189)
> =============================
>
> I would (perhaps naively) expect that the error should be in the uncast
> assignment if we are being strictly typed or implicitly cast the variable to
> varchar on assignment if we want to be weakly typed.
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
