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
11437	[soc2009/multidb] M2M Relationship with through=[model] whose primary key is renamed fails with wrong column name	anonymous	nobody	"Deleting an object that is involved in a many to many relationship using an intermediary model whose primary key is renamed at the db level fails because the generated SELECT statement is wrong.

In the example below, clicking on 'Delete' of an 'AdSalesAccount' results in ""OperationalError: (1054, ""Unknown column 'ad_order_listing_bridge.id' in 'field list'"")""

{{{
Error occurs in django\db\models\sql\query.py in execute_sql on line 2370:

Traceback:
File ""C:\Python25\lib\site-packages\django\core\handlers\base.py"" in get_response
  87.                 response = middleware_method(request, callback, callback_args, callback_kwargs)
File ""build\bdist.win32\egg\firepython\middleware.py"" in process_view
  305.         return self._profile_wrap(callback)(*args, **callback_kwargs)
File ""C:\Python25\lib\site-packages\django\contrib\admin\sites.py"" in root
  480.                 return self.model_page(request, *url.split('/', 2))
File ""C:\Python25\lib\site-packages\django\views\decorators\cache.py"" in _wrapped_view_func
  44.         response = view_func(request, *args, **kwargs)
File ""C:\Python25\lib\site-packages\django\contrib\admin\sites.py"" in model_page
  499.         return admin_obj(request, rest_of_url)
File ""C:\Python25\lib\site-packages\django\contrib\admin\options.py"" in __call__
  1092.             return self.delete_view(request, unquote(url[:-7]))
File ""C:\Python25\lib\site-packages\django\contrib\admin\options.py"" in delete_view
  1009.         get_deleted_objects(deleted_objects, perms_needed, request.user, obj, opts, 1, self.admin_site)
File ""C:\Python25\lib\site-packages\django\contrib\admin\util.py"" in get_deleted_objects
  125.             for sub_obj in getattr(obj, rel_opts_name).all():
File ""C:\Python25\lib\site-packages\django\db\models\query.py"" in _result_iter
  110.                 self._fill_cache()
File ""C:\Python25\lib\site-packages\django\db\models\query.py"" in _fill_cache
  707.                     self._result_cache.append(self._iter.next())
File ""C:\Python25\lib\site-packages\django\db\models\query.py"" in iterator
  242.         for row in self.query.results_iter():
File ""C:\Python25\lib\site-packages\django\db\models\sql\query.py"" in results_iter
  287.         for rows in self.execute_sql(MULTI):
File ""C:\Python25\lib\site-packages\django\db\models\sql\query.py"" in execute_sql
  2370.         cursor.execute(sql, params)
}}}
The reason is invalid SQL is generated here:
{{{
sql = u'SELECT `ad_order_listing_bridge`.`id`, #####Should be ad_orderId
`ad_order_listing_bridge`.`ad_order_listing_bridgeId`, `ad_order_listing_bridge`.`ad_orderId`, `ad_order_listing_bridge`.`listingId` FROM `ad_order_listing_bridge` WHERE `ad_order_listing_bridge`.`ad_orderId` = %s '}}}

{{{
#!python
AdSalesModel = models.Model
class AdSalesAccount(AdSalesModel):
    id = models.AutoField(primary_key=True, db_column='accountId')
    class Meta:
        db_table = u'account'
        ordering = ('-date_created', 'name')
        using = 'adsales'

class AdSalesAdOrder(models.Model):
    id = models.AutoField(primary_key=True, db_column='ad_orderId')
    account = models.ForeignKey(AdSalesAccount, db_column='accountId')
    listings = models.ManyToManyField('AdSalesListing', through='AdSalesAdOrderListingBridge')
    class Meta:
        db_table = u'ad_order'
        ordering = ('-date_created', )
        using = 'adsales'

class AdSalesAdOrderListingBridge(models.Model):
    id = models.IntegerField(db_column='ad_order_listing_bridgeId')
    adorder = models.ForeignKey(AdSalesAdOrder, db_column='ad_orderId')
    listing = models.ForeignKey('AdSalesListing', db_column='listingId')
    class Meta:
        using = 'adsales'
        db_table = u'ad_order_listing_bridge'

class AdSalesListing(AdSalesModel):
    id = models.AutoField(primary_key=True, db_column='listingId')
    class Meta:
        db_table = u'listing'
        ordering = (""-date_created"", ""descriptive_line"")
        using = 'adsales'
}}}"		closed	Database layer (models, ORM)	soc2009/multidb		invalid	multidb manytomany db_column		Unreviewed	0	0	0	0	0	0