Project

General

Custom queries

Profile

Actions
Copy link

Patch #25066

open

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

Added by Andrey Lobanov (RedSoft) about 8 years ago. Updated over 7 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

Download all files
Added_null_placement_at_order_statement.patch (9.56 KB) Added_null_placement_at_order_statement.patch Andrey Lobanov (RedSoft), 2017-02-14 13:05
Added_null_placement_at_order_statement_v2.patch (36.8 KB) Added_null_placement_at_order_statement_v2.patch Andrey Lobanov (RedSoft), 2017-02-21 13:34
Null_placement_tests.patch (4.42 KB) Null_placement_tests.patch Andrey Lobanov (RedSoft), 2017-02-21 13:34

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
#4

Updated by Go MAEDA about 8 years ago

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

Updated by Andrey Lobanov (RedSoft) about 8 years ago

#8

Updated by Marius BĂLTEANU over 5 years ago

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

Also available in: Atom PDF