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 Kenned
y
Add ne
w
AP
I
function sqlite3_cr
e
ate_w
i
nd
o
w_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
ned
y
A
d
d ex
t
ra
O
OM t
e
st
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix an
o
ther prob
l
em in lead()/lag()
.
And some er
r
ors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
F
i
x a bug in the lead() and
lag(
)
window f
u
nctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a problem
with
h
a
n
d
l
in
g
of statemen
t
s
c
o
n
taining
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix problem
with wind
o
w func
t
io
n
s min() and max(
)
w
hen
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge late
s
t
t
r
unk ch
a
nges into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Imp
r
ove
comments and co
d
e legibility in ne
w
file win
d
ow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kennedy
F
ix pr
o
blems with "RANGE BETWEE
N
CURREN
T
ROW AND UNBOUND
E
D
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
F
ix so
m
e test case numbers in expert1
.
t
e
s
t
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unles
s
SQLITE_OMIT_A
U
TOIN
I
T is
d
e
fined, allow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
e
nnedy
Check
that mal
l
oc() has not al
r
eady failed when
i
nvoki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
K
en
n
edy
F
i
x another issue to do
w
i
t
h window-f
u
nct
i
o
ns i
n
aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
enn
e
dy
Fix s
o
me proble
m
s with
using window-functions in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
K
ennedy
Clarify the
relati
o
nship between a
W
i
n
dow object
a
nd
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an
K
ennedy
F
ix hand
l
i
ng o
f
window fr
a
mes con
t
ainin
g
nega
t
iv
e
nu
m
ber
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an Kennedy
F
ix
a
typon in
main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Ke
n
nedy
Update Mak
e
fil
e
.
msc to include w
i
ndow
.
c i
n
the buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Kennedy
Merge
recent trunk chan
g
es with this
b
r
a
nc
h
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Update
the amalg
a
mation build scrip
t
to include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Add suppor
t
f
o
r FIL
T
ER clause on aggregate window functions
.
commit
|
commitdiff
|
tree
2018-06-08
D
an Ken
n
e
d
y
Add sup
p
o
r
t f
o
r the WINDOW cla
u
se
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
Do n
o
t flatten su
b
-que
r
i
e
s that contain window funct
i
o
ns
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to allow group_concat() to be us
e
d
as a wi
n
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Da
n
Kenn
e
dy
Merge lat
e
st trunk
c
han
g
es with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
A
dd
w
indow functio
n
s lag() a
n
d lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
enned
y
A
d
d support
f
or wind
o
w functi
o
n
first_valu
e
(
)
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
edy
Fix problems with t
h
e nth_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
A
d
d
i
m
plem
e
nt
a
tion of nth_value()
win
d
ow functi
o
n
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
Kenne
d
y
Calculate no
n
-aggregate expressio
n
s in t
h
e SELECT li
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
K
ennedy
A
dd implem
e
ntation of last_value() window
function
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Ke
n
nedy
Add imp
l
ementation of win
d
o
w functi
o
n
ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenne
d
y
Merge lat
e
s
t t
r
unk changes into this
b
ra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
A
dd support
f
or win
d
o
w function cume_dist()
.
Impr
o
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Ke
n
ne
d
y
Add sup
p
ort fo
r
window functions row
_
number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n
K
ennedy
Update a test case
i
n malloc5
.
t
est to take into ac
c
ount
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allow an entire p
a
rt
i
tion to be cached in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kenn
e
dy
Fix a bug
in t
h
e S
Q
LITE_ENABLE
_
SORTER_REF
E
RENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan
Kennedy
Allow min()
a
nd max
(
) to be
used
a
s window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenned
y
Inc
r
ease the n
u
mber of dat
a
base
h
andles opened
b
y tes
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Ke
n
ned
y
F
i
x
autoinc
.
t
e
st and resetdb
.
t
e
s
t so tha
t
they w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
More minor change
s
to test scr
i
pts
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
Fix some tes
t
script i
s
sues caused by recen
t
EXPLAI
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
D
o
not
run test file
"
resetdb
.
t
e
s
t
"
as part of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan K
e
nnedy
Fur
t
her w
i
ndow fr
a
me tests
and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kennedy
Do not require a
statement journal
in
c
ases wher
e
REPLA
C
E
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More fixes for differe
n
t window
f
r
a
me
t
y
pe
s
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix "RANGE BETWEEN
CURRENT
ROW AND UNBOUNDED
FOLL
O
W
I
NG
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenned
y
Merge
l
atest trunk changes into this bra
n
c
h
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fixes for
"ROWS BETW
E
E
N <expr> FOL
L
OWI
N
G
A
ND <
e
xpr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
A
l
low
"<
e
xpr> PRECEDING" to be used to
s
p
e
cify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nnedy
Support other frame
t
y
pe
s
that use "<
e
xpr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Da
n
Kennedy
Add suppor
t
for "ROWS
B
ETWEEN <
e
xpr> PRECEDING AN
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenne
d
y
Merge
latest tr
u
nk chan
g
es into this
branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Ken
n
edy
A
d
d comments
to window
.
c describing h
o
w other w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
D
a
n K
e
nnedy
Begi
n
adding support for more esoteri
c
wi
n
dow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Ke
n
n
e
dy
Fix minor
pr
o
blems on this branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan K
e
nnedy
Evaluate
m
ultip
l
e
window f
u
nc
t
i
ons i
n
a
s
ingle
p
ass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Handle
m
ultiple w
i
ndow-funct
i
ons in a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Star
t
of experimen
t
al implementati
o
n of
S
QL w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
Fix a test case pro
b
le
m
in wherelimit
.
t
est
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
A
dd a test
ca
s
e to check that th
e
fts5 unicode64 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kenned
y
Fix
a
p
r
o
b
le
m
i
n the xBestInde
x
me
t
hod of t
h
e cl
o
sure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan
K
ennedy
Fix
a
n
RBU pro
b
lem
c
aus
i
ng spu
r
ious SQLITE_
C
ONSTRAI
N
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Ken
n
edy
Update
test script
f
ts3e
x
pr4
.
t
es
t
so th
a
t it
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
Ken
n
edy
Fix a
t
est script
erro
r
causing te
s
ts to fail in
s
oak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenn
e
dy
W
hen processing an "OR
D
ER BY
.
.
.
LIMIT" tha
t
do
e
s not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan
Ke
n
nedy
When
p
rocessing
an "ORDER BY
.
.
.
LIMIT" that does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Da
n
Kennedy
U
p
da
t
e the "fuzz_malloc
.
test"
script to print SQL statements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenn
e
dy
Re
m
ove a
re
c
en
t
ly added NEVE
R
() macro
from a branc
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
an
K
e
n
n
e
dy
Fix a pro
b
le
m
w
ith
processing
"LEFT
JOIN tbl ON
t
bl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
a
n Ke
n
nedy
Do not att
e
mpt to read valu
e
s from indexes-on-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
an
Kennedy
A few mor
e
test
s
for
u
psert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan
K
ennedy
En
h
ance th
e
"rbu" com
m
and li
n
e utili
t
y
a
bi
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ken
n
ed
y
Add tests for
n
a
me reso
l
uti
o
n
in ON CONFLICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan
Kenne
d
y
Add test cases
f
or
UPSERT
.
And a fix for a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kenned
y
M
odi
f
y a test case in zipf
i
le2
.
test to take into account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
A
dd the
"
sorter-
r
eference"
o
ptim
i
zation, al
l
owi
n
g SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
M
i
n
or
changes to
t
e
st scr
i
pt ups
e
rt4
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
edy
A
d
d ext
r
a
test cases for UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
Kennedy
Fix
a
problem in the shell preventin
g
it
f
rom working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Da
n
Kenned
y
Add som
e
more si
m
ple te
s
t
c
ases f
o
r UPSERT
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
a
n
Kennedy
Add SQLITE_CONFIG
_
SORTER
R
E
F_SIZ
E
config
u
r
a
tion option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
Exp
e
rim
e
n
tal ch
a
nge to "SELECT * FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
an Kenn
e
dy
M
inor
s
implification to internal functio
n
generateSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
Kennedy
Fix a problem caus
i
ng the
LEFT JOIN strength re
d
uction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When testing, avoid injecting an
O
OM fault i
n
t
o
a
f
ile
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix a problem
c
ausi
n
g the L
E
FT JOIN
strength red
u
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix the f
t
s5 xBestIndex method so that
i
t
is not confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kenned
y
A
dd a "flags" p
a
rameter to experime
n
tal API
sqlite
3
changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Ken
n
edy
Fix a proble
m
in the sessions
m
o
d
u
l
e c
a
using sqli
t
e3session_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Kennedy
Fix a
n
instan
c
e where an uninit
i
alized VM register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Da
n
K
e
n
n
ed
y
Updat
e
s
peedtest1
.
c with new te
s
tset "trigger" b
a
sed
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Ke
n
ned
y
Fix a few small test
s
cript
i
ssue
s
affecting SQLI
T
E
_
TEM
P
_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan
K
ennedy
Fix an asser
t
ion f
a
ilu
r
e trig
g
e
r
ed by a SELECT
with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan
K
ennedy
A
n
o
ther chan
g
e to te
s
t file zipfile
.
test to help it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Fix a
t
est script bug
causing zipfile
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Ken
n
edy
U
pdate memdb1
.
test
so that it works
with
S
QLITE_DEFAUL
T
_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
a
n Ken
n
e
dy
Add -DSQLITE_ENA
B
LE_DESERIALIZE to t
h
e "D
e
vice-
T
w
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan
K
en
n
edy
Fix a typo preventing test scr
i
pt avtran
s
.
test from
.
.
.
commit
|
commitdiff
|
tree
next