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 wal mode, if a "BEGIN EXCLU
S
IVE" com
m
and (or
a
ny
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kennedy
Test
that a race cond
i
tion c
a
n cause a "BEG
I
N
EXC
L
U
SIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
Kennedy
Fix a problem
i
n the xI
n
vers
e
callback for the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Da
n
Ken
n
edy
F
i
x a segfault
c
aused by having i
d
e
ntical window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix
a
c
ras
h
ca
u
sed b
y
a LIKE pattern that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segfaul
t
caus
e
d
by invoking a reg
u
lar aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Avoid a warning
i
n fts5
.
c due
t
o
not
usin
g
g
ener
a
ted
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Mer
g
e im
p
lementation
of SQL window functions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
F
i
x a minor pr
o
blem in the code for determini
n
g
whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
an
Kennedy
Merge all changes from
the weak
-
fallback branch excep
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have the
to
k
eniz
e
r h
a
ndle fallbac
k
for t
o
kens "OV
E
R
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ken
n
e
dy
F
u
r
t
her perfor
m
ance related
t
w
e
aks for sqlite3RunPars
e
r()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n Kennedy
Further tweaks to sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenne
d
y
I
m
prove o
n
th
e
previo
u
s c
h
eckin
.
Still a
bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Kennedy
I
n
s
tead of u
s
ing a
l
emon
%
fallback dire
c
tiv
e
,
have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kennedy
Mod
i
fications t
o
parse
.
y to better support
ba
c
kwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add missin
g
Vdb
e
Co
v
e
ra
g
e() an
d
VdbeCoverageNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
an Ke
n
nedy
Avoid
redunda
n
t ORDER
BY op
e
rat
i
ons
when rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
D
a
n Ke
n
nedy
Merge latest trunk
c
hanges
.
commit
|
commitdiff
|
tree
2018-06-25
Da
n
Kenn
e
dy
Add documentation
c
omment for sqlite3_create_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
D
an Kenne
d
y
Fix another problem th
a
t could cause a cr
a
sh when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
F
ix problems with using w
i
ndow-functions in correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ke
n
nedy
F
i
x a problem wi
t
h using LIMIT in window
-
function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan
Ke
n
n
edy
Fix
a problem with using a window-function
S
ELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Da
n
Ke
n
nedy
Omit all window-function rela
t
ed code when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Mer
g
e latest trun
k
c
h
anges
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a p
r
oblem with handling single row parti
t
i
o
ns in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
D
a
n Kennedy
Add te
s
ts
t
o
i
mp
r
ove co
v
er
a
ge of code
in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
Ke
n
ne
d
y
Merge latest
t
ru
n
k ch
a
nges
w
ith t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a prob
l
em caus
e
d by a sub-qu
e
ry co
n
t
a
ining a win
d
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
e
dy
Fix a problem wi
t
h
usi
n
g min() or max() as a wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Da
n
Kennedy
Fix pro
b
lem
s
w
ith usi
n
g window functions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
e
dy
Add test case for the fix in
t
he previous comm
i
t
.
commit
|
commitdiff
|
tree
2018-06-18
Da
n
Ke
n
nedy
E
n
sure that al
l
four callb
a
cks ar
e
prov
i
ded when
r
e
g
i
ster
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add n
e
w API func
t
ion
sqlite3_create_w
i
ndow_func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Add
e
xtra OOM t
e
st
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
F
i
x
a
n
other
p
roblem in le
a
d()/lag(
)
.
An
d
some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
nne
d
y
Fix a bug in the
lead() and lag()
w
indo
w
functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a p
r
oblem w
i
t
h h
a
ndling of statements contain
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
n
ed
y
F
i
x problem
with wind
o
w functions
m
i
n() and max(
)
when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kennedy
M
e
r
g
e latest t
r
unk
c
h
anges i
n
to t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
an
K
ennedy
Impro
v
e comments and code legibility i
n
new fi
l
e wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
Ken
n
e
d
y
Fix problems with "
R
ANGE BE
T
WEEN CURRENT ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
n
e
dy
Fix so
m
e test c
a
se numbers in e
x
pert
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
enn
e
dy
Unless SQLITE_OMIT
_
AUTOINIT is defined, all
o
w sqlite3_vfs_
u
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
Check that
m
alloc() has not already fail
e
d
when
i
n
voking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan K
e
nnedy
Fix
a
nother
issue to d
o
with
win
d
ow-fun
c
t
i
ons
in aggreg
a
te
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenne
d
y
Fix some pro
b
lems with using windo
w
-funct
i
ons in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
K
enn
e
d
y
Clarify the relationship
b
et
w
een a Win
d
ow object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an K
e
nnedy
Fi
x
handling of window frames cont
a
ining
negative
number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
n
n
edy
Fix a typon
i
n
main
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
Dan
Kennedy
U
pd
a
te
Makefile
.
msc
t
o in
c
lu
d
e window
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
D
an
K
enn
e
dy
M
erge rec
e
n
t trunk ch
a
nges with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Updat
e
the amalgamation build script
t
o include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
d
y
Add supp
o
rt
for FILTER clause on a
g
gre
g
ate wi
n
dow
f
u
n
ctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan K
e
nnedy
Add support f
o
r
th
e
WINDOW c
l
ause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do
not
f
lat
t
en
sub-queries th
a
t contain wi
n
dow function
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenne
d
y
Fixes to allow group
_
concat() to be
u
se
d
as a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
Merge la
t
e
s
t trun
k
changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kenn
e
dy
Add
w
indow function
s
lag() a
n
d
l
e
ad()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
en
n
edy
Add s
u
pport for wind
o
w fun
c
tion firs
t
_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenne
d
y
Fix
p
roblems
w
ith
the nth_value() fu
n
c
t
ion
.
commit
|
commitdiff
|
tree
2018-06-06
Da
n
Kennedy
Add imple
m
entation of nth_value()
w
i
n
dow function
.
commit
|
commitdiff
|
tree
2018-06-05
D
an Kenn
e
d
y
Calculate non
-
aggregat
e
ex
p
r
e
ssions in
t
he
SELECT li
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan
Ken
n
edy
Add implementation
of la
s
t_v
a
l
u
e() window funct
i
on
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
nedy
Add imp
l
e
m
entation of win
d
ow funct
i
on nt
i
le()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge latest tr
u
nk changes into
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Ad
d
support
for wi
n
dow functio
n
cume_
d
ist()
.
I
m
prov
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Ad
d
support for window
functions row_num
b
er(
)
,
r
ank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
K
e
nn
e
d
y
Update a te
s
t case in ma
l
loc5
.
test to take into
account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenn
e
dy
All
o
w
a
n
en
t
i
re partition to
be cached i
n
a
t
emp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
Kenne
d
y
Fix a bug
i
n
the SQLITE_E
N
ABLE_SORTER_R
E
FERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
a
n Kennedy
Allow min(
)
and max()
to
be used as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kennedy
Increase th
e
numb
e
r
of database handles opened b
y
t
est
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Kenn
e
d
y
Fix autoinc
.
test an
d
resetdb
.
test s
o
that the
y
work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kennedy
M
o
r
e
m
i
nor changes
to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
Fix some t
e
st script issue
s
c
aused
by recent
EXPLA
I
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Ke
n
nedy
Do not run tes
t
file "r
e
setdb
.
test" as
p
art o
f
p
ermutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
a
n
Kennedy
Fur
t
her
w
indow
f
rame te
s
ts and fixe
s
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
Kenne
d
y
Do n
o
t require
a
s
tat
e
ment jo
u
rnal in cases where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Ken
n
edy
M
ore fixes for d
i
fferent window frame
types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenn
e
dy
Fix
"R
A
NGE BETWEEN CURRENT ROW AN
D
UNBOUNDED FOLLO
W
ING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
K
e
nne
d
y
Merg
e
lates
t
trunk changes
into this branc
h
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
Ken
n
e
d
y
F
i
xes
f
o
r "R
O
WS
B
ETWEEN <expr> FOLLOWING
AND <exp
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nnedy
All
o
w
"
<expr> PRE
C
E
DING
"
to be u
s
ed to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan
K
e
nn
e
dy
S
u
p
p
or
t
other
f
rame types that
u
s
e
"<exp
r
> P
R
ECEDIN
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan K
e
nnedy
Add suppor
t
for "ROWS B
E
TWEEN <exp
r
> PRECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Da
n
Kennedy
M
e
r
g
e
latest
t
runk cha
n
ges
i
n
to this branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
K
ennedy
Add comments t
o
window
.
c describ
i
ng how oth
e
r window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kenned
y
Begin adding support f
o
r more
e
soteric w
i
ndow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan
Kenn
e
dy
F
i
x minor p
r
oblems on thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-17
Da
n
Ke
n
n
e
dy
Evaluate multip
l
e wind
o
w
fun
c
tions in a single pa
s
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kennedy
Handle multipl
e
win
d
ow-functions i
n
a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Ke
n
ne
d
y
Start
o
f exp
e
rimental implementation of SQL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan
K
ennedy
F
i
x a test case problem in
w
h
erelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
D
a
n
K
e
n
n
e
dy
Add a test ca
s
e to
c
heck that
the f
t
s5
unicode64 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
a
n
K
e
nne
d
y
Fix a prob
l
em in the xBe
s
tIndex method of t
h
e
c
losure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan
K
ennedy
Fix an RBU problem causing
spuri
o
us
SQLITE_CO
N
STRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenned
y
Update test
s
c
ript fts3expr4
.
test so that it always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
K
enne
d
y
Fix a test script error causin
g
tes
t
s
t
o
fa
i
l
in soa
k
.
.
.
commit
|
commitdiff
|
tree
next