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
Modify tests in window3.test to be tolerant of rounding errors when comparing
2018-07-10
Dan
Kennedy
Modify
tests in wind
o
w3
.
test to be
t
o
l
era
n
t of ro
u
nding
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kennedy
Fix a
p
r
oblem wit
h
using
s
ca
l
ar su
b
-select
s
in wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan
K
e
nnedy
Avoid leaving view-definit
i
o
n
s with an incomplete set
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
D
a
n Ke
n
n
e
dy
Add a couple o
f
OOM t
e
sts
.
commit
|
commitdiff
|
tree
2018-07-09
D
an Kennedy
Throw an e
r
r
o
r
i
f
the secon
d
a
r
gu
m
ent passe
d
to nth_
v
alue
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Ke
n
ne
d
y
Fix
a
bad assert()
i
n window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
D
a
n Kennedy
Fix another proble
m
w
i
th reusing LSM cursors f
o
r
ra
n
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
D
a
n Kennedy
Fix an LSM problem caused by usin
g
the same curs
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenn
e
dy
Ad
d
missin
g
Vd
b
e
C
overage() macro to wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan K
e
nned
y
Fix a prob
l
em w
i
th
t
h
e
h
a
ndling of NULL values in the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Ke
n
ned
y
Also disallo
w
n
on-co
n
stant expressions in
"
<e
x
pr
>
PR
E
CEDING
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Ensure an
error is returned if
t
he
user
s
p
ecifies an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
K
ennedy
P
r
event "UN
B
OUNDED FOLLOWIN
G
" from being
used as the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Da
n
Kenne
d
y
Remove some bad assert() s
t
ateme
n
ts fr
o
m
the impl
e
mentations
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
Kennedy
Return an error if DISTINCT is used w
i
th
a
window-f
u
nctio
n
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
Kenned
y
Update th
e
re
c
ip
e
for resetting
a
dat
a
base using
commit
|
commitdiff
|
tree
2018-07-05
D
an
Kenn
e
dy
Re
t
ur
n
an error if a "RANG
E
" win
d
ow
-
frame u
s
es "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Fix a prob
l
em in the xI
n
verse me
t
hod of window-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
In
w
al
m
o
de, if a "
B
EGIN EXCL
U
SIVE" command (or
a
ny
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
K
e
nn
e
dy
Fix a typo in
s
i
d
e an as
s
ert() st
a
tement
i
ntroduce
d
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
In wal mode, if a "BEGIN EXCLUSIVE"
command (
o
r any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kenne
d
y
Test that a race condition ca
n
cause a "BEG
I
N
EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
K
ennedy
F
i
x a problem in the xInverse callback for
the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nnedy
Fix
a
s
e
gfau
l
t cause
d
by having
id
e
ntica
l
wi
n
dow fun
c
tions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a crash caused
b
y a LIKE
p
atte
r
n th
a
t con
s
ists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan K
e
nnedy
Fi
x
a
s
eg
f
ault caused
by
i
nvoking a regula
r
aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenned
y
Avoid a warning in fts5
.
c due to not u
s
ing generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge impleme
n
tation of
S
Q
L window
fu
n
ctions from
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ke
n
nedy
Fix
a
minor
p
roblem in t
h
e code for dete
r
mining wheth
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n Kennedy
M
e
r
g
e
a
l
l changes from the weak-fallback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Ken
n
edy
Have the tokenizer
handle
fallbac
k
f
or to
k
en
s
"OVE
R
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenned
y
F
u
rt
h
e
r
perf
o
rmance related tweaks f
o
r sql
i
te3
R
unPa
r
ser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Kenne
d
y
Further tweaks to sqlite3Run
P
arser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
an
Kennedy
Improve on the
previous checkin
.
Still
a bit s
l
ow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kennedy
Inste
a
d
o
f u
s
ing
a
lemo
n
%
f
allback directive, have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kenn
e
dy
Modifications to p
a
rse
.
y to better sup
p
ort backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add missing Vd
b
eCoverage() and V
d
beCo
v
erageNeve
r
Take
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Ke
n
ne
d
y
Avoid r
e
dundant ORDER BY
o
p
erations whe
n
rew
r
iti
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Kenne
d
y
M
e
rge
latest t
r
unk
c
hang
e
s
.
commit
|
commitdiff
|
tree
2018-06-25
Da
n
K
e
nnedy
Add docu
m
e
n
tation comment for sq
l
it
e
3_crea
t
e_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
Kennedy
F
ix
a
no
t
her probl
e
m that
c
ou
l
d cause a crash
w
hen
a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix prob
l
ems with usi
n
g window-function
s
i
n correla
t
ed
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
an Kenne
d
y
Fix a pro
b
lem with using LIMIT
i
n wi
n
dow
-
function que
r
ies
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix
a problem with usi
n
g
a
wi
n
dow
-
function S
E
LECT a
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan
K
ennedy
Omit al
l
window-func
t
ion
relat
e
d code when build
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Merge latest
t
runk changes
.
commit
|
commitdiff
|
tree
2018-06-21
Dan
Kennedy
F
i
x a proble
m
wit
h
h
a
n
d
l
i
ng singl
e
r
o
w partitions i
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
A
dd tests
t
o im
p
rove coverage of code in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan K
e
nnedy
Merge
latest tr
u
nk changes w
i
t
h thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix
a
problem caused by a sub-quer
y
con
t
aining a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Da
n
Ke
n
nedy
Fix a pro
b
lem
w
ith us
i
ng min() or max() as
a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
edy
Fix problems wit
h
using windo
w
f
unctions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add test case for the
f
i
x in
the previous
c
ommit
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Ensure that all
four cal
l
backs a
r
e provided when
reg
i
stering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan K
e
nnedy
Add n
e
w API
f
unctio
n
sqlite3_create_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Add e
x
tra
O
OM test
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
K
ennedy
Fi
x
another pro
b
lem in lead()/lag()
.
And s
o
me
er
r
ors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix a bug in t
h
e l
e
ad() and la
g
() window
functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
Kennedy
Fix a
problem with handling of statements
c
ontainin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
i
x pro
b
lem with
w
i
ndo
w
f
u
nct
i
ons min()
a
nd max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
Merge
lat
e
st t
r
u
n
k
changes
int
o
this branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
nnedy
Improve comments a
n
d
code legibility in new file window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix p
r
oblems w
i
th "RA
N
GE BET
W
EE
N
CURRENT R
O
W
A
N
D UNBO
U
NDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan K
e
nn
e
dy
F
ix some t
e
st
case numbers i
n
expe
r
t1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kenned
y
Unless SQLITE_
O
MIT
_
AU
T
O
I
NIT is defined, al
l
ow sq
l
ite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
e
d
y
Check
that malloc() ha
s
not
already faile
d
when invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
ennedy
Fi
x
another issue to do with window-f
u
nct
i
ons
i
n
ag
g
regate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
ennedy
Fi
x
some problems with
using w
i
ndow-functions in
a
ggre
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify
t
he relationship between a Windo
w
object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix handli
n
g of
w
i
nd
o
w fr
a
m
e
s containing negati
v
e nu
m
ber
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
nned
y
Fi
x
a
typon i
n
main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Upd
a
te Makefile
.
msc to include window
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Merge recent trunk changes wit
h
th
i
s
branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Update
t
he amalgamat
i
on
b
uild
s
cr
i
pt to include
wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kenne
d
y
Add sup
p
ort for FILTER clause on agg
r
egate window function
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ken
n
edy
Add support f
o
r the WINDOW cl
a
u
s
e
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
Do
not
f
latt
e
n
sub-queries that contain
win
d
ow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
F
i
x
e
s
to allow group_concat() to be used
a
s a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
Merge latest trunk c
h
anges wi
t
h this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenne
d
y
Add window functio
n
s
l
a
g(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Da
n
Kennedy
Ad
d
su
p
port for
wind
o
w fu
n
ct
i
on f
i
r
s
t_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Fix proble
m
s with the nth_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Ken
n
edy
A
dd implementat
i
on of nth_value() windo
w
function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non-agg
r
egate expression
s
in
t
he SELECT list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
Kennedy
Add imp
l
e
m
enta
t
io
n
o
f
last_value
(
) window function
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add imp
l
ementation of window
function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merg
e
latest tru
n
k
c
han
g
es
into
this bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add support for window function cume_di
s
t()
.
Im
p
rove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenne
d
y
Add support for window functions row_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Ke
n
nedy
Updat
e
a test c
a
se in malloc5
.
te
s
t to
t
ake into ac
c
ount
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kenne
d
y
Allo
w
an
e
nt
i
re partition to be
cache
d
in a
temp ta
b
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
Fix a bug
i
n th
e
SQLITE
_
ENABLE_SORTER_REF
E
RENCES c
o
de
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow
m
in() and max() t
o
be
used as window fun
c
tions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Ken
n
e
dy
I
n
crease the
number of database handl
e
s open
e
d by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
n
n
e
d
y
Fi
x
autoinc
.
test and
r
esetdb
.
test so
t
hat
they
work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
nnedy
More minor changes to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
en
n
e
d
y
Fix some test script issues caused by recent EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do not run test file "rese
t
db
.
test" as pa
r
t of permu
t
ation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenn
e
dy
Further
w
indow fr
a
me tests a
n
d fix
e
s
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenned
y
Do not re
q
uire a statement
journ
a
l in cases wher
e
R
E
P
LACE
.
.
.
commit
|
commitdiff
|
tree
next