diff options
| author | Seif Lotfy <seif@lotfy.com> | 2012-05-11 21:50:39 +0200 |
|---|---|---|
| committer | Seif Lotfy <seif@lotfy.com> | 2012-05-11 21:50:39 +0200 |
| commit | 0f43e86650e609cdbd3cb67b817c5d1d95a5f56b (patch) | |
| tree | fb610e92fac30f04bbcfcf2eb96b1107f390a44f | |
| parent | 8c97b9faa164d0e427fa35335592653fef62b7bf (diff) | |
| download | zeitgeist-0f43e86650e609cdbd3cb67b817c5d1d95a5f56b.tar.gz | |
WhereClause: optimize add_text_condition_subquery
| -rw-r--r-- | src/where-clause.vala | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/where-clause.vala b/src/where-clause.vala index a799a7da..64dc3706 100644 --- a/src/where-clause.vala +++ b/src/where-clause.vala @@ -123,8 +123,8 @@ namespace Zeitgeist bool negation=false) { string search_table = get_search_table_for_column (column); - string sql = "%s = (SELECT id FROM %s WHERE value %s= ?)".printf ( - column, search_table, (negation) ? "!" : ""); + string sql = "%s %s= (SELECT id FROM %s WHERE value = ?)".printf ( + column, (negation) ? "!" : "", search_table); add (sql, val); } |