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 the OOM issue mentioned in the previous check-in.
2018-05-16
D
.
Richard Hi
p
p
Fix the OO
M
issue mentioned in the previous check-in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard H
i
pp
Initial implementa
t
ion of th
e
ability to have auxiliary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
E
n
h
a
nce the sqlit
e
3_str_new() interf
a
ce so that it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
i
chard Hipp
Correct output for th
e
ful
l
k
e
y column
of json_each
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
ichard H
i
pp
M
a
ke more aggressive use of automati
c
i
n
d
exes when
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Conve
r
t the schema creat
i
o
n
l
o
gic in the rtree extension
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richar
d
H
i
pp
Export
t
he deduc
e
DatabaseType() functi
o
n
th
e
shell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
A
dd the --append
o
p
t
i
o
n to the "
.
b
a
cku
p
" command in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
R
ich
a
rd
H
ipp
In the CLI, a
l
l
ow comment lines that
begin with '#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
icha
r
d
H
i
p
p
In
t
h
e
CLI
,
re
t
u
r
n no
n
-zer
o
i
f there are errors
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Ri
c
h
a
rd Hipp
Fix a
typo i
n
the help m
e
ssage from the "
.
sha3sum"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard Hi
p
p
Make
sure
the o
p
en_db() routine in the CLI d
o
e
s not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ric
h
a
rd Hipp
Add 1
4
new i
n
terfaces
t
o the loadable e
x
tension mechanism
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
i
chard
Hipp
Fix
minor problems
w
ith the sqlit
e
3_str interface
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
hard Hi
p
p
M
ake the internal dynamic s
t
ring
i
n
terface availa
b
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
ichard
H
ipp
Fix a t
y
po
in a c
o
mment used for docume
n
tat
i
on
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Correct
l
y
format the STAT1 and STAT4 content
i
n the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard H
i
p
p
Fix a harmle
s
s
c
o
m
pil
e
r
warning
i
n
fu
z
zche
c
k
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard
Hipp
Fuzz
t
est cases for U
P
SERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
H
ip
p
A
ctiv
a
te
the cell
-
ov
e
r
write optimi
z
ation for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichar
d
Hi
p
p
Improved
c
omments on the c
e
ll-overwrite optimization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard H
i
pp
On an UPDATE, try to
overw
r
ite an ex
i
sting btree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
H
ipp
F
ix harml
e
ss compiler w
a
rnings a
s
s
o
ciated with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
F
ix har
m
l
e
s
s compil
e
r warnings in t
h
e
cell-overwr
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Backout change [05fee1a21ea398f1e4d6f1c
f
3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
R
ichar
d
H
ipp
I
n an
O
RDER BY
L
IMIT, make sure the ORDER
B
Y expressi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard H
i
pp
Fix a slig
h
tly incorr
e
c
t
c
orruption detec
t
i
on branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge enhancem
e
n
t
s from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
c
h
ard H
i
pp
Fix requirements marks
.
No
code chan
g
es
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
For the
amal
g
amation-ta
r
ba
l
l
, enable FTS
5
and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard
H
ipp
Mak
e
a separa
t
e limb in t
h
e
E
XP
L
A
I
N QUER
Y
P
L
AN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
In ORDER
B
Y LIMIT queries, try to evaluate the
ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
Fix a bra
n
ch
that
has b
e
come unreachable
due
t
o
recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Improved
securi
t
y for VACUUM
.
This c
h
e
ck-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Overhaul o
f
EXPLAIN QUERY PLAN
.
Th
e
o
utput is now
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
Optimi
z
ations to th
e
new
EQP fr
a
mework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
ha
r
d Hipp
Fix vari
o
us
e
rror
ha
n
d
l
ing
conditions on the cell
o
ver
w
rite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The
B
t
Cursor
.
info fields
a
re on
l
y val
i
d if info
.
n
S
iz
e
!
=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Add more corruption checking to the c
e
ll ove
r
w
r
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Bug fixes in the
overwrite optim
i
zation
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The
s
q
l
i
te3BtreeInsert() routi
n
e tries
to overwr
i
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
Enhance EXPLAI
N
QUERY
PLAN t
o
report the gene
r
ation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
h
ard Hipp
More test cas
e
updates
.
Te
s
ts ar
e
all running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fi
x
test c
a
ses so that they w
o
rk w
i
th the
new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Improved EQP output
f
or re
c
u
rsiv
e
CTEs and multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Prevent VACUU
M
from running any comm
a
nds in sql
i
te_maste
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix a dan
g
ling-else
problem that was c
a
usin
g
recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Improvements to the
E
Q
P display f
o
r compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Begin reengi
n
eerin
g
the EXPLAIN QUERY PLA
N
function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard
Hi
p
p
The SQLITE_ALLOW_SQLITE_MASTER_INDEX
co
m
pil
e
-t
i
me option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richar
d
Hipp
Defe
r
loading result column values i
n
t
o r
e
gis
t
ers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Test
c
a
s
e
s
adde
d
for SQLITE_DBCONFIG_RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Add the SQLI
T
E_D
B
CONFIG_RESET_DATABASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd
H
ipp
A
dd the
S
QLI
T
E_DBCONFIG_
R
ESET_D
A
TABASE
contro
l
a
s a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
Merge
u
p
dates f
r
om t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Pr
e
v
ent de
e
p recursio
n
s on nested COLLATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Fix compil
e
r wa
r
n
in
g
s in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hipp
Add the "PRAGM
A
reset_databas
e
=ON|OFF" command
.
Wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard
H
ipp
Enh
a
nce the comments in th
e
te
m
platevtab
.
c
i
mplementatio
n
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
H
ipp
The
previous fix f
o
r ti
c
ket
[
d85fffd6f
f
e856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Ensure that new
.
* values of an UPDATE do not ge
t
c
l
obber
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
r
d Hipp
Clarification of the
b
e
havior of a BEFORE UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hip
p
Im
p
rove
d
VDBE comm
e
nt on
the
O
P_Param opcode
.
No substa
n
tia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add
ne
w
inte
r
faces f
o
r
a
ccessing the list of S
Q
L keywo
r
ds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard
Hipp
Add the n
e
w
DO
and
N
O
THING keywor
d
s
t
o the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add the new SQL
I
TE_SHEL
L
_INIT_PROC comp
i
le-time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
r
d
Hipp
Avoi
d
ma
n
y
u
nnece
s
sary calls to sqlit
e
3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d H
i
pp
Add an
a
ssert() to ensure that
s
chema mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard H
i
pp
Do not
a
ttempt to use
t
er
m
s
from the WHERE c
l
au
s
e to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Update
the
e
x
pert extension test
c
ases to accou
n
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the O
R
optimiz
a
tion to
p
r
o
c
eed ev
e
n if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard
Hipp
Add a hyper
l
ink to the
t
ic
k
et on the code comme
n
t
f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance the CLI to r
e
nder EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
F
ix a
memory leak fo
l
lo
w
ing failu
r
e
t
o open an
ex
t
ernal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hip
p
In EXPLA
I
N
Q
UERY PLAN
output, d
o
no
t
show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Fix t
o
ch
e
ck-in [ca34c
2
dd20ee071e]
-
a
v
oid a NULL poi
n
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Fix
a
problem
in sqlite3ExprCom
p
are() ass
o
ci
a
ted with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
F
ix a f
o
rmatting issue in the TreeView outpu
t
for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Add
t
he
"
.
imposter off" variant of
t
he "
.
i
mpost
e
r"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
har
d
H
i
p
p
The
"
.
selecttrace 0x2000" com
m
and causes just the
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
h
a
r
d
H
ipp
T
he "
.
selectt
r
a
c
e 4" comman
d
n
ow sho
w
s only a
s
i
n
gle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Do not restore the iSe
l
e
ctId va
l
ue until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
I
n
the "
.
selecttra
c
e" output,
include
the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
Ensure that there a
r
e
no bind-parameters
o
r in
c
o
r
rect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix
an unreachable branch assoc
i
a
ted
w
i
th stack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
ha
r
d
Hipp
P
e
r
f
orman
c
e improvement
s
on the m
a
i
n loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
r
d Hipp
Enhance LEMON to track
w
hich symbol
s
actually
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %extra_co
n
tex
t
direc
t
ive
t
o lemon, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
icha
r
d Hipp
Fix UPSERT so that it
p
l
a
ys nic
e
ly wit
h
AUTO
I
NCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hip
p
Add the -dDI
R
ECTORY command-line o
p
tion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
Hipp
Fix a harmless compile
r
warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the u
s
e
o
f
stat
e
ment j
o
urnals on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Avoid opening a
stat
e
me
n
t jo
u
rnal on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Fix a VDBE comment on upsert
.
Provid
e
an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
p
p
Avoid unnecessary
curs
o
r seeking when pe
r
f
o
rming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Improved VDBE co
m
ment on UPS
E
RT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor si
m
pli
f
icat
i
on of th
e
previous checki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ic
h
ar
d
Hipp
A
v
o
id u
n
n
ecessary cursor seeks durin
g
up
s
ert proc
e
ssin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Enhan
c
e UPSERT
s
o th
a
t
the
UPDATE u
s
e
s
t
he same
set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Minor si
m
plifi
c
at
i
on of th
e
c
u
rsor alloc
a
tion log
i
c
.
.
.
commit
|
commitdiff
|
tree
next