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 implementation of last_value() window function.
2018-06-05
Dan
Kennedy
Add implementation of las
t
_value() window functi
o
n
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
K
en
n
edy
A
d
d implem
e
nt
a
tion of window function ntile
(
)
.
commit
|
commitdiff
|
tree
2018-06-04
D
an Kennedy
M
e
rge la
t
est tru
n
k changes int
o
this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ken
n
edy
Ad
d
sup
p
o
rt for wind
o
w function
c
ume_dist(
)
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
Kenned
y
Add support for wi
n
dow functions row_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
K
e
n
n
ed
y
Update a t
e
st case in malloc5
.
test to take i
n
to account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
ennedy
Allow
a
n
ent
i
re par
t
it
i
on to be cached in
a
temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n
Kennedy
Fix a
b
ug
in the
S
Q
LITE_ENA
B
LE_SORTER_REFERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Ke
n
n
e
d
y
Allow min() and max() to b
e
used as w
i
ndow functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Inc
r
ease the num
b
er o
f
database
hand
l
es opene
d
by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
Fix autoinc
.
test and
r
esetdb
.
test so
that they wo
r
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenne
d
y
More minor changes
t
o test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
i
x some
t
e
s
t
script issues caus
e
d by
recent EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Kennedy
Do not run test file "resetdb
.
t
e
st" as p
a
rt of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Da
n
Kenne
d
y
Further win
d
ow f
r
ame te
s
ts and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenned
y
Do not require a
s
tatement jour
n
a
l in cases
where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More
fi
x
es for
different window fr
a
me
t
yp
e
s
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix "RANGE BETWEEN CURRENT
RO
W
AND UNBOU
N
D
E
D
FOLLO
W
ING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
Merge latest t
r
unk cha
n
ges into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
ennedy
Fixes for "ROWS BETWEEN <ex
p
r> FOLLOWING AND
<expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Kennedy
Allow
"
<expr
>
PRECEDING" to be used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Ken
n
edy
Support other f
r
ame
t
ypes th
a
t
use "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
D
a
n Kennedy
Add support for "RO
W
S
B
ETWEEN <expr> PRECE
D
ING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenne
d
y
Mer
g
e latest
t
runk ch
a
nges into this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n
Ke
n
nedy
Add
c
o
mments t
o
window
.
c
d
escribing h
o
w othe
r
w
i
nd
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Ken
n
edy
Begin
a
dding sup
p
or
t
for more esoteric window
frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix minor
p
roblems on t
h
is
branch
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
E
v
aluat
e
multiple
window functions in a si
n
gle p
a
ss
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an K
e
nnedy
H
a
nd
l
e mul
t
iple window-functions in a single quer
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
S
t
art o
f
expe
r
i
mental i
m
p
l
e
mentat
i
o
n of SQL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
F
ix a tes
t
ca
s
e
probl
e
m in whereli
m
it
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kenn
e
dy
A
dd
a
test case to check that the fts5
u
nicode64 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan
Kennedy
F
i
x a problem
i
n
t
h
e
xBestInd
e
x method of
t
he closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
a
n Ke
n
n
e
d
y
Fix an RB
U
problem causing spuriou
s
S
Q
LITE_CONS
T
RAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
a
n
Ke
n
nedy
Update test
s
c
ript
fts
3
ex
p
r4
.
test so t
h
at it
alwa
y
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix a test script
e
rro
r
c
ausing tests t
o
f
ail
in
s
oak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Da
n
Ke
n
nedy
When process
i
ng an "OR
D
ER BY
.
.
.
L
IM
I
T"
that doe
s
no
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan K
e
nne
d
y
When pro
c
e
s
s
i
n
g an "ORDER BY
.
.
.
LIMI
T
" th
a
t do
e
s
not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Update the "fuzz_malloc
.
t
e
st" script to pr
i
n
t
SQL s
t
ateme
n
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenne
d
y
R
e
mov
e
a rece
n
tly
a
dded NEVER(
)
macro from a bran
c
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Ke
n
nedy
Fix a problem with pr
o
c
e
ssing "LEFT JOIN tbl ON t
b
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
a
n Kennedy
Do not
a
ttempt t
o
read values from indexes-on-express
i
ons
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan
Kennedy
A
f
ew more
tests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Enhan
c
e the
"rbu" comma
n
d
line utility a bit
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ken
n
edy
Add tests for name resolutio
n
i
n
ON CONFLICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add test cases for UPSERT
.
And a fix for a
"
REP
L
AC
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Ken
n
e
d
y
Modify a test case in zipfile2
.
test t
o
take into a
c
count
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add the "sorte
r
-reference
"
opti
m
i
zati
o
n
,
allowing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Minor
changes to test sc
r
i
pt upser
t
4
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
an Kennedy
Add extra
test
c
a
s
e
s for
UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ke
n
nedy
F
ix a probl
e
m
in
the shell
pre
v
ent
i
ng it from working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
Add so
m
e more simpl
e
t
e
st
c
a
s
es for UPSE
R
T
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan
Kenned
y
A
dd SQLITE_CO
N
FIG_SORTERREF_S
I
ZE configura
t
ion optio
n
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
Exper
i
mental ch
a
nge to "
S
ELECT *
F
ROM
.
.
.
ORD
E
R
BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Kennedy
M
inor simpli
f
ication to inter
n
al
f
unction generateS
o
rtTa
i
l
()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan K
e
nn
e
dy
Fix a
p
roblem causing
the LE
F
T JOIN s
t
ren
g
th
reduc
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When testing, avoi
d
injecti
n
g
a
n
O
O
M fault i
n
to a
file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
K
ennedy
Fix a problem ca
u
sing
t
h
e
LEFT
J
OIN
stre
n
gth reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix
t
he
fts
5
xBes
t
Index method so that it is
not conf
u
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Da
n
Kennedy
A
dd a "flags" parameter to experimental AP
I
s
qlite3c
h
angeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Kennedy
Fi
x
a probl
e
m in the se
s
s
i
ons
m
odule causing
sql
i
t
e3
s
ession_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Da
n
K
e
n
ne
d
y
Fix an instance where an unin
i
t
ialized V
M
r
e
gister
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Update s
p
e
e
dt
e
st1
.
c with new testset "tr
i
gger" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan
K
ennedy
Fix a few small test scr
i
pt
issues affecting SQLITE_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan Kenne
d
y
Fix an assertion
fai
l
u
re trigger
e
d by
a
SELECT
with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n Kennedy
An
o
ther chang
e
to
t
est file zipfile
.
test to
h
e
l
p it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
an
Kennedy
Fix a t
e
st script
bu
g
ca
u
s
in
g
zipfile
.
test to
fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n Kennedy
Upda
t
e memdb
1
.
test s
o
that it work
s
with S
Q
L
I
TE_DEFAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
a
n Kenn
e
dy
Add -DSQLITE_ENABLE_
D
ESERIALIZE to the
"
Device-Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Kennedy
F
i
x a
typo preventing test sc
r
i
pt avtrans
.
tes
t
from
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan K
e
nnedy
Fix
a
test s
c
ript problem causing shell1
.
tes
t
to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan K
e
nnedy
Fi
x
typo
s
in
s
qlit
e
3session
.
h preventi
n
g
d
o
c
umentatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Ke
n
nedy
F
ix minor probl
e
ms
w
ith
p
assing NULL poi
n
t
ers to me
m
cmp
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Add APIs to th
e
sessions module f
o
r "rebasing" changeset
s
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Rem
o
ve
some
un
u
sed
co
d
e from sqlite3rebase
r
_rebase()
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
F
ix
a
n
other probl
e
m with rebasing up
d
at
e
s agai
n
st multip
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
a
n
Kennedy
Fix a
n
RBU
pr
o
blem causing errors whe
n
u
p
d
a
ting ta
b
les
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
an Kennedy
Fix a test scr
i
p
t
problem cau
s
ing rbuvacu
u
m
.
test to
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan K
e
nnedy
Add tests to ensu
r
e that patchsets a
r
e handled correctly
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kennedy
Remov
e
s
o
me
unused code from
the
s
essions module
.
commit
|
commitdiff
|
tree
2018-03-21
Da
n
Kennedy
Merge la
t
est trunk change
s
into this branch
.
commit
|
commitdiff
|
tree
2018-03-21
D
a
n Kennedy
Fix some doc
u
menta
t
ion and other issues
w
ith the code
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kennedy
Fix re
b
a
s
ing of UPD
A
T
E changes agains
t
a set of remote
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Da
n
Ken
n
e
dy
Add fu
r
ther tes
t
s a
n
d documenta
t
ion for the sessio
n
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
a
n
Kennedy
Fix
h
andling of "UP
D
A
TE OR REPLACE" stat
e
ments run
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan
K
e
n
nedy
Add a te
s
t case fo
r
the
fix
o
n th
i
s
branch
.
commit
|
commitdiff
|
tree
2018-03-16
Dan
K
enne
d
y
Fix a p
r
oblem with hand
l
i
n
g rebasing
UPDATE ch
a
nges
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan
Kenn
e
dy
F
i
x a problem in te
s
t scr
i
pt
t
hread001
.
t
e
st causing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Kennedy
Add simple t
e
sts fo
r
t
h
e ses
s
io
n
s
modul
e
r
ebase API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Ken
n
edy
Ad
d
largely unt
e
sted APIs for reba
s
ing
c
hangesets
.
commit
|
commitdiff
|
tree
2018-03-14
Dan K
e
nnedy
Improve d
e
tec
t
i
on of out
-
of-
r
ange parameters in sqlite3_stmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
Dan Ke
n
nedy
A
d
d sqlite
3
_changes
e
t_apply_v2() a
n
d apply_v2_strm
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Dan Ken
n
edy
Fix a typo
caus
i
ng SQLITE_
L
OG_CACHE
_
S
P
ILL bu
i
lds t
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
Dan Kenned
y
Fix a probl
e
m in test
file no
c
k
pt
.
t
e
st
causin
g
errors
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
Dan Kenned
y
Avo
i
d
running a coupl
e
o
f
tests
in
crash8
.
test t
h
at
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
Dan
Kennedy
Fix
a
not
h
er crash in t
h
e sess
i
ons module
t
rig
g
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan
Kennedy
In sqlite3_
c
hecker, wrap the call to
"
SE
L
ECT c
h
eckfreelist
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
In a ch
e
ckpoint, figure
o
ut if
i
t is p
o
ssible to chec
k
point
.
.
.
commit
|
commitdiff
|
tree
2018-03-02
Dan Kennedy
Optimize the o
b
scure case of running
a
ch
e
ckpoint a
g
ainst
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
Dan
K
ennedy
Fix further crashes in sq
l
ite3changeset_apply() caus
e
d
.
.
.
commit
|
commitdiff
|
tree
next