repo.or.cz
/
sqlite.git
/
search
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
first
·
prev
·
next
Return an error if DISTINCT is used with a window-function (e.g.
2018-07-06
Dan Kennedy
Ret
u
rn
an err
o
r if DIST
I
NCT
is use
d
w
ith a w
i
ndow
-
function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
Kennedy
Up
d
ate the r
e
cipe f
o
r resetting a database usi
n
g
commit
|
commitdiff
|
tree
2018-07-05
Dan Ke
n
ne
d
y
Return an
error i
f
a "RANGE" window-frame uses "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Ken
n
e
d
y
Fix a pro
b
lem
i
n the xI
n
verse method of window-f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenned
y
I
n wal mode,
i
f a "BEGIN EXCLUSIVE" command
(
or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Fix a typo
i
nside an assert() sta
t
ement introd
u
c
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
I
n
wal mode, if a "B
E
GIN EXCLUSIVE" command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan
K
e
n
nedy
Test that a race condition can
cause a "BEGIN EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
an Kenn
e
dy
F
i
x
a problem in t
h
e xInv
e
rse callback for
the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
a
n K
e
n
n
e
dy
Fix a segfault
caused
b
y having identica
l
window fu
n
ctions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
K
ennedy
Fi
x
a crash caused
by a LIKE pat
t
ern that
cons
i
sts
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
F
i
x a segfault c
a
used by invoki
n
g a regular aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n
Kenned
y
Avo
i
d a war
n
ing in fts5
.
c du
e
to not using generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
enn
e
dy
Merge im
p
lementa
t
ion of SQL wi
n
d
ow fun
c
t
io
n
s from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Fix a mino
r
problem in the code for d
e
termining whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n Kennedy
Me
r
ge all changes from the
w
eak
-
fallback
branch exc
e
pt
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
edy
Have th
e
tokenizer hand
l
e fa
l
lb
a
ck for
t
okens "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kenned
y
Further performa
n
ce
r
elated t
w
eak
s
f
o
r sqlite3RunParser
(
)
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ke
n
nedy
Furt
h
e
r t
w
eaks
t
o sqlite3
R
un
P
arser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
nnedy
I
mp
r
ove
o
n the prev
i
ous
che
c
kin
.
St
i
l
l
a bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Instea
d
of using a lemon
%
fa
l
lback directive, hav
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kenned
y
M
o
dific
a
tion
s
t
o
p
a
rse
.
y to better support backwa
r
ds
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
an Kennedy
Add missing V
d
beCovera
g
e()
and VdbeCo
v
erageNe
v
erTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kenned
y
Avoid redundant ORDER BY
oper
a
tion
s
when rewri
t
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan K
e
nn
e
dy
Merg
e
latest trunk ch
a
nges
.
commit
|
commitdiff
|
tree
2018-06-25
D
an Kenn
e
dy
Add docu
m
e
n
ta
t
i
o
n comment for sqlite3_cr
e
ate_wi
n
dow_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan K
e
n
nedy
Fix a
n
other problem
t
hat c
o
u
l
d cause a crash when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan K
e
nnedy
Fix problems wi
t
h
using window-functions
i
n correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Da
n
K
ennedy
Fix a probl
e
m with using
L
IMIT in window-function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan
Kennedy
Fix a problem wit
h
u
sing a
w
ind
o
w-function SELECT a
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit all windo
w
-funct
i
o
n relat
e
d
c
od
e
when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Merge latest trunk chang
e
s
.
commit
|
commitdiff
|
tree
2018-06-21
D
an Kennedy
Fix a problem wit
h
handling sing
l
e row partitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan K
e
nned
y
Add te
s
ts to improve co
v
erage of code in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan K
e
nne
d
y
Merge
lates
t
trun
k
changes with this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
ennedy
Fi
x
a problem caus
e
d
b
y a sub-query containing a win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a pro
b
lem w
i
th using min
(
) or
max()
a
s a wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix
problems
w
ith usi
n
g wind
o
w functions in CRE
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
edy
Add test c
a
s
e for th
e
f
ix
i
n the prev
i
ous
c
ommit
.
commit
|
commitdiff
|
tree
2018-06-18
D
an Kennedy
Ensure that all
fo
u
r
c
allbacks are provided when register
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
an Kennedy
A
dd new AP
I
f
unction sql
i
t
e
3_create_wind
o
w_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
ned
y
Add extra
OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Kennedy
Fix
a
n
oth
e
r pro
b
le
m
in
l
ea
d
(
)/lag()
.
And
so
m
e errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n K
e
nnedy
F
ix a bug in the lead() and lag
(
)
w
i
ndow
f
u
n
ctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kennedy
Fix
a pro
b
lem wi
t
h handling o
f
st
a
tements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix proble
m
with window
f
un
c
t
i
ons min() and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest trunk chan
g
e
s into this branc
h
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Imp
r
o
v
e comments a
n
d code
legibility in ne
w
fil
e
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
e
n
nedy
Fix problems with "RAN
G
E BETWEEN CURRE
N
T ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Fix so
m
e t
e
st case numb
e
rs
i
n exper
t
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Un
l
ess SQ
L
ITE_O
M
IT_AUTOINIT is define
d
,
allow
s
qlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Ken
n
edy
Check
that ma
l
loc() has n
o
t already failed when i
n
voking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
ennedy
Fix another issue to
d
o wi
t
h window-functions in aggreg
a
te
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
Kennedy
Fix
some
problems
wit
h
us
i
ng window-functi
o
ns in aggr
e
gate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
ennedy
C
la
r
if
y
th
e
relationship between a
W
indow object
and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
e
n
nedy
Fix han
d
ling of
window frames containing n
e
gative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenn
e
d
y
F
i
x a typon in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Update M
a
kefile
.
msc
to
include
w
indow
.
c
in the buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
D
an
K
e
nnedy
M
erge re
c
ent tr
u
nk changes
with
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kennedy
U
p
d
ate the amalgamation buil
d
s
c
ri
p
t to include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n Kennedy
Add support for F
I
L
TER clause on aggrega
t
e
wind
o
w fu
n
ctions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kennedy
Add support fo
r
the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n K
e
nn
e
dy
D
o
not flatten sub-queries
t
hat contain wi
n
dow functions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kennedy
Fix
e
s t
o
allow group_concat() to
b
e
u
s
ed as a wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n K
e
nnedy
Merge lat
e
st
t
runk c
h
a
n
ges with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Da
n
Kenned
y
Add window fun
c
tions lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
Add suppor
t
fo
r
window
function first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenne
d
y
Fi
x
prob
l
ems with the
n
t
h_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan
Kennedy
Add i
m
plementation of nth_value() windo
w
function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
C
a
lc
u
late non-a
g
greg
a
t
e
ex
p
ressions in the
S
E
LECT l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Ken
n
e
dy
Add imple
m
entation
of la
s
t_value() window funct
i
o
n
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Ad
d
imp
l
ement
a
tion of window
f
u
n
ction ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenn
e
dy
Merge l
a
test tru
n
k c
h
an
g
es int
o
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add s
u
pp
o
rt f
o
r wi
n
do
w
function cume_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Add support for window
f
un
c
tions row_number(), r
a
nk
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Updat
e
a
test case i
n
mal
l
oc5
.
test t
o
take
i
nto a
c
count
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allow
a
n entire partition to be cached in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Fix
a
bug in t
h
e SQLITE_ENA
B
L
E_SORTER_REFERENCE
S
co
d
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Al
l
ow min()
a
nd max() to be used as window function
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase the n
u
mber of database handles opene
d
by t
e
st
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Kenne
d
y
Fix autoi
n
c
.
test and resetdb
.
test s
o
that
t
hey w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
nnedy
More m
i
nor changes to test s
c
ripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix some t
e
st scr
i
pt issues
c
a
us
e
d by
r
e
c
e
n
t
EXP
L
AIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
Do n
o
t
ru
n
t
e
s
t
fi
l
e "resetdb
.
test" as part of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Ke
n
nedy
Further
wind
o
w f
r
ame tes
t
s and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
Do not
re
q
uire a statement journal i
n
cases
where REP
L
ACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenned
y
More fi
x
e
s
f
o
r different
w
indow
f
rame typ
e
s
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix "RANGE BETWEEN
C
URREN
T
ROW AND UNBO
U
NDED FOLL
O
WING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenn
e
dy
Mer
g
e l
a
tes
t
trunk changes into
t
his branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
Kennedy
Fixes for "ROWS BET
W
EEN <expr
>
FOLLOWIN
G
AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
a
n K
e
nnedy
A
l
low "<expr> PR
E
CEDING"
t
o be
u
sed to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kenn
e
dy
Support other f
r
a
m
e types that use
"<
e
xp
r
>
PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Ken
n
edy
Add supp
o
rt for "ROWS
BE
T
WE
E
N <expr> PRE
C
E
D
ING
AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenn
e
dy
Merge late
s
t tru
n
k changes into thi
s
b
ranch
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n Kenne
d
y
Add comments to win
d
ow
.
c describing
h
ow other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
K
ennedy
B
egin adding support for more esoter
i
c windo
w
frame
s
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix minor problems
o
n
this bra
n
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Evalua
t
e mul
t
ip
l
e
win
d
ow f
u
nctio
n
s in a s
i
ngle pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan
K
ennedy
Handl
e
multipl
e
window
-
functions in a singl
e
q
u
ery
.
commit
|
commitdiff
|
tree
2018-05-16
D
an
K
ennedy
Start of experimental imp
l
em
e
ntation
o
f SQL wind
o
w
.
.
.
commit
|
commitdiff
|
tree
next