Re: [Virtuoso-users] Problem with quietcast option

[Mitko I. <im...@op...>]

Hi Sören,

The quietcast option works for implicit  casts  e.g.   select * from
sys_users where u_id = 'abc' option (quietcast);
As for explicit cast, this is a function call and it's behavior is not
affected by statement option.

Best Regards,
Mitko

Sören Auer wrote:
> For our DBpedia query builder I need the quitecast option, but I'm not
> getting it to work.
> Consider the following simplified example:
>
> create table qctest (value varchar);
> insert into qctest values('100');
> insert into qctest values('1000');
> insert into qctest values('abc');
>
> Now I'm trying:
>
> select * from qctest where cast(value as int)>500 option (quietcast);
>
> which unfortunately results in the following error:
>
> *** Error 22005: [Virtuoso Driver][Virtuoso Server]SR341: Invalid
> integer value converting 'abc'
> at line 9 of Top-Level:
> select * from qctest where cast(value as int)>500 option (quietcast)
>
> What am I doing wrong?
>
> Sören
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Virtuoso-users mailing list
> Vir...@li...
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>   


-- 
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware