← Back to team overview

zeitgeist team mailing list archive

[Branch ~zeitgeist/zeitgeist/bluebird] Rev 421: WhereClause: Add parentheses to make resultant SQL easier to understand.

 

------------------------------------------------------------
revno: 421
committer: Siegfried-Angel Gevatter Pujals <siegfried@xxxxxxxxxxxx>
branch nick: bluebird
timestamp: Tue 2012-03-13 19:48:33 +0100
message:
  WhereClause: Add parentheses to make resultant SQL easier to understand.
modified:
  src/where-clause.vala


--
lp:zeitgeist
https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird

Your team Zeitgeist Framework Team is subscribed to branch lp:zeitgeist.
To unsubscribe from this branch go to https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird/+edit-subscription
=== modified file 'src/where-clause.vala'
--- src/where-clause.vala	2011-09-19 14:12:03 +0000
+++ src/where-clause.vala	2012-03-13 18:48:33 +0000
@@ -149,7 +149,7 @@
             if (!negation)
                 sql = "%s IN (%s)".printf (column, optimized_glob);
             else
-                sql = "%s NOT IN (%s) OR %s is NULL".printf (column,
+                sql = "(%s NOT IN (%s) OR %s is NULL)".printf (column,
                     optimized_glob, column);
             add_with_array (sql, values);
         }