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 harmless compiler warning in fuzzcheck. Add new OSSFuzz test cases
2018-05-08
D
.
Richard H
i
pp
Fix a harmle
s
s compiler
w
arning in fuzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richa
r
d Hipp
Fuzz test
c
as
e
s for UPS
E
RT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Activate the
cell-over
w
rite optimiz
a
tion for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Rich
a
rd
H
i
pp
I
m
p
roved com
m
ents on the cell-ove
r
write optimization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
On
a
n
U
PDAT
E
, try to overwr
i
te an exist
i
ng b
t
r
ee cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harm
l
ess compiler warnings associ
a
ted with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harml
e
s
s
compiler warnings in the cell-overwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard H
i
pp
Backou
t
change
[
05fee1a21ea39
8
f
1e4d
6
f
1cf3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In an ORDER BY LIMIT
,
make sure the ORDER BY expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slig
h
tl
y
incor
r
e
ct co
r
r
uption
de
t
ection branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge enhanc
e
ments from trun
k
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix r
e
quir
e
me
n
t
s
marks
.
No code chang
e
s
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
For t
h
e am
a
lgama
t
ion-t
a
rball, enable FTS5 and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richar
d
Hipp
Make
a
s
e
parate li
m
b
i
n the EX
P
L
A
IN QUERY PLA
N
out
p
ut
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
In O
R
DER BY LIMIT queries
,
try
t
o
ev
a
luate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
Fix a branch t
h
at has bec
o
me unreachable due
t
o re
c
ent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
I
m
proved s
e
curity for VACUUM
.
This
check-in combi
n
es
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Overhaul of EXPLAIN QUER
Y
PLA
N
.
Th
e
output
i
s now i
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichar
d
Hipp
Optimizations to the
new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
a
r
d Hipp
Fix various err
o
r ha
n
dling conditions on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd H
i
pp
The BtCurso
r
.
i
n
f
o
fields are o
n
ly valid if info
.
nSi
z
e
!
=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Ad
d
more corruptio
n
check
i
ng to the cell over
w
rite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
B
ug fix
e
s in the overwrite optimiza
t
ion
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
r
d
Hipp
The s
q
lite3BtreeInser
t
(
) routine t
r
i
es to ov
e
rwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
Enhance EXPLAIN
QUERY PLAN to r
e
po
r
t th
e
generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard
Hipp
More
t
est case updat
e
s
.
T
e
sts are all r
u
nning now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Fix test
c
ases
s
o that they wor
k
with the new
EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hipp
Im
p
roved EQP output f
o
r recursive CTEs and multi
-
val
u
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Prevent VACUUM from running any comma
n
ds i
n
sqlite_ma
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
Fix a dang
l
ing-else
p
r
o
blem that was causing
r
ecur
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
Hipp
Impr
o
vem
e
nts
to t
h
e EQP
d
i
splay for
c
ompound
s
e
l
ect
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
H
i
p
p
B
e
gi
n
reengineering the E
X
PLAIN QUE
R
Y PLAN func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hip
p
The SQLITE_ALLOW_SQLI
T
E_MASTER_INDE
X
c
ompile
-
time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
D
efer lo
a
ding result column val
u
es
into registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Test
c
ases
a
dde
d
f
or
SQLITE_DBCONFIG_RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
ha
r
d Hipp
Add the SQLITE_DBCONFIG_RESET_DAT
A
BASE c
o
nt
r
ol f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hi
p
p
Ad
d
the SQLITE_DBC
O
N
F
IG_RESET_DATABASE contro
l
as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
H
i
pp
M
e
rge
u
pdat
e
s from trun
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Prev
e
n
t deep r
e
cursi
o
ns on nested COLLATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hip
p
Fix compiler w
a
rnings
in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Add th
e
"
P
RA
G
MA reset_d
a
tabase=ON|OF
F
" command
.
Whe
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhanc
e
the co
m
m
ents
i
n the templ
a
te
v
ta
b
.
c impl
e
mentati
o
n
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
a
r
d
H
i
pp
T
h
e
p
reviou
s
fix
for ti
c
ket [d85fffd
6
ffe85
6
0
92
e
d8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hip
p
Ensure that new
.
* va
l
u
e
s
o
f an UPDATE do
n
ot get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarifica
t
i
on of
the behavior of a BE
F
ORE UPDAT
E
t
rigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VDBE comment on the OP_Para
m
opcode
.
No s
u
bstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
A
dd
n
e
w
interfaces
f
or accessing the
l
i
s
t
of
S
QL keywords
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the ne
w
DO
a
nd NOTHI
N
G keywor
d
s to th
e
keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
r
d Hipp
Add
t
h
e new S
Q
LITE_SHELL_INIT_
P
ROC
com
p
ile-t
i
me e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
cha
r
d Hipp
A
v
oid many unnecessary
c
alls to s
q
lite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an assert() to ensure
t
ha
t
schema mutex
e
s are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
H
i
pp
Do
n
ot attempt to
u
s
e
term
s
f
rom th
e
WHERE
c
lause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
Update the expert extension t
e
st
c
as
e
s
t
o account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the OR optimizat
i
on to proce
e
d
even if t
h
e OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Add a hyperlink to the tick
e
t on the code c
o
mme
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
E
nhance
the
C
LI to
r
en
d
e
r
EXPLAI
N
QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
F
ix a mem
o
ry leak
f
o
llowing f
a
ilure t
o
open an exte
r
nal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
ch
a
rd Hipp
In
E
XPLAIN QUER
Y
P
LAN output,
d
o n
o
t show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix
to check-in [ca34c2dd20ee071e] - av
o
id a NULL pointe
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Fix
a
pro
b
lem in sq
l
ite3ExprCompa
r
e()
a
sso
c
iated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Fix a format
t
ing issue in the TreeVi
e
w ou
t
p
ut for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Add the
"
.
impo
s
ter o
f
f
"
varia
n
t o
f
the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
electtrace 0x2000" comma
n
d cause
s
jus
t
the t
o
p
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selecttrace 4" command now shows only a si
n
gl
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Do
n
ot restore th
e
iSelec
t
Id value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
In the "
.
s
e
l
ecttrace" output, include
the EXPLAI
N
QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
E
n
sure that th
e
re
a
re no
b
ind-
p
arameters or in
c
orrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
F
i
x an unreachable branc
h
associ
a
t
ed
with s
t
ack overf
l
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Perfo
r
mance i
m
pro
v
ements on
the mai
n
loop of the LEM
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance LEMON to track
w
hic
h
symbols actually c
a
rry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Add
the %e
x
t
r
a_context dire
c
tive t
o
l
em
o
n, as
a
n al
t
erna
t
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
Fix UPSERT s
o
that it plays n
i
cely wi
t
h A
U
T
O
INC
R
E
M
E
N
T
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add the -dDIRE
C
TORY command-line op
t
ion to
L
EMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Fix a harm
l
ess c
o
mpi
l
er warn
i
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
a
r
d
Hip
p
A
v
oid the use
of statement journals on D
E
L
E
TEs
o
f a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hi
p
p
Avoid opening a statemen
t
jo
u
rnal o
n
s
ing
l
e-row
U
PDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
F
i
x a VDBE comm
e
nt on upsert
.
Provide an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
i
d unnecessa
r
y
cursor
s
e
eki
n
g
w
hen per
f
orming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Imp
r
oved VDB
E
co
m
ment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor simplification of the previous ch
e
ckin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard
H
ipp
A
void u
n
ne
c
essary cursor se
e
ks du
r
ing upse
r
t processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
Enhanc
e
UPSERT so that t
h
e UPDATE
use
s
t
he same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Mi
n
or
s
i
mp
l
ification of the curs
o
r a
l
loca
t
ion log
i
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
i
x
the
h
andl
i
ng of "PRAGMA count_cha
n
ges=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
M
inor
s
i
m
p
lificat
i
on to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hip
p
A
d
d the --upsert option to the
wordcount test pr
o
gram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the ext
/
mi
s
c/templatevtab
.
c t
e
mp
l
ate for vir
t
ual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Fix a
p
roblem in the new
u
ps
e
rt i
m
plemention,
d
iscove
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard
H
ipp
F
i
x
the table name aliasi
n
g on
INSE
R
T so that it occ
u
rs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
A
v
oid a NULL
-
point
e
r deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fix a te
s
t
ca
s
e ins
i
de
d
i
stinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Improved
m
atching of
COLLATE c
l
au
s
e
s within
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fi
x
a problem in the s
q
lite3E
x
prC
o
mpare
(
) fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
H
ipp
Add support for Po
s
tgreS
Q
L UPSERT syntax and func
t
ionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Fix
th
e
build fo
r
SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ip
p
A
d
d
the -
-
sorterr
e
f
N option
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
ard Hipp
Omi
t
some
c
ode not used without SQLITE_EN
A
BL
E
_SORTER_
R
EFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
H
ipp
R
emo
v
e an
unused
l
ocal
v
ariable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
E
nhance ALT
E
R TABLE ADD COL
U
M
N to support
"DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Add checks
to
th
e
CLI
that issue a
w
arning i
f
SQ
L
ite
.
.
.
commit
|
commitdiff
|
tree
next