Bug 725036 - Rows with null values should appear at the end of tables when sorting by column [RFE]
Summary: Rows with null values should appear at the end of tables when sorting by colu...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat Enterprise MRG
Classification: Red Hat
Component: cumin
Version: 2.0
Hardware: Unspecified
OS: Unspecified
low
medium
Target Milestone: ---
: ---
Assignee: grid-maint-list
QA Contact: MRG Quality Engineering
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-07-22 16:00 UTC by Trevor McKay
Modified: 2016-05-26 20:17 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-05-26 20:17:39 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Trevor McKay 2011-07-22 16:00:38 UTC
Description of problem:

Some data comes through to cumin with null column values.  For certain tables is an error, but for others it is not.  When sorting tables by columns with null data, it would be nice if the rows with nulls sorted at the end of table.

Version-Release number of selected component (if applicable):

2.0

How reproducible:

100%

Steps to Reproduce:
1. Looking under messaging is a good place to find nulls (queues, exchanges)
2. Sort in descending order by a column with nulls.
  
Actual results:

Nulls will be on top.

Expected results:

It would be nice to have nulls at the end, whether sorting ascending or descending.

Additional info:

This can be done easily in newer versions of Postgres, but in 8.1 it's difficult.  We need semi-elaborate schemes using multiple queries, or hidden columns, or defined semantics for replacing nulls with zeroes, etc.

Comment 2 Stanislav Graf 2013-11-13 10:42:56 UTC
Cumin references:
https://fedorahosted.org/grid/wiki/Cumin
https://fedorahosted.org/grid/wiki/CuminAndPersonalCondor
http://tmckayus.github.io/blog/2012/09/24/new-post/

We are interested in:
1] propose patch that fixes the issue
2] propose testing scenario down to individual steps
3] automate testing scenario (from 2]) using your prefered language (optional)

In case you struggle you can:
- ask here in Bugzilla using comment field
- join IRC channels #distcomp and ##cumin on http://freenode.net/
- ask on mailing list (https://fedorahosted.org/grid/wiki/Cumin#OtherUsefulLinks)

Comment 3 Anne-Louise Tangring 2016-05-26 20:17:39 UTC
MRG-Grid is in maintenance and only customer escalations will be considered. This issue can be reopened if a customer escalation associated with it occurs.


Note You need to log in before you can comment on or make changes to this bug.