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
Fix a problem with using a window-function SELECT as a FROM clause sub-query
2018-06-23
Dan Kennedy
Fix a problem w
i
th usin
g
a
w
i
n
d
ow-function SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit
all window-function related code whe
n
buildin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n Kennedy
Merge late
s
t t
r
u
n
k
c
hang
e
s
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fi
x
a
problem wit
h
h
andling sin
g
l
e row pa
r
titions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add
t
ests to improve c
o
verag
e
of code in
window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
ennedy
Merge latest
t
runk changes wi
t
h t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kenn
e
dy
Fi
x
a
proble
m
cau
s
ed b
y
a sub-query con
t
a
ining a wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix
a
p
ro
b
lem with
u
sing min() or max() as a
wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan
Ke
n
nedy
Fix problems w
i
th
u
sing window functions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenne
d
y
Add test ca
s
e
f
o
r
t
he f
i
x
i
n the previous commit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ke
n
nedy
Ensure that
a
l
l
four callbacks are pr
o
vided wh
e
n regist
e
ring
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add
n
ew AP
I
function
s
q
l
ite3
_
c
r
e
ate_win
d
ow_functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
an Kennedy
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
nnedy
Fix anot
h
er problem
i
n lead()
/
lag(
)
.
An
d
s
o
me errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
an K
e
nnedy
F
i
x a b
u
g in
t
h
e le
a
d() and lag() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
ix a proble
m
with hand
l
i
ng of sta
t
ements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
ix problem w
i
th wi
n
dow func
t
ions min() an
d
max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest
trunk change
s
i
n
to t
h
i
s
b
ranc
h
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Improve comm
e
nts
and co
d
e le
g
i
b
ility in new fi
l
e
wi
n
d
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix
p
r
oblems w
i
th "RANGE BETWEEN CURREN
T
ROW AND UN
B
OUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix
s
o
m
e
t
e
st case numbers
in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQLITE_OM
I
T
_
AUTOINIT is defined, allow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
Kennedy
Chec
k
that malloc() has n
o
t alr
e
ad
y
failed wh
e
n invoki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenned
y
Fix a
n
other
issue
to do w
i
th window-functions in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix
some pro
b
lems wi
t
h
using
window-functi
o
n
s
i
n aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Cla
r
ify the relationship
between a Win
d
ow obje
c
t an
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Kennedy
Fix hand
l
i
n
g of window fr
a
me
s
contai
n
ing n
e
ga
t
ive number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenned
y
Fix a
t
y
pon in m
a
i
n
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan
K
ennedy
Upd
a
t
e M
a
kefile
.
msc to include window
.
c
i
n
the b
u
ild
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Mer
g
e r
e
cen
t
tr
u
nk
c
h
a
nges wit
h
this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
Ken
n
edy
U
p
date the ama
l
gamation
b
u
il
d
script to include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ken
n
edy
Add
s
u
pp
o
rt for
FILTER cla
u
s
e
on aggregate wi
n
dow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenned
y
Add s
u
pport for the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
Kennedy
Do n
o
t f
l
a
tten sub-quer
i
e
s
t
hat contain wi
n
dow f
u
nctions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Ke
n
nedy
F
i
xes to
a
l
l
ow group_c
o
ncat() to
b
e u
s
ed as a
w
indo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Merge late
s
t
trunk chan
g
es wi
t
h
this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Ad
d
window function
s
lag() and
le
a
d()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
Add support fo
r
window fu
n
c
tion firs
t
_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Kennedy
Fix probl
e
ms with
the nth_va
l
ue() funct
i
o
n
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
Add impl
e
m
entation of nth
_
v
a
lue() window func
t
ion
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n Kennedy
Ca
l
culate non-aggregate expressio
n
s in the SELECT lis
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Add implementation
of last_value() windo
w
fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
nedy
Add
i
mplementation of window f
u
nction ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Kenne
d
y
Me
r
ge la
t
est t
r
unk chan
g
es
i
nto this branch
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n
K
e
nnedy
Add support f
o
r win
d
ow function cume_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
n
nedy
Add
s
upport for
window
f
u
nc
t
ions row_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Upda
t
e a te
s
t case in malloc
5
.
tes
t
t
o take into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allo
w
an entire partitio
n
to
b
e
cached in
a
temp t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
F
ix a
b
ug in the SQLITE_ENABLE_SORTER_REF
E
REN
C
ES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
an Kennedy
All
o
w min
(
) and max() to be us
e
d as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase the numbe
r
of database handles open
e
d by
t
e
st
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
i
x autoinc
.
tes
t
and r
e
s
e
tdb
.
test so that they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Kenne
d
y
More minor
changes to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n K
e
nnedy
Fix some test script issues
c
aused by rec
e
nt E
X
PLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
enned
y
Do
n
ot
r
un te
s
t
file "resetdb
.
te
s
t" as part of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Further window frame test
s
an
d
fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Da
n
K
ennedy
Do not require a stat
e
ment jour
n
al in cases where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenn
e
dy
More fixes for differen
t
win
d
o
w frame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ken
n
edy
Fix "RANGE BETW
E
EN CURRE
N
T
R
OW AND
U
NBOUNDED FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenn
e
d
y
Merge l
a
test trunk ch
a
n
ges into
t
his
branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
ennedy
Fixes for "ROWS BETWEEN <expr> FOLLOW
I
N
G
AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
A
llow "<expr> PR
E
C
E
DING" to b
e
used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan
K
ennedy
Support other frame types that use "<ex
p
r> P
R
E
C
EDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kenne
d
y
Add support
f
or "ROWS BETWEEN
<
exp
r
>
PRECE
D
I
NG AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
D
an Ken
n
edy
M
erge latest trunk
c
hanges
into
this branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Ken
n
edy
Add
c
omments
t
o
w
in
d
ow
.
c describ
i
n
g
how other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan K
e
nnedy
Beg
i
n adding
su
p
port
f
o
r more esoteric window fram
e
s
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix minor problems on thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kenned
y
Evalu
a
te multiple
window functions in a sing
l
e pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Handl
e
mult
i
ple
w
in
d
ow-functions
i
n a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Da
n
Kennedy
Start of
experimental i
m
pl
e
ment
a
t
ion of SQL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
D
a
n
K
enn
e
dy
Fix a t
e
st case probl
e
m in wher
e
l
imit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
D
a
n Kennedy
Add a test case to c
h
e
ck that
the fts5 unicode64 tok
e
nizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Ke
n
nedy
Fix a problem in
t
he xBestIndex method
o
f the
clos
u
re
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kenn
e
dy
Fix
a
n R
B
U
problem causin
g
spur
i
ous SQLITE
_
CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenned
y
Update test script fts3expr4
.
test so that it alway
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Da
n
Kenne
d
y
Fix a test script error ca
u
sing tests
to fai
l
i
n soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenne
d
y
Whe
n
processing an "ORDER BY
.
.
.
LIMI
T
" t
h
at does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenne
d
y
Wh
e
n processing an "ORDER BY
.
.
.
LIMIT" that
d
o
es not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan K
e
nnedy
Update
the "f
u
zz_malloc
.
t
est" s
c
r
i
pt to print SQL
s
tat
e
ments
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenne
d
y
Remo
v
e
a rec
e
ntly added NEVER() macro fro
m
a br
a
nch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix
a
problem with
proce
s
sing "LEFT JOIN
t
bl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ken
n
e
dy
Do not
a
tt
e
mpt to r
e
ad values fr
o
m
i
n
dex
e
s-on-expr
e
ssio
n
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Ke
n
nedy
A few m
o
re t
e
s
ts for up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Enh
a
n
c
e
t
h
e "rbu"
c
ommand line utility a bi
t
.
commit
|
commitdiff
|
tree
2018-04-20
D
an Kennedy
A
dd
t
e
s
ts for
n
a
m
e
resolution in ON CONFLICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Da
n
Kennedy
A
d
d test ca
s
es for
U
PSE
R
T
.
And a fix f
o
r a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Mod
i
f
y
a t
e
s
t
cas
e
in zipfile2
.
te
s
t to take into account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
Kennedy
Add the "so
r
ter-
r
eference" optimization, allowin
g
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
K
ennedy
M
i
nor
c
hanges to test script upsert4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
a
n Kenned
y
Add extr
a
t
e
st
cases for UPSE
R
T
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ke
n
nedy
Fix a prob
l
em in t
h
e shel
l
prev
e
nting it from working
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
Add s
o
me mor
e
sim
p
l
e
t
est cases fo
r
UPSERT
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan Kennedy
Ad
d
SQLITE_CONFIG_
S
ORTERREF_SIZE configuration option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Ke
n
nedy
Experimental change to "SELEC
T
* FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Kennedy
M
inor simpli
f
ication
t
o internal function generateSo
r
tT
a
il()
.
commit
|
commitdiff
|
tree
2018-04-10
D
a
n K
e
nnedy
Fi
x
a
problem
c
a
using the LEF
T
J
OIN stre
n
g
t
h
r
eduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Da
n
K
e
nnedy
When test
i
ng, avoid injecting an OO
M
fau
l
t i
n
to a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix a p
r
oble
m
causing the LEFT JOIN st
r
ength reduc
t
io
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Ke
n
n
e
dy
Fix the fts5 xBestIndex method so that it
i
s not confu
s
ed
.
.
.
commit
|
commitdiff
|
tree
next