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
Fix a minor problem in the code for determining whether or not an SQL
2018-06-30
Dan Kennedy
Fix a mi
n
or problem in the code for determ
i
ning whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ke
n
nedy
Merge
a
ll changes fro
m
the
w
eak-
f
a
l
lback branc
h
excep
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
K
enne
d
y
Have
t
h
e
to
k
enizer
h
andle fallbac
k
for tokens "O
V
ER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ke
n
nedy
Fur
t
he
r
pe
r
formance relate
d
t
weaks for sqli
t
e3RunPar
s
er()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
K
ennedy
F
u
rther
tweaks
to
s
q
l
ite3
R
unParser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
nnedy
Improve on
the previou
s
checkin
.
Still a
b
i
t
slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ke
n
nedy
Ins
t
ead of using a le
m
on %fallback dir
e
ct
i
ve,
ha
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kennedy
Modifications to parse
.
y to bet
t
er
support backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add
missing VdbeCoverage() and
Vd
b
eCoverageNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan
K
e
n
nedy
Avoid redundant ORDER BY operations
when
r
ewri
t
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
D
an Kennedy
Merge
l
atest tr
u
nk changes
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
Add documentation comment for sql
i
te3_c
r
e
ate_window_f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
F
i
x
an
o
ther problem that
could c
a
use a cra
s
h when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
Fi
x
problems with
using wi
n
do
w
-fu
n
ctions in correla
t
ed
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix a pro
b
lem wi
t
h u
s
ing LIMIT
in wi
n
dow-function quer
i
es
.
commit
|
commitdiff
|
tree
2018-06-23
Da
n
Kennedy
Fix a problem with
using a window-function SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Da
n
Kennedy
Omit all win
d
ow-fun
c
ti
o
n rela
t
ed code when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Ken
n
edy
Mer
g
e latest trunk chan
g
es
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kenned
y
Fix
a pr
o
blem with handling single row partitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Da
n
K
ennedy
Ad
d
te
s
ts to improve co
v
erage of code in w
i
ndo
w
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan K
e
nnedy
Merge lates
t
trunk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan K
e
nnedy
F
i
x a problem ca
u
sed by a sub-query conta
i
nin
g
a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
edy
Fix
a pro
b
lem with using min() or ma
x
(
) as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kenn
e
d
y
Fix pro
b
lems wit
h
u
sing window function
s
in
C
R
EATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
edy
Add te
s
t c
a
se fo
r
the fix
in the p
r
e
v
ious
c
ommit
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Ensure that all four cal
l
back
s
are
provided
w
hen registe
r
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan K
e
nnedy
A
dd new API function s
q
l
ite3_create_win
d
ow_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kenn
e
dy
Add extr
a
OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix an
o
t
h
er problem
i
n le
a
d()/lag(
)
.
And some
er
r
ors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n Ke
n
nedy
Fi
x
a bug in th
e
lead() and lag() window
f
unctions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a problem with handlin
g
of
s
tatement
s
containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenned
y
Fi
x
problem with wind
o
w
functions min
(
) and max() w
h
en
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Merge
lat
e
st trunk change
s
into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
K
e
nnedy
Improve
c
o
mme
n
ts and code legibility
i
n n
e
w f
i
le
w
indow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
ed
y
Fix
problems with "RANGE BETWEEN CURRENT ROW AND
UNBOUNDE
D
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
F
ix some t
e
st ca
s
e numbers in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless
SQLITE_OMIT_AUTOINIT i
s
define
d
, allow s
q
lit
e
3_vfs_
u
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
K
ennedy
Check that malloc() has
n
ot alre
a
dy f
a
i
led when
invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix anot
h
er issue
t
o do with window-functions
i
n aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix some
problems with u
s
ing window-function
s
in agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n Kennedy
Clarify the relationship between a Wind
o
w
obj
e
c
t
and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
Kennedy
Fix
hand
l
ing
o
f
window
f
r
ames contain
i
ng
n
egative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
ennedy
Fix a typon in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Update Makefile
.
msc to
i
nclude win
d
ow
.
c i
n
the bui
l
d
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
Merge
r
ecent trunk
changes with this
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Update th
e
a
m
algamation
b
uild script to
i
n
clude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Add su
p
p
o
rt
for FILTER clause
on ag
g
r
e
g
ate windo
w
f
unctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan K
e
nn
e
dy
Add support for the WIN
D
OW
clau
s
e
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
K
enn
e
dy
Do not fl
a
tten sub-qu
e
r
ies
t
h
a
t contain
w
in
d
ow functio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
F
ixes to
allow
g
ro
u
p_concat
(
)
to
be used
a
s
a w
i
ndo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan K
e
nnedy
Merge latest trunk chan
g
e
s with th
i
s
b
ranch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add
w
indow functions l
a
g()
a
n
d
l
ead(
)
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
Add
s
upport fo
r
wind
o
w func
t
ion
first
_
valu
e
()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Fi
x
probl
e
ms wi
t
h the nth_va
l
u
e
() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kenned
y
Add implementa
t
i
on
of
nth_value(
)
window functi
o
n
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
C
a
lculate non
-
aggregate ex
p
re
s
sions i
n
the SELEC
T
li
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
A
d
d
i
m
plemen
t
ation of l
a
st_
v
alue() wind
o
w fu
n
ctio
n
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add implementa
t
ion of window func
t
ion nti
l
e()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge latest trunk c
h
anges into this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-04
D
an
K
enned
y
A
d
d support for window function cume_dist()
.
I
m
pr
o
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
A
d
d support for window functions row
_
n
u
mber(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenne
d
y
U
pdate a
test case in
m
allo
c
5
.
t
est to tak
e
into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n Kennedy
A
l
l
ow
a
n entire part
i
tion to be
cach
e
d in a
t
emp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
ennedy
Fix
a bug
i
n the SQ
L
ITE_ENABLE_S
O
R
TER_REFER
E
NCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Ke
n
n
e
dy
Al
l
o
w
m
in()
a
nd
max() to b
e
used as window f
u
n
c
t
ions
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Ken
n
edy
Increa
s
e the nu
m
ber of database handles opened by te
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Ke
n
ne
d
y
F
ix autoinc
.
test
and reset
d
b
.
test so t
h
at they
w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
More minor ch
a
nges to test script
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
ne
d
y
F
ix some
t
est script issues
caused b
y
recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
n
edy
Do not ru
n
test file "re
s
etdb
.
test" as
part of pe
r
mutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
Further
window frame
t
es
t
s
and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Ken
n
edy
Do not require a st
a
tem
e
nt journ
a
l
in cases wher
e
REP
L
ACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More
fixes for different
w
i
ndow f
r
ame
t
ypes
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
Fix "RANGE BET
W
EEN CURRENT ROW
A
N
D
UNBOUNDE
D
FOL
L
OWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Kennedy
Merge l
a
test trunk c
h
anges into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fixes for "ROWS BET
W
E
E
N <expr> FOLLOWING AN
D
<expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kenn
e
dy
Allow "<expr> PRECEDING" to be
used
t
o
sp
e
c
i
fy the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an
K
e
n
n
edy
Support othe
r
fra
m
e typ
e
s that us
e
"<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Ke
n
nedy
Add suppor
t
for
"ROWS BETWEEN
<ex
p
r
> PR
E
C
E
D
ING
A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n
Ken
n
edy
M
e
rge l
a
test trunk
c
hanges
into this branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Add
c
omment
s
to window
.
c describing how othe
r
wi
n
d
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
Ke
n
nedy
Begi
n
adding support for more
e
soteric wind
o
w
frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fix
m
i
n
or
p
roblem
s
o
n
thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evaluate mult
i
ple
window functions i
n
a
single pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
H
andle multip
l
e window-fun
c
t
ions in a single
query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Start of experimental
i
mplementa
t
ion of SQL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
D
an Kennedy
Fix a t
e
st case problem in wher
e
limit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan
Kennedy
Add a
t
est
c
ase to
c
hec
k
that
t
he fts5 unicode64 tok
e
nizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
Fi
x
a prob
l
e
m
in the
x
BestIndex
method of the closur
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan
K
e
nne
d
y
Fix an RBU problem causing spuri
o
us SQLITE_CONSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Ke
n
nedy
Update test script fts3expr
4
.
test s
o
that
i
t always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenne
d
y
Fix a test
s
cript error causing tests to fa
i
l in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
W
hen proc
e
ssing
an
"
O
R
DER
BY
.
.
.
L
I
MIT" th
a
t doe
s
no
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Wh
e
n processing an "O
R
D
E
R
BY
.
.
.
LIMIT" that d
o
es not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kenned
y
Update the "fuzz_malloc
.
test" script to pri
n
t SQ
L
state
m
ents
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
a
n Kennedy
Remove a re
c
ently added NEVER() macr
o
from a br
a
nch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan K
e
nnedy
Fix
a
p
r
oblem with
proc
e
ssing "LEFT JOIN tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Do not attempt to
read values from indexes-on-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
an Kenn
e
dy
A few more tests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Da
n
Ke
n
nedy
Enhance t
h
e "rbu" command line utility a bi
t
.
commit
|
commitdiff
|
tree
next