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 crash caused by a LIKE pattern that consists of a single escape
2018-07-02
Dan K
e
nn
e
d
y
Fi
x
a crash caused by a LIKE patter
n
that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan
K
enn
e
dy
F
i
x a
s
egfault caus
e
d by invoking a regular aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenne
d
y
Avoid a warning in
fts5
.
c due to not using
gen
e
rated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Kennedy
Merge implementation of SQL window
f
unctions from the
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Kennedy
Fix
a
minor p
r
obl
e
m in the code fo
r
deter
m
ining whether
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan K
e
nnedy
Merge
all changes fr
o
m
the weak-fallback branch ex
c
e
p
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
an Kennedy
Have the tokenizer han
d
le
fallback
for
t
o
kens "
O
V
ER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Fu
r
ther pe
r
formance
r
elated tweaks for sq
l
ite3Ru
n
Pars
e
r()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenn
e
d
y
F
urther twe
a
ks to s
q
l
i
te3RunPa
r
ser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
an
K
ennedy
Improve on
t
he previous chec
k
in
.
Still a
b
i
t
slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Instead o
f
u
sing
a lemon %fallbac
k
dire
c
tive, have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
D
an Kennedy
Modificati
o
n
s
to pa
r
se
.
y to better s
u
pport backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kenne
d
y
Add mi
s
s
in
g
VdbeCov
e
rage() and VdbeCo
v
erageNeverTa
k
en
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
a
n Ke
n
nedy
Avoid
r
edu
n
dant
O
RDER BY
operati
o
ns
when rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
e
n
n
e
dy
M
e
rge
l
atest tr
u
nk changes
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Ken
n
edy
Add documen
t
a
t
i
o
n c
o
m
ment
f
o
r
s
qlite3_create_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
K
enne
d
y
Fix another probl
e
m t
h
at
c
ou
l
d cause
a crash when
a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix problems with using
window-functio
n
s i
n
correlat
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
D
an Kennedy
Fix
a prob
l
em with using LIMIT in window-fu
n
cti
o
n queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan
Kennedy
Fix
a
problem with using a window-func
t
i
on SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan K
e
nnedy
Omit a
l
l window-function r
e
la
t
ed
c
ode when buildin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kenned
y
Merge
la
t
est trun
k
c
h
a
n
g
es
.
commit
|
commitdiff
|
tree
2018-06-21
Dan K
e
nnedy
F
i
x a problem with handling
s
ing
l
e row
p
artitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add tests to improve coverage of code in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Merge latest
t
r
u
nk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
edy
Fix
a
p
r
oblem ca
u
sed by a sub-query
containing a
w
indow
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a problem with using min() or ma
x
() as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan
Kennedy
F
i
x problems wi
t
h using window functions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenned
y
Add test case for the fix in
t
he
p
revious commit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
En
s
ure that all f
o
ur callb
a
cks are
p
rov
i
ded w
h
en registerin
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add new API function
s
qlite3_cr
e
ate_w
i
nd
o
w
_f
u
ncti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
A
dd extra OO
M
test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
n
e
dy
Fix another problem in lead()/lag()
.
And some err
o
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix
a bu
g
in the
l
ead() and lag()
w
indow function
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
nne
d
y
F
i
x a problem with
hand
l
in
g
of statements con
t
aining
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n K
e
n
n
edy
Fix problem with window fu
n
ction
s
min() and
max
(
) wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an Kenned
y
M
e
r
g
e
latest
t
runk changes in
t
o t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Improve
comments and code legibility
in new file window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Fix problems with "
R
ANGE BETWEEN CURRENT R
O
W A
N
D UNBOU
N
DED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix some test case
n
u
m
bers
in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n
Kennedy
Unl
e
s
s SQLITE_OMIT_AUTOINIT is d
e
fined, al
l
ow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kennedy
Check that malloc() has n
o
t alre
a
dy failed when
invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix
another
i
ssue to
d
o wi
t
h wi
n
dow-functions in aggrega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix some probl
e
m
s
with using window-functions in agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
Kenne
d
y
Cl
a
rify
the
relationship bet
w
ee
n
a Window object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an Kenned
y
F
ix handli
n
g
of window
frames containi
n
g neg
a
t
i
ve num
b
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ken
n
edy
Fix a
typon in
main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan K
e
nn
e
d
y
Update Ma
k
efile
.
ms
c
to include window
.
c in the b
u
ild
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n Kennedy
Merg
e
r
e
cent trunk changes w
i
th thi
s
b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Kenned
y
Update the ama
l
gam
a
tion b
u
ild script to in
c
lude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Da
n
Ke
n
nedy
Add sup
p
ort
for
FILTER clau
s
e on
aggregat
e
wi
n
dow fun
c
tio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenned
y
Add s
u
p
p
o
rt for the
WINDOW cla
u
se
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do not flatten sub-queries that contain w
i
ndow funct
i
ons
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ke
n
ne
d
y
Fixes to allow group_con
c
a
t
(
) to b
e
used as a windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n K
e
nne
d
y
Merge latest
tru
n
k changes with this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
enn
e
dy
Add
window f
u
nc
t
ions la
g
()
an
d
lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add support for
windo
w
function fi
r
s
t
_
v
alue()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n K
e
nnedy
Fix problems
with
the nth_value()
function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan K
e
n
n
e
d
y
Ad
d
implementat
i
on of nth
_
value(
)
w
i
ndow function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non-agg
r
e
g
ate ex
p
res
s
ions in the SELECT lis
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n
K
e
nnedy
Add
implementa
t
io
n
of l
a
st_value() window fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
K
ennedy
Add implementation of window funct
i
on ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n Kennedy
Merge l
a
test tru
n
k changes into t
h
is branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add s
u
pport for window
func
t
ion c
u
me_dist()
.
I
mprove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Add support
f
o
r
wi
n
d
o
w f
u
nct
i
ons
r
ow_num
b
er(
)
, rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
nnedy
Update a test ca
s
e
i
n malloc5
.
test
t
o ta
k
e int
o
a
ccount
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
A
llow
a
n entire p
a
rtition
to be cached
in a temp ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n
Kennedy
Fix a
b
ug in the SQ
L
ITE_ENABLE_SORTER_RE
F
ER
E
NCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Ke
n
nedy
Allow min()
a
nd max() to be used as window f
u
n
c
tions
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Kennedy
Increase the number
of dat
a
ba
s
e handles opened b
y
test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ken
n
edy
Fix a
u
toinc
.
tes
t
and reset
d
b
.
test so that they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kenne
d
y
More
minor
changes to te
s
t sc
r
ipts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
Fix
s
ome test s
c
ript issues caused by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ken
n
edy
Do not run test
f
ile "resetdb
.
t
e
st" as par
t
of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kennedy
Further win
d
o
w
f
ra
m
e
t
ests and fi
x
e
s
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenne
d
y
Do not requ
i
re a statement journal in ca
s
es where
REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenn
e
dy
More fixes for
differ
e
nt w
i
ndo
w
fra
m
e types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ken
n
edy
Fix "RANGE BETWEEN CURRENT ROW AND
U
NBOUNDED
FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n Ke
n
nedy
M
erge lates
t
trunk change
s
int
o
this branch
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
Kenne
d
y
Fixes for "ROW
S
B
E
T
W
EEN <expr
>
FOLLOWIN
G
AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Ken
n
ed
y
A
l
l
o
w
"
<
e
x
p
r> PRECED
I
N
G" to be used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
an Ken
n
edy
Su
p
port other
f
r
a
m
e type
s
that use "<expr> PRECED
I
NG
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Ke
n
nedy
Add
s
up
p
ort fo
r
"ROWS BETW
E
EN
<
expr> PRECEDING
A
N
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Ken
n
edy
M
e
rg
e
latest trunk changes in
t
o this br
a
nch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Add commen
t
s to window
.
c descri
b
ing how other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
D
a
n K
e
nnedy
Begin
a
dding
support
f
o
r
more esoteric window frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fi
x
minor proble
m
s
o
n t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Eva
l
uat
e
multiple window fun
c
tions in a single p
a
s
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kenn
e
dy
Handl
e
mu
l
tiple window-functions in
a
s
ingle que
r
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kenne
d
y
Start of experiment
a
l implement
a
tion
o
f
S
QL window
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Ken
n
e
dy
Fix a test c
a
se p
r
oblem
i
n
wh
e
re
l
imit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add
a test
case to check th
a
t the ft
s
5 uni
c
o
d
e64 t
o
kenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan K
e
nnedy
F
ix a pr
o
b
l
em in the
x
B
estIndex method of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Ken
n
edy
Fix an RBU
problem causing spuriou
s
SQLIT
E
_CONSTRAIN
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kenned
y
U
p
d
a
t
e
test script fts3expr4
.
test
s
o
th
a
t
i
t
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Kennedy
Fix a test
script error ca
u
s
i
ng t
e
sts to fail in so
a
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Da
n
Kennedy
W
h
en pr
o
ces
s
ing a
n
"ORDER BY
.
.
.
LIMIT"
t
h
at does
not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Wh
e
n processing an "OR
D
E
R
BY
.
.
.
L
I
MI
T
" that does
n
ot
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
Update the "fuzz_malloc
.
test" s
c
r
i
p
t
to pr
i
nt SQL s
t
atem
e
nts
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Da
n
Kennedy
Remove a
recently
added NEVER() macro from a branch
.
.
.
commit
|
commitdiff
|
tree
next