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 Kenn
e
d
y
Add support
f
o
r window
f
unctions row_number
(
)
,
r
ank
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allow
an entire par
t
ition to be cached
in a temp
tab
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan K
e
nnedy
Allo
w
m
in() and ma
x
()
t
o b
e
used as w
i
ndow functions
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Further window frame test
s
and fixes
.
commit
|
commitdiff
|
tree
2018-05-26
Da
n
Ke
n
nedy
More
fixes for d
i
ff
e
rent
window
f
r
ame types
.
commit
|
commitdiff
|
tree
2018-05-25
D
an Kennedy
Fix "R
A
N
GE
BETWEEN CURRENT ROW A
N
D
U
NBOUNDED FOLLOW
I
NG
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge latest trunk changes into this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
Kennedy
Fixes for "ROW
S
B
ETWEEN <exp
r
> FOLLO
W
ING AND <
e
xpr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Al
l
o
w
"<expr>
P
REC
E
DING" to be us
e
d
to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Ke
n
nedy
S
upport oth
e
r f
r
ame types that use "<expr> PR
E
CEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan K
e
nnedy
Add su
p
port for "RO
W
S
BETWEEN <exp
r
>
P
RECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenned
y
Merge late
s
t t
r
u
n
k changes into this br
a
nch
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n K
e
nn
e
dy
Add co
m
ments t
o
window
.
c des
c
ribing how other w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin
adding s
u
p
p
ort fo
r
more
e
s
oteric wi
n
dow fra
m
es
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Ken
n
e
d
y
Fix mino
r
problems
o
n this br
a
nch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evaluate mu
l
tiple window fun
c
ti
o
ns in a sin
g
le
pas
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kenn
e
dy
H
andl
e
multiple wind
o
w-functions in
a
single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Star
t
of experimen
t
al
i
mplementatio
n
of
S
QL w
i
n
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan K
e
nn
e
d
y
Fix a
t
est
c
a
s
e problem in where
l
imit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kenn
e
dy
Add a
tes
t
ca
s
e to che
c
k that the fts5 u
n
icode64
tok
e
nizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Ke
n
nedy
Fix a proble
m
in
the xBestIndex me
t
hod of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
an
K
e
n
ne
d
y
F
i
x
an RBU problem
c
ausing spurio
u
s
SQLI
T
E_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Up
d
ate
t
e
st script f
t
s3e
x
pr4
.
test so that it always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan K
e
nnedy
Fix
a
te
s
t
sc
r
ipt error
caus
i
ng tests to fail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When pro
c
essing an "ORDER BY
.
.
.
L
I
MIT" tha
t
d
o
es n
o
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
When
pro
c
essing an "ORD
E
R B
Y
.
.
.
LI
M
IT" that does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
a
n Kennedy
U
p
d
ate
t
he
"fuzz
_
malloc
.
test" sc
r
ip
t
to print SQL state
m
en
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Remove a recently
a
dded N
E
VER() macro
f
r
om a br
a
nch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
F
i
x a p
r
obl
e
m
wit
h
processing "LEFT
J
OI
N
tb
l
ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenned
y
Do not attempt to r
e
a
d values from
i
n
dex
e
s
-
on-expres
s
ions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan K
e
nnedy
A few more t
e
sts for
up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
En
h
ance the "rbu" command line utility a bit
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Ad
d
tests for name resolution in ON CONFLICT clau
s
e
s
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add test cases for UPSERT
.
And a fix
f
o
r a "R
E
PLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
a
n
K
ennedy
Modify
a te
s
t case in
zipfile2
.
t
e
st
t
o take into accou
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add the "s
o
r
ter-referen
c
e
"
optimizati
o
n
, a
l
lowing SQLi
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
Kenn
e
dy
Mi
n
o
r c
h
anges to test script
u
psert4
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Ad
d
extra test cases for UPSER
T
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix a proble
m
in th
e
shell preventing it from
w
o
r
k
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
a
n Kennedy
Add some mo
r
e simple
t
est cases for UP
S
ERT
.
A
n
d a mino
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan Kennedy
Add S
Q
LITE_CONFIG_SORTERREF_SIZE configuration option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kenne
d
y
Exp
e
r
imental chang
e
to
"
S
ELE
C
T * FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan
K
ennedy
M
i
nor simplific
a
tion to i
n
ter
n
al
functi
o
n genera
t
e
SortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix
a
problem
causing th
e
LEFT JOIN
s
trength reductio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When tes
t
ing
,
avoid injectin
g
an OOM fault
i
nt
o
a
f
il
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
Kennedy
Fix a problem causin
g
the LEFT JOIN stren
g
t
h
r
e
duction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan K
e
nnedy
Fix
the fts5 xB
e
stI
n
dex method so that it i
s
not confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan
K
enne
d
y
Add a "flags"
p
a
r
ameter to experimental
API sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
an
K
ennedy
Fix a problem in
the sess
i
ons module cau
s
ing sqlite3ses
s
ion_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Kennedy
Fix an
i
n
sta
n
c
e
w
he
r
e
an
uninitialized
VM
register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Update sp
e
edtest1
.
c wi
t
h
n
e
w
testset "
t
rigger" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Fix a f
e
w
small t
e
s
t
s
c
ript issues affec
t
ing S
Q
LITE_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan Kenned
y
Fix an as
s
ertion failure trig
g
ered by a SELECT with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n
Kennedy
Another cha
n
ge to test file zipfi
l
e
.
t
e
st to
hel
p
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n
K
ennedy
Fix a test script bug causing zipfile
.
te
s
t
to
fai
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Update
memd
b
1
.
test
s
o that it w
o
rk
s
with SQLITE_DEFA
U
LT_A
U
TO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kenned
y
Add -DS
Q
LIT
E
_ENABLE_D
E
SE
R
IALIZE to the "Device-Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan
K
ennedy
Fix a typo preven
t
ing test
sc
r
ipt
avtrans
.
t
e
s
t
from
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kenn
e
dy
Fix a tes
t
script
prob
l
em causi
n
g sh
e
ll1
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Kennedy
F
ix
t
ypos in
sqli
t
e3
s
ession
.
h prev
e
nting documentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Kenn
e
dy
F
ix
m
inor
p
roblem
s
wit
h
passing N
U
LL pointer
s
to memcm
p
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenned
y
Add APIs to th
e
sess
i
ons module for "r
e
bas
i
n
g"
c
hangese
t
s
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenne
d
y
R
emove some unused code
f
r
om sqli
t
e3re
b
aser_rebase()
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ke
n
nedy
Fix
anot
h
e
r proble
m
with reb
a
sing updates ag
a
inst multiple
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenn
e
dy
Fi
x
an RBU problem causi
n
g errors when up
d
a
t
ing t
a
bles
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Fix a test script problem causing rbuvacu
u
m
.
t
est to
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenn
e
d
y
Add tests
to ensure tha
t
pa
t
chsets are han
d
led c
o
rrect
l
y
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan
K
ennedy
Remove some u
n
used
c
o
d
e from
t
h
e sessions modul
e
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kenne
d
y
Mer
g
e latest trunk changes i
n
to
t
his
b
ranch
.
commit
|
commitdiff
|
tree
2018-03-21
D
a
n Kennedy
Fix some documentat
i
on
a
nd other iss
u
es with the code
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
Dan
Kenn
e
dy
Fix
r
e
basing of
U
PDAT
E
changes against a set of remo
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Ke
n
nedy
Add
f
u
r
t
her tests a
n
d d
o
cumentati
o
n for
t
he sessi
o
ns
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
an Kenn
e
dy
Fi
x
handli
n
g of "UPDATE OR REP
L
AC
E
" statemen
t
s ru
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kenned
y
A
dd
a te
s
t case fo
r
th
e
fix
on
this branch
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
F
ix
a
pro
b
lem wit
h
handling
r
ebasing UPDATE changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
Fix a problem
i
n test sc
r
i
p
t thr
e
ad001
.
test causing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Kennedy
Ad
d
simple tests
for the sessio
n
s
m
o
dule reb
a
se API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan
K
e
nned
y
A
d
d larg
e
ly u
n
tested APIs for rebasing c
h
angeset
s
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Ken
n
edy
Improve detecti
o
n
of
o
ut-o
f
-range pa
r
a
m
ete
r
s in sqlite3_
s
tmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
Dan Kennedy
Add sqlite3_changeset_apply_v2()
and
a
p
ply
_
v2_strm
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Dan
K
e
n
n
edy
Fix a typo causing SQLITE_LOG_
C
ACHE_SPILL builds to
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
Dan Kennedy
Fix a problem in te
s
t file
n
ockpt
.
test c
a
u
s
ing errors
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
Dan Ke
n
ned
y
Av
o
id running a
c
o
u
ple of
t
e
sts
in cras
h
8
.
test
that
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
Dan Kenn
e
dy
F
i
x another cras
h
in the se
s
s
i
ons
m
odule trigge
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
D
a
n
K
ennedy
I
n
s
ql
i
te3_checker, wrap the cal
l
to
"
S
E
L
E
CT checkfr
e
elist
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Ken
n
edy
In
a checkpoint
,
figur
e
out if it is pos
s
ible to ch
e
c
kpoin
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kenned
y
Op
t
imize the obscure
c
ase of running a checkpoint
a
gainst
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan Kennedy
Fix further crashes in sqlite3chang
e
se
t
_apply() caus
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
a
n
K
e
n
nedy
F
ix some crashes in the sqlite3changeset_apply() function
.
.
.
commit
|
commitdiff
|
tree
2018-02-17
Dan Ken
n
edy
Fix a data
r
a
c
e causing a tsan complaint
w
ith SQL
I
T
E_ENABLE_
.
.
.
commit
|
commitdiff
|
tree
2018-02-13
Dan Kennedy
Ensure
t
hat multiple up
d
ates o
f
th
e
s
a
m
e
FTS4 ro
w
.
.
.
commit
|
commitdiff
|
tree
2018-02-12
D
an Ken
n
edy
Update
test fi
l
e func6
.
test so that it works with SQLITE_
E
NA
.
.
.
commit
|
commitdiff
|
tree
2018-02-09
Dan Kenned
y
Make the tests i
n
func6
.
t
e
st
m
o
re robust again
s
t implement
a
t
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Kennedy
I
n
extension
s
r
tree, fts3
a
n
d
ft
s
5,
e
nsure that when
.
.
.
commit
|
commitdiff
|
tree
2018-02-07
Dan Kennedy
W
h
en
the final connectio
n
disconnects
f
rom a wal
m
ode
.
.
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
Fix another minor problem in walro2
.
test
.
commit
|
commitdiff
|
tree
2018-02-05
Dan Kennedy
U
pdat
e
test fil
e
w
alro2
.
t
e
s
t
to a
c
cou
n
t for systems
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
D
a
n
Kennedy
Re
m
ove
the "includ
e
<io
.
h
>" win32 d
e
pendency
from the
.
.
.
commit
|
commitdiff
|
tree
2018-02-02
Dan
K
e
nnedy
Rem
o
ve
t
h
e
t
i
me() depend
e
ncy from the zip
f
i
le extension
.
.
.
commit
|
commitdiff
|
tree
2018-02-01
Dan
K
e
n
nedy
Add a few more zipfile tests
.
No changes to co
d
e
.
commit
|
commitdiff
|
tree
next