Migration 031_remove_duplicated_locations.py fails with DB2

[Ma Wen Cheng]

glance-manage db_sync

2014-03-03 03:09:03.899 18584 CRITICAL glance [-] ProgrammingError: (ProgrammingError) ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "AND" was found following ".meta_data) AND true". Expected tokens may include: "<interval_qualifier>". SQLSTATE=42601 SQLCODE=-104 'SELECT image_locations_1.id \nFROM image_locations AS image_locations_1 \nWHERE image_locations_1.id > (SELECT min(image_locations.id) AS min_1 \nFROM image_locations \nWHERE image_locations.image_id = image_locations_1.image_id AND image_locations."value" = image_locations_1."value" AND image_locations.meta_data = image_locations_1.meta_data) AND true AND image_locations_1.deleted = ?' ('0',)

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/77546

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/77546
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=e687098cf14e7e83e2c7c4252c895324e6735e24
Submitter: Jenkins
Branch: master

commit e687098cf14e7e83e2c7c4252c895324e6735e24
Author: Wen Cheng Ma <email address hidden>
Date: Mon Mar 3 17:49:15 2014 +0800

    Fix glance db migration failed on 031

    In fact, the first where expression has filtered the duplicated locations,
    and the second filters the locations which have more than 1 rows, so the
    second result set is included in the first.
    In DB2, if the boolean of where expression is true, it will throw error.
    So remove the second where expression to fix glance db migration failed on 031.

    Fixes bug #1287087

    Change-Id: Id485b6d20696e989d10f3759011387137543918a