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
In wal mode, if a "BEGIN EXCLUSIVE" command (or any other command that
2018-07-05
Dan Kennedy
In wa
l
mo
d
e
,
if a "BEGIN EX
C
LUSIV
E
" command
(
or
any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kennedy
Test that
a
race
co
n
dition can cause a "BEGIN E
X
CLUSI
V
E
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a problem
i
n the xInve
r
se callback for the buil
t
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nn
e
d
y
Fix a segfault c
a
used by having ident
i
cal w
i
ndow functio
n
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Ke
n
nedy
Fix a crash caused by a LIKE pattern t
h
at consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nne
d
y
Fix a segfau
l
t caused
b
y invo
k
ing a r
e
gular aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenn
e
dy
Avoid a
w
a
rn
i
ng i
n
fts
5
.
c due to not u
s
ing generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n
K
ennedy
M
erge implementation of S
Q
L
w
indow fun
c
tions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n Kennedy
Fix a mino
r
problem in the co
d
e for dete
r
m
ini
n
g whe
t
h
er
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
edy
Merge all c
h
ang
e
s from
the w
e
ak-fa
l
lback
branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan K
e
nnedy
Have the tokeniz
e
r handle
fallb
a
c
k
for tok
e
ns "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Further p
e
r
f
orm
a
nce
related tweaks for sqlite3RunP
a
rser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenn
e
dy
F
urther tweaks
to sqlite3RunPa
r
ser(
)
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
nnedy
Improve on the previous checkin
.
Still
a
bit slo
w
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenne
d
y
Instead of using a lemon
%
fallback dire
c
tive, h
a
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan
Ke
n
nedy
Modif
i
cations to parse
.
y
t
o
b
etter support backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Da
n
Kennedy
A
d
d m
i
s
s
ing
VdbeCover
a
ge()
a
nd VdbeC
o
verageN
e
verTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
a
n K
e
nnedy
Avoi
d
r
e
d
u
ndant
ORDER BY operations when rewritin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Ke
n
n
edy
Merge latest tr
u
nk changes
.
commit
|
commitdiff
|
tree
2018-06-25
Dan K
e
nnedy
Add docu
m
entation comment f
o
r s
q
lite3_cr
e
a
t
e_window_
f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
Kennedy
Fix another problem
t
h
at could
c
aus
e
a crash when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
a
n
Kenned
y
Fix probl
e
m
s
with using window-functi
o
ns
i
n
corre
l
ated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan
K
e
nnedy
Fi
x
a
p
roblem with usin
g
LIMIT in
w
indow-function q
u
e
r
ies
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
Fix a problem with using a window-function SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit all
w
indow-function related
code when b
u
i
l
d
in
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
M
erge latest
t
r
unk
c
ha
n
g
e
s
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kenne
d
y
Fix a p
r
oblem wi
t
h
ha
n
d
l
ing sin
g
l
e
row p
a
rtitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add tests to
i
mp
r
ove cover
a
ge
o
f
code in
w
indow
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
Kennedy
Merge latest trunk changes wit
h
thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a
p
roblem caused
b
y
a
s
ub-query c
o
nta
i
ning a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a prob
l
em with using
min() or
max(
)
as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenned
y
Fix p
r
oblems
w
ith
u
si
n
g
window functio
n
s in CREAT
E
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n
Ken
n
edy
Add
t
est
c
ase
f
o
r
the fix in the
previous co
m
m
i
t
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenn
e
dy
Ensure tha
t
all four callbac
k
s
are provid
e
d when
registerin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add new API func
t
ion sqlite3_create_window_functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
K
ennedy
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
Kenn
e
dy
Fix a
n
othe
r
p
roble
m
in lead()/lag()
.
And some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
F
i
x
a
b
ug in
t
he lead() and lag() wind
o
w
f
unctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix
a prob
l
em with
h
andling of sta
t
em
e
nts
containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n
Kenne
d
y
Fix problem with window func
t
ions
min()
and max
(
) whe
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest trunk changes i
n
to
t
his b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
Impro
v
e
comments and
code le
g
ibility in new f
i
le w
i
ndow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
Kenne
d
y
F
i
x proble
m
s with "RANG
E
BETWEEN CURR
E
N
T
ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kenne
d
y
Fix some test case numbers in exp
e
rt1
.
tes
t
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Unle
s
s
S
QLITE_OMIT_AUTOI
N
IT is
defined,
a
llow
sqli
t
e3_v
f
s
_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kennedy
Che
c
k that mallo
c
()
h
a
s
not alre
a
dy failed when in
v
oking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
Kennedy
F
ix
a
nother issue
to do wit
h
w
indow-f
u
nctions i
n
aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
a
n Kennedy
Fix some prob
l
ems with using wind
o
w-f
u
nctions in ag
g
regate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify the r
e
lati
o
ns
h
ip betwe
e
n
a Window objec
t
and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix handli
n
g
o
f window frames contai
n
in
g
negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Kenn
e
dy
Fix a typon in
m
ain
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Da
n
Kennedy
Up
d
ate Mak
e
file
.
msc to include window
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenne
d
y
M
e
rge recent
t
r
unk changes w
i
th t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kenne
d
y
Update t
h
e amalgamation build
s
cript
t
o include wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Add
support for FILTE
R
c
l
ause on aggre
g
ate
window functi
o
ns
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
Add suppo
r
t
for the W
I
NDO
W
clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ken
n
e
dy
Do no
t
flat
t
e
n
sub
-
q
u
eries that con
t
ain
w
i
ndow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ke
n
nedy
Fixes to allow
group_concat() to be used as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Ken
n
edy
Merge latest t
r
u
n
k changes
with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add window
f
unctions lag(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
e
d
y
Add
s
upport for window function
f
irst
_
value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Fix problems
w
i
th the
n
th_value()
functi
o
n
.
commit
|
commitdiff
|
tree
2018-06-06
Da
n
Kenn
e
dy
Add implementation o
f
nth_
v
alue() window func
t
ion
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenne
d
y
Calc
u
late
n
o
n
-aggr
e
gate expre
s
s
i
on
s
in the
SE
L
ECT
l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan K
e
nnedy
Add implementation of last_value() window fun
c
t
i
on
.
commit
|
commitdiff
|
tree
2018-06-04
D
an Kenn
e
dy
Ad
d
i
m
plem
e
ntat
i
on o
f
wi
n
dow functio
n
ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ken
n
e
dy
Merge la
t
es
t
trunk changes into
t
h
is
b
r
a
nch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
A
d
d
support for wi
n
dow function cume_dist
(
)
.
Improv
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
an Kennedy
A
d
d supp
o
rt for window functions row_n
u
mber(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n Kennedy
U
p
d
a
te a t
e
st case in malloc5
.
test t
o
take into acco
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
Allow
a
n
entire partition to be cached in a tem
p
table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Kennedy
Fix a bug
i
n the SQLITE_ENABLE_SOR
T
ER_REFERE
N
C
E
S
c
ode
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
a
n Kennedy
Allow m
i
n() and max() t
o
be used as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenne
d
y
Increase the number of
d
ata
b
ase handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix au
t
oinc
.
tes
t
and resetd
b
.
test
s
o tha
t
they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
More minor changes to t
e
st
s
c
r
i
pt
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
Fix some tes
t
script
i
ssues
c
aus
e
d
by
r
ece
n
t EXP
L
AIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
Do
not r
u
n
t
est file "resetdb
.
test" as part of
p
e
r
mutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
a
n Kenned
y
Further window frame tests and fi
x
es
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
Do not
r
equi
r
e a statement
j
ournal in
cases wh
e
re REPL
A
C
E
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Ken
n
edy
Mor
e
fixes
for
d
i
fferent
w
in
d
o
w
frame
t
ypes
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
Fix "R
A
NGE
BETWEE
N
CURRENT RO
W
AND UNBOUNDE
D
FOLLO
W
I
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge latest trunk changes into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
Fi
x
es fo
r
"
ROWS BETWEEN <expr>
F
OLLOWING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Allo
w
"
<
expr> PRECEDING" to be use
d
t
o specify
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Ke
n
nedy
Suppor
t
o
ther frame types that
u
se "<expr
>
PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Ke
n
n
e
dy
Add sup
p
ort for "RO
W
S BE
T
W
E
EN
<
e
x
p
r> PRECEDING
A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merge lates
t
trunk chang
e
s
i
n
t
o
this branc
h
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Ke
n
nedy
Add
c
o
m
men
t
s to window
.
c describing how
o
t
her window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin adding support for more e
s
ot
e
r
i
c
window frames
.
commit
|
commitdiff
|
tree
2018-05-19
D
a
n Ken
n
e
d
y
Fix minor problems on this branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evaluat
e
multiple window fun
c
tion
s
in a single pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Handle multiple window-functions in a
single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Ke
n
nedy
S
t
ar
t
of expe
r
imental implementation of SQL
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan K
e
nnedy
Fix a te
s
t case problem in
wherelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add a t
e
st c
a
se to
c
heck that the fts5 unicode64 token
i
zer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan K
e
n
n
e
dy
Fix a prob
l
e
m in the xBestI
n
dex method
o
f
the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kenn
e
d
y
F
i
x an RBU problem c
a
using
spurious SQLIT
E
_
C
ON
S
T
RAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenne
d
y
Upda
t
e
test
script fts3expr4
.
test
so th
a
t
i
t
a
lways
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix a test script error causi
n
g te
s
ts to f
a
il in
s
oak
.
.
.
commit
|
commitdiff
|
tree
next