Hi Hugh, I will update the version (06.01.3128) on my computer and test.
On Virtuoso *06.01.3127* the problem still exist. See below: Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. *ORIGINAL (Not use ORDER)* sparql define input:default-graph-uri <http://example.com/> define input:inference <http://example.com/ruleset> select distinct ?s ?label FROM <http://example.com/sports/> { { ?s a <http://example.com/base/player> ; ?p ?o . ?o bif:contains "'Ronaldo' AND 'Silva'" . ?s rdfs:label ?label . } } LIMIT 100 *RESULT* s label VARCHAR VARCHAR _______________________________________________________________________________ http://example.com/player/53087 Ronaldo - João Ronaldo da Silva http://example.com/player/45443 Ronaldo - Ronaldo dos Santos da Silva http://example.com/player/42424 Ronaldo Testa - Ronaldo Ferreira da Silva http://example.com/player/63408 Rone - José Ronaldo Ferreira da Silva http://example.com/player/40875 Ronaldo - Ronaldo da Silva Oliveira http://example.com/player/63346 Ronaldo Macapá - Ronaldo da Costa Silva http://example.com/player/42158 Ronaldo - Ronaldo Costa da Silva http://example.com/player/63153 Nei Júnior - Ronaldo da Silva http://example.com/player/44209 Ronaldo Silva - Ronaldo Silva http://example.com/player/51145 Ronaldo - Ronaldo Tôrres da Silva http://example.com/player/53428 Magal - Ronaldo Luís Pereira Silva http://example.com/player/55951 Ronaldo - Ronaldo Afonso da Silva http://example.com/player/51834 Ronaldo - Ronaldo da Silva http://example.com/player/50610 Ronaldo - Ronaldo Araújo da Silva http://example.com/player/50681 Ronaldo - Ronaldo Silva Oliveira http://example.com/player/46747 Ronaldo - Ronaldo Moraes da Silva http://example.com/player/50710 Ibateguara - Ronaldo José da Silva http://example.com/player/53771 Índio - Ronaldo Odilon da Silva http://example.com/player/51212 Ronaldo - Ronaldo da Costa Silva http://example.com/player/41888 Ronaldo - Ronaldo José da Silva 20 Rows. -- 1742 msec. *Example (ORDER BY)* sparql define input:default-graph-uri <http://example.com/> define input:inference <http://example.com/ruleset> select distinct ?s ?label FROM <http://example.com/sports/> { { ?s a <http://example.com/base/player> ; ?p ?o . ?o bif:contains "'Ronaldo' AND 'Silva'" . ?s rdfs:label ?label . } } ORDER BY(?label) LIMIT 100 *RESULT* s label VARCHAR VARCHAR _______________________________________________________________________________ http://example.com/player/50710 Ibateguara - Ronaldo José da Silva http://example.com/player/53428 Magal - Ronaldo Luís Pereira Silva http://example.com/player/63153 Nei Júnior - Ronaldo da Silva http://example.com/player/53087 Ronaldo - João Ronaldo da Silva http://example.com/player/55951 Ronaldo - Ronaldo Afonso da Silva http://example.com/player/50610 Ronaldo - Ronaldo Araújo da Silva http://example.com/player/42158 Ronaldo - Ronaldo Costa da Silva http://example.com/player/41888 Ronaldo - Ronaldo José da Silva http://example.com/player/46747 Ronaldo - Ronaldo Moraes da Silva http://example.com/player/50681 Ronaldo - Ronaldo Silva Oliveira http://example.com/player/51145 Ronaldo - Ronaldo Tôrres da Silva http://example.com/player/51212 Ronaldo - Ronaldo da Costa Silva http://example.com/player/51834 Ronaldo - Ronaldo da Silva http://example.com/player/40875 Ronaldo - Ronaldo da Silva Oliveira http://example.com/player/45443 Ronaldo - Ronaldo dos Santos da Silva http://example.com/player/63346 Ronaldo Macapá - Ronaldo da Costa Silva http://example.com/player/44209 Ronaldo Silva - Ronaldo Silva http://example.com/player/42424 Ronaldo Testa - Ronaldo Ferreira da Silva http://example.com/player/63408 Rone - José Ronaldo Ferreira da Silva http://example.com/player/53771 Índio - Ronaldo Odilon da Silva 20 Rows. -- 1744 msec. Abraços, Renan Oliveira ----------------------------------------------- Busca & Semântica - Globo.com (21) 2483-6727 Y! glb_renan 2011/1/14 Hugh Williams <[email protected]> > Hi Renan, > > Is there are reason you are using a 06.01.3126 (6.1.1) open source build > which is from Feb 2010 time , as there have been some order by fixes since > his release ? The latest official open source archive on source forge is > 06.01.3128 (6.1.2) from Jul 2010 : > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload > > Or a 6.1.3 snapshot release can be downloaded from: > > > ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110105.tar.gz > > With the latest fixes, I would suggest you compile and re-test this issue > with ... > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 13 Jan 2011, at 16:57, Renan Moreira de Oliveira wrote: > > Hi Aldo, Ivan Mikhailov and Virtuoso Users. > > Can you help me in using the ORDER BY? > He is by default case and accents sensitive?! > Is there any way to bypass this setting? > > Driver: 06.01.3126 OpenLink Virtuoso ODBC Driver > > > *ORIGINAL (Not use ORDER)* > > http://example.com/define input:default-graph-uri <http://example.com/> > define input:inference <http://example.com/ruleset> > > select distinct ?s ?label > FROM <http://example.com/sports/> > > { > > { > ?s a <http://example.com/base/player> ; ?p ?o . > ?o bif:contains "'Ronaldo' AND 'Silva'" . > ?s l ?label . > } > > } > LIMIT 100 > * > RESULT* > > *s label* > VARCHAR VARCHAR > > _____________________________________________________________________________ > > http://example.com/player/53087 Ronaldo - João Ronaldo da Silva > http://example.com/player/45443 Ronaldo - Ronaldo dos Santos da Silva > http://example.com/player/42424 Ronaldo Testa - Ronaldo Ferreira da > Silva > http://example.com/player/63408 Rone - José Ronaldo Ferreira da Silva > http://example.com/player/40875 Ronaldo - Ronaldo da Silva Oliveira > http://example.com/player/63346 Ronaldo Macapá - Ronaldo da Costa > Silva > http://example.com/player/63153 Nei Júnior - Ronaldo da Silva > http://example.com/player/44209 Ronaldo Silva - Ronaldo Silva > http://example.com/player/42158 Ronaldo - Ronaldo Costa da Silva > http://example.com/player/51145 Ronaldo - Ronaldo Tôrres da Silva > http://example.com/player/53428 Magal - Ronaldo Luís Pereira Silva > http://example.com/player/55951 Ronaldo - Ronaldo Afonso da Silva > http://example.com/player/51834 Ronaldo - Ronaldo da Silva > http://example.com/player/50610 Ronaldo - Ronaldo Araújo da Silva > http://example.com/player/50681 Ronaldo - Ronaldo Silva Oliveira > http://example.com/player/53771 Índio - Ronaldo Odilon da Silva > http://example.com/player/50710 Ibateguara - Ronaldo José da Silva > http://example.com/player/51212 Ronaldo - Ronaldo da Costa Silva > http://example.com/player/46747 Ronaldo - Ronaldo Moraes da Silva > http://example.com/player/41888 Ronaldo - Ronaldo José da Silva > > 20 Rows. -- 2440 msec. > > > *Example (ORDER BY)* > > define input:default-graph-uri <http://example.com/> > define input:inference <http://example.com/ruleset> > > select distinct ?s ?label > FROM <http://example.com/sports/> > > { > > { > ?s a <http://example.com/base/player> ; ?p ?o . > ?o bif:contains "'Ronaldo' AND 'Silva'" . > ?s l ?label . > } > > } > ORDER BY(?label) > LIMIT 100 > > > s label > VARCHAR VARCHAR > > _______________________________________________________________________________ > > http://semantica.globo.com/atleta/50710 Ibateguara - Ronaldo José da > Silva > http://semantica.globo.com/atleta/53428 Magal - Ronaldo Luís Pereira > Silva > http://semantica.globo.com/atleta/63153 Nei Júnior - Ronaldo da Silva > http://semantica.globo.com/atleta/53087 Ronaldo - João Ronaldo da > Silva > http://semantica.globo.com/atleta/55951 Ronaldo - Ronaldo Afonso da > Silva > http://semantica.globo.com/atleta/50610 Ronaldo - Ronaldo Araújo da > Silva > http://semantica.globo.com/atleta/42158 Ronaldo - Ronaldo Costa da > Silva > http://semantica.globo.com/atleta/41888 Ronaldo - Ronaldo José da > Silva > http://semantica.globo.com/atleta/46747 Ronaldo - Ronaldo Moraes da > Silva > http://semantica.globo.com/atleta/50681 Ronaldo - Ronaldo Silva > Oliveira > http://semantica.globo.com/atleta/51145 Ronaldo - Ronaldo Tôrres da > Silva > http://semantica.globo.com/atleta/51212 Ronaldo - Ronaldo da Costa > Silva > http://semantica.globo.com/atleta/51834 Ronaldo - Ronaldo da Silva > http://semantica.globo.com/atleta/40875 Ronaldo - Ronaldo da Silva > Oliveira > http://semantica.globo.com/atleta/45443 Ronaldo - Ronaldo dos Santos > da Silva > http://semantica.globo.com/atleta/63346 Ronaldo Macapá - Ronaldo da > Costa Silva > http://semantica.globo.com/atleta/44209 Ronaldo Silva - Ronaldo Silva > http://semantica.globo.com/atleta/42424 Ronaldo Testa - Ronaldo > Ferreira da Silva > http://semantica.globo.com/atleta/63408 Rone - José Ronaldo Ferreira > da Silva > http://semantica.globo.com/atleta/53771 Índio - Ronaldo Odilon da > Silva > > 20 Rows. -- 2479 msec. > > > > Abraços, > Renan Oliveira > ----------------------------------------------- > Busca & Semântica - Globo.com > (21) 2483-6727 > Y! glb_renan > > ------------------------------------------------------------------------------ > Protect Your Site and Customers from Malware Attacks > Learn about various malware tactics and how to avoid them. Understand > malware threats, the impact they can have on your business, and how you > can protect your company and customers by using code signing. > > http://p.sf.net/sfu/oracle-sfdevnl_______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > >
