Glance image-list returns different results for MySQL and PostgreSQL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Glance |
Incomplete
|
Undecided
|
Unassigned |
Bug Description
Glance image-list is returning different results for MySQL and PostgreSQL with sort_key=name
Steps to reproduce:
1. Assume images with following names are present in database
'image-
'Fedora-
'cirros-
'cirros-
'cirros-
2.
a. For MySQL :
List Images with sort_key = name
$ glance image-list --sort-key=name --sort-dir=desc
Output:
+------
| ID | Name | Disk Format | Container Format | Size | Status |
+------
| 662998c2-
| d067e2bd-
| 61ebb7f7-
| 87f3642c-
| e6aeba3c-
-------
Here ,'Fedora-
b. For PostgreSQL :
List Images with sort_key = name
$ glance image-list --sort-key=name --sort-dir=desc
Output:
+------
| ID | Name | Disk Format | Container Format | Size | Status |
+------
| 662998c2-
| e6aeba3c-
| d067e2bd-
| 61ebb7f7-
| 87f3642c-
-------
Here 'Fedora-
Note :
I am adding a new test case in glance tempest to 'list image with sort_key'
Blueprint: testcases-
But after submitting the patch to the community, Jenkins is continuously failing with mismatch error for Test: check-tempest-
Please refer:
http://
Locally this test case is getting passed where i am using MySQL Database.
Changed in glance: | |
assignee: | nobody → Ukesh (ukeshkumar) |
Changed in glance: | |
assignee: | Ukesh (ukeshkumar) → nobody |
Notes gathered in research www.postgresql. org/docs/ current/ static/ citext. html dev.mysql. com/doc/ refman/ 5.6/en/ identifier- case-sensitivit y.html
- http://
- http://
PostgreSQL uses system collation, which in this case will provide POSIX behavior which is explains the behavior noted.