DISTINCT ON queries
Bug #374777 reported by
Abel Deuring
This bug affects 3 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Storm |
Fix Released
|
Medium
|
William Grant | ||
Bug Description
It would be nice if Storm would support the generation of SQL queries containing a DISTINCT ON(column) clause
Related branches
lp:~wgrant/storm/distinct-on
- Thomas Herve (community): Approve
- Данило Шеган (community): Approve
-
Diff: 81 lines (+26/-10)4 files modifiedNEWS (+8/-6)
storm/expr.py (+5/-2)
storm/store.py (+3/-2)
tests/expr.py (+10/-0)
Revision history for this message
| Robert Collins (lifeless) wrote | #1 |
| Changed in storm: | |
| assignee: | nobody → William Grant (wgrant) |
| status: | New → In Progress |
| Changed in storm: | |
| importance: | Undecided → Medium |
| Changed in storm: | |
| status: | In Progress → Fix Committed |
| Changed in storm: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Can workaround with:
store.find(
(SQL("DISTINCT ON (Table.field) 0 AS ignore"), Table),
expr
expr)
using DecoratedResultSet