Opened 5 years ago

Closed 5 years ago

#30860 closed Cleanup/optimization (fixed)

Skip OrderBy.as_sqlite on SQLite >= 3.30

Reported by: Simon Charette Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

From ​https://www.sqlite.org/changes.html#version_3_30_0

Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.

Even if CI is not on SQLite 3.30 it can be tested locally on Linux using LD_PRELOAD ​https://github.com/orf/django-docker-box/issues/25

Change History (3)

comment:1 by Simon Charette, 5 years ago

Has patch: set

comment:2 by Carlton Gibson, 5 years ago

Triage Stage: Unreviewed → Accepted

Super. Yes. Thanks.

comment:3 by Mariusz Felisiak <felisiak.mariusz@…>, 5 years ago

Resolution: → fixed
Status: new → closed

In 8b103578:

Fixed #30860 -- Disabled unneeded NULLS FIRST/LAST workaround on SQLite 3.30+.

Note: See TracTickets for help on using tickets.
Back to Top