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 support f
o
r window func
t
ion
s
row_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Ken
n
edy
Allow an entire part
i
tion
to be
cached
in a
t
emp table
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow min()
and max()
t
o be used as wi
n
d
ow functi
o
ns
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenn
e
dy
F
u
rther window frame tests and fixes
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More fixes for di
f
fere
n
t
w
indow fram
e
t
ypes
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix "R
A
N
G
E
B
ETWE
E
N CURRENT
ROW AND UNBOUND
E
D FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Ken
n
edy
Merge latest t
r
unk c
h
anges into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
F
i
xes
f
o
r "ROWS BETWEEN
<
expr> FOLLOWING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
Kenne
d
y
A
l
l
o
w "<expr> PRECEDI
N
G
"
to be used to spec
i
fy
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Support other fram
e
ty
p
e
s
that use "
<
expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
D
a
n Kennedy
Add support for "ROWS BETWEEN <expr
>
PRECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
K
ennedy
Merge latest
trunk c
h
an
g
es into t
h
is branc
h
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenn
e
d
y
Add comments to window
.
c describi
n
g how
o
t
h
er win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin adding
support
f
or more e
s
o
t
e
ric window fr
a
mes
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix
minor pro
b
lems on t
h
is br
a
n
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evaluate mul
t
iple window functi
o
ns i
n
a single pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan K
e
nnedy
Handl
e
multiple window-function
s
in a single
q
uery
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
S
tar
t
of experime
n
t
al imple
m
entatio
n
of SQL
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
Fix a test case
problem i
n
wherelimit
.
tes
t
.
commit
|
commitdiff
|
tree
2018-05-09
D
an
Kenne
d
y
Add a
tes
t
ca
s
e to check that
t
h
e f
t
s5 u
n
ico
d
e64 tokeni
z
er
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan K
e
nnedy
F
ix a problem in the
xBestIndex
m
etho
d
of th
e
c
l
osure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
an Kennedy
Fix an
RBU problem
causing spuri
o
us S
Q
LITE_CONSTRA
I
NT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Da
n
Kennedy
Update test s
c
ript fts3exp
r
4
.
test so that it alway
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix a test script error
c
ausing
t
e
s
t
s to fail in so
a
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
W
h
en proc
e
s
sing a
n
"ORDER
B
Y
.
.
.
LIMIT" tha
t
does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Wh
e
n pr
o
cessing an "ORDER BY
.
.
.
LIMIT" that does
no
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenne
d
y
Update
t
h
e
"fuzz_ma
l
loc
.
test" script t
o
print SQL
sta
t
ements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
a
n Kennedy
Remove a recent
l
y added NEVER(
)
macro
f
ro
m
a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
an Kennedy
Fix
a problem with processin
g
"LEF
T
JO
I
N
tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
Ke
n
nedy
Do not attem
p
t
t
o read values from inde
x
es-on-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Kennedy
A few more
tests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Enhance the "rbu
"
comman
d
line ut
i
lity a bit
.
commit
|
commitdiff
|
tree
2018-04-20
Dan
Kennedy
Add
t
e
s
ts for na
m
e
r
esolution in
O
N
CONFL
I
CT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add test cases for
UPSERT
.
And a fix f
o
r a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Ke
n
nedy
Modify a test case in z
i
pfile2
.
test
to
take in
t
o accou
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
Kennedy
A
d
d t
h
e
"sorter-reference
"
optimizat
i
o
n
, a
l
lowing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Minor changes to test sc
r
ipt upsert
4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add extra test ca
s
es
f
or UPS
E
RT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ke
n
ne
d
y
Fix
a
problem
i
n the shell preven
t
ing
i
t f
r
om working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan
K
ennedy
Add some more simp
l
e test cases for UPSERT
.
An
d
a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
a
n Ke
n
n
edy
Add SQL
I
TE_CON
F
IG_SO
R
TERREF_SIZ
E
configuration option
.
commit
|
commitdiff
|
tree
2018-04-14
D
an Kennedy
Exp
e
rimental
change to "SELECT *
F
R
O
M
.
.
.
ORD
E
R BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Ken
n
e
d
y
M
i
nor simplif
i
catio
n
to
inte
r
n
a
l function genera
t
eSortT
a
i
l()
.
commit
|
commitdiff
|
tree
2018-04-10
D
a
n Ken
n
edy
F
ix a
problem causing the
LEFT JOIN s
t
rength re
d
uction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
K
ennedy
When test
i
n
g
,
avoi
d
injectin
g
an OOM
f
a
ult
i
n
to a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
an Kennedy
Fix
a
pr
o
blem
c
ausi
n
g the LEF
T
JOIN strength re
d
u
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kenned
y
F
i
x the fts5 x
B
e
stIndex me
t
hod
s
o that it is n
o
t confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kenned
y
Add a "fl
a
g
s" parameter to experimental API sqlit
e
3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
a
n K
e
nnedy
Fix a problem
in
the
sessions
module causing sqlit
e
3
s
ession_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
an
K
e
n
ne
d
y
Fi
x
an instance w
h
ere
an unini
t
ialized
VM regis
t
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Update speedtest1
.
c
with n
e
w
te
s
tset "trigger" b
a
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
a
n
K
enned
y
Fix a few small t
e
st script iss
u
es affecting SQLITE_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
a
n Kenn
e
d
y
Fix an assertion failur
e
triggered by
a SELECT with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kenne
d
y
A
no
t
her change to test
fil
e
zi
p
file
.
test
t
o help it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan
Ke
n
nedy
Fix
a test script
b
ug causing z
i
pfile
.
t
e
st to fai
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
U
p
date memdb1
.
test s
o
that it wor
k
s with SQL
I
TE_DEFAULT_
A
UT
O
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan
K
ennedy
Ad
d
-DSQLITE
_
ENA
B
LE_DE
S
E
RIALIZE
to the
"
Device
-
Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Kenne
d
y
Fix a typo prev
e
ntin
g
t
est s
c
ript avtrans
.
tes
t
f
rom
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kenned
y
Fix a test scr
i
pt
p
roblem
c
ausi
n
g shell1
.
tes
t
to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
an
Ken
n
edy
Fix typos in
s
qlite3se
s
sion
.
h preventing doc
u
mentatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan
K
ennedy
Fix mi
n
o
r
problems with
p
a
ssing
NULL pointers to memcmp
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Add APIs t
o
t
h
e
sessions module for
"
reba
s
ing" changesets
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
R
e
mov
e
som
e
u
n
used
c
ode
f
r
om sql
i
te3rebas
e
r
_
rebase()
.
commit
|
commitdiff
|
tree
2018-03-22
D
an Kennedy
Fix an
o
t
h
er problem wi
t
h rebasing upda
t
es ag
a
inst
mult
i
p
le
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenne
d
y
Fix an RB
U
pr
o
blem causin
g
erro
r
s when u
p
dating
t
ab
l
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Fix
a
test
script
p
roblem causing rbuvacuum
.
test to
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenn
e
dy
A
d
d tests to
ensure that patchsets
a
re hand
l
e
d
correctly
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan K
e
nned
y
Re
m
ove some
u
nus
e
d
code from the sessions module
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kennedy
Mer
g
e
latest trunk
changes into t
h
is bra
n
ch
.
commit
|
commitdiff
|
tree
2018-03-21
Dan
Kennedy
Fix some documentation and othe
r
i
ssues wi
t
h the code
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kenned
y
Fix rebasi
n
g of U
P
DATE
chang
e
s agains
t
a
s
e
t
of remote
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
an K
e
nned
y
Ad
d
f
u
rther test
s
a
nd do
c
umentation
f
or the s
e
ssions
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Fi
x
handl
i
ng
of "UPDA
T
E OR
R
E
P
LA
C
E" sta
t
ements run
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kenne
d
y
Add a test
ca
s
e for
t
he fix on this branch
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
Fix a p
r
oble
m
with handling reb
a
s
i
ng
U
P
D
A
T
E c
h
a
nges
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan
Ke
n
n
e
dy
Fix a problem in
t
est script th
r
ead001
.
test causing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Kennedy
Ad
d
simpl
e
t
ests
fo
r
the sessi
o
ns
module rebase API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Kennedy
A
d
d largely
untested
APIs for rebasing changesets
.
commit
|
commitdiff
|
tree
2018-03-14
Da
n
K
e
nnedy
Impr
o
ve detection of
o
ut-
o
f-ran
g
e parameters
i
n
sqlite3_stmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
Dan Kenn
e
d
y
Add sqlite
3
_
c
hangeset_apply_v2() and apply
_
v2_strm
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Dan Ke
n
nedy
Fix a typo c
a
u
s
ing SQLITE
_
LOG_CAC
H
E_
S
PILL build
s
to
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
an
Ke
n
nedy
F
i
x
a
problem in te
s
t file nockpt
.
test causing errors
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
Dan Ke
n
nedy
Avoi
d
running a cou
p
le of tests
i
n cr
a
sh
8
.
test that
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
Dan Kenn
e
dy
Fix a
n
other c
r
ash in the
sessions module trigger
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
In sqlite3_checker, wr
a
p the call to "SELEC
T
c
h
e
ckfreelist
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
In a
c
heckpoint,
figu
r
e out
i
f it
i
s
p
ossible to checkpoint
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan K
e
n
nedy
Opt
i
mize the
o
b
s
c
u
re case of running a chec
k
point
agai
n
st
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan Kenne
d
y
Fix further
crashes
in
s
q
l
ite3changes
e
t
_apply() caused
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
a
n Kenne
d
y
F
ix some crash
e
s in t
h
e
sqlit
e
3changes
e
t_apply() function
.
.
.
commit
|
commitdiff
|
tree
2018-02-17
Dan
K
enned
y
Fix
a data race causing a ts
a
n complaint with
SQLITE_
E
NABLE_
.
.
.
commit
|
commitdiff
|
tree
2018-02-13
D
a
n
K
e
nnedy
Ensure that m
u
ltiple updates of t
h
e same FTS4 row
.
.
.
commit
|
commitdiff
|
tree
2018-02-12
Dan Kenne
d
y
Update test
f
ile
func6
.
test
s
o
that it works with SQ
L
ITE_ENA
.
.
.
commit
|
commitdiff
|
tree
2018-02-09
Da
n
K
e
nnedy
Make the te
s
ts in func6
.
test more
robust against implementat
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Ke
n
ned
y
In extensions
r
tree, fts3 a
n
d fts5,
e
ns
u
r
e
that when
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Kennedy
W
h
en
t
he fin
a
l
con
n
ection dis
c
onnects from a
w
al mode
.
.
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
Fix a
n
othe
r
minor problem in walro2
.
test
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
Update
t
est fi
l
e walr
o
2
.
test
t
o acco
u
n
t
f
o
r
s
ystem
s
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
D
an Kennedy
Remo
v
e the "include <io
.
h>" win32 dependency
from
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan Kennedy
Remo
v
e
t
h
e
t
ime(
)
dependency
f
r
om
th
e
zipfile extension
.
.
.
commit
|
commitdiff
|
tree
2018-02-01
Dan Kenned
y
Add a few m
o
re zipfile tests
.
No changes to code
.
commit
|
commitdiff
|
tree
next