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 another problem in lead()/lag(). And some errors that could occur
2018-06-15
Dan Ken
n
edy
Fix another problem in
l
ead(
)
/
l
ag()
.
And some er
r
ors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix a bug in the lead(
)
and lag() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
i
x
a pro
b
lem
wi
t
h ha
n
dling o
f
statem
e
nts conta
i
n
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
ne
d
y
Fix problem with
w
ind
o
w functions min() and max() wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge la
t
est trunk changes int
o
t
h
i
s b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Improve commen
t
s and code legibi
l
ity in
ne
w
f
ile window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Da
n
Ke
n
nedy
Fi
x
p
r
ob
l
ems wi
t
h "RA
N
GE BETWEEN CURRENT
R
OW
AND UNBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan K
e
nnedy
F
ix some
t
es
t
cas
e
num
b
ers in expert
1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Ken
n
edy
Unless
S
QL
I
T
E_OMIT_A
U
TOINIT is defin
e
d, al
l
ow sqlite3_v
f
s_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kenn
e
dy
Check th
a
t malloc() has not already fail
e
d wh
e
n
i
nvoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
ennedy
Fix another
iss
u
e
t
o do with wi
n
dow-functions in aggregat
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
an Kenn
e
dy
Fix
som
e
problems with using w
i
ndow
-
fu
n
cti
o
ns in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Da
n
Ken
n
edy
Clarify the re
l
ationship between a Window obje
c
t and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ken
n
edy
F
ix
handlin
g
of window
frames containing negative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ke
n
nedy
Fix a typo
n
in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Up
d
ate Makefile
.
msc to i
n
clude w
i
n
dow
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
D
an Kenn
e
dy
Me
r
ge recent trunk cha
n
ges w
i
th this
bra
n
c
h
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Update t
h
e amal
g
amation build scr
i
p
t to include
window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Add support for FI
L
TER
c
la
u
se on aggregate window functions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kenne
d
y
A
d
d support for t
h
e WIN
D
OW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenne
d
y
Do not flatten sub-querie
s
that contain
wind
o
w
functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
K
e
nnedy
Fixes to
a
l
low
grou
p
_concat() to be u
s
ed as a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Merge l
a
test trunk cha
n
g
e
s with this bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-07
Da
n
K
ennedy
A
d
d
w
indow functions lag
(
)
and lea
d
()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
A
d
d suppor
t
for window
f
unction f
i
rs
t
_
v
alue()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Fix p
r
obl
e
ms with t
h
e nt
h
_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan K
e
nnedy
A
d
d
i
mplementati
o
n of nth_v
a
lue() windo
w
function
.
commit
|
commitdiff
|
tree
2018-06-05
D
an Kennedy
Calcula
t
e
non-aggre
g
a
te
e
xpressio
n
s
in the SELE
C
T list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan K
e
nnedy
A
d
d i
m
pl
e
mentation
of last
_
value() window function
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ken
n
e
d
y
Add implementation of window function ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge l
a
t
e
st
t
runk
changes into this
bran
c
h
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add
support
for window
function
c
ume
_
dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Add support for wi
n
d
o
w
f
un
c
tion
s
r
ow_number(), ra
n
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
nnedy
Update a test c
a
se in mal
l
oc5
.
test
to take into acco
u
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Ken
n
edy
Allow a
n
e
n
tire partition
t
o
be cached in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
enne
d
y
F
i
x
a
bug in the SQLITE_ENABLE_SORTER_REFERENCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan
Kennedy
Allow min() and m
a
x()
t
o
b
e used as windo
w
funct
i
ons
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Increase the number of databas
e
handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix autoinc
.
test and resetdb
.
test so t
h
at they wo
r
k
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Ke
n
n
e
dy
More
m
inor chang
e
s to tes
t
scripts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
ne
d
y
Fix some
t
es
t
script
issues caused by recent
EXPL
A
IN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
Do
n
ot run
te
s
t
f
ile "res
e
tdb
.
test"
a
s par
t
of
permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
F
urther window fr
a
m
e
te
s
t
s and f
i
xes
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Ke
n
nedy
Do not require a statemen
t
jo
u
rnal in cas
e
s
w
here REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kenn
e
dy
More fixes for diffe
r
ent window
f
rame types
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
ennedy
Fix "R
A
NGE BETWE
E
N CURRENT ROW
A
ND UNBOUNDED F
O
L
L
OWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
ennedy
Merge late
s
t trunk changes in
t
o thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-25
D
an K
e
nned
y
Fixes for
"R
O
WS BETWE
E
N <expr
>
FOLLOWING AND
<expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Allow "<
e
xpr> PRE
C
EDING" to be used
t
o
specif
y
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Support ot
h
er frame ty
p
es th
a
t us
e
"<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Da
n
Kennedy
Add
s
up
p
o
rt fo
r
"ROWS BETW
E
EN <expr> PR
E
CE
D
I
NG AN
D
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
D
an Kennedy
M
e
rge latest
t
runk c
h
ang
e
s into th
i
s bra
n
ch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
A
dd com
m
ents
to windo
w
.
c des
c
ribing how o
t
her window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Dan Kenne
d
y
Begin adding support for more eso
t
e
r
ic wi
n
d
ow
f
rames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
Fi
x
mino
r
pro
b
lems on th
i
s branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan Kenned
y
Evaluate multiple window functions
in a s
i
ngle
p
ass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Handle
m
u
ltipl
e
window-fun
c
tions
i
n a single que
r
y
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kenn
e
dy
Start of
e
x
perimental impleme
n
t
ati
o
n of
S
Q
L
windo
w
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Da
n
Kennedy
F
i
x a test
cas
e
problem in wh
e
rel
i
mi
t
.
t
e
s
t
.
commit
|
commitdiff
|
tree
2018-05-09
Dan Kennedy
Add a t
e
st
c
ase to ch
e
c
k
that
the fts5 uni
c
od
e
64 tokenize
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan
Ken
n
e
dy
Fix a problem in
the
x
B
estIndex
m
ethod
o
f
the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kennedy
Fi
x
an RBU problem
causing sp
u
rious SQLITE_C
O
NSTRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Ken
n
e
d
y
Update t
e
st sc
r
ipt fts3expr4
.
test so tha
t
it alwa
y
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Da
n
Kennedy
Fi
x
a te
s
t
s
cript er
r
or cau
s
ing t
e
st
s
to
f
ail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan K
e
nnedy
When pr
o
ce
s
sin
g
an "ORDER BY
.
.
.
LIM
I
T" th
a
t does n
o
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Da
n
Kenned
y
Wh
e
n pro
c
essing
an "ORDER
B
Y
.
.
.
LIMIT" t
h
at does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Ke
n
ne
d
y
Update the "fuzz
_
malloc
.
te
s
t" sc
r
ipt to print SQL stateme
n
ts
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
Ke
n
nedy
Remove a recently add
e
d NEVER() macro
from a bran
c
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Fix a p
r
oblem with
pr
o
cessing "LEFT J
O
IN tbl
ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
Do not attempt to read
v
alues from index
e
s
-
on-
e
xpressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Kennedy
A few more
t
ests for upsert
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Enhance the
"
rbu" command li
n
e utility a b
i
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
A
d
d tests
for
name
re
s
olution
in ON CONF
L
ICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Da
n
Kennedy
A
dd test c
a
ses for UPSERT
.
And a fix for a
"REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kenned
y
Modify
a test case i
n
zip
f
ile2
.
test to take into account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
K
enne
d
y
Add
t
he "sorte
r
-referen
c
e
"
optimiz
a
t
i
on
,
a
l
lowing SQ
L
ite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kenne
d
y
Mi
n
or changes to test scri
p
t u
p
sert
4
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Ken
n
edy
Add extra tes
t
cases for UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
D
an Kenned
y
Fix
a
p
r
ob
l
em in the shell preventin
g
it from
w
o
rking
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
an
Ken
n
edy
A
dd some mor
e
simple test
cases
f
o
r UPSERT
.
And a minor
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan Kennedy
Add SQLI
T
E_CONFIG_SORTERREF_SIZE configurati
o
n option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
E
x
perimen
t
al change
to "SELECT *
FROM
.
.
.
OR
D
E
R
B
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Dan Kennedy
Mino
r
s
imp
l
ification to interna
l
function generateSort
T
ail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan
K
e
n
nedy
Fix
a
pr
o
blem ca
u
sing the LEF
T
JOI
N
strength red
u
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Ke
n
nedy
When te
s
t
ing, avoid i
n
j
ec
t
ing an OOM f
a
ult into a fi
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix a proble
m
ca
u
sing t
h
e LEFT
J
OIN
strength reduc
t
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Kenn
e
dy
F
ix the
f
ts5 xBe
s
tIndex method s
o
that it is not
c
o
nfused
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Da
n
Kenn
e
dy
A
dd
a "f
l
ags" parameter to experimen
t
al AP
I
sqlite3changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan Kenne
d
y
Fix a problem in the session
s
modul
e
causing sqlite3session_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
a
n
Kenn
e
dy
Fix
a
n instan
c
e where an
uninitial
i
zed
VM
register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
a
n
K
enn
e
dy
Update speedtest1
.
c with new te
s
t
set "trigger" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kenned
y
F
i
x a f
e
w sm
a
ll test script iss
u
es af
f
ecting SQ
L
ITE
_
TEM
P
_STO
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan Kenne
d
y
Fix an assertion failure triggered by a SELECT wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Another change to test
file zipfile
.
test to help it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
a
n Ken
n
edy
Fix a
t
est script b
u
g causing zipfile
.
test to f
a
i
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Da
n
Kenne
d
y
Update
m
emdb1
.
test so that it w
o
rks with SQL
I
TE_DEFAUL
T
_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
Dan Kennedy
A
d
d -DSQLITE_ENABLE_DESERIAL
I
ZE to the "Device-Two
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Kennedy
Fix a typo preventing
test scri
p
t avtrans
.
test from
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
Da
n
Ke
n
ne
d
y
Fix a test sc
r
ipt probl
e
m c
a
using s
h
ell1
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
Dan
K
ennedy
Fix typos in sqlite
3
session
.
h pre
v
enting documen
t
a
tion
.
.
.
commit
|
commitdiff
|
tree
next