Hi Alex,
Are you able to provide a simple test case for recreation of this issue ?
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 8 Apr 2014, at 09:56, Alex Bondo Andersen <abon...@gmail.com> wrote:
> Hi,
>
> I have a couple of QUAD maps on top of relational tables. When I query the
> graph, which is defined by the QUAD map, without binding the property all
> triples with data properties will have the object
> "iri_id_0_with_no_name_entry" or in some cases "node://" followed by numbers.
> Object properties work fine. Example:
>
> I run the query:
> CONSTRUCT {?S ?P ?O}
> FROM <http://extbi.lab.aau.dk/materialized_data/business>
> WHERE {
> ?S ?P ?O . FILTER(?S =
> <http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this>)}
>
> through the isql(-vt) interface or the conductor SPARQL interface and get:
>
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/name iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/productionUnitIdentifier
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/telephoneNumberIdentifier
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/hasActivity
> http://extbi.lab.aau.dk/data/business/activity/description/aldersintegrerede_institutioner#this
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/mainActivityValidFromDate
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/officialAddress
> http://extbi.lab.aau.dk/data/business/address/Ølstedvej_24____3310__#this
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/startDate
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/nameValidFromDate
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://extbi.lab.aau.dk/ontologies/business/ProductionUnit
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/belongsTo
> http://extbi.lab.aau.dk/data/business/company/29188416#this
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/mainDivisionIndicator
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/employmentQuarterEmploymentIntervalCode
> iri_id_0_with_no_name_entry
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/addressOfficialValidFromDate
> iri_id_0_with_no_name_entry
>
> I experience the same when using a SELECT query. If i bind the predicate to
> one of the data properties it works fine and I get the data I would expect,
> example:
>
> CONSTRUCT {?S ?P ?O}
> FROM <http://extbi.lab.aau.dk/materialized_data/business>
> WHERE {
> ?S ?P ?O . FILTER(?S =
> <http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this> && ?P
> =<http://extbi.lab.aau.dk/ontologies/business/name>)}
>
> results in:
>
> http://extbi.lab.aau.dk/data/business/productionunit/1008862857#this
> http://extbi.lab.aau.dk/ontologies/business/name Ølsted Børnehus - Afdeling
> Ølstedvej
>
> Note that this is a predicate which failed before when the the predicate ?P
> was variable. I have even made queries with several ORs between the "?P =
> <...>" conditions, thereby getting all the data required. However, this makes
> the my queries quite big and unwieldy, not to mention very inflexible.
>
> My first thought was that it might be permissions with the IRI classes or the
> QUAD maps, since I have been running in to such problems before. However, I
> am running the queries as DBA and would therefore expect to have full
> permissions to everything.
>
> Any ideas? I am running on Ubuntu with version:
> Version: 07.10.3207
> Build: Apr 2 2014
>
> --
> Med venlig hilsen / Best Regards
> Alex Bondo Andersen
> ------------------------------------------------------------------------------
> Put Bad Developers to Shame
> Dominate Development with Jenkins Continuous Integration
> Continuously Automate Build, Test & Deployment
> Start a new project now. Try Jenkins in the cloud.
> http://p.sf.net/sfu/13600_Cloudbees_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
