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
