summaryrefslogtreecommitdiff
path: root/tests/raw_query/tests.py
diff options
context:
space:
mode:
authorAlex Hill <alex@hill.net.au>2013-12-13 14:04:28 +0800
committerTim Graham <timograham@gmail.com>2014-08-06 08:41:34 -0400
commit938da36cb12c07c93a44bb1b77984427e809d213 (patch)
tree63900d2347837b6d432139344ca2bd911e8f4287 /tests/raw_query/tests.py
parentedcc75e5ac5b9dc2f174580e7adacd3be586f8bd (diff)
Fixed #21603 -- Fixed complex RawQuerySets queries on some versions of SQLite.
Diffstat (limited to 'tests/raw_query/tests.py')
-rw-r--r--tests/raw_query/tests.py6
1 files changed, 6 insertions, 0 deletions
diff --git a/tests/raw_query/tests.py b/tests/raw_query/tests.py
index 80372c1ae0..7d81ee8ded 100644
--- a/tests/raw_query/tests.py
+++ b/tests/raw_query/tests.py
@@ -239,3 +239,9 @@ class RawQueryTests(TestCase):
def test_query_count(self):
self.assertNumQueries(1, list, Author.objects.raw("SELECT * FROM raw_query_author"))
+
+ def test_subquery_in_raw_sql(self):
+ try:
+ list(Book.objects.raw('SELECT "id" FROM (SELECT * FROM raw_query_book WHERE paperback) sq'))
+ except InvalidQuery:
+ self.fail("Using a subquery in a RawQuerySet raised InvalidQuery")