Skip to content

Instantly share code, notes, and snippets.

@charettes

charettes/ticket-34597-sqlite.diff

Created May 30, 2023 04:36
Show Gist options
  • Save charettes/5256c4d52470a6f48f8955a92bce2135 to your computer and use it in GitHub Desktop.
Save charettes/5256c4d52470a6f48f8955a92bce2135 to your computer and use it in GitHub Desktop.
Download ZIP
SQL changes when running the test suite for django#34597
Raw
ticket-34597-sqlite.diff
--- test_add (many_to_many.tests.ManyToManyTests):sqlite:556fa4bbba
+++ test_add (many_to_many.tests.ManyToManyTests):sqlite:bbf141bcdc
@@ -41,7 +41,7 @@
INNER JOIN "many_to_many_article_publications" ON ("many_to_many_publication"."id" = "many_to_many_article_publications"."publication_id")
WHERE "many_to_many_article_publications"."article_id" = %s
ORDER BY "many_to_many_publication"."title" ASC
-ROLLBACK TO SAVEPOINT "s4705965568_x3"
+ROLLBACK TO SAVEPOINT "s4422178304_x3"
INSERT INTO "many_to_many_publication" ("title")
VALUES (%s)
INSERT
--- test_selects (many_to_many.tests.ManyToManyTests):sqlite:556fa4bbba
+++ test_selects (many_to_many.tests.ManyToManyTests):sqlite:bbf141bcdc
@@ -85,8 +85,10 @@
"many_to_many_article"."headline"
FROM "many_to_many_article"
WHERE (NOT ("many_to_many_article"."headline" = %s)
- AND NOT ("many_to_many_article"."id" IN
- (SELECT U1."article_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "many_to_many_article_publications" U1
- WHERE U1."publication_id" = %s)))
+ WHERE (U1."publication_id" = %s
+ AND U1."article_id" = "many_to_many_article"."id")
+ LIMIT 1)))
ORDER BY "many_to_many_article"."headline" ASC
--- test_annotate_and_join (aggregation_regress.tests.AggregationTests):sqlite:556fa4bbba
+++ test_annotate_and_join (aggregation_regress.tests.AggregationTests):sqlite:bbf141bcdc
@@ -4,11 +4,13 @@
FROM "aggregation_regress_author"
LEFT OUTER JOIN "aggregation_regress_author_friends" ON ("aggregation_regress_author"."id" = "aggregation_regress_author_friends"."from_author_id")
LEFT OUTER JOIN "aggregation_regress_author" T3 ON ("aggregation_regress_author_friends"."to_author_id" = T3."id")
- WHERE NOT ("aggregation_regress_author"."id" IN
- (SELECT U1."from_author_id"
+ WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "aggregation_regress_author_friends" U1
INNER JOIN "aggregation_regress_author" U2 ON (U1."to_author_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."from_author_id" = "aggregation_regress_author"."id")
+ LIMIT 1))
GROUP BY "aggregation_regress_author"."id") subquery
SELECT COUNT(*) AS "__count"
FROM "aggregation_regress_author"
--- test_reverse_relations (null_queries.tests.NullQueriesTests):sqlite:556fa4bbba
+++ test_reverse_relations (null_queries.tests.NullQueriesTests):sqlite:bbf141bcdc
@@ -32,8 +32,9 @@
SELECT "null_queries_outerb"."id",
"null_queries_outerb"."data"
FROM "null_queries_outerb"
-WHERE NOT ("null_queries_outerb"."id" IN
- (SELECT U1."third_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "null_queries_inner" U1
WHERE (U1."id" IS NOT NULL
- AND U1."third_id" IS NOT NULL)))
+ AND U1."third_id" = "null_queries_outerb"."id")
+ LIMIT 1))
--- test_exclude_plain (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_plain (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,8 +1,10 @@
SELECT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_exclude_plain_distinct (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_plain_distinct (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,8 +1,10 @@
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_exclude_with_q_is_equal_to_plain_exclude (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_with_q_is_equal_to_plain_exclude (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,16 +1,20 @@
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_exclude_with_q_is_equal_to_plain_exclude_variation (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_with_q_is_equal_to_plain_exclude_variation (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,16 +1,20 @@
SELECT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_exclude_with_q_object_distinct (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_with_q_object_distinct (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,8 +1,10 @@
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_exclude_with_q_object_no_distinct (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_exclude_with_q_object_no_distinct (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,8 +1,10 @@
SELECT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1))
ORDER BY "queries_order"."id" ASC
--- test_only_orders_with_all_items_having_status_1 (queries.tests.ExcludeTest17600):sqlite:556fa4bbba
+++ test_only_orders_with_all_items_having_status_1 (queries.tests.ExcludeTest17600):sqlite:bbf141bcdc
@@ -1,8 +1,10 @@
SELECT DISTINCT "queries_order"."id",
"queries_order"."name"
FROM "queries_order"
-WHERE NOT (NOT ("queries_order"."id" IN
- (SELECT U1."order_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_orderitem" U1
- WHERE U1."status" = %s)))
+ WHERE (U1."status" = %s
+ AND U1."order_id" = "queries_order"."id")
+ LIMIT 1)))
ORDER BY "queries_order"."id" ASC
--- test_exclude_reverse_fk_field_ref (queries.tests.ExcludeTests):sqlite:556fa4bbba
+++ test_exclude_reverse_fk_field_ref (queries.tests.ExcludeTests):sqlite:bbf141bcdc
@@ -14,9 +14,10 @@
"queries_annotation"."name",
"queries_annotation"."tag_id"
FROM "queries_annotation"
-WHERE NOT ("queries_annotation"."tag_id" IN
- (SELECT U2."tag_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_note" U2
WHERE (U2."note" = "queries_annotation"."name"
- AND U2."tag_id" IS NOT NULL)))
+ AND U2."tag_id" = "queries_annotation"."tag_id")
+ LIMIT 1))
LIMIT 21
--- test_exclude_with_circular_fk_relation (queries.tests.ExcludeTests):sqlite:556fa4bbba
+++ test_exclude_with_circular_fk_relation (queries.tests.ExcludeTests):sqlite:bbf141bcdc
@@ -1,6 +1,8 @@
SELECT COUNT(*) AS "__count"
FROM "queries_objectb"
-WHERE NOT ("queries_objectb"."objecta_id" IN
- (SELECT U2."objecta_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_objectb" U2
- WHERE U2."name" = "queries_objectb"."name"))
+ WHERE (U2."name" = "queries_objectb"."name"
+ AND U2."objecta_id" = "queries_objectb"."objecta_id")
+ LIMIT 1))
--- test_subquery_exclude_outerref (queries.tests.ExcludeTests):sqlite:556fa4bbba
+++ test_subquery_exclude_outerref (queries.tests.ExcludeTests):sqlite:bbf141bcdc
@@ -3,10 +3,12 @@
WHERE EXISTS
(SELECT (1) AS "a"
FROM "queries_responsibility" V0
- WHERE NOT (V0."description" IN
- (SELECT U1."responsibility_id"
+ WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_jobresponsibilities" U1
- WHERE U1."job_id" = "queries_jobresponsibilities"."job_id"))
+ WHERE (U1."job_id" = "queries_jobresponsibilities"."job_id"
+ AND U1."responsibility_id" = V0."description")
+ LIMIT 1))
LIMIT 1)
LIMIT 1
DELETE
@@ -20,9 +22,11 @@
WHERE EXISTS
(SELECT (1) AS "a"
FROM "queries_responsibility" V0
- WHERE NOT (V0."description" IN
- (SELECT U1."responsibility_id"
+ WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_jobresponsibilities" U1
- WHERE U1."job_id" = "queries_jobresponsibilities"."job_id"))
+ WHERE (U1."job_id" = "queries_jobresponsibilities"."job_id"
+ AND U1."responsibility_id" = V0."description")
+ LIMIT 1))
LIMIT 1)
LIMIT 1
--- test_ticket14511 (queries.tests.ExcludeTests):sqlite:556fa4bbba
+++ test_ticket14511 (queries.tests.ExcludeTests):sqlite:bbf141bcdc
@@ -157,10 +157,11 @@
FROM "queries_company"
INNER JOIN "queries_employment" ON ("queries_company"."id" = "queries_employment"."employer_id")
WHERE ("queries_employment"."employee_id" = %s
- AND NOT ("queries_company"."id" IN
- (SELECT U1."employer_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_employment" U1
- WHERE (U1."title" IN (%s,
- %s)
- AND U1."id" = "queries_employment"."id"))))
+ WHERE (U1."title" IN (%s, %s)
+ AND U1."id" = "queries_employment"."id"
+ AND "queries_employment"."employer_id" = "queries_company"."id")
+ LIMIT 1)))
ORDER BY "queries_company"."name" ASC
--- test_to_field (queries.tests.ExcludeTests):sqlite:556fa4bbba
+++ test_to_field (queries.tests.ExcludeTests):sqlite:bbf141bcdc
@@ -1,22 +1,27 @@
SELECT "queries_food"."id",
"queries_food"."name"
FROM "queries_food"
-WHERE NOT ("queries_food"."name" IN
- (SELECT U1."food_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_eaten" U1
WHERE (U1."meal" = %s
- AND U1."food_id" IS NOT NULL)))
+ AND U1."food_id" = "queries_food"."name")
+ LIMIT 1))
SELECT "queries_job"."id",
"queries_job"."name"
FROM "queries_job"
-WHERE NOT ("queries_job"."name" IN
- (SELECT U1."job_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_jobresponsibilities" U1
- WHERE U1."responsibility_id" = %s))
+ WHERE (U1."responsibility_id" = %s
+ AND U1."job_id" = "queries_job"."name")
+ LIMIT 1))
SELECT "queries_responsibility"."id",
"queries_responsibility"."description"
FROM "queries_responsibility"
-WHERE NOT ("queries_responsibility"."description" IN
- (SELECT U1."responsibility_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_jobresponsibilities" U1
- WHERE U1."job_id" = %s))
+ WHERE (U1."job_id" = %s
+ AND U1."responsibility_id" = "queries_responsibility"."description")
+ LIMIT 1))
--- test_ticket_21787 (queries.tests.ForeignKeyToBaseExcludeTests):sqlite:556fa4bbba
+++ test_ticket_21787 (queries.tests.ForeignKeyToBaseExcludeTests):sqlite:bbf141bcdc
@@ -26,10 +26,12 @@
"queries_specialcategory"."special_name"
FROM "queries_specialcategory"
INNER JOIN "queries_simplecategory" ON ("queries_specialcategory"."simplecategory_ptr_id" = "queries_simplecategory"."id")
-WHERE NOT ("queries_specialcategory"."simplecategory_ptr_id" IN
- (SELECT U2."category_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_categoryitem" U2
- WHERE U2."id" = %s))
+ WHERE (U2."id" = %s
+ AND U2."category_id" = "queries_specialcategory"."simplecategory_ptr_id")
+ LIMIT 1))
ORDER BY "queries_simplecategory"."name" ASC
SELECT "queries_simplecategory"."id",
"queries_simplecategory"."name",
--- test_inverted_q_across_relations (queries.tests.JoinReuseTest):sqlite:556fa4bbba
+++ test_inverted_q_across_relations (queries.tests.JoinReuseTest):sqlite:bbf141bcdc
@@ -17,12 +17,16 @@
SELECT "queries_student"."id",
"queries_student"."school_id"
FROM "queries_student"
-WHERE NOT ("queries_student"."school_id" IN
- (SELECT U2."school_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_classroom" U2
- WHERE U2."name" = %s)
- AND "queries_student"."school_id" IN
- (SELECT U1."id"
+ WHERE (U2."name" = %s
+ AND U2."school_id" = "queries_student"."school_id")
+ LIMIT 1)
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "queries_school" U1
LEFT OUTER JOIN "queries_classroom" U2 ON (U1."id" = U2."school_id")
- WHERE U2."has_blackboard" IS NULL))
+ WHERE (U2."has_blackboard" IS NULL
+ AND U1."id" = "queries_student"."school_id")
+ LIMIT 1))
--- test_exclude_many_to_many (queries.tests.ManyToManyExcludeTest):sqlite:556fa4bbba
+++ test_exclude_many_to_many (queries.tests.ManyToManyExcludeTest):sqlite:bbf141bcdc
@@ -18,21 +18,23 @@
"queries_identifier"."name"
FROM "queries_identifier"
LEFT OUTER JOIN "queries_program" ON ("queries_identifier"."id" = "queries_program"."identifier_id")
-WHERE NOT ("queries_program"."id" IN
- (SELECT U2."program_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_channel_programs" U2
- WHERE U2."channel_id" = %s)
- AND "queries_program"."id" IS NOT NULL)
+ WHERE (U2."channel_id" = %s
+ AND U2."program_id" = "queries_program"."id")
+ LIMIT 1))
ORDER BY "queries_identifier"."name" ASC
SELECT "queries_identifier"."id",
"queries_identifier"."name"
FROM "queries_identifier"
LEFT OUTER JOIN "queries_program" ON ("queries_identifier"."id" = "queries_program"."identifier_id")
-WHERE NOT ((("queries_program"."id" IN
- (SELECT U1."id"
- FROM "queries_program" U1
- LEFT OUTER JOIN "queries_channel_programs" U2 ON (U1."id" = U2."program_id")
- WHERE U2."channel_id" IS NULL)
- AND "queries_program"."id" IS NOT NULL)
+WHERE NOT ((EXISTS
+ (SELECT (1) AS "a"
+ FROM "queries_program" U1
+ LEFT OUTER JOIN "queries_channel_programs" U2 ON (U1."id" = U2."program_id")
+ WHERE (U2."channel_id" IS NULL
+ AND U1."id" = "queries_program"."id")
+ LIMIT 1)
OR "queries_program"."id" IS NULL))
ORDER BY "queries_identifier"."name" ASC
--- test_ticket_12823 (queries.tests.ManyToManyExcludeTest):sqlite:556fa4bbba
+++ test_ticket_12823 (queries.tests.ManyToManyExcludeTest):sqlite:bbf141bcdc
@@ -59,8 +59,10 @@
"queries_book"."chapter_id"
FROM "queries_book"
INNER JOIN "queries_chapter" ON ("queries_book"."chapter_id" = "queries_chapter"."id")
-WHERE NOT ("queries_chapter"."paragraph_id" IN
- (SELECT U3."paragraph_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_paragraph_page" U3
INNER JOIN "queries_page" U4 ON (U3."page_id" = U4."id")
- WHERE U4."text" = %s))
+ WHERE (U4."text" = %s
+ AND U3."paragraph_id" = "queries_chapter"."paragraph_id")
+ LIMIT 1))
--- test_double_exclude (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_double_exclude (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -6,11 +6,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -34,11 +36,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
--- test_exclude (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_exclude (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -6,11 +6,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -21,11 +23,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -36,16 +40,20 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT ((EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)
- OR "queries_item"."id" IN
- (SELECT U1."item_id"
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)
+ OR EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -56,16 +64,20 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT ((EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)
- OR "queries_item"."id" IN
- (SELECT U1."item_id"
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)
+ OR EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -76,16 +88,20 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT ((EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)
- OR NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)
+ OR NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -96,15 +112,19 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT ((EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)
- OR NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)
+ OR NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
--- test_exclude_in (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_exclude_in (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -6,12 +6,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" IN (%s,
- %s)))
+ WHERE (U2."name" IN (%s, %s)
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -22,12 +23,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" IN (%s,
- %s)))
+ WHERE (U2."name" IN (%s, %s)
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -38,12 +40,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" IN (%s,
- %s))))
+ WHERE (U2."name" IN (%s, %s)
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
--- test_excluded_intermediary_m2m_table_joined (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_excluded_intermediary_m2m_table_joined (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -4,11 +4,12 @@
"queries_note"."tag_id",
"queries_note"."negate"
FROM "queries_note"
-WHERE NOT ("queries_note"."tag_id" IN
- (SELECT U2."tag_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation" U2
- WHERE U2."name" = "queries_note"."note")
- AND "queries_note"."tag_id" IS NOT NULL)
+ WHERE (U2."name" = "queries_note"."note"
+ AND U2."tag_id" = "queries_note"."tag_id")
+ LIMIT 1))
ORDER BY "queries_note"."note" ASC
SELECT "queries_note"."id",
"queries_note"."note",
@@ -19,9 +20,10 @@
INNER JOIN "queries_tag" ON ("queries_note"."tag_id" = "queries_tag"."id")
INNER JOIN "queries_annotation" ON ("queries_tag"."id" = "queries_annotation"."tag_id")
WHERE ("queries_annotation"."name" = %s
- AND NOT ("queries_note"."tag_id" IN
- (SELECT U2."tag_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation" U2
- WHERE U2."name" = "queries_note"."note")
- AND "queries_note"."tag_id" IS NOT NULL))
+ WHERE (U2."name" = "queries_note"."note"
+ AND U2."tag_id" = "queries_note"."tag_id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" ASC
--- test_nested_exclude (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_nested_exclude (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -6,11 +6,13 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -21,10 +23,12 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE NOT (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
--- test_ticket7096 (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_ticket7096 (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -23,11 +23,13 @@
"queries_item"."note_id"
FROM "queries_item"
WHERE NOT ("queries_item"."name" = %s
- AND "queries_item"."id" IN
- (SELECT U1."item_id"
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_item"."name" ASC
SELECT "queries_item"."id",
"queries_item"."name",
@@ -38,11 +40,13 @@
FROM "queries_item"
WHERE ("queries_item"."name" IN (%s,
%s)
- AND NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_item"."name" ASC
SELECT "queries_item"."id",
"queries_item"."name",
@@ -53,11 +57,13 @@
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
WHERE NOT (NOT ("queries_item"."name" = %s
- AND "queries_item"."id" IN
- (SELECT U1."item_id"
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_item"."id",
@@ -69,11 +75,13 @@
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
WHERE (NOT ("queries_item"."name" = %s
- AND "queries_item"."id" IN
- (SELECT U1."item_id"
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
AND "queries_item"."name" = %s)
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
@@ -86,11 +94,13 @@
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
WHERE NOT (NOT ("queries_item"."name" = %s
- AND "queries_item"."id" IN
- (SELECT U1."item_id"
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
AND "queries_item"."name" = %s)
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
--- test_tickets_5324_6704 (queries.tests.Queries1Tests):sqlite:556fa4bbba
+++ test_tickets_5324_6704 (queries.tests.Queries1Tests):sqlite:bbf141bcdc
@@ -18,11 +18,13 @@
"queries_item"."creator_id",
"queries_item"."note_id"
FROM "queries_item"
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_item"."name" ASC
SELECT DISTINCT "queries_item"."id",
"queries_item"."name",
@@ -31,21 +33,25 @@
"queries_item"."creator_id",
"queries_item"."note_id"
FROM "queries_item"
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_item"."name" DESC
SELECT DISTINCT "queries_author"."id",
"queries_author"."name",
"queries_author"."num",
"queries_author"."extra_id"
FROM "queries_author"
-WHERE NOT ("queries_author"."id" IN
- (SELECT U1."creator_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item" U1
- WHERE U1."name" = %s))
+ WHERE (U1."name" = %s
+ AND U1."creator_id" = "queries_author"."id")
+ LIMIT 1))
ORDER BY "queries_author"."name" ASC
SELECT "queries_item"."id",
"queries_item"."name",
@@ -54,11 +60,13 @@
"queries_item"."creator_id",
"queries_item"."note_id"
FROM "queries_item"
-WHERE NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
ORDER BY "queries_item"."name" ASC
SELECT "queries_item"."id",
"queries_item"."name",
@@ -68,16 +76,20 @@
"queries_item"."note_id"
FROM "queries_item"
INNER JOIN "queries_note" ON ("queries_item"."note_id" = "queries_note"."id")
-WHERE (NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+WHERE (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s))
- AND NOT ("queries_item"."id" IN
- (SELECT U1."item_id"
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1))
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_item_tags" U1
INNER JOIN "queries_tag" U2 ON (U1."tag_id" = U2."id")
- WHERE U2."name" = %s)))
+ WHERE (U2."name" = %s
+ AND U1."item_id" = "queries_item"."id")
+ LIMIT 1)))
ORDER BY "queries_note"."note" DESC,
"queries_item"."name" ASC
SELECT "queries_tag"."id",
--- test_join_reuse_order (queries.tests.Queries4Tests):sqlite:556fa4bbba
+++ test_join_reuse_order (queries.tests.Queries4Tests):sqlite:bbf141bcdc
@@ -11,16 +11,20 @@
INNER JOIN "queries_teacher_schools" ON ("queries_teacher"."id" = "queries_teacher_schools"."teacher_id")
INNER JOIN "queries_teacher_schools" T4 ON ("queries_teacher"."id" = T4."teacher_id")
WHERE ((NOT ("queries_teacher"."id" = %s)
- AND NOT ("queries_teacher"."id" IN
- (SELECT U1."from_teacher_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_teacher_friends" U1
- WHERE U1."to_teacher_id" = %s))
+ WHERE (U1."to_teacher_id" = %s
+ AND U1."from_teacher_id" = "queries_teacher"."id")
+ LIMIT 1))
AND "queries_teacher_schools"."school_id" = %s
AND T4."school_id" = %s)
OR (NOT ("queries_teacher"."id" = %s)
- AND NOT ("queries_teacher"."id" IN
- (SELECT U1."from_teacher_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_teacher_friends" U1
- WHERE U1."to_teacher_id" = %s))
+ WHERE (U1."to_teacher_id" = %s
+ AND U1."from_teacher_id" = "queries_teacher"."id")
+ LIMIT 1))
AND "queries_teacher_schools"."school_id" = %s
AND T4."school_id" = %s))
--- test_ticket24525 (queries.tests.Queries4Tests):sqlite:556fa4bbba
+++ test_ticket24525 (queries.tests.Queries4Tests):sqlite:bbf141bcdc
@@ -50,7 +50,9 @@
INNER JOIN "queries_annotation_notes" ON ("queries_annotation"."id" = "queries_annotation_notes"."annotation_id")
WHERE ("queries_annotation_notes"."note_id" = %s
AND "queries_annotation"."tag_id" = %s
- AND NOT ("queries_annotation"."id" IN
- (SELECT U1."annotation_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation_notes" U1
- WHERE U1."note_id" IN (%s))))
+ WHERE (U1."note_id" IN (%s)
+ AND U1."annotation_id" = "queries_annotation"."id")
+ LIMIT 1)))
--- test_tickets_8921_9188 (queries.tests.Queries6Tests):sqlite:556fa4bbba
+++ test_tickets_8921_9188 (queries.tests.Queries6Tests):sqlite:bbf141bcdc
@@ -7,41 +7,47 @@
SELECT "queries_pointera"."id",
"queries_pointera"."connection_id"
FROM "queries_pointera"
-WHERE NOT ("queries_pointera"."connection_id" IN
- (SELECT U2."connection_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_pointerb" U2
- WHERE U2."id" = %s))
+ WHERE (U2."id" = %s
+ AND U2."connection_id" = "queries_pointera"."connection_id")
+ LIMIT 1))
SELECT "queries_tag"."id",
"queries_tag"."name",
"queries_tag"."parent_id",
"queries_tag"."category_id"
FROM "queries_tag"
-WHERE NOT ("queries_tag"."id" IN
- (SELECT U0."id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_tag" U0
LEFT OUTER JOIN "queries_tag" U1 ON (U0."id" = U1."parent_id")
- WHERE U1."id" IS NULL))
+ WHERE (U1."id" IS NULL
+ AND U0."id" = "queries_tag"."id")
+ LIMIT 1))
ORDER BY "queries_tag"."name" ASC
SELECT "queries_tag"."id",
"queries_tag"."name",
"queries_tag"."parent_id",
"queries_tag"."category_id"
FROM "queries_tag"
-WHERE NOT ("queries_tag"."parent_id" IN
- (SELECT U2."tag_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation" U2
- WHERE U2."name" = %s)
- AND "queries_tag"."parent_id" IS NOT NULL)
+ WHERE (U2."name" = %s
+ AND U2."tag_id" = "queries_tag"."parent_id")
+ LIMIT 1))
ORDER BY "queries_tag"."name" ASC
SELECT "queries_annotation"."id",
"queries_annotation"."name",
"queries_annotation"."tag_id"
FROM "queries_annotation"
-WHERE NOT ("queries_annotation"."tag_id" IN
- (SELECT U2."parent_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_tag" U2
WHERE (U2."name" = %s
- AND U2."parent_id" IS NOT NULL)))
+ AND U2."parent_id" = "queries_annotation"."tag_id")
+ LIMIT 1))
SELECT "queries_annotation"."id",
"queries_annotation"."name",
"queries_annotation"."tag_id"
--- test_ticket_24605 (queries.tests.TestTicket24605):sqlite:556fa4bbba
+++ test_ticket_24605 (queries.tests.TestTicket24605):sqlite:bbf141bcdc
@@ -20,10 +20,12 @@
"Individual"."alive"
FROM "Individual"
WHERE NOT (NOT "Individual"."alive"
- AND "Individual"."id" IN
- (SELECT U0."id"
+ AND EXISTS
+ (SELECT (1) AS "a"
FROM "Individual" U0
LEFT OUTER JOIN "RelatedIndividual" U1 ON (U0."id" = U1."related_id")
WHERE (U1."id" IS NULL
- AND U0."id" = "Individual"."id")))
+ AND U0."id" = "Individual"."id"
+ AND "Individual"."id" = "Individual"."id")
+ LIMIT 1))
ORDER BY "Individual"."id" ASC
--- test_ticket_20101 (queries.tests.Ticket20101Tests):sqlite:556fa4bbba
+++ test_ticket_20101 (queries.tests.Ticket20101Tests):sqlite:bbf141bcdc
@@ -22,11 +22,12 @@
"queries_note"."tag_id",
"queries_note"."negate"
FROM "queries_note"
-WHERE NOT ("queries_note"."id" IN
- (SELECT U1."note_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation_notes" U1
- WHERE U1."annotation_id" IN (%s,
- %s)))
+ WHERE (U1."annotation_id" IN (%s, %s)
+ AND U1."note_id" = "queries_note"."id")
+ LIMIT 1))
ORDER BY "queries_note"."note" ASC
SELECT "queries_note"."id",
"queries_note"."note",
@@ -44,10 +45,11 @@
"queries_note"."negate"
FROM "queries_note"
LEFT OUTER JOIN "queries_annotation_notes" ON ("queries_note"."id" = "queries_annotation_notes"."note_id")
-WHERE (NOT ("queries_note"."id" IN
- (SELECT U1."note_id"
+WHERE (NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_annotation_notes" U1
- WHERE U1."annotation_id" IN (%s,
- %s)))
+ WHERE (U1."annotation_id" IN (%s, %s)
+ AND U1."note_id" = "queries_note"."id")
+ LIMIT 1))
OR "queries_annotation_notes"."annotation_id" IN (%s))
ORDER BY "queries_note"."note" ASC
--- test_ticket_20788 (queries.tests.Ticket20788Tests):sqlite:556fa4bbba
+++ test_ticket_20788 (queries.tests.Ticket20788Tests):sqlite:bbf141bcdc
@@ -31,7 +31,9 @@
"queries_book"."chapter_id"
FROM "queries_book"
INNER JOIN "queries_chapter" ON ("queries_book"."chapter_id" = "queries_chapter"."id")
-WHERE NOT ("queries_chapter"."paragraph_id" IN
- (SELECT U3."paragraph_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_paragraph_page" U3
- WHERE U3."page_id" = %s))
+ WHERE (U3."page_id" = %s
+ AND U3."paragraph_id" = "queries_chapter"."paragraph_id")
+ LIMIT 1))
--- test_ticket_22429 (queries.tests.Ticket22429Tests):sqlite:556fa4bbba
+++ test_ticket_22429 (queries.tests.Ticket22429Tests):sqlite:bbf141bcdc
@@ -19,8 +19,10 @@
SELECT "queries_student"."id",
"queries_student"."school_id"
FROM "queries_student"
-WHERE NOT ("queries_student"."id" IN
- (SELECT U1."student_id"
+WHERE NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_classroom_students" U1
INNER JOIN "queries_classroom" U2 ON (U1."classroom_id" = U2."id")
- WHERE U2."school_id" = "queries_student"."school_id"))
+ WHERE (U2."school_id" = "queries_student"."school_id"
+ AND U1."student_id" = "queries_student"."id")
+ LIMIT 1))
--- test_ticket_23605 (queries.tests.Ticket23605Tests):sqlite:556fa4bbba
+++ test_ticket_23605 (queries.tests.Ticket23605Tests):sqlite:bbf141bcdc
@@ -25,8 +25,8 @@
INNER JOIN "queries_ticket23605b" W4 ON (W0."ticket23605aparent_ptr_id" = W4."modela_fk_id")
WHERE (W1."field_b0" >= (%s / W2."field_c0")
AND W1."field_b1"
- AND NOT (W0."ticket23605aparent_ptr_id" IN
- (SELECT V1."modela_fk_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_ticket23605b" V1
WHERE (V1."id" IN
(SELECT U0."id"
@@ -35,7 +35,9 @@
WHERE NOT (U0."field_b1"
AND U0."field_b0" >= (%s / U1."field_c0")
AND U0."field_b0" IS NOT NULL))
- AND V1."id" = W1."id")))
+ AND V1."id" = W1."id"
+ AND W1."modela_fk_id" = W0."ticket23605aparent_ptr_id")
+ LIMIT 1))
AND W4."field_b1"))
SELECT "queries_ticket23605aparent"."id",
"queries_ticket23605a"."ticket23605aparent_ptr_id"
@@ -49,8 +51,8 @@
INNER JOIN "queries_ticket23605b" W4 ON (W0."ticket23605aparent_ptr_id" = W4."modela_fk_id")
WHERE (W1."field_b0" >= (%s / W2."field_c0")
AND W1."field_b1"
- AND NOT (W0."ticket23605aparent_ptr_id" IN
- (SELECT V1."modela_fk_id"
+ AND NOT (EXISTS
+ (SELECT (1) AS "a"
FROM "queries_ticket23605b" V1
WHERE (V1."id" IN
(SELECT U0."id"
@@ -59,5 +61,7 @@
WHERE NOT (U0."field_b1"
AND U0."field_b0" >= (%s / U1."field_c0")
AND U0."field_b0" IS NOT NULL))
- AND V1."id" = W1."id")))
+ AND V1."id" = W1."id"
+ AND W1."modela_fk_id" = W0."ticket23605aparent_ptr_id")
+ LIMIT 1))
AND W4."field_b1")))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment