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
Fix a typo inside an assert() statement introduced by the previous commit.
2018-07-05
Dan Kennedy
Fix a typ
o
inside an assert() statement introduced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan
K
ennedy
In
wal mode, if a
"
BEGIN EXC
L
USIVE" command (o
r
a
ny
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kennedy
Test that a race condi
t
ion can cause a "BEGIN
EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
a
n Kenned
y
Fix a pr
o
ble
m
in the xInverse
c
al
l
bac
k
for
t
he
b
uilt
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
F
ix a s
e
g
fault caused by having identical window function
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
an Kennedy
Fix a crash caused by a LIKE pattern that c
o
nsis
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
K
e
nnedy
Fix a segf
a
ult c
a
used
by
i
nvoking
a
r
egu
l
ar
a
ggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
an Ken
n
e
dy
Avoid a warning in fts5
.
c du
e
to not using generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge implementatio
n
o
f
SQ
L
window functions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
Fix a minor pr
o
blem in
t
h
e code for
determ
i
ning whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n Kenned
y
Merge
all
changes from the weak-fallback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have t
h
e tok
e
nizer handle fallback
for
tokens "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenned
y
F
u
rther perf
o
rman
c
e
related twe
a
ks
fo
r
sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ke
n
nedy
Further tweaks to
sqli
t
e3
R
u
n
Parser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ken
n
ed
y
Improve on the pre
v
i
o
u
s checkin
.
Still a
bit slo
w
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
nnedy
Instead of using a
lemon
%fallback direct
i
ve, ha
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan K
e
nned
y
Modific
a
t
i
on
s
t
o
pars
e
.
y to better support backw
a
rds
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan
Kenne
d
y
Add missing VdbeCovera
g
e() an
d
Vdbe
C
overageNe
v
erTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Avoid red
u
n
dant ORDER B
Y
o
p
erati
o
ns w
h
en rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Kenne
d
y
Merge late
s
t trunk changes
.
commit
|
commitdiff
|
tree
2018-06-25
D
an Ken
n
edy
Add
d
ocumentation co
m
ment
fo
r
s
q
lite
3
_create_
w
in
d
ow
_
func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan K
e
n
n
e
dy
Fix another problem that co
u
ld cause a crash wh
e
n a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix problems wit
h
using window-f
u
nction
s
in correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kenn
e
dy
Fix a problem with using LIMIT in wind
o
w
-
function quer
i
es
.
commit
|
commitdiff
|
tree
2018-06-23
Da
n
K
ennedy
Fix a problem
w
ith
u
s
ing a w
i
ndow-func
t
ion
S
ELEC
T
as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Da
n
Kennedy
Omit all window-function
r
elated
c
od
e
w
hen building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n
K
e
n
nedy
Me
r
ge latest
trunk
c
hange
s
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a
p
r
oblem wi
t
h handling
s
ingle row partitions
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add tests to improve
coverage of c
o
de
i
n window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
a
n
K
enne
d
y
Merge
l
a
t
est trunk change
s
with th
i
s
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kenn
e
dy
Fix a pro
b
lem caused by a sub-query containing a windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
an Kennedy
Fix
a proble
m
with usin
g
min() or
max() as
a win
d
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Fix problems with using w
i
ndow functions in CRE
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add test
case
for
t
h
e fix
i
n the previous
c
ommit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
E
nsure
th
a
t a
l
l four
cal
l
backs are pro
v
ided wh
e
n reg
i
steri
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Add new API
f
un
c
tion s
q
lite3
_
c
r
ea
t
e_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
n
edy
Add e
x
tra OO
M
te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kenned
y
Fix another prob
l
em
i
n lead()/lag
(
)
.
An
d
some
errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix
a
bug in
t
he lead() and
l
ag(
)
window
f
unct
i
ons
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
i
x a prob
l
e
m
with
h
a
ndling of st
a
tements cont
a
ining
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
enned
y
Fix problem with window f
u
nctions
m
in() and max(
)
when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest tr
u
nk chang
e
s into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kenn
e
dy
Improve co
m
m
en
t
s a
n
d c
o
de legibilit
y
i
n
new
file window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an K
e
nne
d
y
Fix probl
e
ms
w
ith
"RAN
G
E BETWEEN CURRENT ROW AND UNB
O
U
N
DED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
e
nnedy
F
ix some test c
a
se numbers i
n
ex
p
e
r
t1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
ennedy
Unless SQLITE_OMI
T
_AUTOINIT i
s
d
e
fine
d
, allow
s
qlite3_
v
fs
_
un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kennedy
Ch
e
ck tha
t
mal
l
oc() has not already
f
ailed
w
hen in
v
oking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix anoth
e
r issu
e
to do wi
t
h
w
i
ndow-functions in aggrega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
Ke
n
nedy
Fix
s
ome problems wit
h
using window-
f
uncti
o
ns in aggre
g
a
te
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n Kenn
e
d
y
Clarify the relationship
b
etwe
e
n a
W
indow
o
bject an
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenne
d
y
Fix
h
andling o
f
w
indow
frames contain
i
ng
n
egative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix a typon i
n
main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
D
an Ken
n
edy
Update
Makefile
.
msc
to in
c
lude wi
n
dow
.
c i
n
th
e
bu
i
ld
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
M
erg
e
recent t
r
unk ch
a
nge
s
with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kenne
d
y
Update the amalgamat
i
on b
u
ild script to inc
l
ude wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan K
e
nnedy
A
d
d
s
u
p
port for FILTER
clause
o
n
aggregate window f
u
nctio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Ke
n
nedy
Add support for the WIND
O
W
clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do
n
ot
flatte
n
s
u
b-
q
u
e
ries t
h
at contain w
i
ndow func
t
ion
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan K
e
nnedy
Fixes
t
o
a
llow group_concat() to b
e
used as a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
M
erg
e
latest
t
run
k
chan
g
e
s with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
nedy
Add window functions lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
enne
d
y
A
dd support for win
d
ow function first
_
val
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
Fix proble
m
s
with t
h
e nth_v
a
lu
e
(
)
f
unc
t
ion
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
A
dd implementat
i
on of nth_value
(
) window function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenned
y
Calculate non-aggrega
t
e e
x
pressio
n
s in the SELE
C
T list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenne
d
y
Add implemen
t
a
tion of last_val
u
e() w
i
ndow
f
unction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenne
d
y
Add implementation of window fu
n
ction n
t
i
l
e
(
)
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Me
r
ge latest
tr
u
n
k
changes into this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ken
n
edy
Ad
d
support for window function cume_
d
ist()
.
I
mprove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
n
nedy
A
d
d supp
o
rt for window functions row_
n
umber(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
Kennedy
Updat
e
a test cas
e
in malloc5
.
te
s
t
t
o
take into
a
ccou
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n
Kennedy
Allow an
e
n
tire partition
t
o be c
a
ched in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kennedy
Fix a bug in the SQLITE_
E
NA
B
L
E
_
SORTER_RE
F
ERENCES
c
ode
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow
m
in()
a
n
d
m
a
x() to be use
d
as wi
n
dow fu
n
cti
o
ns
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
n
edy
Increas
e
the num
b
er of database handles
o
pened by te
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
n
edy
Fix autoinc
.
t
e
st
and resetdb
.
test so
that they wor
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kennedy
More min
o
r changes to te
s
t scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Ken
n
edy
Fix
s
o
me test
script issues cause
d
by recen
t
EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
D
o
not
r
un test file "resetd
b
.
test"
as pa
r
t
of
p
e
rmutatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Furt
h
er
window frame
te
s
ts and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
an
Kenne
d
y
D
o not require a statement
j
o
u
rnal in cases
whe
r
e RE
P
LA
C
E
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan
Ke
n
ne
d
y
More fix
e
s f
o
r diffe
r
e
nt window fram
e
t
ypes
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kennedy
F
i
x
"RANG
E
BETWEEN CURRE
N
T
RO
W
AND UNBOUNDED
F
OLLO
W
ING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
Kennedy
Merge latest trunk changes
into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
F
i
xes for
"R
O
W
S
BETWEEN <ex
p
r> FOLLO
W
ING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Kenn
e
dy
Allow "<ex
p
r> PRE
C
EDING"
to be
used
to s
p
e
c
ify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an
K
enn
e
d
y
Suppo
r
t other frame types th
a
t use "<ex
p
r> PR
E
CEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kenn
e
dy
Add suppor
t
for "ROWS BETWEEN <expr> P
R
E
CED
I
N
G
A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merge latest tru
n
k change
s
into this branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Add
c
omments to window
.
c
describing how other
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan
K
ennedy
Begin
ad
d
ing support for more esoteric window
frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix m
i
nor proble
m
s
on
this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evalua
t
e multiple windo
w
fu
n
ctions in a s
i
n
g
le pas
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Ke
n
nedy
Ha
n
dle
multi
p
le window-f
u
nctions in a single que
r
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Start
o
f
e
xp
e
rimental im
p
le
m
entation o
f
SQL wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kenne
d
y
F
ix a test case problem in where
l
imit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Ke
n
n
e
dy
Add a test case to
c
h
eck that the fts
5
unicode64 tokeniz
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
F
i
x a problem in
t
he
x
BestIndex method of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan
K
e
n
nedy
Fix an RBU pr
o
b
l
em
c
ausing spurious SQLITE_CONSTR
A
INT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Updat
e
t
est script fts3expr4
.
tes
t
s
o
that
i
t alway
s
.
.
.
commit
|
commitdiff
|
tree
next