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
Add the "categories" option to the unicode61 tokenizer in fts5.
2018-07-13
D
an Kenne
d
y
A
d
d th
e
"categ
o
rie
s
" opt
i
o
n
to
th
e
un
i
c
o
de
6
1
toke
n
izer
.
.
.
commit
|
commitdiff
|
tree
2018-07-12
Dan Kennedy
Add a test-control to
d
isable the skip-s
c
a
n
optimizati
o
n
.
commit
|
commitdiff
|
tree
2018-07-12
Dan Kenn
e
dy
Add
a
t
est case to check tha
t
SQLITE_DBCONFI
G
_RESE
T
_D
A
TA
B
ASE
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kenne
d
y
Mod
i
fy
t
e
sts
in win
d
ow3
.
tes
t
t
o
be tolerant of ro
u
nding
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan K
e
nnedy
Fix a problem
w
ith
using
scalar sub-se
l
ects in window
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Kenne
d
y
Av
o
id leavi
n
g
v
ie
w
-def
i
nitions
with an i
n
compl
e
te set
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Kenned
y
A
dd a coupl
e
o
f O
O
M te
s
ts
.
commit
|
commitdiff
|
tree
2018-07-09
D
an Kennedy
Throw an error if the second argum
e
nt passed to nth_
v
alue
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Ken
n
edy
F
ix a bad assert
(
) in window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix another
p
r
oblem
w
ith reusing LSM cu
r
sors
f
or range
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix an LSM p
r
oblem caused b
y
using
t
he same curso
r
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
A
d
d m
i
ssin
g
Vd
b
eCoverage() macro to window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Ke
n
nedy
Fix a
p
roble
m
with
the handlin
g
of NULL
v
a
lues in
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
K
ennedy
Als
o
disal
l
ow non-constant e
x
pressi
o
ns
i
n "<expr> PRE
C
E
DING
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Ensure an error is returned if the
u
ser
s
pe
c
ifi
e
s an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Da
n
Kenn
e
dy
Prevent "UNB
O
UNDED FOLLOWING" fro
m
being used as the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Remove
s
ome bad
a
ssert() statements
f
rom
the implementat
i
o
n
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
D
a
n Kenne
d
y
Return
an error if DISTINCT is used with
a window-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan
K
ennedy
Update
t
he reci
p
e f
o
r resetting
a
d
a
tab
a
se using
commit
|
commitdiff
|
tree
2018-07-05
Dan
K
e
n
nedy
Return an error if a "
R
ANGE"
w
in
d
ow-frame uses "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan K
e
nnedy
F
i
x
a problem in the xInverse method of window-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan K
e
nnedy
I
n wal mode, i
f
a "BEG
I
N EXCLUSIV
E
" comma
n
d (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kenn
e
dy
Fi
x
a typo ins
i
de an
a
ssert(
)
s
t
atement in
t
rod
u
ced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
Kennedy
In wa
l
mode, if
a "BE
G
I
N EXCLUS
I
VE" comman
d
(or an
y
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kennedy
Test
t
h
a
t
a
race condit
i
on can
cause a "
B
EGIN EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
an Kennedy
F
ix a problem in the xInverse callba
c
k for the bu
i
lt
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Ke
n
nedy
Fix a segfault cau
s
ed
by hav
i
ng
i
dentical
w
indow function
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
a
n
Kennedy
Fix a crash ca
u
sed by a LIKE pattern that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a
segfault caused by i
n
voking a regular aggre
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
Avoid a w
a
rning in ft
s
5
.
c
due
to no
t
u
s
ing ge
n
era
t
ed
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenned
y
Me
r
ge implementation of
S
QL
window functions
f
rom the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
ennedy
Fix a mino
r
problem in the code
f
o
r
determining
w
hether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Mer
g
e
a
l
l
chan
g
e
s from the wea
k
-f
a
l
l
b
ack branch
e
xcept
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have the tokenizer hand
l
e fa
l
lback
f
or toke
n
s "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Further performance r
e
lated t
w
e
a
ks for sq
l
ite3RunParser
(
)
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Further
tweaks to sq
l
ite3Run
P
arser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ke
n
n
edy
Imp
r
ove
on the previo
u
s c
h
e
ckin
.
Still a bit slo
w
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Inste
a
d of
using a lemon %fallback directive,
h
a
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
D
an K
e
nnedy
Modific
a
t
ions t
o
par
s
e
.
y
t
o bette
r
support backwa
r
d
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
A
d
d
m
issing
V
d
beCoverage() a
n
d
V
dbeCoverageNev
e
rTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
a
n
Kennedy
Avoid
r
edunda
n
t
ORDER BY op
e
rations
w
h
e
n rew
r
iting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
enned
y
Merge
l
a
test trunk c
h
anges
.
commit
|
commitdiff
|
tree
2018-06-25
D
an K
e
nnedy
Ad
d
documenta
t
ion
c
omment for sqlite3_
c
reate_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Da
n
Ke
n
nedy
Fix anothe
r
pro
b
lem
that
c
ould
c
a
use a cr
a
sh wh
e
n a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kenne
d
y
Fix proble
m
s w
i
th using window-func
t
ion
s
in
correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
a
n Ken
n
ed
y
Fi
x
a
problem with using LIMIT in
w
i
n
d
o
w
-
function
queries
.
commit
|
commitdiff
|
tree
2018-06-23
D
an Kennedy
F
i
x a problem with us
i
n
g
a
windo
w
-function S
E
LECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
an Kennedy
Omit all window-function related code w
h
en building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Ken
n
e
dy
Me
r
ge l
a
t
e
st trunk changes
.
commit
|
commitdiff
|
tree
2018-06-21
Da
n
Ke
n
nedy
Fix
a
problem wi
t
h
h
andling single r
o
w partitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan
Ken
n
edy
A
dd tes
t
s
t
o improve co
v
erage of
c
o
d
e in
win
d
ow
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
enned
y
Merge
l
at
e
st tr
u
nk c
h
anges with t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a problem caused by a sub-query containi
n
g a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
F
i
x
a
prob
l
em with u
s
i
ng min(
)
or max() as
a
w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix proble
m
s
with using window fu
n
ction
s
in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenne
d
y
A
d
d test case fo
r
t
he fi
x
in t
h
e
p
r
evious commit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ens
u
re that all four
c
all
b
ack
s
are provided whe
n
registering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Da
n
K
e
nne
d
y
Add new API f
u
n
c
tion sqlite3_c
r
eate_window_f
u
nctio
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Add extra O
O
M t
e
st
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
n
n
ed
y
Fix
another probl
e
m in
l
ead
(
)/lag()
.
And some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
an Kennedy
Fix a bug in t
h
e lead() and
la
g
() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kennedy
Fix a problem wit
h
handling of
s
tateme
n
ts cont
a
ini
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kenn
e
d
y
F
ix proble
m
with window
functions
min() and max(
)
when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
Ke
n
nedy
Merg
e
late
s
t
t
runk changes
in
t
o this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Im
p
rove comments and c
o
d
e
leg
i
b
i
lity in new file wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an K
e
nnedy
Fi
x
pro
b
lems wit
h
"R
A
NGE BETWE
E
N
CURRENT ROW AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
ennedy
Fix
som
e
t
est
c
ase
numbe
r
s in
e
xpert1
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQ
L
ITE
_
OMIT_AUTOINIT is defined, allow sqli
t
e3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n
Kennedy
Ch
e
ck that malloc() has not
already failed w
h
en invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
Kennedy
Fix another issue to do with window-functions in aggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix some problems with using
w
i
nd
o
w-functions i
n
agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenn
e
d
y
Clarify
t
he rel
a
tion
s
hip between a
Window o
b
ject and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
F
i
x h
a
ndli
n
g of win
d
ow frame
s
containin
g
negative numbe
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Kenne
d
y
Fix
a
t
ypo
n
i
n
m
a
in
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
D
a
n Kennedy
Up
d
ate
M
a
kefile
.
msc to in
c
l
u
de
window
.
c in the bu
i
ld
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kennedy
Merge recent trunk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Up
d
ate t
h
e
amalgamati
o
n
b
uild script to inclu
d
e window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
A
dd support for F
I
LT
E
R claus
e
on aggregate window
functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
K
enned
y
A
d
d support
f
or the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do not flatten sub-queries
that contain window functions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kenn
e
dy
Fixes to
a
l
l
ow group_concat() to be used as
a
wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
e
n
nedy
Merge latest
t
runk
chan
g
e
s with this bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenne
d
y
A
dd window fu
n
c
tion
s
lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n
K
e
nnedy
Add suppor
t
for wi
n
dow fun
c
tion first_val
u
e
()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
edy
Fix problems with
t
he
n
th_value() func
t
ion
.
commit
|
commitdiff
|
tree
2018-06-06
Da
n
Kennedy
Ad
d
impl
e
mentation of nth_value()
w
indow function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non-aggregate expressi
o
ns i
n
the SELECT l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Ke
n
nedy
Add i
m
pl
e
mentation of last
_
value() w
i
ndow
f
unction
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
Kennedy
Add i
m
plementation of window
funct
i
o
n ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenne
d
y
Merge
l
atest trunk
c
hanges
into this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
K
ennedy
Add support for wi
n
dow
f
unct
i
on cume_dist()
.
Impro
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Da
n
Kennedy
Ad
d
support fo
r
window functions row_number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenn
e
dy
Up
d
a
te a test ca
s
e
in m
a
lloc5
.
tes
t
to t
a
ke into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
Kenned
y
All
o
w
an entire p
a
rtition to be cac
h
e
d
in a t
e
mp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Fix a
b
ug i
n
t
h
e SQLITE_ENABLE_SORTE
R
_RE
F
ERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kenn
e
dy
Allow min()
a
nd max() to be us
e
d as w
i
ndo
w
f
u
nction
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Incr
e
ase the number of database handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
F
i
x a
u
toinc
.
test
a
n
d resetdb
.
test
s
o
t
h
a
t
t
h
ey wo
r
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kennedy
More mi
n
or cha
n
ges t
o
test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix
s
ome test script issues caus
e
d by recen
t
E
X
PLAIN
.
.
.
commit
|
commitdiff
|
tree
next