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
D
a
n
Kennedy
Add support for w
i
ndow fun
c
tio
n
s row_number(
)
, rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
Allow an entire partitio
n
to be cached
i
n
a temp tab
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Da
n
Kennedy
A
l
low mi
n
()
a
n
d
ma
x
(
)
to
b
e
used as window fu
n
c
t
ions
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Further window f
r
ame tests
and fixes
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Ke
n
nedy
More fixes f
o
r different window f
r
a
me types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenne
d
y
Fix
"
RANGE BETWEEN
C
U
RRE
N
T
ROW AND UNBOUNDED FO
L
L
OWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge lates
t
t
runk c
h
ange
s
into this branc
h
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
Kennedy
Fixes for "ROWS BETWEEN <expr> FOL
L
O
WING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Allow "<expr> PRECEDIN
G
"
t
o be used to spec
i
fy the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Kennedy
Su
p
p
o
rt other frame types that use "<ex
p
r> PR
E
CEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add support for
"ROWS BETWEEN <expr> PREC
E
DING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merge la
t
est trunk chang
e
s i
n
to this branch
.
commit
|
commitdiff
|
tree
2018-05-22
D
an Kennedy
Add c
o
mmen
t
s
to window
.
c descri
b
ing ho
w
o
ther window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
D
a
n Kenned
y
Begin
a
d
ding support for mor
e
esote
r
ic win
d
ow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kenn
e
dy
Fix min
o
r proble
m
s on this branc
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kenn
e
dy
Eva
l
uate mult
i
ple w
i
ndow
f
unctions in a sing
l
e pas
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kennedy
Handl
e
multiple windo
w
-functions i
n
a s
i
ngle query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
S
t
art of e
x
pe
r
im
e
n
tal implementation of S
Q
L window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
D
a
n Ken
n
edy
Fix a test ca
s
e
prob
l
em in wher
e
limi
t
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add a test case to check that the fts5 unicode64 to
k
e
n
iz
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kenned
y
Fix a problem in the xBe
s
tIndex me
t
hod of the clo
s
ur
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan
Kenne
d
y
Fix an R
B
U
p
r
o
blem causing spur
i
ous SQLITE_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenne
d
y
Up
d
ate t
e
st
s
crip
t
fts3e
x
p
r
4
.
test so that it always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix a t
e
st s
c
r
i
pt erro
r
causing tests
t
o fa
i
l in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
Wh
e
n pro
c
essing an "ORDER BY
.
.
.
LIMIT" that do
e
s not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Ken
n
edy
When p
r
o
ces
s
ing an "ORDER BY
.
.
.
LIMIT"
that does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Update the
"fuzz_mal
l
oc
.
test"
script
t
o print
S
Q
L stat
e
ments
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
K
ennedy
Remove a re
c
ently
a
dded NEVE
R
(
) macro
f
rom
a
branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
K
enned
y
Fix a pro
b
lem with pr
o
c
e
ssi
n
g "LEFT
J
OIN tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Ken
n
e
dy
Do not
attempt to
r
ead valu
e
s f
r
o
m
indexes-on-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Ke
n
nedy
A few more tests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Enhanc
e
the
"
rbu" c
o
mmand line utility a bit
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n Kennedy
Add tes
t
s for
n
ame resolu
t
ion in ON CONFLI
C
T clauses
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n Kenned
y
A
d
d tes
t
cases for UPSER
T
.
And a
f
i
x
for a "R
E
PLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Modify
a test case in zi
p
fil
e
2
.
test to
t
ake into acc
o
unt
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
edy
A
dd the "sorter
-
reference"
o
p
t
imiza
t
ion,
a
llo
w
ing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ke
n
nedy
Minor ch
a
nges to
t
est script upsert4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
Dan K
e
nnedy
A
d
d extra test ca
s
es for UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix a prob
l
em in the shell preventing
it
f
r
o
m working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan
K
e
nnedy
Add some more
s
impl
e
test cases f
o
r UPSERT
.
A
n
d a m
i
no
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan Kennedy
Add
SQLITE_CONFIG_
S
ORTE
R
RE
F
_SIZE configuration option
.
commit
|
commitdiff
|
tree
2018-04-14
Da
n
Kennedy
Ex
p
er
i
ment
a
l
chan
g
e to "SE
L
ECT * FR
O
M
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan
Kennedy
Minor simplification to inte
r
nal fu
n
ction generateSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ke
n
n
e
dy
Fix a problem
c
ausing
the
L
EFT JO
I
N str
e
ngth reductio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenn
e
dy
When testing
,
avoid i
n
jecting an
O
OM fault into a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
a
n
K
e
n
nedy
Fix a problem
c
aus
i
n
g
t
h
e LEFT
J
O
IN strength r
e
duction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Da
n
Kennedy
Fix the f
t
s
5
x
BestIndex method so that it is not confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Add a "flags" parameter to
e
x
perimen
t
al API sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
a
n Kennedy
Fix a pro
b
lem in t
h
e
s
essions module causing sqlite3ses
s
ion_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Da
n
Kennedy
F
ix an ins
t
ance where an uninitialized
V
M
regis
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Update s
p
eedtest1
.
c with new tests
e
t "trigger" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
an Kennedy
Fix a few
smal
l
test script
issues aff
e
c
t
ing
S
QLITE_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Da
n
Kennedy
Fix an asse
r
tion failu
r
e triggered
b
y
a SE
L
ECT with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
An
o
ther c
h
a
nge t
o
t
e
st file zi
p
file
.
t
e
st to help it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Fix
a test script bug
c
ausing zipfi
l
e
.
t
e
s
t to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n Kenne
d
y
Update memdb1
.
t
e
st so tha
t
i
t
work
s
w
i
t
h
SQLITE_D
E
FAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kenne
d
y
Add -DSQL
I
T
E_ENABL
E
_DESERIAL
I
ZE to the "Device-Tw
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan K
e
nnedy
Fi
x
a typo p
r
eventi
n
g tes
t
script avtrans
.
test from
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kennedy
Fix a t
e
st sc
r
ipt problem causing shell1
.
test to
f
a
i
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Kennedy
Fix typos
i
n
sqlite3
s
e
s
sion
.
h prev
e
nting docum
e
ntation
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Kenned
y
Fix minor pro
b
lem
s
with
passing N
U
L
L pointers to memcmp
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan K
e
n
n
ed
y
Add APIs to
the s
e
ssio
n
s
module for "rebasin
g
"
c
hanges
e
t
s
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenn
e
d
y
Remove some un
u
sed code fr
o
m s
q
lit
e
3rebaser_rebase()
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ke
n
ne
d
y
F
i
x
another pro
b
lem
with
r
eba
s
ing updates against multi
p
le
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Fix
a
n
R
BU probl
e
m
c
ausin
g
e
rrors when
updating t
a
bles
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
a
n Kennedy
Fix a
t
est script
proble
m
causing
rbuvacuum
.
test to
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Add test
s
to e
n
sure that patchsets
a
re handled
corre
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Remove some unused cod
e
fr
o
m
t
he sessi
o
n
s
m
odul
e
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kenned
y
M
erg
e
la
t
e
s
t t
r
unk changes into this b
r
anch
.
commit
|
commitdiff
|
tree
2018-03-21
Da
n
Kenn
e
dy
Fix some documentation and
o
th
e
r iss
u
es with the
c
ode
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
an Kennedy
Fi
x
rebasing of
U
P
DATE changes against a set o
f
remote
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Add further tests an
d
doc
u
mentation
fo
r
the sessions
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Fix handlin
g
of "UPD
A
TE OR
R
E
P
LACE" statements run
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Add a test c
a
se for the f
i
x on this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
Fix a problem with ha
n
dling re
b
as
i
ng
U
PD
A
TE cha
n
ges
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
Fix a problem
in test s
c
ript thread001
.
test
c
a
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Kennedy
A
dd simple tests
f
or the sessi
o
ns module r
e
b
ase API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Kennedy
Add larg
e
l
y un
t
ested APIs
for rebasin
g
change
s
ets
.
commit
|
commitdiff
|
tree
2018-03-14
Dan
Ken
n
edy
I
m
pr
o
ve d
e
tection of
o
ut-of-range parame
t
ers in sql
i
te3_stmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
Dan Kennedy
Add sqlite3_changese
t
_apply_v2()
and
a
pply_
v
2_strm
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Dan Kennedy
F
ix a
t
y
po c
a
u
sing
S
Q
LITE_LOG
_
CACHE_SPILL builds to
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
Dan
Kennedy
Fix
a proble
m
in tes
t
file nockpt
.
test causing errors
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
Dan Kennedy
Avoid running a coupl
e
of te
s
ts in
crash8
.
test that
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
an Kenne
d
y
Fix another crash in the se
s
sions module triggered
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
In sqlite3_checker,
w
rap the
call to "
S
ELEC
T
chec
k
freelist
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
D
a
n
Kennedy
In a checkpoint, figure o
u
t if it is possible to
c
h
eckpoint
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan
K
ennedy
Optimize the obsc
u
r
e
case of r
u
nning a checkpoint
ag
a
i
n
st
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan Kennedy
Fix
f
u
r
ther c
r
ashes in sqlite3changeset_apply() caus
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan Ke
n
ned
y
Fi
x
s
o
me crashes
i
n
t
he sqlite3changeset_apply() function
.
.
.
commit
|
commitdiff
|
tree
2018-02-17
Dan Kennedy
Fix a da
t
a race ca
u
sin
g
a tsan complaint with SQLITE_ENA
B
LE_
.
.
.
commit
|
commitdiff
|
tree
2018-02-13
Dan Kennedy
Ensure that mu
l
tiple upd
a
te
s
of the
same FTS4 row
.
.
.
commit
|
commitdiff
|
tree
2018-02-12
D
an Kennedy
Update test file func6
.
test so that
i
t
w
or
k
s with SQLITE_ENA
.
.
.
commit
|
commitdiff
|
tree
2018-02-09
Dan Kennedy
Make the tests in func6
.
test more robust agains
t
implement
a
t
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Kennedy
In extensions
rtree, fts3 a
n
d fts
5
,
e
nsure
t
h
a
t wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Kenn
e
dy
When
the final c
o
nnection dis
c
onn
e
cts from a wa
l
mode
.
.
.
commit
|
commitdiff
|
tree
2018-02-05
Dan K
e
n
ned
y
F
ix anothe
r
minor
p
roblem in wa
l
ro2
.
t
es
t
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kenned
y
Upd
a
te test f
i
le walro2
.
test to account for systems
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan Kennedy
R
e
m
ove the "include <io
.
h>" win32 dependency fr
o
m t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan Kenne
d
y
Remo
v
e the time() dependency from the zipfile extension
.
.
.
commit
|
commitdiff
|
tree
2018-02-01
D
an Kennedy
Add a few
m
ore
zi
p
fi
l
e tests
.
No changes to
code
.
commit
|
commitdiff
|
tree
next