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 new API function sqlite3_create_window_function(), for creating new
2018-06-18
Dan Kennedy
A
dd
n
ew API function
s
qlite3_create_window_fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kenne
d
y
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix another problem
i
n lea
d
()/lag()
.
A
nd som
e
errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Kennedy
Fix a
b
ug in the lead() and lag() window fu
n
ctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenn
e
dy
Fi
x
a
p
r
o
ble
m
with h
a
ndling
o
f statements cont
a
ining
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an
Ke
n
ne
d
y
Fix
p
r
oble
m
with window functions
min() a
n
d
max()
w
hen
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Mer
g
e latest trun
k
c
h
anges
i
nto thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
nn
e
dy
Imp
r
ove c
o
mments and code legib
i
lity in n
e
w file window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
Kenne
d
y
Fix
p
roblems with
"RAN
G
E B
E
T
WEEN CURRE
N
T ROW AND UNB
O
U
ND
E
D
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kennedy
Fix some test case numbers in expert
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQLITE_OMIT_AUTOINIT is defi
n
ed, allo
w
sql
i
te3_
v
fs
_
un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Check tha
t
malloc(
)
has not alrea
d
y fail
e
d
when invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenne
d
y
Fix a
n
other is
s
ue to do
with window-functions in aggr
e
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Ke
n
nedy
Fix s
o
me probl
e
ms with us
i
n
g window-
f
unct
i
ons
in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Kennedy
C
larify the relat
i
o
nship between a
Window ob
j
e
ct and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
K
e
nnedy
Fix ha
n
dling of window
f
rames c
o
nta
i
ning ne
g
a
tive number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix a ty
p
on
i
n mai
n
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
D
an Kennedy
Upd
a
te
M
akefile
.
msc to inc
l
ude window
.
c in the
b
uild
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Merg
e
recent t
r
u
n
k
chan
g
es with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
U
p
date the amalgamation build
s
c
r
i
pt to include wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Add support f
o
r FILTER clause
o
n aggregate wind
o
w functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Add sup
p
ort f
o
r
the W
I
NDOW
c
lause
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kenn
e
dy
D
o
not f
l
atten sub-querie
s
that
contain window
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to allow group
_
concat() to b
e
used
a
s a wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Me
r
ge latest trunk ch
a
nges with this br
a
nch
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
A
d
d window function
s
lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add support for window func
t
ion first
_
v
a
l
ue()
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Fix problems with the nth_value() fu
n
cti
o
n
.
commit
|
commitdiff
|
tree
2018-06-06
Dan
Kennedy
Add
implementat
i
on o
f
nth_value()
w
ind
o
w f
u
nct
i
on
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calcula
t
e
non-ag
g
regate ex
p
ressi
o
ns
in t
h
e SELECT l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
D
an Kenn
e
dy
Add implementati
o
n of l
a
st_v
a
lue
(
)
w
indow fun
c
tion
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
Kennedy
Ad
d
i
m
plementation of window
f
u
n
ction ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Kennedy
Merge latest trunk changes into
this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add support for
w
indow fun
c
tion cume_dis
t
()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
K
ennedy
A
dd suppo
r
t for w
i
ndow functions
r
ow_numbe
r
(), r
a
nk
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenned
y
Update a test
ca
s
e in malloc5
.
t
e
st to take into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n Kennedy
Allow an
e
ntire partition t
o
be cac
h
ed in a temp
table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Fix a bug in
the SQLITE_ENABLE_S
O
RTER_REFERENCES cod
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Da
n
Kenn
e
dy
Allow min()
a
nd max
(
) t
o
be used as wind
o
w func
t
io
n
s
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
I
ncre
a
se the
n
u
m
b
er of
database handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
ix autoi
n
c
.
test
a
n
d resetdb
.
t
est s
o
that t
h
ey work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an K
e
nn
e
dy
M
o
r
e m
i
n
or changes to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix some
t
e
s
t script iss
u
es ca
u
sed
by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
Do not r
u
n test file "res
e
tdb
.
test" as par
t
of
permutati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
Kenned
y
F
u
rther
w
indow fra
m
e t
e
sts
a
n
d
fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Da
n
Kennedy
Do not require a statemen
t
journal
in cases where R
E
PLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenn
e
dy
More fixe
s
f
o
r diff
e
re
n
t win
d
ow frame types
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kennedy
Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenned
y
M
e
rge latest trunk changes into
t
his bra
n
ch
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kennedy
F
ixes
f
or "ROWS BETWEEN <expr> FOLLO
W
ING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nnedy
All
o
w "<expr> PRECED
I
N
G
"
to be u
s
ed
to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
a
n
Kennedy
Support other
frame types that u
s
e "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add suppor
t
for "RO
W
S
B
ETWEEN
<
exp
r
> PRECE
D
ING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Kennedy
M
erge latest trunk c
h
an
g
es
int
o
t
h
i
s
branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
A
dd co
m
ments to window
.
c describing how o
t
her window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin adding
s
upport for
more esote
r
ic w
i
ndo
w
f
r
a
m
es
.
commit
|
commitdiff
|
tree
2018-05-19
D
a
n
Kennedy
Fix m
i
nor pro
b
lems on this branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan
Kennedy
Evalua
t
e multiple
window func
t
i
o
n
s in a single p
a
ss
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Da
n
Ken
n
edy
H
a
ndle m
u
ltiple wi
n
d
o
w-funct
i
ons in a si
n
gle query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan
Kennedy
Start of experim
e
ntal implement
a
tion
of S
Q
L
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
Fix a test case problem in
w
h
erelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Da
n
Kennedy
Add a test case to check th
a
t
the f
t
s5 unicode64 token
i
zer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
a
n K
e
nn
e
dy
Fi
x
a problem in the xBest
I
ndex me
t
hod of the
c
losure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan K
e
nnedy
Fix an
R
BU prob
l
em c
a
using spur
i
ous SQ
L
ITE_CON
S
TRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan K
e
nnedy
Update tes
t
script fts3expr4
.
te
s
t so that it always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix
a
t
est script error causing tests to fail in
s
oa
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
a
n Kennedy
When
proc
e
ssing an
"
ORDER BY
.
.
.
LIMIT"
that does n
o
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When proce
s
sing
a
n "O
R
DER
B
Y
.
.
.
LIMIT"
that
does
n
ot
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
Update the
"
fuzz_malloc
.
test" script to pr
i
nt SQL statemen
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Ke
n
ned
y
Remove a recently added N
E
VER() macro from a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
an
K
e
n
nedy
Fix a problem
with process
i
n
g
"LEFT JOIN tb
l
O
N
tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ke
n
nedy
D
o
not atte
m
pt to read val
u
es fro
m
inde
x
es-on-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Kennedy
A few more
t
ests
f
o
r
u
ps
e
rt
.
commit
|
commitdiff
|
tree
2018-04-20
Dan
Ken
n
edy
Enhance the
"rbu" command line ut
i
lity a bit
.
commit
|
commitdiff
|
tree
2018-04-20
Dan
K
ennedy
Add t
e
sts for name resolu
t
ion in ON
C
ONF
L
I
CT c
l
auses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ke
n
n
edy
Add test ca
s
es for U
P
S
ERT
.
And a fix fo
r
a "
R
E
PLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Modify a test case
i
n zipfile2
.
te
s
t
t
o take into acco
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
e
dy
Add the "
s
orter
-
reference" optimizat
i
on, allowing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Minor c
h
anges to test scri
p
t upsert4
.
t
es
t
.
commit
|
commitdiff
|
tree
2018-04-18
Dan K
e
nnedy
Ad
d
extra test cases f
o
r UPS
E
RT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix
a pr
o
blem in
t
he shell
p
r
ev
e
nting
it fro
m
workin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
Add some mo
r
e
simple test c
a
ses for UPSERT
.
An
d
a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan
K
e
n
nedy
Add SQLITE
_
C
O
N
FIG_SO
R
TERREF_SIZE con
f
iguration option
.
commit
|
commitdiff
|
tree
2018-04-14
D
a
n Kenn
e
dy
Expe
r
i
m
ental
c
h
ange to
"SELEC
T
* FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
a
n Kennedy
M
ino
r
s
i
mplification to interna
l
f
u
n
c
tion g
e
nera
t
eSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan K
e
n
n
edy
Fix a probl
e
m causin
g
the
LEFT
JOIN strength red
u
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When testing, avoid injecting a
n
OOM fault i
n
to a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenne
d
y
Fix a pro
b
l
e
m
ca
u
si
n
g the LEFT JOIN str
e
ngth redu
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix
t
he
fts5 xBestIndex method so that it i
s
not confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan K
e
n
n
edy
Add a "flags" parameter to
experi
m
enta
l
API sqlit
e
3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Ken
n
edy
F
i
x a problem in the
s
e
ssio
n
s modul
e
cau
s
in
g
sq
l
i
te3session_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan
K
ennedy
Fix an inst
a
nce
w
h
e
re an
unini
t
ialize
d
VM regis
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
Upd
a
te speedtest1
.
c
w
ith new testset
"trigger" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan
K
en
n
edy
Fix a few sma
l
l
tes
t
sc
r
i
p
t issues affecting SQLITE_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
a
n Kennedy
F
ix an assertion
fai
l
ure
t
riggered by a S
E
L
E
C
T w
i
th
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan
Kennedy
Another change to test f
i
le zipfile
.
test
t
o help
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Da
n
K
e
n
n
edy
Fix a test scri
p
t bug ca
u
si
n
g zipfil
e
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan K
e
nnedy
U
pdate memdb1
.
test so that it wor
k
s with
SQL
I
TE_DEFAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
a
n
Kenne
d
y
Add -DSQLITE_ENABLE
_
DESERIALI
Z
E to the "Device-Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan K
e
nnedy
F
ix a typ
o
preventing test script av
t
rans
.
t
e
st
f
rom
.
.
.
commit
|
commitdiff
|
tree
next