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
Da
n
Ken
n
edy
R
e
turn an
e
rror
if
D
I
S
TINCT is
u
se
d
with a wi
n
dow-fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Update the
r
ecipe f
o
r
re
s
etting a
database using
commit
|
commitdiff
|
tree
2018-07-05
Dan
K
enne
d
y
R
eturn
an error
if a
"
RANGE"
window-
f
rame u
s
es "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenn
e
dy
Fix a p
r
oblem in the xInverse method of win
d
ow-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
In wal mode, if a "BEGI
N
E
XCLUSIVE"
comm
a
n
d
(
o
r
any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
F
ix
a
t
ypo ins
i
de an assert() statement
i
ntroduced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Ke
n
nedy
In w
a
l mode,
if a "BEGIN EXC
L
USIVE" command
(or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kennedy
Tes
t
tha
t
a race c
o
n
d
ition can ca
u
se a
"BEGIN EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a problem
in the xInverse callback for the b
u
ilt
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nnedy
Fix a
s
egfau
l
t cau
s
ed by having
i
dentica
l
window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
a
n Kenne
d
y
Fix
a
crash caused
by a LIKE pattern that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nnedy
Fix a segfault caused b
y
invoking a regular a
g
gregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Kenned
y
Avoi
d
a w
a
rning i
n
f
t
s5
.
c
due to not using generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
M
e
rge implementat
i
on o
f
S
QL windo
w
function
s
from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Kenne
d
y
F
i
x a
minor problem in t
h
e code for dete
r
mini
n
g w
h
eth
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Kenned
y
Merge a
l
l
change
s
fr
o
m the we
a
k-fall
b
ack branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have the tokenizer
h
andle fallback for tokens "
O
V
E
R
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n Kennedy
F
urther performan
c
e related tweaks
for sqli
t
e3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n
Kenn
e
dy
Further tweaks to sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Improve on t
h
e previ
o
u
s
c
heckin
.
S
t
ill a bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Instead of
u
si
n
g a
le
m
on
%
fallback directive,
hav
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Ken
n
e
dy
Modificati
o
ns
to parse
.
y to better support bac
k
ward
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
a
n Kennedy
A
d
d mi
s
s
ing VdbeCove
r
age() and Vd
b
eCove
r
a
g
eNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kenn
e
dy
Avoid red
u
n
d
ant
O
RD
E
R BY o
p
erations when rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan K
e
n
nedy
Merge
latest t
r
u
n
k ch
a
ng
e
s
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kenn
e
dy
Add documentat
i
on comm
e
nt fo
r
sqli
t
e3_create_window
_
f
unctio
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
F
ix another problem that co
u
l
d
cause a crash when
a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ke
n
ned
y
F
i
x problems wit
h
using window-functions in corr
e
la
t
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
a
n Kennedy
Fix
a problem with using LIMIT in window-function qu
e
r
i
e
s
.
commit
|
commitdiff
|
tree
2018-06-23
D
a
n Kennedy
Fix
a
pr
o
b
lem
with using
a
window-function SELECT
as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit
a
ll wind
o
w-fun
c
tion
r
elat
e
d c
o
d
e when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan K
e
nnedy
M
erge latest trunk
c
hanges
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a
p
robl
e
m with handling single
r
o
w partitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kenne
d
y
Add te
s
ts t
o
improve coverage of
c
ode in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
a
n
Kennedy
Merg
e
l
ate
s
t trunk
c
hanges with this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-19
D
an Kennedy
Fix a pro
b
l
em caused by a
s
u
b-query containing a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a probl
e
m
w
ith
u
s
i
n
g min
(
)
o
r max() a
s
a
w
i
n
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n
Kenned
y
Fix problems wi
t
h using w
i
ndow fun
c
tions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
ed
y
Add tes
t
case for the fix in the pre
v
io
u
s commit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ensur
e
that all four callba
c
ks are provided
w
h
e
n regi
s
tering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add new AP
I
fu
n
ction sq
l
ite3_create_wind
o
w_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ken
n
edy
Add
e
x
t
r
a OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
ne
d
y
F
ix
a
noth
e
r problem in lead()/lag()
.
A
n
d some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Ke
n
nedy
F
i
x a bug
in th
e
lead() and lag() wi
n
dow functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a problem wi
t
h handling of statements con
t
ainin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Ke
n
n
e
dy
Fix problem with w
i
ndow functions min()
a
nd max
(
) wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge latest trun
k
changes into thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
n
ned
y
I
m
prove comments and code legibili
t
y
in new f
i
le
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
Fi
x
p
roblems
with
"
R
A
NGE BE
T
W
E
EN CURRENT ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
ennedy
Fix
s
ome test case
n
umbers in expert1
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
ennedy
Unl
e
s
s
SQLITE_OMIT_A
U
TOINIT is defi
n
ed, allow s
q
lite3_vfs
_
un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
enned
y
Che
c
k that mal
l
oc() has not alr
e
ady failed when i
n
voking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
Ken
n
e
d
y
Fix
another
i
s
s
ue to do w
i
th window
-
functions in aggrega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix s
o
me problem
s
with
using window-function
s
in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify the rel
a
tionship
b
etw
e
e
n
a Window object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix
hand
l
ing
of window frames containing
n
egative num
b
er
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix
a
typon in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Update Mak
e
f
ile
.
msc to
i
nclude window
.
c in
the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan K
e
n
n
ed
y
Merge recent trunk c
h
anges with this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
Kennedy
Update the amalg
a
m
a
t
i
on buil
d
script
t
o in
c
l
ude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
Kennedy
Add sup
p
ort for FILT
E
R
clause on aggr
e
g
a
te
w
indow
functio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
A
dd support f
o
r
the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
Kenned
y
Do not fla
t
ten sub-qu
e
ries t
h
at contain win
d
ow functions
.
commit
|
commitdiff
|
tree
2018-06-08
D
an Kennedy
Fixes to allow g
r
oup_concat(
)
to
be used a
s
a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Merge latest
t
r
u
n
k chan
g
es
w
i
th this branch
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Add w
i
ndow f
u
nct
i
ons lag(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
n
e
dy
Ad
d
support
for window function first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan K
e
nnedy
Fix probl
e
ms with the nth_
v
alue
(
)
f
unction
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
A
dd implementation of n
t
h_value() window function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non-aggr
e
gate expressions in the SELE
C
T
list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan K
e
n
n
edy
Add implementati
o
n of last_value() window fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
Kennedy
Add implementati
o
n
o
f w
i
nd
o
w function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge lat
e
st trunk chan
g
es into this
b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kennedy
Add support
f
or window
f
unction cu
m
e_dist()
.
Improv
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n Kennedy
Add support for window functi
o
n
s
r
o
w
_
number(), ra
n
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Update a test case in malloc5
.
test to take into a
c
co
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
ennedy
Allo
w
an entire partition to be cached in a temp
t
able
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
e
dy
F
i
x a bug
in the
SQLITE_EN
A
B
LE_SORTER_REFERENCES co
d
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow min() and
max() t
o
be
u
sed a
s
wind
o
w
fun
c
tions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
nn
e
d
y
In
c
rease the number of database handl
e
s
o
pened
b
y
test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kennedy
Fix au
t
oinc
.
test and re
s
etd
b
.
test
s
o th
a
t they w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
nne
d
y
More m
i
nor ch
a
nges to test
s
cripts
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kennedy
Fix some test scri
p
t issues caused
b
y re
c
ent EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
D
o
not run test file "resetdb
.
test" as part
o
f permutatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Da
n
Kennedy
F
urth
e
r window frame tests
and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
a
n Kenne
d
y
Do not re
q
u
ire
a statement jou
r
nal in cases wher
e
REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan
K
ennedy
More fixes for different window f
r
ame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix
"
RANGE BETWEEN CUR
R
E
N
T ROW
A
N
D
UN
B
O
UNDED FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
enned
y
Merge latest
t
r
u
nk cha
n
g
es into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
D
an Kenned
y
Fixes for
"
ROWS BETWEEN <exp
r
> FOLLOWIN
G
AND <
e
xpr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan
Ke
n
nedy
Allo
w
"<expr> PRECEDING"
to be us
e
d to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
K
ennedy
Support other
f
rame type
s
that use "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan K
e
n
n
e
dy
Add support for "ROWS BETW
E
EN
<
expr> PRECEDING
A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merge la
t
e
st trunk cha
n
ges
i
nto this branch
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n Kennedy
Add c
o
m
ments
t
o
win
d
ow
.
c
d
e
scribing how
other
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
K
en
n
ed
y
B
e
gin adding suppor
t
f
or mo
r
e esoteric window frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan
K
ennedy
Fi
x
m
i
nor
p
roblem
s
on thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evalua
t
e multiple
w
indow function
s
in a si
n
gle
p
as
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kenned
y
Handle
multipl
e
window-functions in a s
i
ngle query
.
commit
|
commitdiff
|
tree
2018-05-16
Da
n
Kennedy
Start of
e
xper
i
mental implem
e
ntation of SQL window
.
.
.
commit
|
commitdiff
|
tree
next