Hi Jonas, Also, you indicate this error does not occur via ODBC ie the SQL Virtuoso interface, but it does for me:
SQL> sparql select * from <http://localhost:8862/lod2.ttl> where {?s ?p ?o } ORDER BY ?s ?p ?o; *** Error 22026: [Virtuoso Driver][Virtuoso Server]SR...: Sorting key too long in order by key, exceeds 1900 bytes. at line 2 of Top-Level: sparql select * from <http://localhost:8862/lod2.ttl> where {?s ?p ?o } ORDER BY ?s ?p ?o SQL> so curious as to how this is being run in OntoWiki via ODBC ? 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 11 May 2011, at 13:30, Hugh Williams wrote: > Hi Jonas, > > I have been able to recreate this locally, we are looking into this and will > get back to you ... > > 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 > > PS: You need to register on the virtuoso-users mailing list to prevent you > posts from being moderated before allowed on: > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMailingLists > > On 10 May 2011, at 14:24, Jonas Brekle wrote: > >> Hi, >> >> i have a rdf model which contains very long literals (the lod2.eu >> website model - see attacchments). When i send the sparql query: >> SELECT * FROM <http://lod2.eu/> WHERE {?s ?p ?o} ORDER BY ?s ?p ?o >> via the conductor, it tells me >> 22026 Error SR...: Sorting key too long in order by key, exceeds 1900 bytes. >> when i do the same query via odbc (in ontowiki) i get no error but a >> unsorted result... >> this is crucial to our rdf/xml serialization algorithm. >> can you recomend anything to us? or fix this somehow (i know its >> probably intended so, but we could also live with a config option + a >> slower query) >> >> regards, >> Jonas >> AKSW >> <lod2.ttl>------------------------------------------------------------------------------ >> Achieve unprecedented app performance and reliability >> What every C/C++ and Fortran developer should know. >> Learn how Intel has extended the reach of its next-generation tools >> to help boost performance applications - inlcuding clusters. >> http://p.sf.net/sfu/intel-dev2devmay_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >
