Project

General

Profile

Actions

Patch #25066

open

Sort order with null placement (NULLS FIRST, NULLS LAST)

Added by Andrey Lobanov (RedSoft) about 7 years ago. Updated over 6 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues filter
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Added ability to sort with null placement. Sometimes it's very useful.
Tested on sqlite3, mysql, firebird, postgres.


Files


Related issues

Related to Redmine - Feature #6034: sorting should disregard blank fieldsNew2010-08-04

Actions
Related to Redmine - Defect #32404: Group results is different between MySQL and PostgreSQLNew

Actions
Actions #1

Updated by Mischa The Evil about 7 years ago

I find this interesting, but I don't know if this is something that is (going to be) widely used (thus not being something that might fit the core). At least, I haven't seen requests for this before. Could you maybe provide some use-case(s) describing where and how this could be used and to what purposes? And could you please provide some tests for this feature?

Actions #2

Updated by Andrey Lobanov (RedSoft) about 7 years ago

I'll certianly add some tests a bit later.
So in my company projects some fields can be null, and default sort order on this fields will put not null values at the end, and null values at the top. So this feature allows you to put null values in wanted place.

Actions #4

Updated by Go MAEDA about 7 years ago

  • Related to Feature #6034: sorting should disregard blank fields added
Actions #5

Updated by Andrey Lobanov (RedSoft) about 7 years ago

Here 2 new tests and few old tests fixed.
Also small fix, to complete tests (attachment also contains full patch with bug fixes).

Actions #6

Updated by Andrey Lobanov (RedSoft) almost 7 years ago

Would someone review this feature?

Actions #7

Updated by Vito Marolda over 6 years ago

Hello thank you very much for your job!
I am interested in your patch, and I would like to test it.
All patches must be applied? Or only v2 and test?

Actions #8

Updated by Marius BÄ‚LTEANU over 4 years ago

  • Related to Defect #32404: Group results is different between MySQL and PostgreSQL added
Actions

Also available in: Atom PDF