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
F
i
x
a pr
o
b
l
em with using
a
window-function SELE
C
T
as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n Kennedy
Omit
all w
i
n
do
w
-fu
n
ction related
code when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Merge l
a
test tr
u
nk changes
.
commit
|
commitdiff
|
tree
2018-06-21
D
a
n Kennedy
Fix a p
r
oblem wit
h
hand
l
i
ng single row parti
t
i
o
n
s in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan K
e
nnedy
Add
tests to improve coverage of code in
windo
w
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
M
erge la
t
est
t
ru
n
k
changes with this
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
Kennedy
Fix a p
r
oblem
c
a
u
sed by a
sub
-
query containing a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a
p
roblem with us
i
ng min() or
m
ax() as a win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ke
n
nedy
F
i
x problem
s
wi
t
h
using window functions in CREAT
E
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ke
n
nedy
Add te
s
t
case for
t
he fix in the
p
r
e
v
ious
c
om
m
it
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ensure
t
hat
a
l
l four callbacks are p
r
ovide
d
when regi
s
tering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenne
d
y
Add
n
ew API function sql
i
te
3
_
c
r
e
ate_w
i
ndow_functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
n
n
edy
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
Kennedy
Fix another probl
e
m in lead(
)
/
l
ag()
.
A
nd s
o
me e
r
rors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Ken
n
ed
y
Fix a
b
ug
i
n the lead() and lag() wind
o
w functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n
Kennedy
Fix a problem with handling of sta
t
ements
containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenne
d
y
Fix
p
roblem with w
i
n
d
ow functions mi
n
() and
m
ax() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
nedy
M
e
rge l
a
t
e
st trunk cha
n
ges into t
h
is bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
Kennedy
Improve
comment
s
an
d
c
o
de legibility in
new fil
e
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fi
x
pr
o
blems
w
ith
"
RANGE BETWEEN CURRENT ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
Kennedy
Fix s
o
me test case
numbers in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
U
n
l
es
s
SQLITE_
O
M
IT
_
AU
T
OI
N
IT is defin
e
d
, a
l
low sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Check that malloc()
h
as not already
fa
i
led when invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
Kenne
d
y
Fix
ano
t
h
er issue t
o
do with wi
n
dow-fu
n
ctions in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenne
d
y
F
i
x
s
om
e
pro
b
lems
w
ith using window-fun
c
tion
s
in agg
r
e
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
Kennedy
Clarify the relationship
b
etween
a Wind
o
w
object
a
nd
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n K
e
nnedy
Fix handling o
f
window fram
e
s c
o
n
t
ainin
g
n
egative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ken
n
edy
Fix a
t
ypon i
n
main
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
D
a
n K
e
n
nedy
Update Makefile
.
msc to include wi
n
dow
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ke
n
n
edy
M
erge re
c
e
n
t trun
k
changes wit
h
this br
a
nch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenne
d
y
Update the amalg
a
mat
i
on buil
d
sc
r
ipt to include wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
A
d
d s
u
pport for
F
ILTER clau
s
e on a
g
greg
a
t
e window
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
D
an Ken
n
edy
A
d
d support for t
h
e
W
I
ND
O
W cl
a
use
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kennedy
Do
not flatten sub-queries
that cont
a
in
w
indow
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
Fixes t
o
allow group_concat(
)
to be used as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
n
e
dy
Merge lat
e
st trunk changes
with
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add window funct
i
on
s
lag
(
) and l
e
ad
(
)
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
Add suppor
t
for w
i
nd
o
w
f
unc
t
ion firs
t
_
v
a
l
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
F
ix pr
o
blems with the nth
_
v
a
lue
(
)
f
unc
t
ion
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
A
d
d
i
mple
m
en
t
ation of nth_value()
w
indow fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n
K
ennedy
Ca
l
cul
a
te
n
o
n-aggregate
e
xpressions in th
e
SELECT list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenn
e
dy
Ad
d
implementation of las
t
_value() window
f
unction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add
implementati
o
n of window functi
o
n
nti
l
e()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenne
d
y
Merge latest trunk change
s
into thi
s
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Kennedy
A
d
d
support for window functio
n
cum
e
_
dist(
)
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Da
n
K
e
n
n
edy
Add support
f
or w
i
nd
o
w functions row
_
n
umber(),
rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Ken
n
edy
Update
a t
e
s
t
case in malloc5
.
test to take
i
nto a
c
c
ount
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
Kennedy
Allow an entire partition to b
e
cached in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan K
e
nnedy
Fi
x
a bug in the SQLITE_ENABLE_S
O
RTER_REFEREN
C
ES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
an
K
ennedy
Allow min() an
d
ma
x
() to be used
as window functi
o
n
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase the number of database handles
opened by
t
est
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
i
x
auto
i
nc
.
test and resetdb
.
test so that the
y
work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
e
nn
e
d
y
M
ore
m
i
no
r
changes to test
s
c
rip
t
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
Fix some
test script issues caused by rec
e
nt EXPLA
I
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Ken
n
edy
Do
n
o
t run t
e
st f
i
le "re
s
etdb
.
te
s
t
"
a
s par
t
o
f
permutati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Ken
n
edy
Further window frame
t
e
sts and
fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Ke
n
nedy
Do
n
o
t requ
i
re a state
m
ent jour
n
al in cases where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More
fixe
s
for differe
n
t window frame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
Kenned
y
Fix "RA
N
GE BETWEEN
C
URRENT R
O
W AND UNBOUNDED FOLL
O
WING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge lat
e
st trun
k
changes in
t
o
t
his
bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
Kennedy
Fixes for
"ROWS B
E
TWEEN <expr
>
F
O
LLOWING A
N
D
<
e
xpr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an
K
ennedy
All
o
w
"
<expr> PRECE
D
ING"
to
b
e used
t
o specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nnedy
Su
p
port
o
ther frame
t
ypes that use "
<
expr
>
P
REC
E
D
I
NG
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
A
dd sup
p
ort for "ROWS B
E
TWEEN <expr> PRECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
M
er
g
e
latest
t
runk
change
s
i
n
to t
h
is branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kenned
y
Add
comments to
w
ind
o
w
.
c describing how other wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kenn
e
dy
B
e
gin adding
support for more esoteri
c
window frame
s
.
commit
|
commitdiff
|
tree
2018-05-19
Dan
Kennedy
F
i
x minor pro
b
lems
o
n
this branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan
K
en
n
edy
Evaluate mul
t
iple window f
u
nc
t
ions
in a sing
l
e pa
s
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kennedy
H
an
d
le mu
l
tiple window-fun
c
tions in
a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kenned
y
Start
of experimental
i
mplementa
t
ion of
SQL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
F
ix a
test case problem in wherelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan K
e
nnedy
Add a test case to ch
e
ck that
t
h
e fts5
u
n
i
code64 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Ken
n
e
dy
Fix
a problem in the xBestIn
d
ex
m
ethod of t
h
e
closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kennedy
Fi
x
a
n R
B
U problem causing spuriou
s
SQLITE_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
a
n
Kennedy
Up
d
ate
tes
t
script fts3expr4
.
test so
t
hat
i
t al
w
a
y
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
Kenned
y
Fix a
test sc
r
ipt error causing tests t
o
fail in soa
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When
p
rocessing an "ORDER BY
.
.
.
LIMIT" th
a
t d
o
es n
o
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenn
e
dy
W
hen processing a
n
"ORDER BY
.
.
.
L
I
MIT" that
d
oes
not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
a
n K
e
nnedy
Upd
a
te the "fuzz_mallo
c
.
t
est" script to
p
rint SQL statement
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Kennedy
Remove a recently
added
N
EV
E
R() macr
o
from a
b
ranch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix a problem with processing "LEFT JOIN tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenn
e
dy
Do not attempt to read
values from indexes-
o
n-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
a
n Kennedy
A few more tests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ke
n
nedy
Enhance the
"
rb
u
" command
li
n
e utilit
y
a
bit
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add tests for n
a
me resolution in O
N
CO
N
FLICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Ad
d
tes
t
c
a
ses for
U
PSER
T
.
An
d
a
fix for a
"REPL
A
CE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Modify
a test case i
n
zipfile2
.
test to take into ac
c
oun
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add the "so
r
ter-reference" optimiza
t
ion, allow
i
ng
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Minor chan
g
es to test script upsert4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
A
d
d
extra
test c
a
ses fo
r
UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
D
an Ken
n
ed
y
Fix a pro
b
lem
i
n the shell prev
e
nting it from
w
o
r
king
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan
Kennedy
Add s
o
me more
s
imple te
s
t cas
e
s f
o
r UPSER
T
.
And
a
minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan K
e
nnedy
Add SQLITE_CONFIG_SORTERREF
_
S
I
ZE configuration optio
n
.
commit
|
commitdiff
|
tree
2018-04-14
D
an Kennedy
Exp
e
rime
n
t
a
l change to "SELECT * FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Ke
n
nedy
Minor sim
p
lific
a
tion to internal func
t
ion gener
a
teSortTail(
)
.
commit
|
commitdiff
|
tree
2018-04-10
D
an Kennedy
Fix a problem
c
a
u
sing t
h
e LE
F
T JOI
N
strength reduc
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When testing, avoid injecting an OOM fault into a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
K
enn
e
dy
Fix a
p
robl
e
m c
a
usi
n
g
the L
E
FT JOIN
s
tren
g
th reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
an Kennedy
Fix
t
he fts5 xB
e
s
t
Index metho
d
so that it is not confused
.
.
.
commit
|
commitdiff
|
tree
next