id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 20300,"Django 1.5.1, update sql trouble",hjcnbckfd@…,nobody,"Django 1.5.1 {{{ Comment.objects.filter(post_id__in=[1,2,3]).exclude(post_id__in=[4,5]) \ .update(is_published=True) }}} Такой queryset дает для PostgeSQL запрос вида: {{{ UPDATE ""message_comment"" SET ""is_published"" = true WHERE ""message_comment"".""post_id"" IN (1, 2, 3) }}} Для MySQL же выдается: {{{ UPDATE `message_comment` SET `is_published` = 1 WHERE `message_comment`.`post_id` IN (SELECT U0.`post_id` FROM `message_comment` U0 WHERE U0.`post_id` IN (1, 2, 3)); args=(True, 1, 2, 3) }}} Конечно же MySQL выдает ошибку ''''DatabaseError: (1093, ""You can't specify target table 'message_comment' for update in FROM clause"")''''",Bug,closed,"Database layer (models, ORM)",1.5,Normal,worksforme,"update, orm, mysql, postgresql",,Unreviewed,0,0,0,0,0,0