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 a minor problem in the code for determining whether or not an SQL
2018-06-30
Da
n
Kenn
e
dy
Fix a minor problem i
n
t
he c
o
de for d
e
ter
m
ini
n
g whe
t
her
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
D
a
n
Kennedy
Merge all
c
hanges
f
ro
m
the we
a
k-fallback branch except
.
.
.
commit
|
commitdiff
|
tree
2018-06-30
Dan Kennedy
H
a
ve the tokenizer handle fallback f
o
r
to
k
ens "
O
VER
.
.
.
commit
|
commitdiff
|
tree
2018-06-29
Dan Kenne
d
y
Further performance related twea
k
s
for sqlite3RunParser()
.
commit
|
commitdiff
|
tree
2018-06-29
D
a
n
Kennedy
Further tweaks to sqlit
e
3RunPars
e
r()
.
commit
|
commitdiff
|
tree
2018-06-29
Da
n
Kennedy
Imp
r
ove on
t
he
prev
i
ous check
i
n
.
Still a bit slow
.
commit
|
commitdiff
|
tree
2018-06-29
D
an Kenn
e
dy
I
n
s
t
ead of using
a
lemon %
f
allback
directive, h
a
ve
.
.
.
commit
|
commitdiff
|
tree
2018-06-28
Dan
K
enned
y
Modifi
c
a
tions to parse
.
y to b
e
t
ter
s
u
pport backwards
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Kennedy
Add missing Vdbe
C
overage() and VdbeCo
v
era
g
eNeverTaken
.
.
.
commit
|
commitdiff
|
tree
2018-06-27
Dan Ken
n
edy
Avoid redu
n
dant
ORDER BY o
p
erations
w
hen rewriting
.
.
.
commit
|
commitdiff
|
tree
2018-06-26
Dan Ken
n
edy
Merge l
a
test trunk cha
n
ges
.
commit
|
commitdiff
|
tree
2018-06-25
Dan
K
ennedy
A
d
d
doc
u
men
t
ation
comment for
s
qlite3_create_windo
w
_function
.
.
.
commit
|
commitdiff
|
tree
2018-06-25
Da
n
Kennedy
Fix another problem that could
c
ause a cr
a
sh when a
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
Fix problems wit
h
us
i
ng window-func
t
i
o
ns
i
n correlated
.
.
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Kennedy
F
i
x
a problem with
u
s
in
g
LIMIT in window-func
t
i
o
n queries
.
commit
|
commitdiff
|
tree
2018-06-23
Dan Ken
n
edy
Fix a p
r
o
b
lem with
u
sing a window-functio
n
SELE
C
T as
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan Kennedy
Omit all
w
i
ndow-function relat
e
d
c
ode when building
.
.
.
commit
|
commitdiff
|
tree
2018-06-22
Dan
Kennedy
Merge
latest trun
k
changes
.
commit
|
commitdiff
|
tree
2018-06-21
Dan Kennedy
Fix a problem with ha
n
dling sing
l
e row partitions
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-06-20
Dan Kennedy
Add tests to imp
r
ove coverage of code in window
.
c
.
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Merge latest
t
r
u
nk change
s
with this bra
n
ch
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Kennedy
Fix a proble
m
cau
s
ed by a sub-
q
u
e
r
y
co
n
taining
a
w
ind
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-06-19
Dan Ken
n
edy
Fix a pr
o
blem
w
i
t
h
u
s
ing min
(
) or max()
as a window
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
F
ix pr
o
blems w
i
th
u
sing
window f
u
nctions in
CREATE
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Ke
n
nedy
A
d
d test case for the fix in the previous commit
.
commit
|
commitdiff
|
tree
2018-06-18
D
a
n Kennedy
Ensur
e
tha
t
all four callbacks are provided wh
e
n re
g
istering
.
.
.
commit
|
commitdiff
|
tree
2018-06-18
Dan Kennedy
Ad
d
new API function sqlite3_cr
e
ate_window_fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Ken
n
e
d
y
A
d
d extra OOM te
s
t
.
commit
|
commitdiff
|
tree
2018-06-15
Dan
K
en
n
edy
Fix another pr
o
blem in
l
ead()/lag()
.
And some errors
.
.
.
commit
|
commitdiff
|
tree
2018-06-15
Dan Kennedy
Fix a
bug in t
h
e
lead() and lag() window funct
i
ons
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan Kennedy
Fix a
problem with ha
n
dling of statem
e
nt
s
containing
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n
K
e
n
n
edy
Fix pr
o
ble
m
with window f
u
nctions min() and
m
ax()
w
hen
.
.
.
commit
|
commitdiff
|
tree
2018-06-14
Dan
K
e
n
n
e
dy
Mer
g
e lates
t
trun
k
changes i
n
to this branch
.
commit
|
commitdiff
|
tree
2018-06-14
D
a
n Kennedy
Improve comments a
n
d code
l
egibility in new
f
ile window
.
c
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kenn
e
dy
Fix pro
b
lems with "RANGE BET
W
EEN CURRENT ROW AND UNBO
U
N
DED
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Fix some test
case number
s
in expert
1
.
t
est
.
commit
|
commitdiff
|
tree
2018-06-13
Dan
K
e
nn
e
dy
Unless
S
QLITE_OMIT_A
U
TOINIT
is defin
e
d, allo
w
s
qlite3_vfs_un
.
.
.
commit
|
commitdiff
|
tree
2018-06-13
Dan Kennedy
Check that m
a
lloc() has
n
ot already
fai
l
e
d
w
hen
i
n
voki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
Dan
K
ennedy
Fix another issue
to do with w
i
n
dow-functions in a
g
g
r
ega
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-06-12
D
an Kenned
y
Fix some p
r
oble
m
s with u
s
ing window-functi
o
ns in aggregate
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan Kenne
d
y
C
l
arify the relat
i
onship between a Window
o
b
j
e
c
t
a
nd
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
D
an Kenn
e
dy
Fix handling of window f
r
ames containing negativ
e
number
.
.
.
commit
|
commitdiff
|
tree
2018-06-11
Dan K
e
nnedy
Fix
a
typon
in main
.
m
k
.
commit
|
commitdiff
|
tree
2018-06-10
Dan Kennedy
Update Ma
k
efile
.
msc
to inclu
d
e w
i
ndow
.
c in the build
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kenn
e
dy
Merge recent tru
n
k
changes with this b
r
anch
.
commit
|
commitdiff
|
tree
2018-06-09
Dan Kennedy
U
pdate t
h
e
amalgam
a
tion build scr
i
pt
to include window
.
c
.
commit
|
commitdiff
|
tree
2018-06-09
D
a
n Kennedy
Add s
u
pport for FILTE
R
c
lause on
a
g
g
regat
e
window fu
n
ctions
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Kenn
e
dy
Ad
d
s
u
p
port f
o
r the WINDOW cl
a
us
e
.
commit
|
commitdiff
|
tree
2018-06-08
Dan Ke
n
nedy
Do not flatten sub-quer
i
es that
c
on
t
ai
n
window func
t
ions
.
commit
|
commitdiff
|
tree
2018-06-08
D
a
n Ken
n
edy
Fi
x
es to a
l
low group_co
n
cat() t
o
b
e used as a win
d
ow
.
.
.
commit
|
commitdiff
|
tree
2018-06-07
Dan Kennedy
Merge latest
trunk c
h
anges wit
h
this branch
.
commit
|
commitdiff
|
tree
2018-06-07
Dan
Kennedy
Add window fun
c
tions lag() and lead()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n Ke
n
n
e
dy
Add su
p
p
ort for window
f
unction fir
s
t_value()
.
commit
|
commitdiff
|
tree
2018-06-07
D
a
n
Kennedy
Fix problems with the nth_value() function
.
commit
|
commitdiff
|
tree
2018-06-06
D
a
n
Kennedy
A
d
d implementation o
f
nth_value() window func
t
ion
.
commit
|
commitdiff
|
tree
2018-06-05
D
a
n Ke
n
n
e
dy
Calculat
e
non-aggregate expressio
n
s in the
SELECT
lis
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-05
Da
n
Kenn
e
dy
Add implementa
t
i
on
of last_val
u
e() w
i
ndo
w
function
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
ne
d
y
A
d
d
implemen
t
a
tion o
f
window functio
n
n
t
ile()
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Ke
n
n
e
dy
Merge
l
a
test trunk change
s
i
n
to this branch
.
commit
|
commitdiff
|
tree
2018-06-04
Dan Kennedy
Add supp
o
rt for
w
i
n
dow function cume_dist()
.
I
mprove
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan
Kennedy
A
d
d suppo
r
t
fo
r
window
f
un
c
t
i
o
n
s row_number
(
), rank
.
.
.
commit
|
commitdiff
|
tree
2018-06-02
Dan Kennedy
Update a t
e
st
ca
s
e
in malloc5
.
t
e
st to
t
ake in
t
o acc
o
u
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
Dan Kennedy
Allow an
e
n
t
i
re p
a
rtition to be c
a
ched in a temp table
.
.
.
commit
|
commitdiff
|
tree
2018-06-01
D
an Ken
n
e
dy
Fix a bug
in
the SQ
L
IT
E
_EN
A
B
L
E
_
SORTER_REFEREN
C
ES
c
ode
.
.
.
commit
|
commitdiff
|
tree
2018-05-30
Dan Ken
n
edy
Allow min() and ma
x
() to be used as w
i
ndow
f
u
ncti
o
ns
.
commit
|
commitdiff
|
tree
2018-05-29
D
an Kennedy
Increas
e
the numbe
r
of database handles opened by
tes
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ken
n
edy
Fix
a
utoinc
.
t
e
st and
r
e
setdb
.
te
s
t so that they work
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Ke
n
nedy
More
m
inor changes to test
s
cri
p
ts
.
commit
|
commitdiff
|
tree
2018-05-29
Dan
K
ennedy
Fix some test script issues cau
s
ed b
y
rec
e
nt EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-29
Dan Kenned
y
Do not run tes
t
file "reset
d
b
.
t
e
s
t
" as
p
art
o
f
permutatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-28
D
a
n Kennedy
Fur
t
her window frame tests and
f
ixes
.
commit
|
commitdiff
|
tree
2018-05-28
D
an Kenn
e
dy
Do not require a sta
t
eme
n
t journal in case
s
w
h
ere REPLACE
.
.
.
commit
|
commitdiff
|
tree
2018-05-26
D
an Ke
n
n
e
dy
M
ore f
i
xes for
different window frame typ
e
s
.
commit
|
commitdiff
|
tree
2018-05-25
Da
n
K
ennedy
Fix "RAN
G
E BET
W
E
E
N CURREN
T
ROW A
N
D UNBOUND
E
D FOLLOWING
.
.
.
commit
|
commitdiff
|
tree
2018-05-25
Dan Kennedy
Merge
l
a
test tr
u
nk
c
hanges i
n
t
o thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-25
Dan
K
ennedy
Fi
x
es for
"ROWS BETWEEN <expr> FO
L
LOWING AND <expr
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kenne
d
y
Allow "<expr> PRECEDING"
to b
e
used to specify
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-24
Dan Kennedy
Support other frame types that use "<ex
p
r> PRECEDING
.
.
.
commit
|
commitdiff
|
tree
2018-05-23
Dan Kennedy
Add support for "ROWS BETWEEN <expr>
PRECED
I
NG AND
.
.
.
commit
|
commitdiff
|
tree
2018-05-22
Dan K
e
nnedy
Merge latest tr
u
nk
changes into this br
a
nc
h
.
commit
|
commitdiff
|
tree
2018-05-22
Dan Kennedy
Add comments
t
o
wi
n
dow
.
c describi
n
g
h
ow other window
.
.
.
commit
|
commitdiff
|
tree
2018-05-21
Da
n
K
ennedy
Beg
i
n adding s
u
pport for more
esoteric w
i
ndow frames
.
commit
|
commitdiff
|
tree
2018-05-19
D
an Ke
n
nedy
Fix minor problems on
thi
s
branch
.
commit
|
commitdiff
|
tree
2018-05-17
Dan K
e
nn
e
dy
E
valuate multiple window func
t
ions in a single
p
ass
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
a
n Kennedy
Handle multiple wind
o
w
-function
s
in a si
n
g
l
e query
.
commit
|
commitdiff
|
tree
2018-05-16
Da
n
Kennedy
Start of experimental implementation of SQL wi
n
dow
.
.
.
commit
|
commitdiff
|
tree
2018-05-15
Dan
K
e
nnedy
Fi
x
a te
s
t case problem in wherelimit
.
test
.
commit
|
commitdiff
|
tree
2018-05-09
Dan
K
ennedy
A
d
d a test
c
a
se to c
h
eck
that
t
h
e fts5 unicode6
4
tokenizer
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
Dan Kennedy
F
i
x a pr
o
blem in
t
he x
B
estIndex met
h
od of the cl
o
sure
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
Dan Kennedy
Fix an
R
BU pro
b
lem causin
g
sp
u
r
ious SQLITE_CON
S
TRAINT
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
an Kennedy
U
p
date test
s
c
r
ipt fts3ex
p
r4
.
test so t
h
a
t
it a
l
ways
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
Dan Ke
n
nedy
Fi
x
a test
scr
i
p
t e
r
ror
causing t
e
sts
to fail in soak
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
W
h
en proc
e
ss
i
n
g
a
n
"ORDER BY
.
.
.
LIMIT"
t
h
a
t does not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
Dan Kennedy
When
p
roc
e
ssing an "ORDER BY
.
.
.
LI
M
IT" that does
not
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
a
n
Ken
n
edy
Update
t
he
"fuzz_malloc
.
tes
t
" script to print SQL state
m
ents
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
an Ken
n
edy
Re
m
ov
e
a
r
ec
e
ntly added NEVER() macro
from a b
r
anch
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Ken
n
e
dy
Fix a pro
b
l
e
m with
p
rocessing "L
E
FT JOI
N
tbl ON tb
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
Dan Kenn
e
d
y
Do
n
ot atte
m
pt t
o
read val
u
es from inde
x
es-on
-
e
x
pressions
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
Dan
K
ennedy
A
few m
o
re
tests for upse
r
t
.
commit
|
commitdiff
|
tree
2018-04-20
Dan Ken
n
edy
E
n
hance the
"
rbu" command line uti
l
i
t
y a b
i
t
.
commit
|
commitdiff
|
tree
next