"Launch instance" dialog has "Error: Unable to retrieve list of volumes." with postgres db as backend

[Thomas Bechtold]

When using postgres, searching for volumes with "bootable=1" doesn't work.
The error is from the cinder-api log is:

 u'cd20675e9d0748c7a742827dc4d67840', 'bootable_1': 1, 'status_1': u'available'}
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters context)
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: operator does not exist: boolean = integer
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters ^
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters
2015-05-20 17:23:56.162 12837 ERROR cinder.api.middleware.fault [req-2c01592d-7555-4766-9876-2c2f5b99ca85 2e0ec0a31b724dc2bcd6e2f9863ed252 cd20675e9d0748c7a742827dc4d67840 - - -] Caught error: (ProgrammingError) operator does not exist: boolean = integer
LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...

I think this should be fixed in the cinder code so the search parameters are handled correctly, but as a workarround, search for 'true' does work.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Change abandoned by Thomas Bechtold (<email address hidden>) on branch: master
Review: https://review.openstack.org/184562
Reason: Duplicate of https://review.openstack.org/#/c/184471/