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
Modify tests in window3.test to be tolerant of rounding errors when comparing
2018-07-10
Dan
Kennedy
M
o
d
i
fy tests in wind
o
w3
.
t
est t
o
b
e
to
l
erant of rounding
.
.
.
commit
|
commitdiff
|
tree
2018-07-10
Dan Kennedy
Fix a problem wit
h
u
s
ing scalar
sub-selects in
wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan Ken
n
e
dy
A
v
oid
l
e
a
v
ing view-definitions w
i
th an i
n
com
p
l
ete set
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan K
e
nned
y
Add a cou
p
le of OOM tests
.
commit
|
commitdiff
|
tree
2018-07-09
Da
n
Kenn
e
d
y
Throw an error if
the second
a
rgume
n
t pass
e
d to nt
h
_
v
alue
.
.
.
commit
|
commitdiff
|
tree
2018-07-09
Dan
K
ennedy
Fi
x
a bad assert() in
w
i
n
dow
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kenne
d
y
Fix another prob
l
em with
r
e
using LSM cursors for
r
ange
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan
K
ennedy
F
ix an
L
S
M
problem caus
e
d by using t
h
e sa
m
e curso
r
.
.
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Add mis
s
ing Vdb
e
Coverage
(
) macro
t
o window
.
c
.
commit
|
commitdiff
|
tree
2018-07-07
Dan Kennedy
Fix a
problem
w
ith
th
e
ha
n
dling of NULL values i
n
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Also disallow non
-
constant e
x
pres
s
ions in "<expr> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
Kennedy
Ensure an error
i
s returned if the user
s
p
ecifies an
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan Kennedy
Pre
v
en
t
"UNBOUNDED FOLLOWING"
from being us
e
d
a
s
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
D
an Kennedy
Remove some bad asser
t
() statements from th
e
implementations
.
.
.
commit
|
commitdiff
|
tree
2018-07-06
Dan
Kenne
d
y
R
etur
n
a
n error if DISTINC
T
is u
s
ed w
i
t
h a
w
indo
w
-function
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan
Kenn
e
dy
Update the recipe for resett
i
ng a database
u
sing
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
Return an
e
rror if a "RAN
G
E
" windo
w
-f
r
am
e
us
e
s
"<expr
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
D
a
n Ken
n
edy
F
ix a proble
m
in the xInverse m
e
thod of win
d
ow-funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Ken
n
edy
In wal mode, if a "
B
E
GIN EXCLUS
I
VE" command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
F
ix a typo ins
i
d
e a
n
assert() st
a
tement introduc
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-07-05
Dan Kennedy
In
wa
l
mode, if a "BEGIN EX
C
LUSIVE" command (or any
.
.
.
commit
|
commitdiff
|
tree
2018-07-03
Dan
K
enne
d
y
Test that a
r
ace condition can cause
a
"B
E
G
I
N EXCL
U
SIVE
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
an
Kenn
e
dy
Fix a problem in the xInv
e
rse callback for the bu
i
lt
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Kenne
d
y
Fix
a
s
egfault
c
ause
d
by
h
aving identical
window funct
i
ons
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
Dan Ken
n
ed
y
Fix a crash caused by a
LIKE pattern that consists
.
.
.
commit
|
commitdiff
|
tree
2018-07-02
D
a
n Ke
n
nedy
Fix
a
segfault caused by invoking a regular agg
r
egate
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
edy
Avoid a warning in ft
s
5
.
c d
u
e to not using gene
r
ated
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kenn
e
dy
M
erg
e
implem
e
n
tatio
n
of SQL window
functions
from t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Da
n
Kenn
e
dy
F
i
x a minor prob
l
e
m
in the code for
determining
wheth
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan
Kennedy
Merge
a
ll chang
e
s from the weak-fa
l
l
b
ack
b
r
a
nc
h
except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Ken
n
edy
Have
t
h
e
tok
e
n
i
zer handle fallback for
to
k
en
s
"OVER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n
K
e
nne
d
y
Further performance related tweaks
fo
r
sqli
t
e3RunP
a
rser
(
)
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kennedy
Further tweaks to sqlit
e
3RunParse
r
()
.
commit
|
commitdiff
|
tree
2018-06-29
Dan K
e
n
nedy
Improve on the p
r
e
v
io
u
s ch
e
ck
i
n
.
Still a bit slo
w
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Ken
n
edy
Inst
e
ad of using a
l
emo
n
%fa
l
lba
c
k directive, have
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
D
an Kennedy
M
odifications to parse
.
y
t
o bett
e
r support backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
an Ken
n
edy
Add missing VdbeCoverage
(
)
and VdbeCove
r
ageNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
D
an Kenned
y
Avoid redunda
n
t
O
R
DER BY
o
p
erations when
r
ew
r
iting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Kennedy
M
e
rge lat
e
st trunk ch
a
ng
e
s
.
commit
|
commitdiff
|
tree
2018-06-25
Dan Kennedy
Add documentation commen
t
fo
r
s
q
l
ite3
_
cr
e
ate_window_func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Dan K
e
nnedy
F
ix another problem that coul
d
cause a
c
rash when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
F
ix p
r
oblems with using win
d
ow-func
t
ions in
correlat
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
Fix a problem with using
L
IMIT in window-function queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan
Kenned
y
Fix a pro
b
lem wit
h
using
a wi
n
dow-funct
i
on SELECT as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan K
e
nnedy
Omit all
w
indow-func
t
ion related
c
o
de when
b
uilding
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kenn
e
dy
Merge latest trunk
changes
.
commit
|
commitdiff
|
tree
2018-06-21
D
an Kennedy
Fix a pr
o
blem with handling single row partiti
o
ns in
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan K
e
nnedy
A
dd
t
ests to im
p
rove
coverage of code
i
n
w
i
nd
o
w
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ke
n
nedy
Merge l
a
test trunk c
h
anges w
i
th this
branc
h
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
edy
Fix a
problem c
a
used
by a su
b
-query cont
a
ini
n
g a
w
i
ndow
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kenn
e
dy
Fix a p
r
oblem with using
min() or max() as a win
d
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
an Kennedy
Fix pr
o
blems
w
ith us
i
ng wi
n
d
ow functi
o
n
s in CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan
Kennedy
Add test ca
s
e
f
o
r the fix
in
t
he pr
e
vious
c
ommit
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kenne
d
y
Ensure that all four callbacks are pro
v
ided
w
hen regi
s
teri
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n K
e
nnedy
Add new API
f
uncti
o
n
s
ql
i
t
e
3_create_win
d
o
w
_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Da
n
Kennedy
A
d
d extra OOM test
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
Ke
n
ne
d
y
Fix
a
n
o
t
h
e
r
problem in lead()/lag()
.
And
s
ome errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ken
n
e
dy
Fix
a bug i
n
the
lead() and lag() window functions
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
an K
e
nnedy
Fix a problem
w
i
t
h h
a
ndli
n
g of statements containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan K
e
nnedy
Fix problem with w
i
n
dow functions min()
and max() when
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Ke
n
nedy
Merge latest trunk changes
in
t
o
this branch
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
enne
d
y
Improve comment
s
and code leg
i
bility i
n
new file window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kenn
e
d
y
Fix problems w
i
th "RANGE BETWEE
N
CU
R
RENT ROW AND UNB
O
UNDED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix s
o
me test case
n
umber
s
in
e
xpert1
.
test
.
commit
|
commitdiff
|
tree
2018-06-13
D
an Kennedy
Unless
SQLITE_OMIT_AUTOINIT is
defined, allow s
q
lite3_vfs_
u
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
D
a
n Kenne
d
y
Check that ma
l
loc
(
)
has n
o
t alre
a
dy fa
i
le
d
when invoking
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Kennedy
F
i
x another is
s
ue to do with
w
i
n
dow-functions
in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan Ken
n
edy
Fix
s
ome problems
w
i
t
h
using
w
indow-functions in agg
r
e
g
a
te
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Clarify the re
l
a
ti
o
nship between a Window
o
b
j
e
c
t and
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kennedy
Fi
x
handling o
f
wi
n
dow fr
a
mes
c
ontaining ne
g
ative number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
a
n K
e
nnedy
Fix
a typo
n
i
n
main
.
mk
.
commit
|
commitdiff
|
tree
2018-06-10
D
a
n
Ken
n
e
d
y
Update Ma
k
efile
.
msc to include win
d
ow
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Merge
r
ecent trunk changes with this branch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Ken
n
e
dy
Update the amalgama
t
ion build scr
i
pt
to i
n
clude
w
indow
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenne
d
y
A
dd
support
for
F
ILTE
R
c
lause on aggregate window functio
n
s
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kennedy
Add support
f
or the
W
I
NDOW clause
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Kenned
y
Do not f
l
atten sub-que
r
ies tha
t
contai
n
win
d
ow functions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ke
n
nedy
Fixes to all
o
w g
r
o
up
_
con
c
at() to be used a
s
a
window
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kenned
y
M
erge latest trunk
ch
a
nges with this
branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Ken
n
edy
Add window func
t
ions lag(
)
and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Add sup
p
ort for
w
indow
fun
c
tion first_value()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n
K
enned
y
F
i
x problems with t
h
e nth_va
l
u
e() function
.
commit
|
commitdiff
|
tree
2018-06-06
Dan
K
e
n
n
edy
Add implementa
t
ion of nth_value(
)
wi
n
dow fu
n
ction
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
K
e
nnedy
Calculate n
o
n
-
aggr
e
gate e
x
pressions in the SELECT list
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Dan
Kenne
d
y
Add implementation of
l
a
s
t_value() w
i
n
dow
function
.
commit
|
commitdiff
|
tree
2018-06-04
Da
n
Kennedy
A
dd implemen
t
ation of
w
indow function n
t
ile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Merge
latest trunk c
h
a
n
ges into this
b
ranc
h
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
A
dd s
u
p
port for window function cume_dist()
.
Improve
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan K
e
nnedy
Ad
d
sup
p
ort for window funct
i
ons row
_
number(), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
D
an
Kennedy
Update a
test
case in ma
l
l
o
c5
.
test to take into accoun
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kenn
e
dy
Allow an entire p
a
rtition to be cach
e
d in a
temp ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Kennedy
Fix a bug
i
n the SQLITE_ENA
B
LE_SORTER_REFEREN
C
ES co
d
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
D
a
n K
e
nned
y
All
o
w mi
n
() and max() to be used as wi
n
d
ow functions
.
commit
|
commitdiff
|
tree
2018-05-29
D
a
n
Kennedy
Increa
s
e t
h
e number of database handles opened by test
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenne
d
y
Fix aut
o
inc
.
test and resetd
b
.
test s
o
that t
h
e
y w
o
rk
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
More minor chang
e
s t
o
test
sc
r
ip
t
s
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Fix
some test scri
p
t issu
e
s c
a
us
e
d by recent EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kennedy
Do not
r
un
tes
t
f
ile "rese
t
db
.
test"
a
s p
a
rt of permutation
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kennedy
Fu
r
ther
w
indow frame tes
t
s and fi
x
es
.
commit
|
commitdiff
|
tree
2018-05-28
Dan Kenned
y
Do not
r
e
quire a
s
tatemen
t
journal in
cas
e
s where
REPLACE
.
.
.
commit
|
commitdiff
|
tree
next