Hi Rob,
The change was made between the 6.1.5 and 6.16 release it seems, but testing
against an older 6.1.3 build either the "bif" or "sql:" prefixes work, so you
could change to use the latter to cover all bases:
C:\virtuoso-opensource-win64-20110330\virtuoso-opensource\database>..\bin\virtuoso-t
-?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.3.3127-threads as of Mar 30 2011
Compiled for Win64 (x86_64-generic-win-64)
Copyright (C) 1998-2011 OpenLink Software
SQL> sparql delete from <http://sample/> {
`sql:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
callret-0
VARCHAR
_______________________________________________________________________________
Delete from <http://sample/>, 1 (or less) triples -- done
1 Rows. -- 210 msec.
SQL> sparql delete from <http://sample/> {
`bif:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
callret-0
VARCHAR
_______________________________________________________________________________
Delete from <http://sample/>, 1 (or less) triples -- done
1 Rows. -- 127 msec.
SQL>
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 7 Feb 2014, at 12:08, Rob Vesse <rve...@yarcdata.com> wrote:
> Ok thanks
>
> Could you perhaps track down when exactly the change happened (I.e which
> release)?
>
> Ideally my code needs to continue to be backwards compatible with people
> using older Virtuoso installations so being able to detect which form of the
> function call I should use by inspecting the server version information would
> be useful
>
> Or alternatively do you know if swapping bif: for sql: is backwards
> compatible with older Virtuoso releases?
>
> Thanks,
>
> Rob
>
>
> From: Hugh Williams <hwilli...@openlinksw.com>
> Date: Friday, 7 February 2014 11:48
> To: Rob Vesse <rve...@yarcdata.com>
> Cc: "virtuoso-users@lists.sourceforge.net"
> <virtuoso-users@lists.sourceforge.net>
> Subject: Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer supported?
>
>> Hi Rob,
>>
>> Ah, it must be a bif: (built-in-function) vs sql: (Virtuoso PL) function
>> change then as there were some changes for SPARQL 1.1 compliance in this
>> area in 2012, so use the sql: prefix instead:
>>
>> SQL> sparql delete from <http://sample/> {
>> `bif:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
>>
>> *** Error 37000: VD [Virtuoso Server]SQ074: Line 1: SP031: SPARQL compiler:
>> Unknown function bif:rdf_make_iid_of_qname()
>> at line 2 of Top-Level:
>> sparql delete from <http://sample/> {
>> `bif:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> }
>> SQL> sparql delete from <http://sample/> {
>> `sql:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
>>
>> Done. -- 5 msec.
>> SQL>
>>
>> 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 7 Feb 2014, at 09:49, Rob Vesse <rve...@yarcdata.com> wrote:
>>
>>> As the original error message I posted implies I am attempting to use the
>>> function via SPARQL hence the bif: prefix and why the error comes from the
>>> SPARQL compiler
>>>
>>>>> OpenLink.Data.Virtuoso.VirtuosoException : Virtuoso Error:
>>>>> SQL_ERRORSQLSTATE: 37000Message: [Virtuoso .NET Data Provider][Virtuoso
>>>>> Server]SQ074: Line 7: SP031: SPARQL compiler: Unknown function
>>>>> bif:rdf_make_iid_of_qname()
>>>
>>> I.e. I am making a SPASQL query/update
>>>
>>> Rob
>>>
>>> From: Hugh Williams <hwilli...@openlinksw.com>
>>> Date: Thursday, 6 February 2014 17:36
>>> To: Rob Vesse <rve...@yarcdata.com>
>>> Cc: "virtuoso-users@lists.sourceforge.net"
>>> <virtuoso-users@lists.sourceforge.net>
>>> Subject: Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer
>>> supported?
>>>
>>>> Hi Rob,
>>>>
>>>> I downloaded the same Window 32bit installer from the VOS download site
>>>> and the function does exist and is found whether fully qualified or not:
>>>>
>>>> C:\virtuoso-opensource-x86-20131211\virtuoso-opensource\database>..\bin\virtuoso-t
>>>> -?
>>>> Virtuoso Open Source Edition (multi threaded)
>>>> Version 6.1.7.3127-threads as of Dec 11 2013
>>>> Compiled for Win32 (i686-generic-win-32)
>>>> Copyright (C) 1998-2013 OpenLink Software
>>>>
>>>> C:\>cd virtuoso-opensource-x86-20131211\virtuoso-opensource\bin\
>>>>
>>>> C:\virtuoso-opensource-x86-20131211\virtuoso-opensource\bin>.\isql 1111
>>>> Connected to OpenLink Virtuoso
>>>> Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
>>>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>>>> Type HELP; for help and EXIT; to exit.
>>>> SQL> select count(*) from RDF_QUAD where G =
>>>> rdf_make_iid_of_qname('http://localhost:8890/DAV');
>>>> count
>>>> INTEGER
>>>> _______________________________________________________________________________
>>>>
>>>> 0
>>>>
>>>> 1 Rows. -- 0 msec.
>>>> SQL> select count(*) from RDF_QUAD where G =
>>>> DB.DBA.rdf_make_iid_of_qname('http://localhost:8890/DAV');
>>>> count
>>>> INTEGER
>>>> _______________________________________________________________________________
>>>>
>>>> 0
>>>>
>>>> 1 Rows. -- 0 msec.
>>>> SQL> status('');
>>>> REPORT
>>>> VARCHAR
>>>> _______________________________________________________________________________
>>>>
>>>> OpenLink Virtuoso Server
>>>> Version 06.01.3127-threads for Win64 as of Dec 11 2013
>>>> Started on: 2014/02/06 17:53 GMT+00
>>>>
>>>> I also tested the 32bit installer and it also exists there as well:
>>>>
>>>> C:\virtuoso-opensource-x64-20131211\virtuoso-opensource\database>..\bin\virtuoso-t
>>>> -?
>>>> Virtuoso Open Source Edition (multi threaded)
>>>> Version 6.1.8.3127-threads as of Dec 11 2013
>>>> Compiled for Win64 (x86_64-generic-win-64)
>>>> Copyright (C) 1998-2013 OpenLink Software
>>>>
>>>> C:\virtuoso-opensource-x64-20131211\virtuoso-opensource\database>..\bin\isql
>>>> 1111
>>>> Connected to OpenLink Virtuoso
>>>> Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
>>>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>>>> Type HELP; for help and EXIT; to exit.
>>>> SQL> select count(*) from RDF_QUAD where G =
>>>> rdf_make_iid_of_qname('http://local
>>>> host:8890/DAV');
>>>> count
>>>> INTEGER
>>>> _______________________________________________________________________________
>>>>
>>>> 0
>>>>
>>>> 1 Rows. -- 31 msec.
>>>> SQL> status('');
>>>> REPORT
>>>> VARCHAR
>>>> _______________________________________________________________________________
>>>>
>>>> OpenLink Virtuoso Server
>>>> Version 06.01.3127-threads for Win64 as of Dec 11 2013
>>>> Started on: 2014/02/06 16:53 GMT+00
>>>>
>>>> Thus I am curious and confused as to how you are calling this via the
>>>> ADO.Net Provider such that it is not located ?
>>>>
>>>> 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 6 Feb 2014, at 14:09, Rob Vesse <rve...@yarcdata.com> wrote:
>>>>
>>>>> Hugh
>>>>>
>>>>> Virtuoso Open Source Edition (multi threaded)
>>>>> Version 6.1.7.3127-threads as of Dec 11 2013
>>>>> Compiled for Win32 (i686-generic-win-32)
>>>>> Copyright (C) 1998-2013 OpenLink Software
>>>>>
>>>>> Which is interesting because the fact that your build is 6.1.8 and from a
>>>>> day after mine implies that development found issues with 6.1.7 and did a
>>>>> rebuild
>>>>>
>>>>> Btw this was a pre-built Windows binary downloaded from the VOS wiki so
>>>>> those links should be checked and updated if relevant
>>>>>
>>>>> Rob
>>>>>
>>>>>
>>>>> From: Hugh Williams <hwilli...@openlinksw.com>
>>>>> Date: Thursday, 6 February 2014 12:44
>>>>> To: Rob Vesse <rve...@yarcdata.com>
>>>>> Cc: "virtuoso-users@lists.sourceforge.net"
>>>>> <virtuoso-users@lists.sourceforge.net>
>>>>> Subject: Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer
>>>>> supported?
>>>>>
>>>>>> Hi Rob,
>>>>>>
>>>>>> What is the specific version of v6 you are using as I just tested with
>>>>>> my 6.1.8 build from latest git stable/6 branch:
>>>>>>
>>>>>> $ ../bin/virtuoso-t -?
>>>>>> Virtuoso Open Source Edition (Row Store) (multi threaded)
>>>>>> Version 6.1.8-rc1.3127-pthreads as of Dec 12 2013
>>>>>> Compiled for Darwin (x86_64-apple-darwin12.3.0)
>>>>>> Copyright (C) 1998-2013 OpenLink Software
>>>>>>
>>>>>> and the function does exist:
>>>>>>
>>>>>> SQL> status('');
>>>>>> REPORT
>>>>>> VARCHAR
>>>>>> _______________________________________________________________________________
>>>>>>
>>>>>> OpenLink Virtuoso Server
>>>>>> Version 06.01.3127-pthreads for Darwin as of Dec 12 2013
>>>>>> Started on: 2014/02/06 12:29 GMT+00
>>>>>>
>>>>>> Database Status:
>>>>>> File size 515899392, 62976 pages, 22921 free.
>>>>>> 10000 buffers, 9309 used, 0 dirty 0 wired down, repl age 0 0 w. io 0
>>>>>> w/crsr.
>>>>>> Disk Usage: 9335 reads avg 0 msec, 0% r 0% w last 0 s, 93 writes,
>>>>>> 93 read ahead, batch = 94. Autocompact 0 in 0 out, 0% saved.
>>>>>> Gate: 117 2nd in reads, 0 gate write waits, 0 in while read 0 busy
>>>>>> scrap.
>>>>>> Log = /usr/local/vos-6/database/virtuoso.trx, 155 bytes
>>>>>> 39955 pages have been changed since last backup (in checkpoint state)
>>>>>> Current backup timestamp: 0x0000-0x00-0x00
>>>>>> Last backup date: unknown
>>>>>> Clients: 1 connects, max 1 concurrent
>>>>>> RPC: 6 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads (0%),
>>>>>> 0 second brk=9
>>>>>> Checkpoint Remap 76 pages, 0 mapped back. 0 s atomic time.
>>>>>> DB master 62976 total 22921 free 76 remap 0 mapped back
>>>>>> temp 768 total 763 free
>>>>>>
>>>>>> Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
>>>>>> Currently 1 threads running 0 threads waiting 0 threads in vdb.
>>>>>> Pending:
>>>>>>
>>>>>> 23 Rows. -- 8 msec.
>>>>>> SQL> rdf_make_iid_of_qname();
>>>>>>
>>>>>> *** Error 07S01: [Virtuoso Driver][Virtuoso Server]SR183: Required
>>>>>> argument qname (no 1) not supplied to DB.DBA.RDF_MAKE_IID_OF_QNAME
>>>>>> at line 3 of Top-Level:
>>>>>> rdf_make_iid_of_qname()
>>>>>> SQL> select count(*) from RDF_QUAD where G =
>>>>>> rdf_make_iid_of_qname('http://localhost:8890/DAV');
>>>>>> count
>>>>>> INTEGER
>>>>>> _______________________________________________________________________________
>>>>>>
>>>>>> 0
>>>>>>
>>>>>> 1 Rows. -- 879 msec.
>>>>>> SQL>
>>>>>>
>>>>>> 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 6 Feb 2014, at 09:38, Rob Vesse <rve...@yarcdata.com> wrote:
>>>>>>
>>>>>>> Hi All
>>>>>>>
>>>>>>> I've run into an issue with after upgrading to a recent Virtuoso 6
>>>>>>> installation to reproduce a user reported bug in my Virtuoso
>>>>>>> integration. That bug was an easy fix but in running regression
>>>>>>> testing one of my tests for an unrelated feature no longer functions.
>>>>>>>
>>>>>>> Essentially the problem seems to be that the
>>>>>>> bif:rdf_make_iid_of_qname() is no longer supported, I get the following
>>>>>>> error from the Virtuoso compiler:
>>>>>>>
>>>>>>> OpenLink.Data.Virtuoso.VirtuosoException : Virtuoso Error:
>>>>>>> SQL_ERRORSQLSTATE: 37000Message: [Virtuoso .NET Data Provider][Virtuoso
>>>>>>> Server]SQ074: Line 7: SP031: SPARQL compiler: Unknown function
>>>>>>> bif:rdf_make_iid_of_qname()
>>>>>>>
>>>>>>> This worked fine in past versions of Virtuoso and is still detailed in
>>>>>>> your documentation at
>>>>>>> http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulfunc
>>>>>>> so I am little confused. Did you guys intentionally remove this
>>>>>>> function or is this a bug?
>>>>>>>
>>>>>>> For reference the version of Virtuoso I am using is as follows:
>>>>>>>
>>>>>>> Version: 06.01.3127
>>>>>>> Build: Dec 11 2013
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Rob
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Managing the Performance of Cloud-Based Applications
>>>>>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>>>>>> Read the Whitepaper.
>>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>>>>>> Virtuoso-users mailing list
>>>>>>> Virtuoso-users@lists.sourceforge.net
>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Managing the Performance of Cloud-Based Applications
>>>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>>>> Read the Whitepaper.
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>>>> Virtuoso-users mailing list
>>>>> Virtuoso-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>
>>> ------------------------------------------------------------------------------
>>> Managing the Performance of Cloud-Based Applications
>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>> Read the Whitepaper.
>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
