Bug 245157

Summary: email feeder creates invalid SPARQL for addresses containing quoted-strings
Product: [Frameworks and Libraries] Akonadi Reporter: Will Stephenson <wstephenson>
Component: Nepomuk Feeder AgentsAssignee: Tobias Koenig <tokoe>
Status: RESOLVED FIXED    
Severity: normal CC: kdepim-bugs, vkrause
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: Unlisted Binaries   
OS: Linux   
Latest Commit: Version Fixed In:

Description Will Stephenson 2010-07-19 18:35:42 UTC
Version:           unspecified
OS:                Linux

Email addresses of the form "John Doe"@domain.org are ugly but legal.  The extra quoting creates invalid SPARQL queries:

[/space/kde/installs/4_5/bin/nepomukservicestub] "/space/kde/installs/4_5/bin/nepomukservicestub(4830)" Error in thread 2923506544 : "SQLExecDirect failed on query 'sparql  SELECT ?person WHERE { ?person <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hasEmailAddress> ?email . ?email <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#emailAddress> ""DL-Germany AllUsers"@novell.com"^^<http://www.w3.org/2001/XMLSchema#string> }' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SQ074: Line 1: SP030: SPARQL compiler, line 1: syntax error at 'DL' before '-')"


Reproducible: Didn't try

Steps to Reproduce:
Allow folders containing mail with To: addresses of this form to be indexed.

Actual Results:  
nepomuk-email-feeder hangs and causes virtuoso, dbus and itself to uses 100% cpu between them