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
