Fix SQL for metadata queries in SQLite module.

Refs #1766

diff --git a/pithos/backends/lib/sqlite/node.py b/pithos/backends/lib/sqlite/node.py
index 6348a3d..55581ed 100644 (file)
--- a/pithos/backends/lib/sqlite/node.py
+++ b/pithos/backends/lib/sqlite/node.py
@@ -635,7 +635,7 @@ class Node(DBWorker):
             append(subq)
         
         if opers:
-            t = (("(key = ? and value %s ?)" % (o,)) for k, o, v in opers)
+            t = (("(a.key = ? and a.value %s ?)" % (o,)) for k, o, v in opers)
             subq = "(" + ' or '.join(t) + ")"
             for k, o, v in opers:
                 args += (k, v)