Hi Nicola,
I have loaded your dataset into the latest Virtuoso 7.2 open source develop/7
branch and the property path query with the plus sign returns 24 rather than 4
rows as you indicated. What is the version a build dat of the Virtuoso instance
you are using ?
SQL> ld_dir ('.', 'wikidata-taxonomy.nt', 'http://wikidata-taxonomy.nt');
Done. -- 5 msec.
SQL> select * from load_list;
ll_file
ll_graph
ll_state ll_started ll_done ll_host
ll_work_time ll_error
VARCHAR NOT NULL
VARCHAR
INTEGER TIMESTAMP TIMESTAMP INTEGER INTEGER
VARCHAR
_______________________________________________________________________________
./wikidata-taxonomy.nt
http://wikidata-taxonomy.nt
0 NULL NULL NULL NULL
NULL
1 Rows. -- 1 msec.
SQL>
SQL> rdf_loader_run();
Done. -- 2179 msec.
SQL> sparql select count(*) from <http://wikidata-taxonomy.nt> where {?s ?p ?o};
callret-0
INTEGER
_______________________________________________________________________________
379214
1 Rows. -- 143 msec.
SQL>
SQL> SPARQL PREFIX wd: <http://www.wikidata.org/entity/> SELECT DISTINCT ?scl
WHERE {wd:Q3336843 rdfs:subClassOf* ?scl};
scl
VARCHAR
_______________________________________________________________________________
http://www.wikidata.org/entity/Q3336843
http://www.wikidata.org/entity/Q717478
http://www.wikidata.org/entity/Q5164076
http://www.wikidata.org/entity/Q1763527
http://www.wikidata.org/entity/Q10864048
http://www.wikidata.org/entity/Q1799794
http://www.wikidata.org/entity/Q7275
http://www.wikidata.org/entity/Q6256
http://www.wikidata.org/entity/Q15916867
http://www.wikidata.org/entity/Q56061
http://www.wikidata.org/entity/Q43229
http://www.wikidata.org/entity/Q1048835
http://www.wikidata.org/entity/Q82794
http://www.wikidata.org/entity/Q15642541
http://www.wikidata.org/entity/Q874405
http://www.wikidata.org/entity/Q18613914
http://www.wikidata.org/entity/Q618123
http://www.wikidata.org/entity/Q16686448
http://www.wikidata.org/entity/Q7703766
http://www.wikidata.org/entity/Q35120
http://www.wikidata.org/entity/Q223557
http://www.wikidata.org/entity/Q2221906
http://www.wikidata.org/entity/Q488383
http://www.wikidata.org/entity/Q17334923
http://www.wikidata.org/entity/Q107
25 Rows. -- 5 msec.
SQL> SPARQL PREFIX wd: <http://www.wikidata.org/entity/> SELECT DISTINCT ?scl
WHERE {wd:Q3336843 rdfs:subClassOf+ ?scl};
scl
VARCHAR
_______________________________________________________________________________
http://www.wikidata.org/entity/Q717478
http://www.wikidata.org/entity/Q5164076
http://www.wikidata.org/entity/Q1763527
http://www.wikidata.org/entity/Q10864048
http://www.wikidata.org/entity/Q1799794
http://www.wikidata.org/entity/Q7275
http://www.wikidata.org/entity/Q6256
http://www.wikidata.org/entity/Q15916867
http://www.wikidata.org/entity/Q56061
http://www.wikidata.org/entity/Q43229
http://www.wikidata.org/entity/Q1048835
http://www.wikidata.org/entity/Q82794
http://www.wikidata.org/entity/Q15642541
http://www.wikidata.org/entity/Q874405
http://www.wikidata.org/entity/Q18613914
http://www.wikidata.org/entity/Q618123
http://www.wikidata.org/entity/Q16686448
http://www.wikidata.org/entity/Q7703766
http://www.wikidata.org/entity/Q35120
http://www.wikidata.org/entity/Q223557
http://www.wikidata.org/entity/Q2221906
http://www.wikidata.org/entity/Q488383
http://www.wikidata.org/entity/Q17334923
http://www.wikidata.org/entity/Q107
24 Rows. -- 3 msec.
SQL> SPARQL PREFIX wd: <http://www.wikidata.org/entity/> SELECT DISTINCT ?scl
WHERE {wd:Q3336843 rdfs:subClassOf{1,} ?scl};
scl
VARCHAR
_______________________________________________________________________________
http://www.wikidata.org/entity/Q717478
http://www.wikidata.org/entity/Q5164076
http://www.wikidata.org/entity/Q1763527
http://www.wikidata.org/entity/Q10864048
http://www.wikidata.org/entity/Q1799794
http://www.wikidata.org/entity/Q7275
http://www.wikidata.org/entity/Q6256
http://www.wikidata.org/entity/Q15916867
http://www.wikidata.org/entity/Q56061
http://www.wikidata.org/entity/Q43229
http://www.wikidata.org/entity/Q1048835
http://www.wikidata.org/entity/Q82794
http://www.wikidata.org/entity/Q15642541
http://www.wikidata.org/entity/Q874405
http://www.wikidata.org/entity/Q18613914
http://www.wikidata.org/entity/Q618123
http://www.wikidata.org/entity/Q16686448
http://www.wikidata.org/entity/Q7703766
http://www.wikidata.org/entity/Q35120
http://www.wikidata.org/entity/Q223557
http://www.wikidata.org/entity/Q2221906
http://www.wikidata.org/entity/Q488383
http://www.wikidata.org/entity/Q17334923
http://www.wikidata.org/entity/Q107
24 Rows. -- 4 msec.
SQL> SPARQL PREFIX wd: <http://www.wikidata.org/entity/> SELECT DISTINCT ?scl
WHERE {wd:Q3336843 rdfs:subClassOf{2,} ?scl};
scl
VARCHAR
_______________________________________________________________________________
http://www.wikidata.org/entity/Q1799794
http://www.wikidata.org/entity/Q7275
http://www.wikidata.org/entity/Q6256
http://www.wikidata.org/entity/Q15916867
http://www.wikidata.org/entity/Q56061
http://www.wikidata.org/entity/Q43229
http://www.wikidata.org/entity/Q1048835
http://www.wikidata.org/entity/Q82794
http://www.wikidata.org/entity/Q15642541
http://www.wikidata.org/entity/Q874405
http://www.wikidata.org/entity/Q18613914
http://www.wikidata.org/entity/Q618123
http://www.wikidata.org/entity/Q16686448
http://www.wikidata.org/entity/Q7703766
http://www.wikidata.org/entity/Q35120
http://www.wikidata.org/entity/Q223557
http://www.wikidata.org/entity/Q2221906
http://www.wikidata.org/entity/Q488383
http://www.wikidata.org/entity/Q17334923
http://www.wikidata.org/entity/Q107
20 Rows. -- 3 msec.
SQL> SPARQL PREFIX wd: <http://www.wikidata.org/entity/> SELECT DISTINCT ?scl
WHERE {wd:Q3336843 rdfs:subClassOf{3,} ?scl};
scl
VARCHAR
_______________________________________________________________________________
http://www.wikidata.org/entity/Q56061
http://www.wikidata.org/entity/Q6256
http://www.wikidata.org/entity/Q43229
http://www.wikidata.org/entity/Q1048835
http://www.wikidata.org/entity/Q82794
http://www.wikidata.org/entity/Q15642541
http://www.wikidata.org/entity/Q874405
http://www.wikidata.org/entity/Q18613914
http://www.wikidata.org/entity/Q618123
http://www.wikidata.org/entity/Q16686448
http://www.wikidata.org/entity/Q7703766
http://www.wikidata.org/entity/Q35120
http://www.wikidata.org/entity/Q223557
http://www.wikidata.org/entity/Q2221906
http://www.wikidata.org/entity/Q488383
http://www.wikidata.org/entity/Q17334923
http://www.wikidata.org/entity/Q107
17 Rows. -- 2 msec.
SQL> status('');
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso Server
Version 07.20.3213-pthreads for Darwin as of Apr 25 2015
Started on: 2015-04-26 23:53 GMT+1
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 2015, at 18:15, Nicola Vitucci <nicola.vitu...@gmail.com> wrote:
>
> Hi Hugh,
>
> you can pick up and use this file:
>
> https://tools.wmflabs.org/wikidata-exports/rdf/exports/20150126/wikidata-taxonomy.nt.gz
>
> <https://tools.wmflabs.org/wikidata-exports/rdf/exports/20150126/wikidata-taxonomy.nt.gz>
>
> Nicola
>
> Il 07/04/2015 01:44, Hugh Williams ha scritto:
>> HI Nicola,
>>
>> Are you able to provide a test case we can setup locally to demonstrate
>> 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 4 Apr 2015, at 19:49, Nicola Vitucci <nicola.vitu...@gmail.com
>>> <mailto:nicola.vitu...@gmail.com <mailto:nicola.vitu...@gmail.com>>> wrote:
>>>
>>> Hi all,
>>>
>>> I think that SPARQL queries using property paths which include the plus
>>> sign yield incorrect results. This is what I get with the following
>>> queries (number of results between brackets):
>>>
>>> SELECT DISTINCT ?scl WHERE {wd:Q3336843 rdfs:subClassOf* ?scl} (25 rows)
>>> SELECT DISTINCT ?scl WHERE {wd:Q3336843 rdfs:subClassOf+ ?scl} (4 rows)
>>>
>>> SELECT DISTINCT ?scl WHERE {wd:Q3336843 rdfs:subClassOf{1,} ?scl} (24
>>> rows)
>>> SELECT DISTINCT ?scl WHERE {wd:Q3336843 rdfs:subClassOf{2,} ?scl} (20
>>> rows)
>>> SELECT DISTINCT ?scl WHERE {wd:Q3336843 rdfs:subClassOf{3,} ?scl} (17
>>> rows)
>>> ...
>>>
>>> This is the output of EXPLAIN on the first and second queries (the
>>> latter 3 have apparently the same plan as the first one):
>>>
>>> ----------------------------
>>> {
>>>
>>> Precode:
>>> 0: __all_eq := Call __all_eq ( #/Q3336843 )
>>> 5: BReturn 0
>>> Transitive dt dir 1, input: (__all_eq)
>>> input shadow: (ZÁ^D)
>>> output: (_::trans_obj_1_1)
>>> {
>>> RDF_QUAD 1.8 rows(s_1_4_t0.S, s_1_4_t0.O)
>>> inlined P = ##subClassOf , S = k_ZÁ^D
>>>
>>> After code:
>>> 0: _::trans_subj_1_0 := := artm s_1_4_t0.S
>>> 4: _::trans_obj_1_1 := := artm s_1_4_t0.O
>>> 8: BReturn 0
>>> Subquery Select(_::trans_subj_1_0, _::trans_obj_1_1)
>>> }
>>> Distinct (_::trans_obj_1_1)
>>>
>>> After code:
>>> 0: scl := := artm _::trans_obj_1_1
>>> 4: BReturn 0
>>> Subquery Select(scl)
>>>
>>> After code:
>>> 0: scl := Call __ro2sq (scl)
>>> 5: BReturn 0
>>> Select (scl)
>>> }
>>> ----------------------------
>>>
>>> ----------------------------
>>> {
>>> RDF_QUAD 8 rows(s_1_2_t0.O)
>>> inlined P = ##subClassOf , S = #/Q3336843
>>> Distinct (s_1_2_t0.O)
>>>
>>> After code:
>>> 0: scl := := artm s_1_2_t0.O
>>> 4: BReturn 0
>>> Subquery Select(scl)
>>>
>>> After code:
>>> 0: scl := Call __ro2sq (scl)
>>> 5: BReturn 0
>>> Select (scl)
>>> }
>>> ----------------------------
>>>
>>> Have you already encountered this issue? I'm using build
>>> f609f14aa6bdb8ef29d4da038fdb7934c6ca65d7.
>>>
>>> Thanks,
>>>
>>> Nicola
>>>
>>> ------------------------------------------------------------------------------
>>> Dive into the World of Parallel Programming The Go Parallel Website,
>>> sponsored
>>> by Intel and developed in partnership with Slashdot Media, is your hub
>>> for all
>>> things parallel software development, from weekly thought leadership
>>> blogs to
>>> news, videos, case studies, tutorials and more. Take a look and join the
>>> conversation now. http://goparallel.sourceforge.net/
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> <mailto:Virtuoso-users@lists.sourceforge.net>
>>> <mailto:Virtuoso-users@lists.sourceforge.net
>>> <mailto:Virtuoso-users@lists.sourceforge.net>>
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>>
>
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> <http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-> event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> <mailto:Virtuoso-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
