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 a test-control to disable the skip-scan optimization.
2018-07-12
Da
n
Ke
n
n
edy
A
dd a test-control
t
o dis
a
ble th
e
skip-scan opt
i
m
i
zation
.
commit
|
commitdiff
|
tree
2018-07-12
Da
n
Kennedy
Add a
test case to chec
k
that SQLI
T
E_DBCONFIG_R
E
S
E
T_D
A
T
AB
A
SE
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
D
a
n Ken
n
e
dy
Modify tests in window3
.
test
t
o be tol
e
rant of round
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kenned
y
F
i
x a problem wi
t
h
using scalar sub-selects in window
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan K
e
nn
e
dy
A
void le
a
ving view-defi
n
ition
s
wit
h
an i
n
comp
l
e
te s
e
t
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
D
an Kennedy
Add a
c
o
up
l
e of OO
M
tests
.
commit
|
commitdiff
|
tree
2018-07-09
Da
n
K
e
nnedy
Throw a
n
error if t
h
e s
e
c
o
nd
argument
passed to nth_val
u
e
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
D
an Kennedy
F
ix a bad assert
(
)
in window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenned
y
Fix anot
h
e
r pr
o
blem with reu
s
i
n
g LSM cursors f
o
r
ran
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan K
e
nnedy
Fix an LSM pro
b
lem c
a
used
b
y
using
t
he
sa
m
e c
u
rsor
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenne
d
y
Add
missing VdbeCoverage() m
a
cro to wi
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix a pro
b
l
em with
t
he
handling
of N
U
L
L v
a
lues
i
n
the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
D
an Kennedy
Al
s
o
disallow non-constant e
x
p
ress
i
ons
i
n
"<expr
>
P
R
E
CEDING
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Ken
n
edy
Ensure
an error is r
e
tu
r
n
e
d if the user specifies an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan K
e
n
nedy
Preven
t
"UNBOUNDED FO
L
LOWI
N
G"
from be
i
ng used as the
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kenne
d
y
Remove
s
o
m
e
b
ad assert() statements fro
m
the imple
m
entation
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kenne
d
y
Return
a
n
e
rror if DISTINCT i
s
used with a wind
o
w
-functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Da
n
K
e
nnedy
U
pdate the re
c
ipe for res
e
tt
i
ng a data
b
a
se
using
commit
|
commitdiff
|
tree
2018-07-05
D
a
n
K
ennedy
Ret
u
rn an error
i
f a "RANGE" window-
f
rame uses "<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Ken
n
edy
Fi
x
a prob
l
e
m in the xI
n
ve
r
se method of window-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan K
e
n
ned
y
In wal mode,
i
f a "BEG
I
N E
X
CLUSIVE" comm
a
nd (or a
n
y
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
F
ix
a
ty
p
o in
s
ide an assert() st
a
tement introd
u
ced
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n Ke
n
nedy
I
n
wal mo
d
e, if a "BEGIN EXCLU
S
I
V
E"
command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan K
e
nned
y
Test that a
ra
c
e condi
t
ion c
a
n
c
ause
a
"BE
G
IN
EXCL
U
SIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
an
K
ennedy
Fix a pr
o
blem in
the xInverse callb
a
c
k
for the bui
l
t
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a segfault caus
e
d
b
y
ha
v
ing
i
dentical wi
n
dow function
s
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kennedy
Fix a crash cause
d
by
a
LIKE pattern that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kenn
e
d
y
Fix a
s
egfau
l
t
c
a
used by invo
k
i
n
g
a re
g
ular aggrega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Avoid
a
warning i
n
fts5
.
c du
e
t
o not using generated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Merge
implementation of SQL window functions from t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Fix a minor problem in t
h
e code f
o
r determining wh
e
the
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
an Kennedy
Merge all chan
g
es from the weak-fallback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
Have the tokenizer han
d
le
f
allback for tokens "OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Da
n
Kennedy
Further
per
f
ormance related
tweaks f
o
r sqlite3RunP
a
rse
r
()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
K
ennedy
Furt
h
er twe
a
ks to s
q
lite3RunP
a
rser()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Imp
r
ove on the previous checkin
.
Still
a
bi
t
slow
.
commit
|
commitdiff
|
tree
2018-06-29
Dan
Kennedy
Inste
a
d of using a lem
o
n
%fa
l
lback directive
,
h
a
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan Kenned
y
M
odifica
t
ions to par
s
e
.
y
to b
e
tte
r
suppor
t
backwa
r
ds
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
A
dd mis
s
ing VdbeCoverage() and VdbeCover
a
ge
N
everTake
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kenn
e
dy
A
void
r
e
dun
d
ant ORDER BY operations when rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan
K
ennedy
Me
r
ge
l
atest trun
k
c
ha
n
ges
.
commit
|
commitdiff
|
tree
2018-06-25
Dan K
e
nnedy
Add documentation c
o
mment for sqlite3_cre
a
te_window_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
F
i
x anot
h
er problem tha
t
could
cause a
c
rash when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
F
i
x
problems with u
s
ing window-f
u
nctions in
corr
e
lated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix a problem with
u
sing LIM
I
T i
n
w
in
d
ow-fu
n
ction queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix a p
r
oble
m
with
using a window
-
fun
c
tion SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit a
l
l window-f
u
nction related c
o
de when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Merge lates
t
trunk
c
hang
e
s
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a problem with handling single row partitions in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add
tests to improve
c
o
verage of code i
n
window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Merge lat
e
st trunk changes with this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kenned
y
Fix a problem ca
u
se
d
b
y
a sub-q
u
ery containing
a wind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fi
x
a p
r
oblem wi
t
h using min()
o
r
max() as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Fix problems
w
ith using window fu
n
ctions in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenned
y
A
d
d test case for the
f
i
x in the previo
u
s commit
.
commit
|
commitdiff
|
tree
2018-06-18
D
an Kenned
y
Ensure that all four ca
l
lbacks
a
re provided when
regi
s
tering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Ken
n
edy
Add
n
e
w AP
I
fun
c
tion sqlite3_create
_
w
indow_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
D
a
n
Ke
n
n
edy
Add extra O
O
M
t
e
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix
a
nother proble
m
in le
a
d(
)
/lag
(
)
.
And some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix a
b
ug in
th
e
l
e
a
d
() and
lag() window
func
t
ions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
F
ix a problem
w
it
h
ha
n
dlin
g
of statements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
nedy
F
ix pro
b
lem with
w
indow functions
m
in() and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Merge la
t
est
t
runk
changes into this branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
an
Kenn
e
dy
I
m
pro
v
e comments and cod
e
legibility in ne
w
f
ile windo
w
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Ke
n
nedy
Fix problems
with
"RA
N
GE BETWEEN
CU
R
R
E
NT ROW AND
U
NBOUNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kenne
d
y
Fix some test case
nu
m
bers in expert1
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kenned
y
Unless
S
QLITE_OMIT_AUTOINIT is define
d
,
allow sqlite3_vfs_u
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
C
h
eck
that
m
alloc(
)
has
n
ot alre
a
dy fai
l
e
d
when invo
k
ing
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
a
n Kennedy
F
ix
a
noth
e
r i
s
su
e
to do
w
it
h
window-f
u
ncti
o
ns in agg
r
ega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
Kenne
d
y
F
ix
som
e
prob
l
ems with using window-fu
n
c
tions in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify
th
e
relations
h
ip between a
W
indow object and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n
Ke
n
nedy
Fix handling of window frames
c
ont
a
ini
n
g
neg
a
tive
num
b
er
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n Kennedy
Fix
a
t
y
p
on in main
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
D
a
n
Kennedy
Update Make
f
ile
.
msc to
in
c
lude window
.
c in the buil
d
.
commit
|
commitdiff
|
tree
2018-06-09
Dan K
e
nnedy
Merge rece
n
t trunk chan
g
e
s wi
t
h thi
s
branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
Upd
a
te the
a
malgamati
o
n build script to incl
u
de window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ke
n
nedy
Add sup
p
ort for
F
ILTER cla
u
s
e
on aggregate window functions
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Ke
n
nedy
Add suppo
r
t for the WINDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Do no
t
fla
t
ten su
b
-queries that c
o
nt
a
in window
f
uncti
o
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Da
n
Kennedy
F
i
xes
t
o allo
w
group_con
c
at()
to be u
s
ed
as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
D
an Kennedy
Merge l
a
test trunk c
h
anges with t
h
is b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
K
ennedy
A
dd win
d
ow functions lag
(
) and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan K
e
nned
y
Add support for window func
t
ion f
i
rst_va
l
u
e
()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Kennedy
Fix
p
rob
l
ems with
t
he n
t
h_value() func
t
i
o
n
.
commit
|
commitdiff
|
tree
2018-06-06
D
an Kennedy
Add
implement
a
tion of nth_valu
e
() window funct
i
on
.
commit
|
commitdiff
|
tree
2018-06-05
Dan K
e
nnedy
Calc
u
late non-agg
r
eg
a
t
e
expression
s
in the SELEC
T
list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan
K
enn
e
dy
Add implem
e
ntation o
f
last
_
v
alue() window funct
i
on
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kenned
y
Add implementation of window func
t
ion ntile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge latest
trun
k
changes into this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
A
d
d support for window
functio
n
cume_
d
i
s
t()
.
I
m
p
rove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Ke
n
nedy
Ad
d
s
upport for window functions r
o
w
_
nu
m
ber(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
K
ennedy
Up
d
ate a test
c
ase in
m
alloc5
.
test t
o
take
into ac
c
o
u
nt
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan K
e
nnedy
A
l
low a
n
ent
i
re pa
r
tition to
b
e
c
ached in a temp ta
b
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Da
n
Ke
n
n
e
dy
Fix
a bug in the SQ
L
ITE_E
N
ABLE_
S
ORTER_REFER
E
NCES code
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Kennedy
Allow min() and m
a
x() to be us
e
d as window functions
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kenned
y
Increa
s
e the n
u
mbe
r
of database hand
l
es open
e
d by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix autoinc
.
test and
resetdb
.
test
so t
h
at they
work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
e
n
n
e
dy
More minor changes to
t
est scripts
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
Fix some test sc
r
ipt
issues caused by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do
not
r
u
n test file
"rese
t
db
.
te
s
t"
a
s part
o
f permutation
.
.
.
commit
|
commitdiff
|
tree
next