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 Kenn
e
dy
Add the "cate
g
ories" option to the
u
nicode61 tokeniz
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-07-12
Dan Kennedy
Add a test-control to disable the
skip-sca
n
optimization
.
commit
|
commitdiff
|
tree
2018-07-12
Dan Ke
n
nedy
Add a test
c
ase to
c
heck th
a
t S
Q
LITE_DBC
O
N
F
I
G_
R
ESET_DATABASE
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Ken
n
edy
Modify tests in wi
n
dow3
.
test to b
e
t
o
lerant of ro
u
nding
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kennedy
Fix a problem
w
ith using scalar
sub-sel
e
cts in window
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Da
n
Ke
n
n
edy
Avoid l
e
a
v
in
g
vi
e
w
-defin
i
tions with an
incom
p
lete set
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
D
an
K
ennedy
Add a co
u
ple of OOM tests
.
commit
|
commitdiff
|
tree
2018-07-09
Dan K
e
n
nedy
Th
r
ow an er
r
or if
th
e
sec
o
nd argu
m
ent passed
t
o
n
th_value
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Ke
n
nedy
F
i
x a
b
ad assert
(
) in window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fi
x
another
p
rob
l
em with reusi
n
g LSM
c
ur
s
ors fo
r
r
a
nge
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix an LSM probl
e
m
caused by using the
s
ame
cursor
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenn
e
dy
Add missing Vd
b
eCovera
g
e()
m
a
c
r
o to wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix a problem with th
e
handl
i
n
g of
N
ULL val
u
es in
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Ken
n
edy
Also disallow non-const
a
nt
e
xpressions in "<e
x
pr> PRECEDIN
G
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kenne
d
y
E
nsure
a
n
err
o
r is
r
eturned if the user specifi
e
s an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
D
a
n
Kennedy
Preven
t
"
U
NBOUNDE
D
F
O
LLOWING" from bein
g
u
s
e
d as the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Rem
o
ve some bad asser
t
() sta
t
ements
from th
e
impleme
n
tat
i
ons
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
Kennedy
Return an error i
f
DISTINCT is us
e
d
w
ith a window-fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n Kenn
e
dy
Upd
a
te the recipe
for resetting a
da
t
abas
e
u
sing
commit
|
commitdiff
|
tree
2018-07-05
Da
n
Kennedy
Retu
r
n an error if a "RANGE"
win
d
o
w-
f
r
a
me
u
se
s
"<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan K
e
nnedy
F
i
x a problem in the x
I
nverse method of
w
in
d
ow-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n Kennedy
In wal mode, if
a
"
B
EGIN EXC
L
USIVE" com
m
and (
o
r any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
an Kenned
y
Fix a
t
ypo inside an assert
(
) statement i
n
troduced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n
K
enn
e
dy
In
w
a
l
m
ode,
if a "BEGI
N
EXCLU
S
IVE" command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan K
e
nned
y
Test
t
ha
t
a
race condition can cause
a "BEGIN EXCLUSIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a problem
in the xInverse callback
f
or the built
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
Kennedy
Fix a segf
a
ul
t
c
a
used
b
y
h
aving identical window functions
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a
c
r
ash cau
s
e
d by a L
I
K
E
pattern that c
o
nsist
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Da
n
Ken
n
e
d
y
Fix
a
segfault caused by
invoking a r
e
gular aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
A
void a
w
arn
i
ng
i
n f
t
s5
.
c
d
ue to not u
s
ing generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Ke
n
nedy
Merge im
p
l
ementat
i
on of SQ
L
w
indow
functions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenned
y
Fix a mi
n
o
r pro
b
lem in the code fo
r
determining wh
e
ther
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge all c
h
anges from the
w
eak-fallback
b
ran
c
h except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
Have t
h
e tokenizer handle f
a
llba
c
k for tokens "OV
E
R
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n K
e
nnedy
Further performance r
e
lated tweaks for sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
F
urther tweaks to sqlite3RunPar
s
e
r()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n Kennedy
Improv
e
o
n the previ
o
us
c
h
ec
k
in
.
Still
a bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kenned
y
Instead
o
f usi
n
g
a
l
e
mon %f
a
llback d
i
r
e
c
tive, have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Da
n
Kenned
y
Mo
d
ifications to parse
.
y
t
o
better
s
u
p
port backward
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add
m
i
s
sing VdbeCov
e
rage() and VdbeCoverage
N
everTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Avoid redund
a
nt ORDER BY operations when
rew
r
iti
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Kennedy
Merge late
s
t trunk cha
n
ges
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
Kennedy
Add documentation c
o
m
ment for
sqlite3_create_window_funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kenne
d
y
Fix a
n
other pr
o
blem tha
t
co
u
ld cause a
c
rash when
a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix pr
o
ble
m
s with using
windo
w
-functions in correl
a
t
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
F
ix a p
r
ob
l
em w
i
th us
i
n
g LIMIT i
n
w
i
n
d
o
w-function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
Fix a pr
o
blem with
usi
n
g a
w
indow
-
f
unctio
n
S
E
L
ECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n Ken
n
edy
Omit all
windo
w
-fu
n
cti
o
n related
code
w
hen
b
u
i
lding
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
D
a
n K
e
nn
e
dy
Merge
late
s
t tr
u
nk changes
.
commit
|
commitdiff
|
tree
2018-06-21
Da
n
K
e
nnedy
Fix a
pro
b
lem with handling single row parti
t
i
ons
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kenned
y
Ad
d
t
ests t
o
i
m
prove cove
r
a
g
e of
c
ode
in
w
indow
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
a
n K
e
nnedy
Merge
latest
t
runk
c
han
g
es
w
ith this branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan K
e
nnedy
Fix a problem cau
s
e
d
by a sub
-
query contain
i
ng
a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ke
n
n
e
d
y
F
i
x
a problem with using min
(
)
or max() as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenned
y
Fix problems
with using
window
f
u
n
ctio
n
s in CREA
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenn
e
d
y
Ad
d
test case
for
t
h
e fix in the
pr
e
v
ious com
m
it
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
E
n
sure that all four callbacks are pr
o
vi
d
ed when
regist
e
ring
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
A
d
d
new API f
u
n
ctio
n
sqlite3_cr
e
ate_
w
indow
_
function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n
K
ennedy
Add
extra
O
OM te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
D
an Kennedy
Fix another problem in lea
d
(
)
/
l
ag(
)
.
A
n
d som
e
e
r
r
ors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ken
n
e
dy
Fix a bug in the le
a
d() and lag() wi
n
do
w
functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a prob
l
e
m
with han
d
ling
of statements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
Fix problem with wi
n
dow fu
n
ct
i
ons
min() a
n
d max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
M
erge latest trunk changes into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Improve
c
omments and c
o
de legi
b
i
l
it
y
in new
f
ile wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
F
i
x
problems wit
h
"RANGE BETWE
E
N
CURR
E
NT ROW
AND UNBOUND
E
D
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix s
o
me test case numbers in expert
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
K
ennedy
Unless SQL
I
TE_OMIT_AUTO
I
NIT is defi
n
ed, allow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
an K
e
nnedy
Check t
h
at malloc
(
) has not already failed when i
n
voking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
Ke
n
nedy
F
ix an
o
ther issue to do with window-functions in aggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Ken
n
edy
Fi
x
som
e
proble
m
s with using window-func
t
ions in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenn
e
dy
Clarify the relationship between a Window
obje
c
t and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix h
a
n
d
ling of window
f
rames containing negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix a typon in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Ken
n
e
dy
Upd
a
te Make
f
ile
.
msc to in
c
lud
e
window
.
c
in t
h
e buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Kennedy
Merge re
c
ent
t
r
unk cha
n
ges w
i
th thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n Kennedy
Update the amalgamatio
n
b
ui
l
d
s
cript to i
n
cl
u
de
wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ken
n
e
dy
Add supp
o
rt for FILTER
c
lause
o
n ag
g
regat
e
window functi
o
ns
.
commit
|
commitdiff
|
tree
2018-06-08
Dan K
e
nnedy
Add
s
upport fo
r
t
he WINDOW clau
s
e
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do
not fl
a
t
ten s
u
b-q
u
e
r
ies that
c
ontain window functio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to
allow
group_con
c
a
t
() to be used a
s
a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ke
n
ned
y
Merge
latest tr
u
nk chan
g
es wi
t
h
th
i
s branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan K
e
nned
y
A
d
d
window
f
u
nction
s
lag() and lead
(
)
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add suppo
r
t
f
o
r
window f
u
n
c
tion first_value
(
)
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
F
i
x pro
b
l
e
ms with the nth_value()
fu
n
ct
i
on
.
commit
|
commitdiff
|
tree
2018-06-06
Dan
K
ennedy
Add i
m
plementation
o
f nth_value() window function
.
commit
|
commitdiff
|
tree
2018-06-05
D
an Kenne
d
y
Calcu
l
ate non-ag
g
regate expressions in the
S
E
LECT list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Add implementation of
l
a
st_valu
e
()
w
indow
f
unction
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Ke
n
ned
y
Ad
d
implementation of window function
ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
nedy
Mer
g
e latest trunk changes into this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan K
e
nnedy
Add s
u
p
p
ort for
w
indow functio
n
c
um
e
_dist
(
)
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Add support f
o
r window functions row
_
number(),
rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Update a tes
t
case i
n
m
alloc5
.
test
to take
into a
c
count
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Ke
n
nedy
Allow a
n
ent
i
re par
t
it
i
on to be cached in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kenne
d
y
F
i
x a bug
in the SQLITE_ENABL
E
_SORTE
R
_REFERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow min() and max() to be used as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Inc
r
ease
t
he
number
of datab
a
s
e
hand
l
es opened by
t
e
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenn
e
dy
Fix autoinc
.
t
e
s
t and resetdb
.
t
est so tha
t
th
e
y work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Ke
n
nedy
More
m
i
nor
changes to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
F
ix some
t
est sc
r
ip
t
issues
caus
e
d by recent
E
XPL
A
I
N
.
.
.
commit
|
commitdiff
|
tree
next