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 Kenne
d
y
Merge latest trunk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ke
n
nedy
Fix
a problem ca
u
sed by a sub-query containing a
windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a p
r
oblem with using min() o
r
max() as
a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenne
d
y
F
i
x pro
b
le
m
s
w
i
th using w
i
ndow f
u
ncti
o
ns
i
n CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
an
K
ennedy
Add
t
est cas
e
for the
f
ix in
the previo
u
s commit
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n
Ke
n
nedy
E
nsure
that all four
c
a
l
lbac
k
s a
r
e pr
o
vided when registering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Add new A
P
I
function sqlite3_
c
reate_wind
o
w_fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kenn
e
d
y
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ke
n
n
e
dy
Fix another
p
ro
b
l
e
m
i
n
lead()/lag()
.
A
nd
s
ome
errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kenn
e
d
y
Fix
a
b
ug in
the lead() and lag()
windo
w
functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
ix
a
p
r
oblem with handl
i
ng of statemen
t
s containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Da
n
K
e
nnedy
F
i
x p
r
ob
l
em
w
it
h
w
i
ndo
w
fun
c
tio
n
s
mi
n
() and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ken
n
edy
Merge
latest trunk cha
n
ges
i
n
t
o
t
h
i
s br
a
n
c
h
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kenned
y
Improve comments and code
legibili
t
y in new file wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
F
ix proble
m
s with "
R
ANGE BETW
E
EN
C
URRE
N
T ROW AND
U
N
BOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan K
e
nn
e
dy
Fix
s
ome test
ca
s
e
nu
m
bers
i
n
e
xper
t
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQLITE_OMIT_AUTOINIT is def
i
ned, allow sql
i
te3_vfs
_
un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Check that ma
l
loc() has not alread
y
failed whe
n
i
n
voking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
a
n Kenn
e
d
y
Fix an
o
ther issue
t
o
do with
w
i
ndo
w
-functi
o
ns
i
n aggre
g
ate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix some p
r
o
b
lems with using
w
indo
w
-funct
i
ons
i
n
a
ggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Ke
n
nedy
Clarify the relationship between
a
Window object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ke
n
nedy
Fix
ha
n
dling of
w
indow frames c
o
n
t
aining ne
g
ati
v
e
number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix a typo
n
i
n m
a
in
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
D
an K
e
nnedy
Update Makefile
.
msc to in
c
lud
e
w
indow
.
c in
the b
u
ild
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Merge recent
t
runk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
U
pdate the ama
l
gamatio
n
build script t
o
include wind
o
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ken
n
ed
y
Add support
for FILTER cl
a
us
e
o
n
a
ggregate window func
t
ions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
A
d
d support fo
r
t
h
e WINDOW
clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
D
o
not fl
a
tten sub
-
queries that
c
o
nta
i
n window
functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes t
o
allow gro
u
p
_
c
o
n
c
at() to be used a
s
a
win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Kennedy
Merge lat
e
st trun
k
changes
w
ith this
b
ra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
edy
A
d
d window
f
un
c
tion
s
l
a
g
() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Add support for
window function first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Fix problems wi
t
h the
n
t
h
_
val
u
e() function
.
commit
|
commitdiff
|
tree
2018-06-06
D
an
K
e
nnedy
A
d
d i
m
plementation of nth_val
u
e() window fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non-aggr
e
gat
e
expressions in the SEL
E
C
T
list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
Kennedy
Add i
m
ple
m
enta
t
i
o
n of la
s
t_valu
e
() window func
t
i
o
n
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add implementation of
w
indo
w
f
u
nction ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge latest
t
run
k
c
han
g
es
i
nt
o
this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Ke
n
nedy
Add support for window f
u
nctio
n
cume_di
s
t()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Ken
n
edy
Add
s
upport for window fun
c
tio
n
s
row_numbe
r
(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
nnedy
Update a test ca
s
e
in malloc5
.
test to take
i
n
t
o
acco
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allow an
e
ntire p
a
rtition to be cached in a
temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kenne
d
y
Fix a
b
u
g
in
t
h
e
SQLITE_ENABLE_SORTER_REF
E
RENCE
S
code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
an
Kennedy
Allow m
i
n() and
max() to be use
d
as
w
indow
functions
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n Ken
n
e
dy
Increase the
number
of dat
a
base handle
s
op
e
ned b
y
t
e
st
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kenne
d
y
Fix autoin
c
.
test a
n
d rese
t
db
.
test so that they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
K
e
nnedy
M
o
r
e min
o
r changes to test scripts
.
commit
|
commitdiff
|
tree
2018-05-29
D
an
K
ennedy
Fix
some test script is
s
ues caus
e
d by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do not
run
t
est file "
r
esetdb
.
t
est"
a
s
part of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenn
e
dy
F
u
rther window fra
m
e tes
t
s and fix
e
s
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
D
o
not req
u
ire a st
a
te
m
ent
j
ournal in cases where REPLA
C
E
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenn
e
dy
More fix
e
s
for differ
e
nt window frame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Fix "
R
ANGE B
E
TWEEN CURR
E
NT
RO
W
AND UNBOUNDE
D
FOLL
O
W
I
N
G
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
D
an Ke
n
ned
y
Merge lat
e
st tru
n
k changes into this
branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
F
i
xes for "ROWS BETWE
E
N <expr> FOLLOWING A
N
D <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
K
e
nnedy
Al
l
ow "
<
expr> PRECEDIN
G
" to be used to
s
pecif
y
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
D
a
n
Kennedy
Supp
o
r
t other
f
rame type
s
that use "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
D
a
n
Ken
n
e
d
y
Add sup
p
or
t
for "ROWS BETWE
E
N <
e
xpr> PRE
C
EDI
N
G
AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Kenned
y
Merg
e
latest trunk changes into this b
r
anch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan
Ke
n
n
e
d
y
A
d
d
c
o
m
ments to window
.
c des
c
ri
b
i
n
g how
o
ther win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kennedy
Begin adding s
u
ppor
t
fo
r
more esote
r
ic window
f
r
am
e
s
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fi
x
mino
r
p
r
ob
l
ems on this
b
r
an
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kennedy
Evaluate multi
p
le wind
o
w
functi
o
ns in a sin
g
le
pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
an Kennedy
Handle multiple window-func
t
ions in a singl
e
quer
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan
K
ennedy
S
t
art
o
f experimental impl
e
m
e
ntati
o
n of SQL
win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kenne
d
y
Fix a test case p
r
ob
l
e
m
in w
h
ereli
m
it
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kenne
d
y
Add a test case to
c
he
c
k th
a
t th
e
f
ts5 unic
o
de64 to
k
enizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
an Kennedy
Fix a
p
roblem in
the xB
e
st
I
ndex
method of the cl
o
sure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kennedy
Fix an
R
B
U
problem
causing spurio
u
s
SQLITE_CO
N
STR
A
IN
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
a
n Ke
n
nedy
Update t
e
s
t
scri
p
t fts3ex
p
r4
.
t
e
st so that i
t
always
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Da
n
Kenn
e
dy
F
ix a t
e
st
script error causing t
e
sts t
o
fail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan K
e
nn
e
dy
When processing an "O
R
DER
B
Y
.
.
.
L
I
MIT" t
h
a
t
does no
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Ke
n
ne
d
y
W
hen processing an "ORDER BY
.
.
.
LIMIT" that does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan
Kennedy
Update the "fuzz_malloc
.
test" script to print SQL stat
e
me
n
ts
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ken
n
e
dy
R
e
move a recently added N
E
V
E
R
(
) m
a
cro f
r
om a branch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix a probl
e
m
wit
h
p
r
ocessing
"LEFT JOIN
t
bl ON t
b
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenne
d
y
D
o
not attempt to r
e
ad values fro
m
indexes-
o
n
-expressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Kennedy
A few
mo
r
e tests fo
r
upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ke
n
n
e
d
y
E
n
hance the "rbu" c
o
mmand line uti
l
ity a bit
.
commit
|
commitdiff
|
tree
2018-04-20
Da
n
Kennedy
A
dd tests
f
or name res
o
lution in ON CON
F
LICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add test cases for UPSER
T
.
And
a fix for a "REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan
Kennedy
M
odify a te
s
t cas
e
i
n
z
ipfile2
.
t
est to take into acc
o
unt
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
edy
Add th
e
"
sort
e
r-re
f
erence" optimization, allowing
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan
K
en
n
edy
M
inor chang
e
s to test script upser
t
4
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
a
n Kennedy
Add extra test cases for U
P
SER
T
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix
a problem in
th
e
shell pr
e
v
en
t
ing it from
w
orking
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan Kennedy
Ad
d
som
e
mo
r
e simple test
cases
for UPS
E
RT
.
An
d
a
minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
an Ken
n
edy
Add S
Q
LITE_
C
O
N
FIG
_
S
O
RTERREF_SIZE
configu
r
ation opt
i
on
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
Experimental ch
a
nge to "SELECT
*
FROM
.
.
.
ORDER
B
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan
K
enn
e
dy
Mino
r
sim
p
li
f
icati
o
n to internal function generateSort
T
ai
l
(
)
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kenn
e
dy
F
i
x a problem causing t
h
e LEF
T
J
O
I
N s
t
rength reduction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ken
n
e
d
y
When testing, avo
i
d
inj
e
cting an OOM fault i
n
t
o
a file
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ken
n
edy
Fix a pr
o
blem
causi
n
g
the LEFT JOIN str
e
ngt
h
redu
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Ke
n
nedy
Fix the ft
s
5
x
BestInde
x
method so that
it is n
o
t
c
onfused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan
K
e
n
nedy
A
d
d a
"flags" parameter to experi
m
ental AP
I
sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Da
n
Kennedy
Fix a pr
o
blem i
n
the ses
s
ions m
o
dul
e
causing sqlite3sess
i
o
n_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
Dan Kennedy
F
i
x an instanc
e
where an unini
t
i
alized VM
register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kenn
e
d
y
Update spee
d
test1
.
c wit
h
n
ew t
e
stset "trig
g
e
r
"
b
ased
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
a
n
K
e
nned
y
F
i
x
a
f
e
w sm
a
l
l
test
s
cript issues affectin
g
SQLITE_TEMP_ST
O
.
.
.
commit
|
commitdiff
|
tree
next