[tracker] SPARQL: Quote variable names in generated SQL query



commit ad8f2ee86e17989532b85354394ccd58dee8df6e
Author: Jürg Billeter <j bitron ch>
Date:   Wed May 6 15:01:19 2009 +0200

    SPARQL: Quote variable names in generated SQL query
    
    Unquoted variable names can conflict with SQL keywords.
---
 src/libtracker-data/tracker-sparql-query.vala |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/libtracker-data/tracker-sparql-query.vala b/src/libtracker-data/tracker-sparql-query.vala
index 44407cf..251989b 100644
--- a/src/libtracker-data/tracker-sparql-query.vala
+++ b/src/libtracker-data/tracker-sparql-query.vala
@@ -983,7 +983,7 @@ public class Tracker.SparqlQuery : Object {
 					pattern_variables.append (binding.variable);
 					pattern_var_map.insert (binding.variable, binding_list);
 
-					pattern_sql.append_printf ("\"%s\".\"%s\" AS %s, ",
+					pattern_sql.append_printf ("\"%s\".\"%s\" AS \"%s\", ",
 						binding.table.sql_query_tablename,
 						binding.sql_db_column_name,
 						binding.variable);



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]