Hi, Hugh.
I updated the virtuouso to the new version (6.1.3) and continues to happen.
Do you know version name is 06.01.3127-pthreads?
Can you help?
*SQL> status();*
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso Server
Version 06.01.3127-pthreads for Darwin as of Jan 14 2011
Started on: 2011/01/14 16:11 GMT-120
Database Status:
File size 220200960, 26880 pages, 15059 free.
2000 buffers, 2000 used, 0 dirty 0 wired down, repl age 3560 0 w. io 0
w/crsr.
Disk Usage: 9302 reads avg 0 msec, 0% r 0% w last 267 s, 102 writes,
228 read ahead, batch = 29. Autocompact 8 in 7 out, 11% saved.
Gate: 44 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = virtuoso.trx, 87 bytes
11723 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 2 connects, max 1 concurrent
RPC: 14 calls, 0 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 26880 total 15059 free 76 remap 0 mapped back
temp 256 total 251 free
Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:
Client 1111:2: Account: dba, 316 bytes in, 2381 bytes out, 1 stmts.
PID: 65379, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:
Running Statements:
Time (msec) Text
103 status()
Hash indexes
37 Rows. -- 104 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. -- 3522 msec.*
*
Abraços,
Renan Oliveira
-----------------------------------------------
Busca & Semântica - Globo.com
(21) 2483-6727
Y! glb_renan
2011/1/14 Renan Moreira de Oliveira <[email protected]>
> 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
>>
>>
>>
>
