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
Return an error if DISTINCT is used with a window-function (e.g.
2018-07-06
Dan Kennedy
Return
a
n error if DISTINCT is used with a window-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenne
d
y
Update the rec
i
pe
for resett
i
n
g
a
d
atab
a
se u
s
in
g
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
R
e
turn a
n
e
r
r
o
r
if a "
R
AN
G
E" win
d
ow-fram
e
uses "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
an Kennedy
Fix
a
problem in the xInverse m
e
thod of win
d
ow-f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenned
y
In wal mode, if a "BEGIN EXCLUSIVE" com
m
and
(
or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
an K
e
nnedy
Fix
a typo inside
an assert() statement introduced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
Ken
n
edy
In
wal mode, if
a
"B
E
GIN EXC
L
USIVE" command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan
Ken
n
edy
Test
t
hat
a
race condition
c
an ca
u
se
a
"BEGIN EXCLUSIV
E
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kenne
d
y
F
ix a
problem in th
e
x
I
nverse callb
a
ck
f
o
r
the b
u
i
lt
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segf
a
ult caused b
y
h
a
ving
identical window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Da
n
K
ennedy
Fix a cra
s
h caused by a LIK
E
patt
e
r
n
th
a
t consist
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segfault
caused
b
y invokin
g
a re
g
ul
a
r aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
K
e
nnedy
Avoid
a warn
i
ng in fts
5
.
c due to not
u
sing gener
a
ted
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge implementation of
S
Q
L w
i
n
d
ow
functions
f
r
om
the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
e
n
n
edy
F
i
x a
m
inor problem in the code f
o
r
d
e
termining wh
e
ther
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
edy
Mer
g
e all changes from the weak-fal
l
bac
k
branch e
x
c
e
p
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Hav
e
the t
o
kenizer handle fallbac
k
f
o
r tokens "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n K
e
nnedy
Fu
r
ther p
e
rfor
m
an
c
e
relat
e
d
tweaks
for sqli
t
e3RunPar
s
er()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
n
n
edy
Fur
t
her tweaks to sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Da
n
Kennedy
Imp
r
ove on t
h
e previo
u
s checkin
.
Still
a bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Inst
e
a
d
o
f
using a lemon %fallba
c
k directive
,
have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kennedy
Modi
f
icati
o
ns to parse
.
y to better
s
u
pport backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Da
n
Kenne
d
y
A
d
d miss
i
ng V
d
b
e
Cover
a
ge() and V
d
beCo
v
erageNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Avoid
redunda
n
t ORDER B
Y
operatio
n
s when rewriti
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Kennedy
Merg
e
l
at
e
st trunk changes
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Ken
n
edy
Add documentation com
m
ent
for sqli
t
e3_create_wind
o
w_functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
K
ennedy
Fi
x
a
nother prob
l
em
that
could cause a crash when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fi
x
probl
e
ms with
us
i
ng window-funct
i
o
n
s
in correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
e
d
y
Fix a pr
o
blem with
using
L
IMIT in window-f
u
n
c
t
i
on qu
e
ries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
ed
y
Fix a p
r
oblem with us
i
ng a window-func
t
i
on SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n Kennedy
Omit all wi
n
dow-
f
unction rela
t
ed code when buil
d
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kenne
d
y
Merge l
a
test trunk changes
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a proble
m
with handling single row
p
artitio
n
s in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kenn
e
d
y
A
dd tests t
o
i
mprove coverage o
f
code in
w
i
ndow
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
a
n Kennedy
Merge latest tr
u
nk chang
e
s with t
h
is
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
e
n
nedy
Fix a
probl
e
m ca
u
s
ed by a sub-query con
t
aining a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fi
x
a probl
e
m with using
m
in()
or
max() as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan
Kenn
e
dy
F
ix problems
with using window fu
n
ctions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
edy
Add test c
a
se
f
or th
e
fix
i
n
the previous commit
.
commit
|
commitdiff
|
tree
2018-06-18
Da
n
Ke
n
nedy
E
nsure that
a
ll
four
c
allb
a
cks are provided when registeri
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add new API
function sqlite3_cre
a
t
e_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Kenne
d
y
Add extra
O
OM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
nnedy
Fix ano
t
her
p
r
o
b
l
em in lead()/lag()
.
And some error
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fi
x
a
bug
i
n the lead() and lag()
w
indow fu
n
ction
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
Kennedy
Fix a problem
w
it
h
han
d
l
ing of
s
tatements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Ken
n
edy
Fix prob
l
em w
i
th
w
indow fu
n
cti
o
ns
min() an
d
max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
ennedy
Merge latest trunk changes into this branc
h
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Imp
r
ove co
m
men
t
s and code
legib
i
l
i
t
y in new file w
i
n
do
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n
Kenn
e
dy
Fix problems wi
t
h "RA
N
GE
B
ETWEEN CURRENT ROW AND U
N
BOUNDE
D
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix some t
e
st
case numbe
r
s in exper
t
1
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQLITE_OMIT_AUTOINIT is def
i
ned, allow sqli
t
e3_vfs
_
un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
Ken
n
e
dy
Check tha
t
m
a
lloc(
)
h
as
not
a
lready
fa
i
led wh
e
n invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
an Ken
n
ed
y
F
i
x another
i
ssue
to do with
w
indow-functions i
n
a
g
g
regat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenn
e
dy
F
i
x some pr
o
blems w
i
t
h using window-funct
i
ons in a
g
gregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
C
larify the rel
a
tionship between a Window o
b
je
c
t
and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix handl
i
n
g
of window fram
e
s conta
i
ning
negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
Ken
n
edy
Fi
x
a typon
i
n main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
D
a
n
Kennedy
Upd
a
te Makefile
.
m
s
c to
incl
u
de window
.
c i
n
t
h
e buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
d
y
Merge recent t
r
unk changes with this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
Kenn
e
dy
U
p
date
t
he
amalgamation build scrip
t
t
o
include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n K
e
nnedy
Add
support for FILT
E
R clause on
a
ggregate window functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Add support for
the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
D
an Kenned
y
Do not fla
t
te
n
sub-queries that contain window functions
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
K
enned
y
F
i
xes to allow grou
p
_con
c
at
(
) to be used as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Merge latest trunk c
h
an
g
es
w
ith this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
nedy
A
d
d wi
n
dow functions lag()
a
nd
l
ead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
A
d
d
support for w
i
ndow function first_va
l
ue()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
e
dy
Fix problems w
i
th
the nth_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Ke
n
nedy
A
d
d
im
p
lementati
o
n of nth_va
l
ue() window function
.
commit
|
commitdiff
|
tree
2018-06-05
D
an Kennedy
C
al
c
ulate n
o
n-aggregate
express
i
o
ns in
t
h
e
SELECT list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Add implementa
t
ion of la
s
t_value()
w
i
n
d
ow f
u
ncti
o
n
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kennedy
Add
implementation of win
d
ow function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Kennedy
M
e
rg
e
latest tr
u
nk changes into
this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add support for window function c
u
me_d
i
st()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Ad
d
support f
o
r
w
i
n
d
ow f
u
nctions ro
w
_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
K
ennedy
Update a
test cas
e
in ma
l
loc5
.
test to tak
e
i
nto
acco
u
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
Allow an e
n
tire partition to be cached in a t
e
mp
t
able
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenn
e
dy
Fix a bug
i
n the SQ
L
ITE_E
N
ABLE_SORTER_REFERENCE
S
code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
A
llow m
i
n()
and max()
t
o
be use
d
as
window f
u
nct
i
ons
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
I
n
c
rease the number of
d
atabase
h
andles open
e
d b
y
test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fi
x
autoinc
.
test a
n
d
r
es
e
t
d
b
.
t
est
s
o that they
w
ork
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
More minor change
s
to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenne
d
y
Fix some test s
c
ript issues caused by rece
n
t EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do not run test file "reset
d
b
.
test" as part o
f
permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Ken
n
edy
Fu
r
ther wind
o
w frame test
s
and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kennedy
Do
n
ot requ
i
r
e a statement journal in ca
s
es where
RE
P
L
A
CE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
Mor
e
f
ixes for different window frame types
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kenned
y
Fix "RANGE BETWEEN CUR
R
ENT ROW AND UNBOUNDED
F
OLLOW
I
NG
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge latest
trunk changes i
n
t
o
this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenned
y
Fix
e
s
for "ROWS BETWEEN <
e
xpr> FOLLOWING AN
D
<
expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Allow "
<
expr> PREC
E
DING" to b
e
used
t
o specif
y
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
Ke
n
nedy
Support other frame
t
ypes tha
t
u
s
e
"<expr> P
R
ECEDI
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add support for "R
O
WS B
E
TWEEN <expr> PR
E
CEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merg
e
latest trunk changes int
o
this b
r
a
nch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Ad
d
comments t
o
window
.
c
d
escrib
i
ng how
other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
Kennedy
Beg
i
n
adding
s
u
pport
for more esote
r
ic
window
f
r
ames
.
commit
|
commitdiff
|
tree
2018-05-19
D
a
n
Kennedy
Fix m
i
nor pr
o
blems on this branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
E
valuate mult
i
p
l
e window f
u
nctions in a single
p
as
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Handle multiple window-function
s
i
n a single query
.
commit
|
commitdiff
|
tree
2018-05-16
D
an Ken
n
edy
Start o
f
experiment
a
l imp
l
ementation
o
f
S
QL
w
i
n
dow
.
.
.
commit
|
commitdiff
|
tree
next