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
Add new API function sqlite3_create_window_function(), for creating new
2018-06-18
Dan Kenn
e
dy
Add new AP
I
functi
o
n sqlite3_create
_
window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
Kennedy
Add extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix another
p
r
oblem in le
a
d()/la
g
()
.
And some
error
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n K
e
nnedy
F
ix
a
b
ug in
t
h
e
l
ea
d
()
a
nd lag() wi
n
d
ow funct
i
on
s
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kenne
d
y
F
ix a problem w
i
t
h
h
andli
n
g of stat
e
ment
s
containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
i
x
problem with win
d
ow funct
i
on
s
min() and max() w
h
en
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an
K
enned
y
Merge latest tru
n
k changes into this
branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Improve comm
e
nts
a
nd code legibility in new fi
l
e
w
indow
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kennedy
Fix problems with "R
A
NGE
B
ETWEEN CURRE
N
T ROW AND
UNB
O
UNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ken
n
e
d
y
Fix som
e
test case numb
e
r
s i
n
e
x
p
ert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Unless SQ
L
I
TE_
O
M
I
T_AUTOINIT is defined, allow sqlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Check
t
ha
t
malloc() ha
s
not a
l
re
a
d
y faile
d
when invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Da
n
Ken
n
ed
y
Fix another
i
s
s
u
e to do with window-functions in
a
ggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
Fix
s
o
m
e problem
s
with using window-functions in agg
r
e
gate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n Kenned
y
Clarif
y
the r
e
lationship between a Window obje
c
t a
n
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fix h
a
ndling of wind
o
w f
r
ames con
t
aining
n
e
gative
number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Ke
n
ned
y
F
ix a typon in main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kenn
e
dy
Updat
e
Makefile
.
msc
to includ
e
window
.
c
in
the buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Merge
r
ecent trunk changes with t
h
i
s branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan
K
enn
e
dy
Up
d
ate the amalgamation build scri
p
t to
i
nclude window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n Kennedy
A
dd support for FILTER
c
lause on ag
g
regate window fun
c
tions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Add
s
upport
f
o
r t
h
e WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan
K
ennedy
Do not
flat
t
en sub-queries that c
o
ntain win
d
o
w
f
unction
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Fixes to all
o
w
gr
o
up
_
con
c
a
t(
)
to
b
e
used as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Da
n
Kenned
y
Merge latest tr
u
nk changes
w
i
t
h
t
hi
s
br
a
n
ch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
A
d
d window
fun
c
tion
s
l
ag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
Ad
d
suppo
r
t
for window
f
un
c
tion first
_
val
u
e()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
F
i
x probl
e
ms with the nth
_
value() f
u
nction
.
commit
|
commitdiff
|
tree
2018-06-06
Dan Kenned
y
Add i
m
p
l
ementation
of nth_
v
alue() wi
n
dow function
.
commit
|
commitdiff
|
tree
2018-06-05
Dan Kennedy
Calculate non
-
aggregate e
x
pressions in th
e
SELECT l
i
s
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n K
e
n
nedy
Add imple
m
entation of
l
ast_valu
e
(
)
window function
.
commit
|
commitdiff
|
tree
2018-06-04
D
a
n
K
ennedy
Add implem
e
nt
a
tion of w
i
ndow func
t
ion nti
l
e()
.
commit
|
commitdiff
|
tree
2018-06-04
D
an Kennedy
Merge latest tru
n
k
changes i
n
to this
branch
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kenn
e
dy
Add
s
u
pport for window fu
n
ction
cume_dist()
.
Imp
r
ove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
a
n Kennedy
Add support
f
or window functio
n
s row_nu
m
b
e
r(), ra
n
k
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kenned
y
Upda
t
e
a
te
s
t ca
s
e
i
n malloc5
.
test to take into account
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan
K
ennedy
A
llow
an e
n
tire partition to be cached
i
n a t
e
mp t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
a
n Ke
n
n
e
dy
Fix a bug
i
n th
e
S
Q
LITE_EN
A
BLE_SOR
T
ER
_
REFERENCE
S
cod
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
an Ken
n
edy
Allow min()
a
nd max(
)
to be
used as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Incr
e
ase th
e
number of datab
a
se
h
andl
e
s opened by tes
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix autoinc
.
t
e
st
an
d
res
e
tdb
.
test s
o
th
a
t the
y
work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
Kenn
e
dy
More minor cha
n
g
es to test
scr
i
pts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenne
d
y
Fix s
o
me te
s
t
script issues caused by rece
n
t EXPLAI
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Da
n
Kenned
y
Do not run test file "
r
esetdb
.
t
est"
a
s part
o
f
p
ermut
a
ti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
ennedy
F
urther window frame tests and fixes
.
commit
|
commitdiff
|
tree
2018-05-28
Dan
K
en
n
e
d
y
Do not requ
i
re
a
statement journal in cases where R
E
PLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
Dan Kennedy
More
fixes for differ
e
nt window fr
a
m
e types
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
K
e
n
nedy
Fix "RA
N
GE BETWEEN CURRENT ROW
A
N
D
U
N
B
O
U
NDED FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kenne
d
y
Merge latest tr
u
nk c
h
ange
s
into this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Ke
n
nedy
Fi
x
es for "RO
W
S
BETWE
E
N <expr> FOLLOWING
A
ND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Da
n
Ke
n
nedy
A
l
low "<ex
p
r> P
R
EC
E
DING" to be used to specify the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Suppor
t
othe
r
frame types that use "<
e
xp
r
> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add support
f
or "ROWS BETW
E
EN <expr
>
PR
E
CEDING AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Merg
e
latest
trunk cha
n
ge
s
i
n
t
o th
i
s branch
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Ken
n
edy
Add
comments t
o
window
.
c
describing how other wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
Kennedy
Begin adding
s
upport
f
or mo
r
e esoteric window frames
.
commit
|
commitdiff
|
tree
2018-05-19
Dan Kennedy
F
ix mi
n
or p
r
o
bl
e
ms
o
n
this b
r
an
c
h
.
commit
|
commitdiff
|
tree
2018-05-17
Da
n
K
en
n
edy
Eval
u
at
e
multiple window functions in a
s
ingle pass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Ke
n
ne
d
y
Hand
l
e multiple window-function
s
in a single query
.
commit
|
commitdiff
|
tree
2018-05-16
Dan Kennedy
Start of experi
m
en
t
al implementation of SQL
w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan Kennedy
Fix a te
s
t case problem in wherelimit
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-05-09
Da
n
Kenne
d
y
Add a test case to c
h
eck tha
t
the fts
5
unicode64 tokenize
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
F
ix a problem in the xBestIndex
method o
f
the closure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kenn
e
dy
Fix an RBU problem
cau
s
ing sp
u
riou
s
SQ
L
ITE_CONSTR
A
INT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan
K
e
nnedy
Update test script fts3expr4
.
t
e
st so that
i
t alwa
y
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
an
K
e
n
nedy
Fix a test
s
cri
p
t error
c
a
using test
s
to fa
i
l in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When processing an "OR
D
ER BY
.
.
.
LIMIT"
that do
e
s not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
a
n Kennedy
When pro
c
essi
n
g an "ORDER BY
.
.
.
L
IMIT" that does no
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan K
e
nn
e
dy
Up
d
ate the "fuz
z
_malloc
.
t
e
s
t" script to
p
rin
t
SQL state
m
ents
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kennedy
R
e
move a
r
e
cently adde
d
N
EVE
R
() macro from a b
r
a
n
c
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ke
n
n
edy
Fix a problem with proce
s
sin
g
"LEFT JO
I
N tbl ON tbl
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan
Kenn
e
dy
D
o
not
a
ttempt to re
a
d value
s
from indexes-on-expression
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan Kennedy
A few mo
r
e
te
s
ts for
upsert
.
commit
|
commitdiff
|
tree
2018-04-20
D
a
n Kennedy
Enhance the
"
rbu" command line utility a bi
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ke
n
n
e
dy
Add te
s
ts for name res
o
lution
i
n ON CO
N
FLICT clauses
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Kennedy
Add test cas
e
s
f
or UPSE
R
T
.
And a fix
f
or a "REPL
A
CE
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
Dan Kennedy
Modi
f
y a test case in zipfile2
.
test to t
a
ke into
account
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Add t
h
e
"
sorter-refer
e
n
ce" opti
m
ization
,
allo
w
ing SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
an
Kenn
e
d
y
Minor ch
a
nges to tes
t
sc
r
i
pt up
s
ert
4
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
Da
n
Kennedy
Add extra test c
a
ses for UPSERT
.
commit
|
commitdiff
|
tree
2018-04-18
Dan Kennedy
Fix a problem i
n
the
s
h
ell preventing it from w
o
rking
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
Dan
Kennedy
Add some
more si
m
ple test cases
f
or
U
PSERT
.
And
a
mi
n
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
Dan
Kenne
d
y
Add
S
QLITE_CONFIG_SORTERREF_SI
Z
E
c
onfiguration option
.
commit
|
commitdiff
|
tree
2018-04-14
Dan Kennedy
Exp
e
rimen
t
al ch
a
nge to "
S
ELECT *
FROM
.
.
.
ORDER BY
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
Da
n
Kennedy
M
i
n
or si
m
plification
t
o
inter
n
a
l
function generateSortTail()
.
commit
|
commitdiff
|
tree
2018-04-10
Dan K
e
nnedy
Fi
x
a problem cau
s
ing the LEFT JOIN stren
g
th reduct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
When t
e
s
ting, avoid in
j
ecting
an OOM fault into a
f
i
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
Dan Kennedy
Fix a problem causing the LEF
T
JOIN s
t
rength red
u
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
an
K
ennedy
Fix the fts5 xBestIndex method so
t
hat it
is
n
o
t
co
n
fus
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
Dan Ke
n
n
e
dy
A
dd a "
f
lags" parameter to experi
m
enta
l
API sqlit
e
3
changeset
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
Dan K
e
nnedy
F
ix a
problem in the sessions
m
o
dule c
a
usin
g
sqlit
e
3session_
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
an Ke
n
nedy
Fi
x
an instance where an uninit
i
a
l
ized V
M
register
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan K
e
nn
e
d
y
Update
speedt
e
st1
.
c with new testset "tr
i
gge
r
" based
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
Dan Kenn
e
dy
Fix a few sma
l
l
test sc
r
ipt issues affecting SQLITE_TEMP_ST
O
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
Dan
Ken
n
edy
Fi
x
an assert
i
on failur
e
trigg
e
r
e
d by a SELECT with
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan K
e
nnedy
Anot
h
er change t
o
t
est f
i
le zipf
i
le
.
test to help it
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Kennedy
Fi
x
a test scrip
t
bug cau
s
ing zi
p
file
.
test to fail
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
Dan Ken
n
edy
U
pdate mem
d
b
1
.
test so t
h
at it works wit
h
SQLITE
_
DEFAULT_AUTO
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
a
n Ke
n
nedy
Add -DSQLITE_ENA
B
LE_DESERIALIZE to th
e
"
D
evice-
T
wo
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
Dan Kennedy
Fix a typo prevent
i
ng test scr
i
pt avt
r
ans
.
t
est from
.
.
.
commit
|
commitdiff
|
tree
next