[MARMOTTA-283] Triples are removed in DELETE/INSERT statement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 3.0-incubating
• Fix Version/s: 3.1-incubating
• Component/s: KiWi Triple Store

Environment

http://connectme.salzburgresearch.at/yoovis

• Assignee: Thomas Kurz
• Reporter: Dietmar Glachs
• Created: 20/Aug/13 11:11
• Updated: 03/Oct/13 13:38
• Resolved: 11/Sep/13 08:39

Description

when issuing a delete insert sparql query like this

WITH <http://connectme.salzburgresearch.at/yoovis/resource/video/yoovisid_7214>
DELETE {
?annotation ?p ?v.
?fragment ?r ?s.
<http://connectme.salzburgresearch.at/yoovis/resource/video/yoovisid_7214> <http://www.w3.org/ns/ma-ont#hasFragment> ?fragment.
}
INSERT {
<http://connectme.salzburgresearch.at/yoovis/resource/video/yoovisid_7214> <http://www.w3.org/ns/ma-ont#hasFragment> <http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> .
<http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.w3.org/ns/ma-ont#MediaFragment> .
<http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> <http://www.w3.org/ns/ma-ont#locator> "https://s3-eu-west-1.amazonaws.com/yoo.120/connectme/7214_519_20130721030604_ogg.ogv#t=43,53"^^<http://www.w3.org/2001/XMLSchema#anyURI> .
<http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> <http://www.w3.org/ns/ma-ont#locator> "https://s3-eu-west-1.amazonaws.com/yoo.120/connectme/7214_519_20130721030604_standard.mp4#t=43,53"^^<http://www.w3.org/2001/XMLSchema#anyURI> .
<http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> <http://www.w3.org/ns/ma-ont#locator> "https://s3-eu-west-1.amazonaws.com/yoo.120/connectme/7214_519_20130721030604_webm.webm#t=43,53"^^<http://www.w3.org/2001/XMLSchema#anyURI> .
<http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> <http://connectme.at/ontology#implicitlyShows> <http://de.dbpedia.org/resource/Ober\u00F6sterreich> .
<http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.openannotation.org/ns/Annotation> .
<http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c> <http://www.openannotation.org/ns/hasTarget> <http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c> .
<http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c> <http://purl.org/dc/terms/creator> <http://www.yoovis.tv/user.aspx?id=519> .
<http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c> <http://purl.org/dc/terms/created> "2013-08-20T08:33:45+00:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
<http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c> <http://www.openannotation.org/ns/hasBody> <http://de.dbpedia.org/resource/Ober\u00F6sterreich> .
<http://www.yoovis.tv/user.aspx?id=519> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
}
WHERE {
?annotation <http://www.openannotation.org/ns/hasTarget> ?fragment.
?annotation ?p ?v.
OPTIONAL

{ ?fragment ?r ?s }

FILTER (?fragment = <http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c>)
}
Code: 200; Message:

verify this:
http://connectme.salzburgresearch.at/yoovis/resource?uri=http://connectme.at/fragment/9358aa9aa1df14994825a822f29c4b2c
http://connectme.salzburgresearch.at/yoovis/resource?uri=http://connectme.at/annotation/9358aa9aa1df14994825a822f29c4b2c

the inserted triples are not stored when they are not changed - the annotation has a modification date - this is the only triple which remains.