Bug 1040999

Summary: [RFE][nova]: Run test_db_api on all backends (sqlite, mysql, postgresql)
Product: Red Hat OpenStack Reporter: RHOS Integration <rhos-integ>
Component: openstack-novaAssignee: RHOS Maint <rhos-maint>
Status: CLOSED UPSTREAM QA Contact: Ami Jeain <ajeain>
Severity: unspecified Docs Contact:
Priority: low    
Version: unspecifiedCC: hateya, markmc, ndipanov, sgordon, yeylon
Target Milestone: ---Keywords: FutureFeature, Reopened, Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://blueprints.launchpad.net/nova/+spec/db-api-tests-on-all-backends
Whiteboard: upstream_milestone_ongoing upstream_status_good-progress upstream_definition_review
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-04-15 14:54:16 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description RHOS Integration 2013-12-12 13:23:05 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/nova/+spec/db-api-tests-on-all-backends.

Description:

There is a lot of different things in SQl backends. For example work with casting.
In current SQLite we are able to store everything in column (with any type). Mysql will try to convert value to required type, and postgresql will raise IntegrityError. So to avoid such nasty errors on db.api layer we should runt test_db_api on all backends. 

Specification URL (additional information):

None