[tracker] functional-tests: Test NB#224760, too many things in IN



commit b06827d34d9d971a10ddd63299134ed2064758f4
Author: Ivan Frade <ivan frade nokia com>
Date:   Fri Feb 4 12:18:13 2011 +0200

    functional-tests: Test NB#224760, too many things in IN

 tests/functional-tests/02-sparql-bugs.py |   15 ++++++++++++++-
 1 files changed, 14 insertions(+), 1 deletions(-)
---
diff --git a/tests/functional-tests/02-sparql-bugs.py b/tests/functional-tests/02-sparql-bugs.py
index 4937713..4c4a1cb 100755
--- a/tests/functional-tests/02-sparql-bugs.py
+++ b/tests/functional-tests/02-sparql-bugs.py
@@ -207,7 +207,20 @@ class TrackerStoreSparqlBugsTests (CommonTrackerStoreTest):
                 # We could be more picky, but checking there are the same number of results
                 # is enough to verify the problem described in the bug.
 
-                
+
+        def test_04_NB224760_too_long_filter (self):
+                """
+                NB#224760 - 'too many sql variables' when filter ?sth in (long list)
+                """
+                query = "SELECT tracker:id (?m) ?m WHERE { ?m a rdfs:Resource. FILTER (tracker:id (?m) in (%s)) }"
+                numbers = ",".join ([str (i) for i in range (1000, 2000)])
+
+                results = self.tracker.query (query % (numbers))
+
+                # The query will raise an exception is the bug is there
+                # If we are here, everything is fine. 
+                self.assertIsNotNone (results)
+                                   
 
                 
 



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