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
Dan
Kennedy
A
d
d the "categories" op
t
i
o
n to the unicode
6
1 tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-07-12
D
an
Kennedy
Add a tes
t
-control t
o
disable the skip-scan o
p
timization
.
commit
|
commitdiff
|
tree
2018-07-12
Dan
K
ennedy
Add a test case
t
o
check
t
hat S
Q
LITE_DBCONFIG_
R
ESET_DATA
B
ASE
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kennedy
Modify t
e
s
t
s in win
d
ow3
.
t
e
st to
be tolerant o
f
roun
d
ing
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kenned
y
Fix a probl
e
m wi
t
h
using
scalar s
u
b-sel
e
cts in
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Kennedy
Avoid leaving view-defin
i
tions with an
i
ncomplete
s
et
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Ke
n
nedy
Add a couple of OOM
tes
t
s
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Kennedy
T
hrow an error if the se
c
ond a
r
gu
m
e
nt p
a
ssed to nth_value
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
D
an
K
ennedy
F
ix a
bad ass
e
rt
(
) in wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix another problem with
r
e
using LSM cursors for
range
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan
K
e
nnedy
F
i
x
an LSM proble
m
c
a
used by using t
h
e same cursor
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Add missin
g
VdbeCoverage()
macro t
o
window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenned
y
Fix
a
proble
m
with th
e
h
an
d
ling of NULL v
a
lues in the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Also disallow non-constant expressions in "<expr> P
R
ECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Ensure
an
error is
ret
u
rned if the user specifies an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Ke
n
nedy
Prevent
"
UNBOUNDED FOLLOWING" fr
o
m being used a
s
the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kenned
y
Rem
o
ve so
m
e
b
ad assert() statem
e
nts
from the
implementations
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Da
n
Kennedy
R
e
tur
n
an
e
rror if DISTINCT is us
e
d with a window-functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Update the recipe
f
or resetting
a database using
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Return an error if a
"RANGE
"
window-fra
m
e
u
se
s
"<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n Ke
n
nedy
F
i
x a problem i
n
th
e
xInverse met
h
od of windo
w
-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
In wal
m
o
d
e, if a
"
BEGIN E
X
CLUSIVE" command
(or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan
K
ennedy
Fix
a typo ins
i
de an ass
e
r
t() stat
e
ment intr
o
duced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Ke
n
n
edy
I
n
wal mo
d
e, if a "BEGIN EXCLUSIVE" command (o
r
any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan Kenn
e
dy
Test that
a
ra
c
e condition can cause a "BE
G
I
N
EXCLUSIV
E
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
F
i
x
a
pro
b
l
e
m in the xInv
e
r
s
e c
a
llb
a
ck for the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Ke
n
nedy
Fix a se
g
fault caused
b
y having iden
t
ical window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Ke
n
nedy
Fix a cr
a
sh cause
d
by
a
LIKE pattern that consis
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segfau
l
t caused by invoking a reg
u
l
ar aggr
e
gate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
A
v
oid
a
w
arning
in ft
s
5
.
c due
t
o not u
s
ing
g
ene
r
ated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
ed
y
Merge implementati
o
n of SQL
w
in
d
ow functi
o
ns from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
an Kennedy
Fix a minor pr
o
blem in the code f
o
r de
t
ermi
n
ing whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Me
r
ge all
chang
e
s
from t
h
e
weak-fallback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have the tokenizer
h
andle f
a
llback for token
s
"O
V
ER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n Kennedy
Further
p
erformance related tweaks for sqlite3Ru
n
Parser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kenne
d
y
Further tw
e
aks to sqlite3RunP
a
rs
e
r()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n
K
enned
y
Improve on the pr
e
vious checkin
.
Still a bi
t
slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
nnedy
I
nstead of using a lemon %fallbac
k
directive
,
h
a
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Da
n
K
ennedy
Mo
d
ific
a
tion
s
to p
a
rse
.
y
to
b
e
tt
e
r
support ba
c
kwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Ke
n
nedy
Add mi
s
sing VdbeCoverage() an
d
V
d
be
C
ov
e
rageNeverTak
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan
K
ennedy
Avoid redund
a
n
t
ORDER BY opera
t
ions whe
n
rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
en
n
edy
M
e
rg
e
l
atest
t
runk c
h
a
nge
s
.
commit
|
commitdiff
|
tree
2018-06-25
D
an Kennedy
Add
d
ocume
n
tati
o
n comment for sqlite3_create_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
Fix another
prob
l
em that coul
d
cause a cras
h
when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kenned
y
Fix problems with
using window
-
f
u
nctions in corre
l
ated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
a
n Kennedy
Fix a problem with
using LIMIT i
n
window-
f
unction
queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kenned
y
Fix a problem wit
h
u
sing a window-function SELECT
as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omi
t
all wi
n
do
w
-function
re
l
ated code whe
n
building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Ke
n
n
e
dy
Merge la
t
est trun
k
changes
.
commit
|
commitdiff
|
tree
2018-06-21
Dan K
e
nnedy
F
i
x a
problem
with h
a
ndling sin
g
le
r
ow pa
r
ti
t
ions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan
Kennedy
Add tests to improve
cov
e
rage of code in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
a
n Ke
n
ne
d
y
Merge la
t
es
t
trun
k
chan
g
es with this branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan
K
ennedy
Fix a problem caused by a sub-query contai
n
ing a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
an Kennedy
Fix a pro
b
lem with
usi
n
g min() or
max()
a
s
a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix probl
e
ms with using windo
w
functions in
CRE
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add te
s
t
c
ase for the f
i
x in
the
p
revious
c
omm
i
t
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ensure that all four ca
l
lbacks are provided when registering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Da
n
Ken
n
e
dy
Add n
e
w API function sqlite3_create_window
_
f
uncti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Add extr
a
OOM
te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Ke
n
nedy
Fix anothe
r
problem in lea
d
()/
l
a
g
(
)
.
An
d
som
e
errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n Kenne
d
y
F
ix a
b
ug
i
n t
h
e lead() and l
a
g
() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
nedy
Fix a problem w
i
th handling
o
f stateme
n
ts containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Fix pro
b
l
em
w
ith window f
u
n
c
tions
m
in() and max(
)
when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
M
erg
e
l
atest
t
run
k
change
s
into thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
Kennedy
Improve
co
m
m
ents and code legibility in n
e
w
f
ile wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kenned
y
Fix problems wit
h
"RANGE BETWEEN CURREN
T
ROW AN
D
UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix
s
om
e
t
est case numbers
in expert
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQLITE_OMIT_AUTOINIT is
defi
n
ed, a
l
l
o
w s
q
lite3_vf
s
_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
Kenne
d
y
C
h
e
ck that mall
o
c(
)
has n
o
t
already fa
i
led
w
hen invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
Kennedy
Fix another issue
t
o
do with wi
n
d
ow-f
u
nc
t
ion
s
in
agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
an Kennedy
Fix some problems
w
ith usi
n
g w
i
ndow-functions
in aggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
Kennedy
Clarify t
h
e relationship between a Window object a
n
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix handling
of window frames containin
g
negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix
a
typon in m
a
in
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
U
pdate Makefile
.
msc t
o
include win
d
ow
.
c in the bu
i
ld
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Kennedy
Merge recent trunk changes with
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
U
p
date the amalgam
a
tion
build script to include wi
n
do
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
K
e
nnedy
Add support fo
r
FILTER clause on
ag
g
regate window functions
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Ke
n
n
edy
Add su
p
port for t
h
e W
I
NDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan K
e
nnedy
Do
n
ot flatten sub-querie
s
that contain w
i
n
d
ow
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
Kennedy
F
ixes to a
l
low group_c
o
ncat() to b
e
used
a
s a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
M
erge lat
e
st t
r
u
nk
changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n
K
ennedy
A
dd win
d
ow functions l
a
g(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
A
d
d support
f
o
r window function first_val
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenn
e
d
y
F
i
x problems with the nth_va
l
ue(
)
function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan
K
ennedy
Add implem
e
n
t
ation of nth_value
(
)
window
f
unct
i
on
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Ke
n
nedy
C
alculate n
o
n-aggregate expressions in
t
he S
E
LECT l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
Kennedy
Add implem
e
ntation
o
f
last_
v
alue(
)
windo
w
function
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add i
m
p
l
ementatio
n
of window function ntile
(
)
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kenned
y
Merge l
a
test trunk ch
a
nges in
t
o this b
r
an
c
h
.
commit
|
commitdiff
|
tree
2018-06-04
D
an
Kenne
d
y
Add support for win
d
ow function cume_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n
Kenne
d
y
Add support for
w
i
ndow
func
t
i
o
ns
row_num
b
er(
)
, rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Update a test case
i
n malloc5
.
test to
t
ake into acco
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Kenne
d
y
Allo
w
an entire part
i
t
io
n
to
be ca
c
hed in a
te
m
p
t
able
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Fix a bug in the SQLIT
E
_ENABLE_SORTER_REFE
R
ENC
E
S code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Da
n
Kenne
d
y
A
l
low
m
in
(
) and max()
t
o be us
e
d as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Inc
r
ease the n
u
mber of database handle
s
opened by
test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kenned
y
F
ix autoinc
.
test and reset
d
b
.
test so
t
hat they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan K
e
nnedy
Mor
e
minor changes t
o
test scrip
t
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kennedy
Fix some test s
c
r
ipt i
s
sue
s
cau
s
ed by
recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
next