Ran
|
Jobs
2
|
Files
0
|
Run time
1s
|
Badge
Embed ▾
README BADGES
|
push
circle-ci
feat: add support for enabling ORDER BY on non projected columns (#1155) In response to PR #1147, we've introduced support for the use of ORDER BY on non-projected columns ``` SELECT name FROM meme_images ORDER BY Similarity(SiftFeatureExtractor(Open("{}")), SiftFeatureExtractor(data)) LIMIT 1; SELECT FaceDetector(data) FROM MyVideo WHERE id < 5 order by scores; SELECT AirForecast(12) order by y; Select name FROM meme_images ORDER BY name; ``` The following query won't work. `Select name AS n FROM meme_images ORDER BY n;` Currently, we execute projection as the last operation. Only when a function expression is present it is executed before projection, allowing its use in ORDER BY. A complete fix will require us to redesign the binder. Right now, we've decided to defer this task because there is no urgency to support it. Ref: https://github.com/duckdb/duckdb/blob/52a47a6b3/src/planner/expression_binder/order_binder.cpp#L68
0 of 0 relevant lines covered (NaN%)
0.0 hits per line
ID | Job ID | Ran | Files | Coverage | |
---|---|---|---|---|---|
1 | e8fb74be-5068-4821-b8e1-1faf90dbfe02.1 | 0 |
0.0 |
||
2 | e8fb74be-5068-4821-b8e1-1faf90dbfe02.2 | 0 |
0.0 |
Coverage | ∆ | File | Lines | Relevant | Covered | Missed | Hits/Line |
---|