Hello Alexander, I'm sorry but I can't reproduce the case. I've tried both Virtuoso Open Source 5.0.8 (a fresh build downloaded from SourceForge) and the snapshot that will become a base for 5.0.9 later this week. The log of isql session follows:
SQL> sparql insert into graph <http://my_graph> { <http://a> <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> }; callret-0 VARCHAR _______________________________________________________________________________ Insert into <http://my_graph>, 1 triples -- done 1 Rows. -- 8 msec. SQL> select sparql_to_sql_text('insert into graph <http://my_graph> { <http://a> <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> }'); callret VARCHAR _______________________________________________________________________________ SELECT TOP 1 DB.DBA.SPARQL_INSERT_DICT_CONTENT ( __box_flags_tweak ( /* QName as sqlval */ __box_flags_tweak ( 'http://my_graph' , 1), 1), DB.DBA.SPARQL_CONSTRUCT ( vector (), vector (), vector ( vector ( 3, DB.DBA.RDF_MAKE_IID_OF_QNAME ( UNAME'http://a' ), 3, DB.DBA.RDF_MAKE_IID_OF_QNAME ( UNAME'http://b' ), 3, DB.DBA.RDF_MAKE_LONG_OF_TYPEDSQLVAL_STRINGS ( '1' , UNAME'http://www.w3.org/2001/XMLSchema#int' , NULL)))), NULL, 1) AS /*retsimple*/ "callret-0" FROM (SELECT TOP 1 1 AS __dummy_retval FROM (SELECT TOP 1 1 AS __stub FROM DB.DBA.RDF_QUAD) AS "stub-s-1-4" ) as "limofs" OPTION (QUIETCAST) 1 Rows. -- 2 msec. SQL> select DB.DBA.RDF_MAKE_LONG_OF_TYPEDSQLVAL_STRINGS ( '1' , UNAME'http://www.w3.org/2001/XMLSchema#int' , NULL); callret VARCHAR _______________________________________________________________________________ 1 1 Rows. -- 2 msec. SQL> select __tag(DB.DBA.RDF_MAKE_LONG_OF_TYPEDSQLVAL_STRINGS ( '1' , UNAME'http://www.w3.org/2001/XMLSchema#int' , NULL)); callret INTEGER _______________________________________________________________________________ 246 1 Rows. -- 2 msec. SQL> sparql select * where { graph ?g {<http://a> <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> }}; g VARCHAR _______________________________________________________________________________ http://my_graph 1 Rows. -- 8 msec. SQL> sparql select * where { graph ?g {<http://a> <http://b> "2"^^<http://www.w3.org/2001/XMLSchema#int> }}; g VARCHAR _______________________________________________________________________________ 0 Rows. -- 6 msec. SQL> sparql select * where { graph <http://my_graph> { ?s ?p ?o }}; s p o VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ http://a http://b 1 1 Rows. -- 5 msec. SQL> sparql select (datatype(?o)) where { graph <http://my_graph> { ?s ?p ?o }}; callret-0 VARCHAR _______________________________________________________________________________ http://www.w3.org/2001/XMLSchema#int 1 Rows. -- 8 msec. SQL> sparql delete from graph <http://my_graph> { <http://a> Type the rest of statement, end with a semicolon (;)> <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> }; callret-0 VARCHAR _______________________________________________________________________________ Delete from <http://my_graph>, 1 triples -- done 1 Rows. -- 10 msec. SQL> sparql select * where { graph <http://my_graph> { ?s ?p ?o }}; s p o VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ 0 Rows. -- 2 msec. Could you please try commands from this log on a blank database and tell us if there any difference? Best Regards, Ivan Mikhailov, OpenLink Software http://virtuoso.openlinksw.com On Sat, 2008-09-13 at 03:40 +0400, Alexander I. Gordeev wrote: > Hi All! > > I'm currently testing Virtuoso because we need a fast RDF store which can > handle billions of triples for my company's several projects and it shows > itself very well so far. However, I've found that several queries do not work > as expected (neither through isql nor jdbc interface): > > sparql insert into graph <http://my_graph> { <http://a> > <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> } > > sparql delete from graph <http://my_graph> { <http://a> > <http://b> "1"^^<http://www.w3.org/2001/XMLSchema#int> } > > I think these queries are correct as they are very much like queries from > sparul examples, but they do nothing. Please, help me to make them work! > > I'm using the demo database in var/lib/virtuoso/db with default configuration. > Virtuoso version is 5.0.8, it is compiled from source and used on Debian > lenny > x86. > > Thanks in advance! > > -- > Alexander
