Context Navigation

Changes between Initial Version and Version 1 of Ticket #26539, comment 5

-              initial
+              v1
 SQLLite and Mysql both passes the test. The queries generated are different(sqllite has SUBSELECT) but the result of the subselect is same as MYSQL.
 Here are the 2 queries thats generated. In MYSQL the select statement is generated first and then the results are applied to the update but in sqllite is select statement is applied directly as a subselect.
+Here are the 2 queries thats generated. In MYSQL the select statement is generated first and then the results are applied to the update but in sqllite the select statement is applied directly as a subselect. Not sure what is expected in this ticket?
 MYSQL results:-
+{{{
 >>> Foo.objects.annotate(bname=F('related_bar__name')).update(bar_name=F('bar_name'))
 SELECT `polls_foo`.`id`
 …
 WHERE `polls_foo`.`id` IN (6,7)
+}}}
 SQLLite:-
+{{{
 >>> Foo.objects.annotate(bname=F('related_bar__name'))
 SELECT "polls_foo"."id",
 …
      INNER JOIN "polls_bar" U1 ON (U0."related_bar_id" = U1."id")) [0.29ms]
 #                            7) [0.22ms]
+}}}