DB2 upgrade failure for 50d5ba354c23_ml2_binding_vif_details

[Xu Han Peng]

When upgrading Neutron with DB2, the following error will be seen at step 50d5ba354c23_ml2_binding_vif_details

sqlalchemy.exc.ProgrammingError: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXPPC64] SQL0401N The data types of the operands for the operation "=" are not compatible or comparable. SQLSTATE=42818 SQLCODE=-401 'UPDATE ml2_port_bindings SET vif_details = \'{"port_filter": true}\' WHERE cap_port_filter = true' ()

The reason is DB2 doesn't support Boolean type but uses small int

[Openstack Gerrit (openstack-gerrit)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/89990
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=7c221c157bf8e933f469e74c2812fc361e65c56b
Submitter: Jenkins
Branch: master

commit 7c221c157bf8e933f469e74c2812fc361e65c56b
Author: Xuhan Peng <email address hidden>
Date: Thu Apr 24 10:58:32 2014 +0800

    Upgrade failure for DB2 at ml2_binding_vif_details

    50d5ba354c23_ml2_binding_vif_details fails during upgrade
    when DB2 is used as the DB backend of neutron because
    Boolean type is not supported by DB2.

    This fix uses "1" instead of "true" in sql when db2 is engine.
    This fix also changes context creation to op.execute.

    Change-Id: I82d2141007894342c634f2c5e62344e20d876d8f
    Closes-Bug: 1311589