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
Add support for window functions row_number(), rank(), dense_rank() and
2018-06-02
Dan Kennedy
Add sup
p
ort f
o
r
w
i
n
d
ow functions row_numb
e
r(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
All
o
w a
n
entire partition to be cached
in
a
tem
p
table
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kenn
e
dy
Allow min() and max
(
) to be us
e
d as
window f
u
nctions
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Furthe
r
w
indow fr
a
m
e
t
es
t
s and fix
e
s
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More fi
x
es for d
i
fferent window frame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ken
n
edy
Fix "RANGE
BETWEEN
C
URRENT ROW AND UNBOUNDED FOLLOWIN
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan K
e
nnedy
M
e
rge lat
e
st trunk ch
a
nges
i
nt
o
this
branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fixe
s
f
or "ROW
S
BETWEEN <expr>
F
OLLOWING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nned
y
Allow "<expr> PRECEDING" t
o
be used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
K
ennedy
Support o
t
her f
r
am
e
t
y
pes that use "<expr>
P
R
ECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
D
a
n
K
e
nnedy
Add support for "ROWS BETWEEN
<
expr> PREC
E
D
I
NG AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Kennedy
Merge latest tr
u
nk
c
hange
s
into this
b
ran
c
h
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Add comme
n
ts to win
d
ow
.
c describing how oth
e
r
win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begi
n
addin
g
suppor
t
for
more esote
r
ic
w
indow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan
Kennedy
Fix minor
problems on this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kenn
e
dy
Evaluate multiple w
i
n
d
o
w functions in a sing
l
e
p
ass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Handle multiple wi
n
dow-functions in
a
singl
e
q
u
ery
.
commit
|
commitdiff
|
tree
2018-05-16
D
a
n
K
ennedy
Start of ex
p
erime
n
t
a
l
i
m
plementation of SQL windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Ke
n
nedy
Fix a test case p
r
oblem in whe
r
elimi
t
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan
K
ennedy
Add a test cas
e
t
o
c
h
e
c
k
that the
fts5 uni
c
ode64 to
k
enize
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Ke
n
nedy
Fix a probl
e
m in
t
he xBestIndex met
h
od of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kenne
d
y
Fix
an
RBU problem causing
spurious
S
QLITE_
C
ON
S
TR
A
INT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
K
e
n
nedy
Update t
e
st s
c
ript fts3ex
p
r4
.
tes
t
so
that
i
t
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
Kennedy
F
ix a t
e
s
t s
c
ript error c
a
using tests
to fail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
an Kenned
y
When
p
roces
s
ing a
n
"
ORD
E
R
BY
.
.
.
L
I
M
IT" that
does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When processi
n
g
an "
O
RDER BY
.
.
.
LIMIT
"
that d
o
es not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Ken
n
edy
Update the "fuzz_malloc
.
test" script to pr
i
nt SQL state
m
ents
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Ke
n
nedy
R
emove a rec
e
ntly added NE
V
E
R
() macro from a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ken
n
edy
Fix
a
problem with pr
o
cessing "LEFT JOIN tb
l
O
N tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Do not attempt to
read values
f
rom inde
x
es-on-e
x
pre
s
sions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan K
e
nne
d
y
A
f
e
w
more test
s
for up
s
e
r
t
.
commit
|
commitdiff
|
tree
2018-04-20
Da
n
Kennedy
Enhance the "rbu" comm
a
nd line
u
t
i
lity
a
bit
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n
K
e
n
nedy
Add tests for n
a
me res
o
l
u
tion
i
n ON
CONFLI
C
T clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
A
dd test ca
s
e
s for UP
S
ERT
.
And
a fix
f
or a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Modify a test
c
a
se in zipfile2
.
t
e
st to
take into account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
K
e
nned
y
A
dd th
e
"so
r
t
e
r-reference" optim
i
zation, allowing S
Q
Lite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
an Kenne
d
y
Mino
r
ch
a
n
g
es to test script upsert4
.
tes
t
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
Kennedy
Add
extr
a
test case
s
fo
r
UPS
E
RT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kenned
y
Fix a
p
roblem in the s
h
ell preventing it from worki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
A
d
d
s
ome more simpl
e
test cases for UPSERT
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Da
n
Kennedy
Add SQ
L
I
T
E_
C
ONFIG_
S
ORTERREF
_
SIZE
c
o
nfiguratio
n
option
.
commit
|
commitdiff
|
tree
2018-04-14
D
an
K
ennedy
Experim
e
ntal ch
a
nge to "S
E
LECT * FROM
.
.
.
ORDER
B
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Kennedy
Minor simplification to inter
n
al
fu
n
ct
i
on generateSo
r
tTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ken
n
edy
Fix a pr
o
ble
m
c
a
u
sing the L
E
FT JO
I
N streng
t
h reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenn
e
dy
Wh
e
n test
i
n
g, avoid inj
e
cting a
n
OOM fault
i
nto a f
i
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix a prob
l
em
causing th
e
LEFT JOI
N
strength reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix the fts5 xB
e
stIndex m
e
t
h
od so that it
i
s not conf
u
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Da
n
Ke
n
nedy
Add
a
"flags" paramet
e
r
to experimental
API sqlite
3
changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan
Kennedy
Fix a pro
b
lem in the
s
ession
s
module c
a
using sqlite3session_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Ke
n
nedy
Fix an insta
n
ce whe
r
e an uninitialized VM re
g
ist
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
U
p
d
ate speedtest1
.
c wi
t
h new testset "trigge
r
" b
a
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
an Kennedy
Fix a
f
e
w
s
m
all test script issues af
f
ec
t
ing SQL
I
TE
_
TE
M
P_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan Kenned
y
Fix an
a
ssertion fail
u
r
e t
r
i
gge
r
ed by a SELEC
T
with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Another chan
g
e to test
file zipfile
.
test to h
e
lp
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Fi
x
a test script bug
c
a
using zipfile
.
t
est to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Da
n
Kennedy
U
pdate memdb
1
.
test so that it works with SQLITE_DEFAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kennedy
Ad
d
-DSQL
I
TE_ENABLE_DESERIALIZ
E
to the "Device
-
Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Ken
n
edy
Fix
a typo preventi
n
g te
s
t script avtrans
.
t
est from
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kennedy
Fix
a
test script p
r
oble
m
causing
s
hell1
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
a
n Kennedy
Fix typos in
s
qli
t
e3s
e
ssion
.
h preve
n
ting
d
ocumentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan K
e
nnedy
Fix minor probl
e
ms with passing
N
ULL pointer
s
to
m
e
mcmp
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ke
n
nedy
Add APIs to
t
he sess
i
o
n
s module
f
or "reb
a
sing" c
h
angesets
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ke
n
nedy
R
emove some unu
s
ed
code from
s
q
lite3rebaser_r
e
base
(
)
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Fix another pr
o
blem wit
h
reb
a
sing u
p
da
t
es against
multi
p
le
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan
K
ennedy
Fix an RBU pr
o
blem ca
u
sing errors when updating
t
ables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ken
n
edy
Fix a test
s
c
r
ipt problem causing r
b
uvacuum
.
t
e
s
t to
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
a
n Ke
n
nedy
Add t
e
s
ts to e
n
su
r
e t
h
at patchsets
a
r
e
handled
c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenn
e
dy
R
e
move
s
ome unused code
from t
h
e s
e
ssions modul
e
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kennedy
M
e
rg
e
l
a
t
est tr
u
nk changes into this
branch
.
commit
|
commitdiff
|
tree
2018-03-21
D
a
n Kenne
d
y
Fix some docum
e
ntation and other issues
w
ith the code
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
a
n
Ken
n
edy
Fix re
b
asing of UPDATE
c
hange
s
against a set of rem
o
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
a
n K
e
n
n
edy
Add further tests
a
nd docu
m
entatio
n
for
t
he ses
s
ions
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Fix handling of "UPDATE OR REP
L
ACE" statemen
t
s run
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kenned
y
Add a test c
a
s
e for the fix on t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-03-16
Dan
K
en
n
e
dy
F
ix
a pro
b
lem
with handli
n
g
r
ebasing
UPDATE changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan
K
en
n
edy
Fi
x
a problem in test scr
i
pt th
r
ea
d
0
0
1
.
tes
t
c
ausing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Kennedy
Add simple tes
t
s for the
s
ess
i
on
s
module
r
ebase
API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Kennedy
Add la
r
gely untested
A
PIs for rebasing change
s
ets
.
commit
|
commitdiff
|
tree
2018-03-14
Dan
K
e
nne
d
y
I
m
p
r
ove detection of out-of-range parameters in sqlite
3
_stmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
Dan
Kennedy
Add sql
i
te3_changeset_apply_v2() and apply_v2_strm
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Da
n
Kennedy
Fix a typo
c
ausi
n
g SQLITE_LOG_
C
AC
H
E_
S
P
I
L
L buil
d
s
to
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
a
n K
e
n
n
edy
F
i
x a
problem in tes
t
file nockpt
.
test ca
u
sing error
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
Dan Kenn
e
dy
Avoid running a couple of tests in c
r
ash8
.
test that
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
Dan Ke
n
nedy
F
i
x another crash i
n
the
session
s
module trigge
r
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
In s
q
lite
3
_c
h
ecker, wrap t
h
e call t
o
"SE
L
ECT checkfreelist
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
D
a
n Kennedy
In
a
c
h
ec
k
point
,
figure out
if it is
pos
s
ible t
o
checkp
o
i
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan
Ken
n
edy
Optimize the obscure case of running a check
p
oin
t
agai
n
st
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan Ken
n
edy
F
ix furth
e
r
c
rashe
s
in sqlite3cha
n
g
eset_apply()
c
aused
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
an Kennedy
Fix some crashes
i
n the sqlite3changes
e
t_appl
y
() function
.
.
.
commit
|
commitdiff
|
tree
2018-02-17
Dan Kennedy
Fix a da
t
a race ca
u
sing a tsan complaint with SQL
I
TE_ENAB
L
E
_
.
.
.
commit
|
commitdiff
|
tree
2018-02-13
Da
n
K
e
n
n
edy
E
n
sure
tha
t
multiple updates of the
s
a
me FT
S
4 row
.
.
.
commit
|
commitdiff
|
tree
2018-02-12
Dan Kenne
d
y
Upda
t
e
test file fu
n
c6
.
test so
that it wo
r
ks w
i
t
h
SQLITE_ENA
.
.
.
commit
|
commitdiff
|
tree
2018-02-09
Dan Kennedy
Make the te
s
ts in f
u
nc6
.
test
m
ore rob
u
st against impl
e
ment
a
t
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
D
an
Kennedy
In ext
e
nsi
o
ns rtree,
fts3 and
f
ts5, en
s
ure that when
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan
Kennedy
When th
e
final co
n
nection dis
c
onnects
f
rom
a
wal mode
.
.
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
Fix a
n
other minor
pro
b
lem in wal
r
o2
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
Up
d
ate
test file walro2
.
test
to account
f
or systems
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan Kenne
d
y
Remove the
"
i
n
clu
d
e <io
.
h>" win32 dep
e
ndency from t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan Kenn
e
dy
Remove t
h
e time
(
)
d
e
p
endency from the zipfile extension
.
.
.
commit
|
commitdiff
|
tree
2018-02-01
Dan Ke
n
nedy
A
d
d a few m
o
re
zipfile tests
.
No changes
t
o code
.
commit
|
commitdiff
|
tree
next