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
D
a
n
K
ennedy
Fix a typo
inside an
a
ssert()
s
t
at
e
m
e
nt i
n
troduced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenn
e
dy
In wal m
o
de, if a
"BEGIN EX
C
L
U
SIVE" comm
a
nd (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Da
n
Kennedy
Test that a rac
e
c
o
ndition ca
n
ca
u
se a "BEGIN E
X
CLU
S
IVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
F
i
x
a p
r
oble
m
in t
h
e xInverse
c
allb
a
c
k
for the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segfault cau
s
ed by
h
a
ving identical window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kenned
y
Fix a
c
rash caus
e
d
by
a LIKE pattern that consist
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nne
d
y
Fix a s
e
gfaul
t
cau
s
ed by invoking a reg
u
lar aggr
e
gate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Kenn
e
dy
A
v
oid a warning
i
n fts5
.
c du
e
to not using g
e
nerated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
e
n
ned
y
Merge implementation of SQL window functions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
e
nn
e
dy
Fix a minor prob
l
em in
t
h
e code
f
or deter
m
ining wheth
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
Merge all change
s
from the we
a
k-fa
l
lback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n Kennedy
Ha
v
e the tokeniz
e
r handle fallbac
k
for token
s
"
O
VER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Ken
n
e
d
y
Further performance
related tweaks for sqlite3Run
P
arser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n Kennedy
F
urther twe
a
ks to sql
i
te3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kennedy
I
m
p
r
ove on the
pr
e
vi
o
us
c
h
e
cki
n
.
S
t
i
l
l a bit sl
o
w
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Inste
a
d of using a l
e
mon %fa
l
lback direc
t
ive, hav
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
D
an Kennedy
Modifi
c
a
t
ions to
p
a
rse
.
y to bette
r
sup
p
ort back
w
ards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
A
dd missing Vdbe
C
ov
e
rage() and Vdb
e
Cov
e
rageNever
T
aken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan K
e
n
n
edy
Avoid
redundan
t
ORDER BY
o
peration
s
when
r
e
writing
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
en
n
edy
Merge
l
atest
t
ru
n
k
changes
.
commit
|
commitdiff
|
tree
2018-06-25
D
a
n Kennedy
Ad
d
documentation comme
n
t for sqlite3_
c
reate_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Ke
n
nedy
Fix another pr
o
blem that cou
l
d caus
e
a crash when
a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix problems
w
ith using
wind
o
w-functio
n
s in corre
l
a
t
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ke
n
ned
y
Fi
x
a problem with u
s
ing LIMIT in
window-function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan K
e
nnedy
Fix a problem with using a
w
in
d
ow-function SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan K
e
n
n
edy
Omi
t
a
ll w
i
ndo
w
-function related
c
ode when
b
uilding
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Me
r
ge latest trunk changes
.
commit
|
commitdiff
|
tree
2018-06-21
Da
n
Kennedy
Fix a problem with ha
n
dling single row partitio
n
s in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add tests to improve coverage
o
f
code in w
i
n
d
ow
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Merge latest trunk changes with t
h
is
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a problem caused
b
y
a s
u
b-query
c
on
t
aining a wi
n
do
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
F
ix a problem
with using min() or ma
x
() as a w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fi
x
prob
l
ems
with using window functions
in C
R
EATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
an Ke
n
n
e
d
y
A
d
d t
e
st cas
e
for t
h
e fix in th
e
pr
e
v
i
ous
com
m
it
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ensure
t
hat
all
fo
u
r cal
l
backs ar
e
prov
i
ded
when register
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenn
e
dy
Ad
d
new API function
s
qlite3_
c
re
a
te_window_f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
K
ennedy
Add extr
a
OOM te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
Kennedy
F
ix another
problem
in lead(
)
/lag()
.
A
n
d some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
ned
y
F
i
x
a bug
in t
h
e lead(
)
and lag() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Fix a p
r
oblem
w
i
th handl
i
ng of st
a
tements c
o
n
t
ai
n
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
e
n
nedy
Fix pr
o
bl
e
m with wind
o
w functions
m
in() and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
M
erge latest trunk changes into
t
his b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenn
e
d
y
Improve
comm
e
n
ts and code legibility in
new file w
i
ndow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
Fix proble
m
s with "RAN
G
E BE
T
WEE
N
CURREN
T
ROW AND
U
NBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix some test cas
e
numbers i
n
expert
1
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unles
s
SQ
L
ITE_
O
MIT_A
U
TOINI
T
is defined,
allow sqlite
3
_
vfs
_
u
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Chec
k
that malloc()
ha
s
not al
r
eady
f
ailed when invok
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenned
y
Fix another issue t
o
do with window-fu
n
c
t
i
ons
i
n
aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
F
ix
s
ome
proble
m
s with us
i
ng window-fun
c
tions in a
g
g
re
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenn
e
dy
C
l
a
rif
y
t
h
e relationship bet
w
ee
n
a Window ob
j
ect and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an Kenned
y
Fix han
d
ling of window fr
a
mes containing negative numbe
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
nnedy
Fi
x
a typon in main
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
Dan
K
ennedy
Update Makefile
.
msc t
o
include window
.
c
in
th
e
build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Merge recent trunk change
s
w
ith this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Updat
e
the amalgamation buil
d
script
t
o in
c
lude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kennedy
A
dd support f
o
r FILT
E
R clause on aggr
e
gate win
d
ow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
A
dd su
p
p
o
rt
for th
e
WINDOW clau
s
e
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n
Kenne
d
y
Do not flatten sub-queries that
contain window func
t
ion
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to allow group
_
conca
t
()
t
o be
used
a
s
a
w
i
n
d
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Mer
g
e latest trunk
c
hang
e
s
with t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
nedy
A
d
d
window functions lag(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add sup
p
ort f
o
r
w
indow function first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Fix problems with the nth_value
(
) function
.
commit
|
commitdiff
|
tree
2018-06-06
D
an K
e
nnedy
A
dd implementation of nth_va
l
ue() window function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan
K
e
n
ned
y
Calcul
a
te non-aggregate expres
s
ion
s
in the
SEL
E
CT l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenne
d
y
A
dd implem
e
ntatio
n
o
f last_value() win
d
ow function
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Ke
n
n
edy
Add
i
mpl
e
me
n
ta
t
ion of window function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge la
t
e
s
t trunk changes into
this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan K
e
n
nedy
Ad
d
s
u
pport for window function cu
m
e_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n Ken
n
edy
A
d
d
sup
p
o
r
t
for window functions r
o
w_nu
m
ber
(
), r
a
nk
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
Kennedy
Update a test cas
e
in malloc5
.
test to
take
into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenn
e
dy
Allow an entire partition to be cached in a
temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
ennedy
Fi
x
a bug
in the SQLITE_ENABLE_S
O
RTER_
R
EFEREN
C
ES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allo
w
min() and
max() t
o
be used as
w
i
n
d
ow functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase
t
he
number of
d
ata
b
a
s
e h
a
ndles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
Fix
autoinc
.
test and res
e
tdb
.
test
s
o
t
h
at they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenned
y
Mo
r
e minor changes
to test scr
i
pts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
i
x some tes
t
sc
r
ipt
i
ssue
s
c
a
used by rece
n
t EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do no
t
run test fil
e
"res
e
tdb
.
test" as part
of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Da
n
Ken
n
edy
F
u
rther
w
indow fr
a
me tests a
n
d
f
ixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
Kennedy
Do not re
q
uire a statemen
t
j
o
urnal in
c
ases where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
Mo
r
e fi
x
es for different window fr
a
me types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
e
nned
y
Fi
x
"RA
N
GE BETWEEN
C
URRENT R
O
W
AND UNBOUNDED FO
L
LOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
M
e
r
g
e l
a
test trun
k
changes into
this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
F
ixes for
"
ROW
S
BET
W
EEN <expr>
FOL
L
OW
I
NG AND <ex
p
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Kennedy
A
l
low "<expr> PRECE
D
ING" to
b
e
u
sed t
o
specify
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Ken
n
edy
Sup
p
o
r
t oth
e
r
f
r
ame types that use "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add support for "ROWS BE
T
WEEN <expr> PRECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Me
r
ge latest trunk
changes
into
this b
r
anch
.
commit
|
commitdiff
|
tree
2018-05-22
D
an Ken
n
e
d
y
Add comments to w
i
ndow
.
c de
s
cribing how o
t
her
w
in
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
B
e
g
i
n a
d
ding support for more esoteric w
i
ndow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Ken
n
edy
F
i
x minor
prob
l
ems on t
h
is
b
ran
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evalua
t
e
multipl
e
window functions i
n
a sing
l
e
p
a
s
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Handle multiple window-functions i
n
a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Sta
r
t of e
x
perimental implement
a
tion of SQL
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Ke
n
nedy
F
i
x a test case pro
b
lem in wherelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add
a
t
e
st case to ch
e
c
k
that
t
he fts5 unic
o
de64 tok
e
n
i
zer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
Fix a pro
b
lem in
t
he xBestInde
x
metho
d
of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
an Kennedy
Fix
a
n RBU problem causing
s
p
urious SQ
L
ITE_CONSTR
A
INT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
an
K
e
nn
e
d
y
Update test scr
i
pt ft
s
3
expr4
.
test so that
i
t always
.
.
.
commit
|
commitdiff
|
tree
next