Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Updates: Status: ThirdParty Comment #9 on issue 1632 by trowb...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 This is actually a problem in sqlite. MySQL and other databases work fine. -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #8 on issue 1632 by jira.s...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 This seems to be database related (the order_by() function in django can order by a list of fields from a table, but there is no way to ignore case (adding lower() around the sort items makes them invalid fields as far as order_by is concerned), so if the database being used is case-sensitive then this defect will occur. I think this would either require a sort after retrieving the entire list from the database, or changing the table structure to have a lower-case column for anything that you want to ignore case (which seems hacky). -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #7 on issue 1632 by jira.s...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 I was able to reproduce this defect: Using SQLite database (not MySQL) Steps: 1. make some new users: Ter ter Hello hello 2. have each user create a review request 3. go to view all reviews 4. click the sort by submitter button 5. should end up with the order: Hello Ter hello ter instead of: Hello hello Ter ter -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #6 on issue 1632 by mstrie...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 This looks like a database issue. Running: SELECT u.username FROM reviews_reviewrequest r INNER JOIN auth_user u ON r.submitter_id = u.id ORDER BY u.username; MySQL: alex mark Nathan SQLite3: Nathan alex mark -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #5 on issue 1632 by jira.s...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 I was able to reproduce this defect: Steps: 1. make some new users: Ter ter Hello hello 2. have each user create a review request 3. go to view all reviews 4. click the sort by submitter button 5. should end up with the order: Hello Ter hello ter instead of: Hello hello Ter ter -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #4 on issue 1632 by dorothy@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 I fail to reproduce it on 1.6 alpha 0... It looks fine even if it is related to Alphabetial sorting. It turns out now as the following:"...alfaomega,anirudaha,asaasa,Ashwani,at3r." I guess this problem has already been fixed. -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-issues@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Comment #3 on issue 1632 by fre...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 I'm curse I did not have this problem at version 0.9... Possibly it depends the Database you are using,like when doing "select ... order by ". (I'm MySQL) If DB is case-sensitive then RB is case-sensitive. Also I'm afraid this is a "issue" to djblets/django after dig their source code. -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-iss...@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Updates: Labels: Component-Dashboard Comment #2 on issue 1632 by trowbrds: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 (No comment was entered for this change.) -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-iss...@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Re: Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Updates: Status: Confirmed Labels: EasyFix Usability Comment #1 on issue 1632 by chipx86: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 Hopefully an easy fix. -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-iss...@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
Issue 1632 in reviewboard: Alphabetial sorting of review requests should not be case sensitive
Status: New Owner: Labels: Type-Defect Priority-Medium New issue 1632 by yodan.ta...@gmail.com: Alphabetial sorting of review requests should not be case sensitive http://code.google.com/p/reviewboard/issues/detail?id=1632 *NOTE: Do not post confidential information in this bug report.* What version are you running? 1.0.6 What's the URL of the page containing the problem? It's on the intranet, so it probably won't help much. http://[review-board-host]/reviews/r/?page=4&sort=submitter What steps will reproduce the problem? 1. Go to a list of review requests, e.g. "All review requests" 2. Sort the list by the submitter name (click on "Submitter" title) What is the expected output? What do you see instead? I can see the requests sorted by the submitter names in this order (note the capitalization): "Alexey, Jenia, Lev, alex, boris, dan..." They should obviously be sorted this way: "alex, Alexey, boris, dan, Jenia, Lev..." What operating system are you using? What browser? Client: Firefox 3.6.3 on Windows XP 64bit Server: Apache/2.2.12 (Ubuntu) Server -- You received this message because you are listed in the owner or CC fields of this issue, or because you starred this issue. You may adjust your issue notification preferences at: http://code.google.com/hosting/settings -- You received this message because you are subscribed to the Google Groups "reviewboard-issues" group. To post to this group, send email to reviewboard-iss...@googlegroups.com. To unsubscribe from this group, send email to reviewboard-issues+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
