diff options
| author | dan <dan@noemail.net> | 2018-06-21 19:20:39 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2018-06-21 19:20:39 +0000 |
| commit | b7306f6f6e56d2d957d29db6f35ec5efc3ddc983 (patch) | |
| tree | 5632498d98505501e077c2e0244ce32ba68a0619 /src/window.c | |
| parent | 9c27758eb4c45d9592f2dab9670726e002b460ba (diff) | |
| download | sqlite-b7306f6f6e56d2d957d29db6f35ec5efc3ddc983.tar.gz sqlite-b7306f6f6e56d2d957d29db6f35ec5efc3ddc983.zip | |
Fix a problem with handling single row partitions in the percent_rank() window
function.
FossilOrigin-Name: b84fbf16eac718c151731e2b2dcc73f2f2a144e3670f8566a30793f1e4e6a3ec
Diffstat (limited to 'src/window.c')
| -rw-r--r-- | src/window.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/window.c b/src/window.c index c025e5ab2..42a7e6ace 100644 --- a/src/window.c +++ b/src/window.c @@ -279,7 +279,7 @@ static void percent_rankValueFunc(sqlite3_context *pCtx){ double r = (double)(p->nValue-1) / (double)(p->nTotal-1); sqlite3_result_double(pCtx, r); }else{ - sqlite3_result_double(pCtx, 100.0); + sqlite3_result_double(pCtx, 0.0); } p->nValue = 0; } |