Hugh, new information : same type error when copying V6 virtuoso.db in a
clean "row store original" V7 , we lost XMLLiteral present in V6 datas :
select ?titre (DATATYPE(?titre ))from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> where
{<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
dcterms:title ?titre}
returns
titre callret-1
"???� rootbVariants of nonlinear normal form observer design"
http://www.w3.org/2001/XMLSchema#string
so now we can exclude error during the row to column store procedure.
Thomas
Le 08/12/2015 15:34, Thomas Michaux a écrit :
Le 08/12/2015 14:03, Hugh Williams a écrit :
Hi Thomas,
Don’t know what you mean by " pbs on datas” ???
I assume this spurious chars at the beginning of the strings ?
yes (triple count is ok in V7/V7, no RDF data loss)
Are you saying this string values where XMLLiteral in vs but are now
XMLSchema#string in v7 , which may be the cause ?
yes XMLLiteral in V6 (via DATATYPE function call) and XMLSchema#string
in V7
Did you convert the RDF_QUAD table to column store mode also ?
yes
As would be interesting to know if this occurred when it was in v7
row store original mode also …
i will check this and provide information
Have you tried dumping and reloading the RDF Quad data as also
suggested as an alternative previously ? ie
not at the moment but i will do as "plan B" if we have the same
missing types in V7 row store test
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 Dec 2015, at 11:55, Thomas Michaux <mich...@abes.fr> wrote:
in SPARQL : select ?titre (DATATYPE(?titre ))from
<http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV>
where
{<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
dcterms:title ?titre}
V7 result :
titre callret-1
"???� rootbVariants of nonlinear normal form observer design"
http://www.w3.org/2001/XMLSchema#string
V6 result:
titre callret-1
Variants of nonlinear normal form observer design
http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral
Thomas
Le 08/12/2015 12:42, Thomas Michaux a écrit :
when we compare the datatypes from V6 and v7 it seems we'd lost the
"strong" typing in V6 to a "generic" V7 type
http://www.w3.org/2001/XMLSchema#string :
SELECT DB.DBA.RDF_DATATYPE_OF_OBJ( "s_1_1_t0"."O") AS
"titre_datatype", DB.DBA.RDF_LANGUAGE_OF_OBJ( "s_1_1_t0"."O") AS
"titre_langage"
FROM DB.DBA.RDF_QUAD AS "s_1_1_t0"
WHERE
"s_1_1_t0"."G" = __i2idn ( __bft(
'http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV'
, 1))
AND
"s_1_1_t0"."S" = __i2idn ( __bft(
'http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w'
, 1))
AND
"s_1_1_t0"."P" = __i2idn ( __bft(
'http://purl.org/dc/terms/title' , 1))
OPTION (QUIETCAST)
V7 :
titre_datatype titre_langage
LONG VARCHAR LONG VARCHAR
_______________________________________________________________________________
http://www.w3.org/2001/XMLSchema#string BLOB 0 chars
1 Rows. -- 2 msec.
V6 :
titre_datatype titre_langage
LONG VARCHAR LONG VARCHAR
_______________________________________________________________________________
#i2320000 BLOB 0 chars
1 Rows. -- 1 msec.
Thomas
-------- Message transféré --------
Sujet : Re: [Virtuoso-users] Problems using +backup-dump from
Virtuoso 6 to Virtuoso 7 with +restore-crash-dump
Date : Tue, 8 Dec 2015 11:16:32 +0100
De : Thomas Michaux <mich...@abes.fr>
Pour : virtuoso-users@lists.sourceforge.net
<virtuoso-users@lists.sourceforge.net>
Copie à : Hugh Williams <hwilli...@openlinksw.com>
Important precision,
we have focused this problems on a specific type of literals :
Je dois préciser que le pb concerne des données de type
Littéraux XML
(http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals) :
<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>
<http://purl.org/dc/terms/title> "Variants of nonlinear normal form observer
design"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> .
------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users