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
Fixes to allow group_concat() to be used as a window function.
2018-06-08
Da
n
Ke
n
nedy
Fixes to allow group_concat() to be u
s
ed
a
s
a
windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenn
e
dy
Merge
l
at
e
st tru
n
k c
h
anges
with this
b
r
a
nch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Kennedy
A
d
d wi
n
dow functions
lag() and le
a
d()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenn
e
dy
Add
s
u
ppo
r
t
for window f
u
nc
t
ion
first_val
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
Fix problems wit
h
t
h
e nth_value() fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-06
Da
n
Ke
n
nedy
Add implementatio
n
of nth_value(
)
win
d
o
w function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calc
u
lat
e
non-ag
g
reg
a
te ex
p
r
e
ssion
s
in
the SELEC
T
list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Ad
d
imple
m
e
n
t
ation of
last_value(
)
window
f
u
nction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add implementation of window
f
unction n
t
ile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan K
e
nnedy
Merge l
a
test trunk cha
n
ges into
this bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
Kennedy
A
dd support for window
f
u
n
ction cume_d
i
st()
.
Im
p
rov
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
A
d
d support f
o
r
window functio
n
s row_number
(
), ran
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n K
e
nned
y
Upd
a
te
a test c
a
se in malloc5
.
test to
take into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
All
o
w an entire
parti
t
ion
t
o be
c
ached in
a
te
m
p table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
Fix a bu
g
in
th
e
SQLITE_ENA
B
LE_SORTER_REF
E
RENCE
S
code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow
min() a
n
d m
a
x() to
b
e
u
s
ed as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenned
y
I
ncrease
t
he number
of databa
s
e handl
e
s opened b
y
t
est
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
ix autoinc
.
t
e
s
t
and
res
e
tdb
.
test
s
o that they
w
o
r
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
M
o
re mi
n
or changes
t
o
test scri
p
ts
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kenn
e
dy
Fix some
test
s
cript issues caused b
y
recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do not
r
un
t
est f
i
le "resetdb
.
test"
as part
of
permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kenn
e
d
y
Further window frame
test
s
an
d
fixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
a
n Kennedy
Do not r
e
qui
r
e a sta
t
e
m
e
nt journal in
cases where R
E
P
L
A
C
E
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Da
n
Kenned
y
M
ore fixes
f
or differen
t
window
frame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ken
n
edy
Fix "
R
ANGE
B
ETWEEN CURRENT ROW AND UNBOUNDED FOLLOWI
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merg
e
latest trunk cha
n
ges into
this br
a
nch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fixes for "RO
W
S BETWEEN <expr
>
F
O
LLOWIN
G
AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an K
e
nn
e
dy
Allo
w
"
<
exp
r
> PRECEDING" to
b
e
u
s
e
d
to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Support other frame types that use "<expr> PRECEDI
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add sup
p
ort for "ROWS BETWEEN <
e
xpr> PRECED
I
NG AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
D
an Ken
n
ed
y
Merge latest
t
ru
n
k
changes into this b
r
anch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenne
d
y
Add comme
n
ts to wind
o
w
.
c desc
r
ibi
n
g
h
ow o
t
h
e
r window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
D
an Kennedy
Begin a
d
d
i
ng support fo
r
m
o
re
e
soter
i
c window f
r
ames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix
m
in
o
r problems on this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kenne
d
y
Evaluate
multiple window fu
n
ctions in a single pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an
K
e
n
nedy
H
andle mu
l
tiple win
d
ow-functions in a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Start
of experimental implement
a
tion of SQL
window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Da
n
K
ennedy
Fix
a
test case problem in w
h
erelimit
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-05-09
D
a
n Kennedy
Ad
d
a test c
a
se
t
o chec
k
that the fts5
unicode64
tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
F
i
x
a proble
m
in the xBest
I
ndex me
t
hod
o
f the clo
s
u
r
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Ke
n
ned
y
Fix an RBU problem causing
spuri
o
us
SQLITE_C
O
NSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Da
n
Kennedy
Update
t
es
t
script fts3expr4
.
test so that i
t
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
F
ix a
t
est script er
r
o
r
causing te
s
ts to fail in
s
oak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenne
d
y
W
h
en p
r
ocessing an "ORDER
B
Y
.
.
.
LIMIT" t
h
at
does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
When
p
rocessing
a
n "ORDER BY
.
.
.
LI
M
IT"
t
h
at does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Upda
t
e the
"fuzz_mallo
c
.
t
est" script to print SQL statements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenne
d
y
Remove
a
recently added NEVER() macro fro
m
a br
a
nch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix a problem with proce
s
sin
g
"LEFT J
O
IN tbl ON t
b
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenned
y
Do not attempt to read val
u
es from indexes-o
n
-
e
x
p
ressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Ke
n
n
edy
A fe
w
more te
s
ts
f
or u
p
ser
t
.
commit
|
commitdiff
|
tree
2018-04-20
D
an Kennedy
Enha
n
ce the "rbu"
c
ommand line utility a
bi
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ke
n
nedy
Add tests for name resolution in
O
N CONFLICT claus
e
s
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
A
d
d
t
est cases for UPSE
R
T
.
A
n
d a fix
f
or
a
"REPL
A
CE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan
Kenn
e
dy
Modify
a te
s
t
c
ase in zipfil
e
2
.
test to ta
k
e
into accou
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
a
n
K
e
nnedy
Add th
e
"
s
o
r
ter-refer
e
nc
e
" optimiz
a
tion, al
l
owing SQ
L
i
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
Ke
n
nedy
Minor ch
a
nges
t
o
test script upsert4
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add extra test cases f
o
r UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix a probl
e
m in the shell
p
r
e
ven
t
ing i
t
from working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
a
n Kenned
y
Add some more si
m
p
l
e test ca
s
es
f
or UPSERT
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
a
n Kennedy
Add SQLITE
_
CONFIG_SORTERREF_S
I
Z
E configuration option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
E
x
p
e
rimental
c
h
ange to "SE
L
E
CT *
FR
O
M
.
.
.
O
R
DER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan
K
en
n
ed
y
M
i
nor si
m
p
l
ification to internal function g
e
nerateSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
D
a
n Kennedy
Fix a problem causing the LEFT JOIN strength re
d
uctio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenn
e
dy
Whe
n
t
e
sting, a
v
oid injecti
n
g an OOM faul
t
into a
f
ile
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
F
ix
a p
r
oblem cau
s
i
n
g the LEFT JOIN
s
trength reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix t
h
e fts5 xBestIndex me
t
hod so that
it i
s
not confuse
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
A
dd
a "f
l
ags" para
m
eter to experimental API sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan
Kennedy
Fix a pr
o
b
l
em in the se
s
sions module c
a
using sql
i
te3sess
i
on_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Kennedy
Fi
x
an
i
n
s
tance where an unin
i
tialized VM reg
i
ster
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Update speedtest1
.
c with n
e
w testse
t
"trig
g
er" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Fix a few small test
script is
s
u
e
s affectin
g
SQLITE
_
T
EMP
_
STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan Kennedy
Fix an
assertion failure triggered by a SELECT with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan K
e
nnedy
Another change to
t
e
s
t
f
i
le zipfile
.
test to he
l
p
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Fix a test s
c
r
ip
t
bu
g
c
a
using zipfile
.
t
est to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan K
e
nnedy
Upd
a
te m
e
mdb1
.
test so th
a
t
it w
o
r
k
s with
S
QL
I
TE_DEFAULT
_
A
UTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kennedy
Add -
D
SQLITE_
E
NABLE_DE
S
ERIALIZ
E
to the "
D
e
v
ice-Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Kennedy
Fix a
typo p
r
even
t
ing test
scrip
t
avtrans
.
test f
r
om
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Dan Kennedy
Fix a test
s
cript pro
b
lem c
a
using shell1
.
t
e
st to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan Kennedy
Fix ty
p
os in sqli
t
e
3se
s
s
ion
.
h
preven
t
i
n
g
documentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
an K
e
nnedy
F
i
x
m
inor problems with passing NULL pointers to memcm
p
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Da
n
K
e
nnedy
Ad
d
APIs
t
o
the session
s
module for "rebasing" changes
e
t
s
.
commit
|
commitdiff
|
tree
2018-03-22
D
a
n K
e
nned
y
Remove
s
om
e
u
nus
e
d code from sql
i
t
e
3
rebaser_reba
s
e()
.
commit
|
commitdiff
|
tree
2018-03-22
Dan K
e
nned
y
F
ix another problem with rebasing upd
a
tes against mult
i
ple
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Kenned
y
Fix an RBU problem causin
g
err
o
rs when upd
a
ting
t
ables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan
K
e
nn
e
dy
Fix a
t
e
st script pro
b
lem cau
s
ing rbuvacuum
.
test
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ken
n
edy
A
dd tests to ensure that pat
c
hsets are
handl
e
d
c
orrec
t
ly
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
Dan Ke
n
ne
d
y
Remove some unused co
d
e from the sessio
n
s module
.
commit
|
commitdiff
|
tree
2018-03-21
Dan Kennedy
M
erg
e
latest trunk changes into
this bran
c
h
.
commit
|
commitdiff
|
tree
2018-03-21
Da
n
K
enn
e
dy
Fix some documenta
t
i
o
n and other issues with the code
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
an Kennedy
Fi
x
re
b
asing of
UPDATE changes against a
s
et of remote
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
a
n
Kenn
e
dy
Add further
t
ests and
do
c
umentation for the sessions
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan K
e
nnedy
Fix h
a
n
d
li
n
g
of
"UPDATE
O
R
REPLACE"
s
t
atements run
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
Dan Kennedy
Add a
t
e
s
t case for the f
i
x on thi
s
branch
.
commit
|
commitdiff
|
tree
2018-03-16
D
an
Kenn
e
dy
F
ix a pr
o
blem with han
d
ling
r
e
b
asi
n
g UPDATE
c
h
a
nges
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
Dan Kennedy
Fix a problem in test script t
h
r
e
ad001
.
test ca
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
Dan Ken
n
edy
Add simple tests fo
r
the se
s
sions
m
odule rebase API
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Ke
n
nedy
Add
l
a
rgely untested APIs for rebas
i
ng changesets
.
commit
|
commitdiff
|
tree
2018-03-14
Dan Kennedy
Impr
o
ve detec
t
ion
of out-of-ran
g
e
p
ara
m
eters
i
n sqlite3_stmt
.
.
.
commit
|
commitdiff
|
tree
2018-03-13
D
an Kenne
d
y
Add
sqlite3_changeset_apply_v
2
() and apply_v2_str
m
.
.
.
commit
|
commitdiff
|
tree
2018-03-12
Dan
Kennedy
Fix a
t
ypo
causing
S
QL
I
TE_LOG_
C
ACHE_SPILL bu
i
lds to
.
.
.
commit
|
commitdiff
|
tree
next