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 crash caused by a LIKE pattern that consists of a single escape
2018-07-02
D
a
n
Kenn
e
dy
Fix a crash caused by
a
LIKE
pat
t
ern that consis
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nnedy
Fix a segfaul
t
c
a
used by i
n
voking a
r
egular aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Avoid
a warning in fts5
.
c due to not u
s
i
n
g
gene
r
ated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Kennedy
Me
r
ge i
m
pl
e
m
e
n
t
a
tion of SQL wi
n
dow
functions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Kennedy
Fix a
m
inor pro
b
lem in the code for determ
i
ning
wheth
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge all chang
e
s from th
e
weak-fallba
c
k branch ex
c
ept
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan K
e
nned
y
H
a
ve the tokenizer handle fallback f
o
r toke
n
s
"O
V
ER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenned
y
Further pe
r
forma
n
ce related tweak
s
for sql
i
te3RunPar
s
er
(
)
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Furthe
r
tweaks to
s
qlite3RunPa
r
s
e
r(
)
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Kennedy
Improve on the
p
revious
checkin
.
Still a bit
s
l
o
w
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Kenne
d
y
Instead
of usi
n
g a
l
e
mon %fallbac
k
directive
,
ha
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kenned
y
Mo
d
ifications to
p
arse
.
y to better
sup
p
ort backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add missing Vd
b
eCoverage() and VdbeC
o
verageNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan
K
e
nnedy
Avoid redundant ORDER B
Y
ope
r
ations when
r
ewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
ennedy
Merg
e
la
t
est trunk changes
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Ke
n
nedy
Add documentation comment for sqlite3_
c
reat
e
_win
d
ow_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kenned
y
F
i
x anothe
r
problem that could
c
ause a crash
w
hen a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
an Kennedy
Fix
p
roblems with usin
g
window-fu
n
ction
s
in correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan K
e
nnedy
Fix
a
problem with
u
sing LIM
I
T in window
-
function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kenne
d
y
Fix a
problem with using a wi
n
d
ow-fu
n
ction SELEC
T
as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Ken
n
edy
Omit all window-funct
i
on
relat
e
d
code when bui
l
di
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan
K
ennedy
Merge l
a
t
est
t
r
u
n
k
changes
.
commit
|
commitdiff
|
tree
2018-06-21
Dan
Ke
n
n
e
dy
F
ix a pr
o
blem with hand
l
ing
single row par
t
i
t
io
n
s in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
A
d
d tests to improve
c
ov
e
rage of code
in windo
w
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
edy
Mer
g
e late
s
t trunk
c
han
g
es with thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
e
nnedy
F
ix a pro
b
lem caused by a sub-query
containi
n
g a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Da
n
Ken
n
edy
Fix a problem w
i
t
h
using min() or max() as
a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix
pro
b
lems with using window f
u
nc
t
i
o
n
s in C
R
EATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Add test case
for the
f
i
x
in
t
h
e previ
o
us c
o
m
mit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ens
u
r
e tha
t
all fo
u
r callb
a
ck
s
are
provided when
registering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan
K
e
n
nedy
Add new
A
PI fun
c
tion
sqlite3_
c
r
eate_window_functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
K
e
nnedy
Add extra
OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n Kennedy
Fix another
p
roblem
in lead()/lag()
.
A
nd s
o
me e
r
ro
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Kennedy
Fix a
b
ug in the
l
e
ad() and l
a
g(
)
windo
w
f
u
nctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
ed
y
Fix a
pr
o
blem with handling of
s
ta
t
e
m
ents
c
ont
a
i
n
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
Kenn
e
d
y
Fi
x
proble
m
w
i
th
w
i
n
d
o
w functions min(
)
and max() w
h
en
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest tru
n
k
changes into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Improve commen
t
s and code legibility in ne
w
file windo
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix pr
o
bl
e
ms with "RANG
E
B
ETWEEN
CURRENT ROW
A
N
D
U
N
BOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
Fix some t
e
st case num
b
ers in expe
r
t1
.
t
est
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
Kennedy
Unle
s
s SQLITE_OMIT_AUTOI
N
IT
i
s defined, allow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Check tha
t
m
a
lloc() h
a
s not alread
y
failed when in
v
oking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
a
n
K
enne
d
y
F
i
x
a
not
h
er is
s
ue to do with window
-
fu
n
c
tions in aggre
g
at
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
K
e
nn
e
d
y
F
ix some
problem
s
wit
h
usin
g
w
i
ndow
-
f
u
nctio
n
s in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify t
h
e relation
s
hip between
a Window object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
nnedy
Fix handlin
g
of w
i
ndow frames containin
g
negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
Kenned
y
Fix a typon in mai
n
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kenne
d
y
Update
M
akefile
.
msc to incl
u
de w
i
ndow
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
M
erge recent
t
runk
changes wi
t
h thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
Updat
e
the amalgamation build scri
p
t to in
c
lude
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
Add support f
o
r FILTER
cla
u
se on
aggregate
windo
w
fu
n
ctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
Kennedy
Ad
d
support for the WINDOW clau
s
e
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenned
y
Do not flatte
n
sub-
q
u
e
ri
e
s th
a
t contain window
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
K
ennedy
Fixes to a
l
low g
r
oup_concat() to be used as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
ne
d
y
Merge
l
a
test
t
r
unk change
s
with this
branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Kenned
y
Add window functions
l
ag()
and
lead()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
Add suppo
r
t
f
or w
i
ndow function firs
t
_val
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan K
e
nnedy
Fix
problem
s
with the nth_va
l
ue() function
.
commit
|
commitdiff
|
tree
2018-06-06
Da
n
Ke
n
nedy
Add implementation of nth_value()
wind
o
w function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Ken
n
edy
Calculate non
-
aggregate expressions in
t
he SELECT
list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Ad
d
i
m
plemen
t
ation
o
f l
a
st_v
a
lu
e
()
window function
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
nedy
Add im
p
le
m
entation of windo
w
fun
c
tion
ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenned
y
Merge l
a
test trunk ch
a
n
g
es into this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
A
dd
su
p
port
f
or window funct
i
on
cume_
d
i
st()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
an Kennedy
A
dd s
u
pport for
w
indow functi
o
ns
r
ow_number(), ra
n
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Updat
e
a tes
t
case in malloc
5
.
test to take i
n
t
o
account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenn
e
dy
A
llow an ent
i
re pa
r
tition
to b
e
cach
e
d in a
temp tabl
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
F
i
x a bug i
n
t
h
e SQLIT
E
_ENABLE_SORTE
R
_REFERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
a
n Ken
n
e
d
y
Allow min() and max() to be u
s
ed a
s
w
indow functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase the nu
m
ber
o
f da
t
abase hand
l
es opene
d
b
y test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kenn
e
dy
F
i
x aut
o
i
nc
.
tes
t
an
d
resetdb
.
test so that they w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ken
n
edy
More minor changes to te
s
t scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenned
y
F
i
x
s
o
m
e test script issues caused by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kenne
d
y
D
o
no
t
run tes
t
file "reset
d
b
.
test" as part of permut
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenned
y
Further wi
n
dow fram
e
tests and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenne
d
y
Do
n
ot require a st
a
te
m
ent journal in cas
e
s
where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan
K
ennedy
More f
i
x
e
s for different w
i
ndow
f
r
a
m
e
types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
F
i
x "RANGE
BETWEEN CURR
E
NT ROW AND UNBOUNDED FOLL
O
W
I
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
M
erge lat
e
s
t
tr
u
nk changes into t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenne
d
y
Fixes for
"
ROWS BETWE
E
N <expr> F
O
LLOW
I
NG AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kenne
d
y
Allow "
<
expr> PR
E
C
EDIN
G
" to be used to
s
pecify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Ke
n
nedy
Support other frame types that use "<e
x
pr> P
R
ECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Da
n
Kenne
d
y
Ad
d
s
u
pport
f
or "ROWS
B
ETWEEN <expr> PREC
E
DI
N
G
A
ND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
M
e
rge
latest trunk changes into this branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Ken
n
edy
Add co
m
ments to win
d
ow
.
c describing ho
w
other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan
K
enned
y
Begin
a
dding support for more esoteric window
f
rames
.
commit
|
commitdiff
|
tree
2018-05-19
D
a
n Kennedy
Fix
minor problems on this branc
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Eva
l
uate mult
i
ple wi
n
dow functions in
a
s
i
ngle pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Ke
n
ned
y
Handle mult
i
ple win
d
ow-fu
n
ctions in a single que
r
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Start of exp
e
rime
n
tal
i
mplementati
o
n
of SQ
L
wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
Fix a test case pr
o
blem i
n
where
l
imit
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Ken
n
ed
y
Add a test case to
c
he
c
k
t
h
at the
f
ts5 unicode64 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Ke
n
nedy
Fix a problem in th
e
xBestInd
e
x method of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Ken
n
edy
Fix an
R
BU p
r
oblem ca
u
s
ing sp
u
rio
u
s
S
QLITE_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Update test script fts3expr4
.
t
e
st
s
o that it al
w
ays
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
an K
e
nnedy
F
ix a test scr
i
pt err
o
r ca
u
sing tes
t
s
t
o
fail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
an
K
enne
d
y
When processing an "ORD
E
R BY
.
.
.
LIMI
T
" t
h
at does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
W
h
en pro
c
e
s
s
in
g
an "ORDE
R
BY
.
.
.
LIMI
T
"
t
h
at do
e
s not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Up
d
ate th
e
"f
u
zz
_
mallo
c
.
test" script to print SQL sta
t
ements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Remo
v
e a
recently adde
d
N
E
VER() macro from a branch
.
.
.
commit
|
commitdiff
|
tree
next