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
Merge latest trunk changes with this branch.
2018-06-19
Dan Kennedy
Merge
latest trunk cha
n
g
e
s with
t
his bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-19
Da
n
K
ennedy
F
i
x a probl
e
m ca
u
sed by
a
su
b
-
query cont
a
i
ning a win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
D
an
Kennedy
Fix
a
problem with
u
sing min()
o
r
m
a
x() as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix pr
o
blems with using w
i
ndow functions
i
n
C
R
EATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add test case for the fix in the previous commit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ke
n
nedy
E
n
sure that
a
ll four
c
al
l
backs are
p
r
o
vided w
h
en r
e
gi
s
tering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add n
e
w
A
PI function sqlite3_create_window_funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
K
ennedy
A
dd
ex
t
ra OOM te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Dan K
e
nn
e
dy
Fix anothe
r
p
r
ob
l
em in lead(
)
/lag()
.
And s
o
m
e er
r
or
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix a bug in the lead() and lag(
)
win
d
ow functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an K
e
nnedy
Fix
a problem w
i
th handling of statemen
t
s containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenn
e
d
y
Fix p
r
oblem
with window fu
n
ction
s
min() and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Mer
g
e la
t
est trunk chang
e
s into this bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
enn
e
dy
Improve comments and
c
o
de legibility in new fil
e
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix
p
roblems with "RANGE BETWEE
N
CURREN
T
R
OW AND
UNBOUN
D
ED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kenned
y
F
ix som
e
t
e
st case numbers in expert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
edy
Unles
s
SQL
I
TE_OMIT_AUTOINIT is def
i
ned,
allow s
q
lite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Check
that
mallo
c
()
has n
o
t already
failed
w
h
en invok
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kenn
e
dy
Fix another i
s
sue to do with wind
o
w-functions in aggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix
s
o
me problems with using window-fun
c
t
i
ons in agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
enn
e
d
y
Clarif
y
the r
e
lati
o
nship
b
e
tween
a
Window object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix hand
l
ing of win
d
ow frames conta
i
ni
n
g negat
i
ve numb
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan
K
ennedy
F
i
x a typon in m
a
i
n
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan
K
e
n
ne
d
y
U
p
da
t
e Ma
k
e
f
ile
.
msc to include window
.
c i
n
t
h
e build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Merge recen
t
trunk c
h
anges with
t
his branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
ennedy
Update the amalga
m
a
ti
o
n build script
t
o include wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan K
e
nnedy
Add su
p
port for FILTE
R
cla
u
se on aggre
g
ate win
d
ow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenned
y
Add s
u
p
p
ort
for
th
e
W
INDOW claus
e
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do not
f
l
a
tten sub
-
queries that c
o
n
t
a
in
w
i
n
dow fun
c
tions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to allow gr
o
up_
c
oncat() to be used
as a wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Merge late
s
t t
r
unk changes with this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add w
i
ndow
f
unction
s
lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n
Kennedy
Add suppor
t
for
w
i
ndo
w
f
u
nction
f
i
rs
t
_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
F
i
x
p
roblems with
t
he nth_valu
e
() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kennedy
Add implementation of nth_value() window function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kenn
e
dy
Calculate n
o
n-aggregate expressions in the SELE
C
T l
i
st
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n Kennedy
Add implementat
i
o
n of last_value()
window function
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kennedy
Ad
d
i
m
plement
a
tio
n
of window functio
n
n
tile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge latest trunk ch
a
nges into t
h
is bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan
Ke
n
n
e
dy
Add suppor
t
for wind
o
w
f
u
nction cume_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
an Kennedy
Add
s
u
pport for window
f
unctio
n
s
row_number(), ran
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Da
n
Ke
n
nedy
Upda
t
e a
test case in malloc5
.
t
est to take into
accoun
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
Allow a
n
enti
r
e partition to be
c
a
c
hed in a
t
emp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Kennedy
Fix a
bug in the SQLITE_ENAB
L
E_SORTER_REFERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow min() and max() to be
u
s
ed as wi
n
dow functi
o
ns
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenn
e
dy
Increa
s
e the nu
m
ber
o
f data
b
ase
handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix autoinc
.
test a
n
d resetdb
.
t
est so th
a
t
they wo
r
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Mor
e
mi
n
o
r ch
a
nges
t
o
t
e
s
t
scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
F
i
x some
t
e
st
s
cript issues
c
aus
e
d b
y
recent
E
XPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
D
o
n
o
t run
t
est file "resetdb
.
test" as part of pe
r
mutat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kenn
e
dy
F
u
rther
window
frame
t
ests and
fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan K
e
nne
d
y
Do no
t
req
u
ir
e
a
statement journal in cases where REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan K
e
nnedy
More fixes fo
r
d
i
ffere
n
t window frame types
.
commit
|
commitdiff
|
tree
2018-05-25
D
a
n K
e
nne
d
y
Fix "RANGE
BETWEEN CURRENT ROW
A
ND UNBOUN
D
ED FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
M
e
rge latest trunk changes into this branch
.
commit
|
commitdiff
|
tree
2018-05-25
D
an Kennedy
F
ixes
f
o
r
"ROWS BE
T
W
E
EN
<
e
xp
r
> FOLLOWIN
G
AND <ex
p
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Allow "<expr> PRECE
D
I
NG"
t
o
be used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan K
e
nnedy
S
uppo
r
t o
t
her frame types
t
hat us
e
"<e
x
p
r
>
PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Ken
n
edy
Add support for "R
O
WS
B
ETWEEN
<
expr
>
PRECEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n K
e
n
n
edy
M
e
rge l
a
test trun
k
cha
n
ge
s
i
nto this bran
c
h
.
commit
|
commitdiff
|
tree
2018-05-22
D
a
n
Kennedy
Add comments
to window
.
c
describing how other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin ad
d
in
g
support f
o
r more
esoteric win
d
ow frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Ken
n
edy
F
ix minor probl
e
ms on this branch
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Evaluate mu
l
tiple win
d
o
w func
t
i
o
n
s
in
a
single
p
ass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Handle multiple wi
n
d
ow-functions i
n
a
sin
g
le
q
uery
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Ken
n
edy
S
t
a
rt o
f
e
x
p
erimen
t
al imp
l
em
e
n
t
ation
o
f SQL
w
i
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan K
e
n
nedy
Fix a test cas
e
prob
l
em in w
h
e
r
elimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add a test cas
e
to check tha
t
t
h
e fts5 unicod
e
64 to
k
enize
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
an Ke
n
nedy
Fix a
pr
o
blem in the
x
Be
s
t
I
ndex method of the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kennedy
Fix an
RBU problem causing
spurious SQLITE
_
CONST
R
A
I
N
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
K
e
n
nedy
U
pdat
e
te
s
t script fts3
e
xpr4
.
test s
o
t
h
a
t i
t
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
K
ennedy
F
i
x a test sc
r
i
pt error
c
ausing
tests to
f
ail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When proces
s
ing an "ORDER
BY
.
.
.
LIMIT" that does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan
Kennedy
When
p
rocessing an
"ORDER BY
.
.
.
LIMI
T
" that does
not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan
K
enn
e
dy
Update
t
h
e "fuz
z
_ma
l
loc
.
test" scr
i
pt to print SQL st
a
tements
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
a
n
K
ennedy
R
emove a
r
ecently added NEVER
(
) macro from a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenne
d
y
Fix a p
r
o
b
l
em wit
h
processi
n
g
"LEFT JOIN tbl
O
N t
b
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ken
n
ed
y
Do not atte
m
pt t
o
r
ead values from
i
ndexes-
o
n
-expression
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan
Kenned
y
A few more tests
fo
r
u
pser
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kenne
d
y
En
h
ance the "rbu"
comm
a
nd line utility a bit
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n
K
ennedy
Add tests for name r
e
soluti
o
n in
O
N
CON
F
L
I
CT c
l
a
uses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan K
e
nnedy
Add test cases
f
or UPSERT
.
A
nd a fix
f
o
r
a
"REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kenn
e
dy
Modify a test case
in zipfile2
.
te
s
t
to t
a
k
e
into account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan K
e
n
n
edy
A
dd the
"
sorte
r
-re
f
erence"
optim
i
zation, allowi
n
g SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
a
n Ke
n
nedy
M
i
nor c
h
anges to test script upsert4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
edy
Add
e
xtra t
e
st cases for UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
Kennedy
F
i
x
a
pr
o
blem in the
shell pre
v
enting i
t
from worki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
a
n Ken
n
ed
y
Add some mo
r
e simple test cases f
o
r UPSERT
.
A
n
d a
minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
a
n K
e
n
n
ed
y
Add SQLIT
E
_CONFI
G
_SORTERREF_SIZE
configuration
o
ption
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Ken
n
edy
Experimental
change
t
o "SELECT * FROM
.
.
.
OR
D
ER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Kennedy
Min
o
r
sim
p
l
ification to internal function generateSort
T
ail()
.
commit
|
commitdiff
|
tree
2018-04-10
D
an Kennedy
Fi
x
a
p
roblem ca
u
sing the LEFT JOIN strengt
h
reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When
t
esting,
a
void inject
i
ng an OOM fault into a f
i
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
a
n Kenne
d
y
Fix a prob
l
e
m ca
u
sing the LEFT J
O
IN strength reduc
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Fix the fts5 xBes
t
I
n
d
ex met
h
od so th
a
t it is not
confused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kennedy
Add a "flags
"
parameter to experiment
a
l API sqlite3
c
hangeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Kenned
y
F
i
x a
p
r
oblem in the sessions module causing s
q
lite3
s
essio
n
_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
an Kennedy
Fix an instanc
e
where an unini
t
ialized VM
register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kennedy
U
p
date
speedtest1
.
c
w
ith new testset "trigger"
b
ased
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
a
n Ken
n
edy
Fix a f
e
w sma
l
l test script issues affe
c
ti
n
g SQLIT
E
_TEMP_STO
.
.
.
commit
|
commitdiff
|
tree
next