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 another problem in lead()/lag(). And some errors that could occur
2018-06-15
Dan Kenne
d
y
F
i
x
a
n
other p
r
oblem in le
a
d(
)
/l
a
g()
.
And so
m
e error
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n
Kennedy
Fix a bug in the lead
(
) and
l
ag() w
i
ndow function
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
nned
y
Fi
x
a
problem with
h
a
ndling of
statemen
t
s
c
ontaining
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an K
e
nnedy
Fix problem
w
i
th window functions min() and max() w
h
en
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenn
e
dy
Merge latest
trunk
c
hanges into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kennedy
I
mprove comm
e
n
t
s an
d
co
d
e legibility in new fi
l
e wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an
K
enned
y
Fi
x
p
roble
m
s with "RANGE BETWEEN CURRENT
ROW
A
N
D UNBOUN
D
ED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan K
e
nnedy
F
ix some test
ca
s
e num
b
ers in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
D
an
K
e
nnedy
Unless
S
QLITE_OMIT_A
U
TOINI
T
is defined, al
l
ow sqlite
3
_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kennedy
C
h
eck tha
t
m
alloc
(
) h
a
s n
o
t
already fail
e
d w
h
en invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenn
e
dy
Fix another issue to do with window-func
t
ion
s
in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix
s
ome
pro
b
l
ems
w
ith using
w
in
d
o
w-functions
i
n aggre
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
nnedy
C
larify the
relationshi
p
b
e
tween a W
i
ndow object a
n
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix handling of windo
w
f
r
a
m
e
s containing negative n
u
mber
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
ennedy
F
i
x a t
y
p
on
i
n main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Ke
n
nedy
Update Makefi
l
e
.
msc to i
n
clude window
.
c in
the build
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Kenned
y
M
e
rg
e
recent
t
runk ch
a
nges with th
i
s branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Update t
h
e amalga
m
ation build scri
p
t
t
o in
c
lude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
A
d
d supp
o
rt for FI
L
TER clause on aggregate wi
n
dow func
t
i
ons
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenned
y
Add s
u
pport
for the
W
INDO
W
c
l
a
u
se
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do n
o
t flatten sub-
q
ueri
e
s t
h
at contai
n
w
i
ndow f
u
ncti
o
ns
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
Fixes to allow g
r
oup_concat() to be u
s
ed
as a w
i
nd
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Ke
n
nedy
Me
r
ge lates
t
trunk
changes
w
ith
t
his branc
h
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add window functions lag() an
d
lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
Add
support for
w
indow fun
c
t
ion first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenn
e
dy
Fix problems with the nth_value() funct
i
on
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Ke
n
n
e
dy
Add impl
e
m
ent
a
tion of nth_value() wi
n
do
w
f
u
ncti
o
n
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate no
n
-aggregate
expressions in the SEL
E
C
T list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Ke
n
ne
d
y
Add
i
m
plementation of last_value()
wind
o
w
f
u
n
ct
i
on
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add implementation
of window function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Me
r
ge latest
trunk ch
a
nges into this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenned
y
Add support for windo
w
function cume_di
s
t()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Da
n
Kennedy
Add supp
o
rt for window functions r
o
w_numbe
r
(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenn
e
d
y
Update
a
test case in
malloc5
.
test
t
o take into accoun
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
Allow an
e
ntire partition to b
e
cached in
a
temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kennedy
Fix a bug in th
e
SQLITE_E
N
ABL
E
_SOR
T
ER
_
REFERENCES
c
ode
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
a
n
Kennedy
Al
l
ow min() a
n
d max() to be used as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
Increase the number of database
h
andles opened
by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
Fix
a
ut
o
in
c
.
test and reset
d
b
.
test so that
they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
M
o
re minor
changes to tes
t
s
c
r
i
pts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
Fi
x
som
e
test
script
is
s
ues
caused by re
c
ent EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do n
o
t
r
un
t
est f
i
le
"resetdb
.
te
s
t" as part
o
f
permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kenne
d
y
Furt
h
er
window
f
rame tests and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
enn
e
d
y
Do no
t
require a
statement journal
i
n cases where RE
P
LACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
M
ore fixes for differen
t
windo
w
fram
e
t
ypes
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ken
n
edy
Fix "RA
N
GE BETWE
E
N CURRE
N
T RO
W
AND UNBOUNDED FO
L
LOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge latest trunk ch
a
nges
i
n
t
o this branch
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kennedy
Fixes for "ROWS B
E
TWE
E
N <expr>
F
OL
L
O
W
I
N
G
AND <ex
p
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan
Kenned
y
Allow "<ex
p
r> PRECEDING" to
be
u
sed to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
a
n
Kennedy
Support other frame types that use "<e
x
pr> PRECE
D
ING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add
s
u
pport for "ROWS
B
ETWEEN <expr
>
PRECEDING A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merge l
a
test
t
runk
c
hanges into this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-22
Da
n
Kennedy
Add commen
t
s to wind
o
w
.
c describ
i
ng ho
w
ot
h
er win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan
Kennedy
Begin adding support for
m
ore esoteric window frames
.
commit
|
commitdiff
|
tree
2018-05-19
D
a
n Kennedy
Fix minor
problems
on
t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Ev
a
luate
multiple window
fun
c
tions in a single pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Ke
n
n
e
d
y
Handl
e
mul
t
iple window-fu
n
ctions in a si
n
gle
query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kenne
d
y
Start of e
x
per
i
mental imp
l
ementation of
S
QL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
D
a
n
Kennedy
Fix a test case p
r
oblem in wh
e
relimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add a test ca
s
e to
chec
k
that the fts
5
unicode64
t
oken
i
zer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
Fix a p
r
oblem in the xB
e
stI
n
dex
m
e
thod of the
c
losure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
a
n Kenned
y
F
i
x an RBU pr
o
b
lem
c
ausin
g
s
p
urious SQLITE_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Ke
n
nedy
Update
t
est script ft
s
3expr4
.
test
so that it
alway
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fi
x
a test scr
i
pt error c
a
usi
n
g tests t
o
fa
i
l in s
o
ak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenne
d
y
When processing an "
O
R
DER BY
.
.
.
L
IMIT" t
h
a
t does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan
K
ennedy
W
hen
p
rocess
i
ng an "
O
RDER BY
.
.
.
LIMIT"
t
hat
does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenn
e
dy
Update
t
h
e "f
u
zz_malloc
.
test" script
t
o
print
SQL s
t
a
t
ements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
Kennedy
R
e
move a recen
t
l
y
a
dded N
E
V
E
R() macro f
r
om a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix a
p
roblem with pro
c
e
s
s
ing "LEFT JOIN tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenned
y
Do
n
ot a
t
tempt to read values from indexes-on-expressi
o
ns
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
an Kennedy
A fe
w
mo
r
e te
s
ts for up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n Kenne
d
y
E
n
hanc
e
the "rbu" comma
n
d
l
in
e
uti
l
ity a bi
t
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n
K
enn
e
d
y
Add tests for n
a
me resoluti
o
n in ON
CO
N
FLIC
T
cl
a
uses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ken
n
edy
Add tes
t
case
s
for
U
PSERT
.
And a fix f
o
r
a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
a
n Kennedy
Modi
f
y a test c
a
se
in zipfile2
.
test to take into
a
ccount
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kenn
e
dy
Add the "so
r
ter-r
e
ference" optimizatio
n
, allo
w
ing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Mino
r
changes t
o
t
e
s
t
scrip
t
u
psert4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kenned
y
Add extra test cases for U
P
S
E
RT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix a problem in
t
he shell
p
r
ev
e
nting
it from working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
Add some mo
r
e s
i
mple test c
a
s
e
s for UPSERT
.
A
n
d a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan Kennedy
A
d
d SQLITE_CONFI
G
_SORTE
R
REF
_
S
IZE configuration opt
i
on
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
Experimen
t
al c
h
a
n
ge
t
o "SE
L
ECT * FRO
M
.
.
.
O
R
D
E
R
B
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Ke
n
nedy
M
inor sim
p
lification to internal funct
i
on generateSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenne
d
y
Fix a prob
l
em
c
ausin
g
the LEFT JOI
N
st
r
ength r
e
duc
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ken
n
edy
When testin
g
,
avoid
i
njecti
n
g a
n
OOM fault into a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ken
n
e
d
y
Fix a problem c
a
u
s
ing the LEFT
J
OIN strength reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan
K
e
n
nedy
Fi
x
th
e
fts5 xBestIndex m
e
thod so that
it is
not conf
u
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Da
n
K
e
nnedy
Add a "
f
lags" param
e
t
er t
o
experimental API sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Kennedy
Fix a prob
l
em in the se
s
sion
s
module causing sqlite3
s
ession_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Kennedy
F
ix an instance wh
e
re
a
n
uninitialized VM reg
i
ster
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan K
e
nnedy
U
p
date
speedtest1
.
c with new t
e
st
s
et "trigger" ba
s
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Fix a f
e
w small
test script issue
s
affectin
g
SQLITE_T
E
MP_
S
TO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan
K
ennedy
Fix an assertion f
a
ilure triggered by a SELECT
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Another ch
a
n
ge to test
file zipf
i
le
.
tes
t
to hel
p
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n
Kenn
e
dy
Fix
a
test scrip
t
b
u
g caus
i
ng zipfile
.
test to
f
ail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Da
n
Ke
n
ne
d
y
Update memd
b
1
.
test
so t
h
a
t
i
t works with SQLITE_DEFAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kennedy
Add -DSQ
L
I
TE_ENABLE_DES
E
RIALIZE to the "Device-
T
w
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
a
n Kennedy
Fix a typo preven
t
ing test
s
cri
p
t avtrans
.
test
f
rom
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kennedy
Fix a
te
s
t script problem causing shell
1
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
a
n
K
ennedy
Fix
typo
s
in sqlite3session
.
h preven
t
ing
d
ocument
a
t
ion
.
.
.
commit
|
commitdiff
|
tree
next