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 Hipp
Fix
the O
O
M issue mentioned in
the p
r
e
v
i
ou
s
check-in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hip
p
I
nitial im
p
lem
e
ntation of the
a
bility to have auxili
a
ry
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
i
chard Hipp
Enhance t
h
e sqlite3_str
_
new(
)
int
e
rface
s
o that
it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
i
char
d
Hipp
Co
r
r
ec
t
output for
t
h
e fullkey column of json_e
a
ch
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
i
char
d
Hipp
Make more aggressive use of automatic indexes w
h
en
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hi
p
p
Co
n
v
ert the schema creation logic in the rtr
e
e ext
e
ns
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ric
h
a
rd Hipp
Ex
p
ort the dedu
c
eDatabas
e
Type() functio
n
the shell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hip
p
Ad
d
t
h
e
--append option
to the
"
.
bac
k
up"
c
o
mman
d
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Ric
h
ard H
i
pp
In the CLI, allow
c
omment
l
ines that
begin with '#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
c
hard
Hipp
In the C
L
I, return no
n
-ze
r
o if
t
here are
error
s
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
chard Hipp
F
i
x a typo
in the
help message from the
"
.
s
ha3su
m
"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Ri
c
h
a
rd Hip
p
Make sure the ope
n
_db() routine in t
h
e CLI does not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Add 14 ne
w
i
nterfac
e
s
t
o
th
e
loadable
e
xt
e
nsion mechanism
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Fix m
i
nor probl
e
ms with the
s
qlite3_str inte
r
fac
e
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richa
r
d Hipp
Make th
e
internal
d
y
namic str
i
ng interfa
c
e available
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
i
ch
a
rd Hipp
Fix a t
y
po i
n
a commen
t
used
f
or documentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richar
d
Hip
p
Correctly format the
S
T
A
T1 and STAT4 con
t
ent
in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Fix a
h
armless com
p
i
ler warning in fuzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ri
c
hard
H
ipp
F
u
zz test c
a
ses fo
r
UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
hard Hipp
Acti
v
ate
t
he cell-o
v
erwri
t
e optimizati
o
n for ind
e
x
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Rich
a
rd Hipp
Impr
o
ved comments on t
h
e cell
-
overw
r
i
t
e optimiz
a
ti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richa
r
d Hipp
On an UP
D
ATE, try to
overwri
t
e an
e
xisting btree cel
l
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richar
d
Hipp
Fix harmle
s
s compi
l
e
r
w
arnings associated wit
h
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harmless compiler warnin
g
s
in
t
he cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
Hi
p
p
Backo
u
t change
[05fee1a21ea398f1e4d6f1cf3] beca
u
se
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
R
i
c
hard Hip
p
In an ORD
E
R BY
LIM
I
T, make sure the OR
D
ER
BY expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richar
d
Hipp
Fix a slig
h
tly incorrect corruption
d
et
e
ction
b
ranch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard
H
i
p
p
Merge
e
n
h
a
ncements from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix
r
equ
i
rements marks
.
No co
d
e change
s
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichard Hipp
F
o
r
t
he a
m
a
l
gamation-tarball, ena
b
l
e
FTS5
a
nd JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hip
p
Make a
separate limb
in the EXPLAIN QUERY PLAN
o
utput
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
cha
r
d Hi
p
p
I
n
OR
D
ER
B
Y LIMIT
q
ueries, tr
y
t
o
evaluate th
e
ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
F
ix a branch that has become unrea
c
h
a
ble
d
ue to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Improved security
f
or VACUUM
.
This check-in combi
n
es
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Over
h
a
ul of EXPLAIN QUERY PLAN
.
The output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Optimizations to
t
he new EQ
P
framewor
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd
Hipp
Fix v
a
rious error
h
andling co
n
d
i
tions
o
n t
h
e cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The BtCursor
.
info fi
e
l
d
s are
only valid if info
.
nSize
!
=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Add
m
ore corru
p
tion checkin
g
to the
c
ell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard H
i
pp
Bug
fixes
i
n the
overwri
t
e
o
p
timiza
t
ion
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The sqlite3Btr
e
eInsert() routine tries to over
w
rit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
h
a
rd Hipp
Enhance
E
XPLAIN QUERY PLAN to
r
epo
r
t
t
h
e generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
More te
s
t
case updates
.
Te
s
ts a
r
e
all run
n
ing
n
ow
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Fix test ca
s
es s
o
t
hat they work w
i
th the ne
w
EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d Hipp
Im
p
r
o
ve
d
E
Q
P out
p
u
t for re
c
u
r
si
v
e CTEs and multi-
v
alue
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
Pre
v
ent
V
ACU
U
M from run
n
ing any
c
ommands in sqlite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
F
ix a d
a
ngling-else
pr
o
b
l
em that was
causi
n
g recu
r
si
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Imp
r
ove
m
ents t
o
the
EQP display for
comp
o
und select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin reengineering
t
he EXPLAIN QUERY PLAN f
u
nc
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ri
c
hard
Hipp
The SQLITE_AL
L
O
W_SQL
I
TE
_
MASTER_INDEX compile-time opt
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Rich
a
rd Hipp
D
e
f
er loading r
e
sult col
u
mn value
s
into registe
r
s on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
T
est cases a
d
ded for SQLITE_DBCONFIG_RE
S
E
T_
D
ATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
A
d
d the SQ
L
ITE_DBCONFIG_RESET_DATAB
A
SE contro
l
f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
r
d Hipp
Add the SQL
I
TE_DBCONFI
G
_
RESET_DATABASE con
t
rol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ich
a
rd Hipp
Me
r
ge updates
from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Pr
e
vent deep recursi
o
n
s on nested C
O
L
L
ATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Fi
x
compiler w
a
r
n
ings in
F
T
S
3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd
H
ipp
A
d
d the
"PRAGMA reset_
d
atab
a
se=ON|OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhance
the comments in
t
he temp
l
a
t
evtab
.
c
implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
ha
r
d Hipp
The p
r
evious fi
x
for tick
e
t [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard
Hipp
E
n
sure that
n
e
w
.
*
values of an UPDATE do no
t
get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarif
i
cation of the behavior of a
BEFORE
UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Im
p
rov
e
d VD
B
E comm
e
nt on the O
P
_Param opcode
.
No s
u
bstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add new int
e
rfaces for accessing
the list of
S
QL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
A
d
d the ne
w
DO and NOTHING keywords to th
e
keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Add
t
h
e
new SQLITE_SHELL_I
N
IT_PROC
co
m
p
i
le
-
t
i
m
e entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd H
i
p
p
A
v
oid many unnecessary calls to s
q
lite
3
ReadSchem
a
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Ad
d
an ass
e
rt
(
) to ensure that schema mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard
H
ipp
D
o
not att
e
mpt to use ter
m
s from t
h
e WHE
R
E clause
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
Update the exper
t
extensio
n
test
case
s
to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
All th
e
O
R optim
i
z
a
tion to proceed even i
f
t
h
e OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
Add a hyperl
i
n
k
t
o
the
tic
k
et on the code
c
o
mment
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
cha
r
d Hipp
Enhance
t
h
e
CLI t
o
render E
X
PLAIN QUERY
PLAN us
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
ha
r
d Hipp
Fix
a
memo
r
y lea
k
following failur
e
t
o
open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
In
E
XPLAI
N
QUERY PLAN ou
t
put, do not show an EXEC
U
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix to check-
i
n [ca34c2dd20ee071e] -
a
void
a
NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard
Hipp
Fix a pro
b
lem
i
n sqlite3ExprCompare() asso
c
i
ated
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Fi
x
a formatting issue in
the TreeView o
u
t
p
ut for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Add the "
.
imposter
off" vari
a
nt
of the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
T
h
e
"
.
selecttr
a
c
e 0x2000" comm
a
nd causes j
u
st the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d H
i
p
p
Th
e
"
.
sel
e
cttr
a
ce 4" comman
d
now sh
o
ws only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not restore the iS
e
lectId
v
alue until aft
e
r th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
In the "
.
s
electtra
c
e"
o
utput, i
n
clude the EX
P
LAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Ensure
t
hat th
e
re are no bind-paramet
e
rs or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unrea
c
hable branch a
s
sociated with
s
tack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard H
i
pp
Performance i
m
provements on the main loo
p
of the
L
EMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ic
h
ar
d
Hipp
Enhance
L
E
M
O
N to track w
h
ich symbols actua
l
ly carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %e
x
tra_cont
e
xt direct
i
ve to lemon,
as an alter
n
ative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Fix UPSERT
s
o that it pla
y
s
n
i
cely with AU
T
OINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
Hipp
Add th
e
-dDIR
E
C
T
ORY command-line opti
o
n to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Fi
x
a
harmless comp
i
le
r
warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
H
ipp
Avo
i
d the use of statement jour
n
als on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Av
o
id opening a
s
tatem
e
n
t journal
o
n
single
-
ro
w
U
P
DATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
Hipp
F
i
x
a VD
B
E comment
o
n upser
t
.
Provide
a
n e
r
ror me
s
s
a
ge
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d Hipp
A
void unnecess
a
ry cursor seeki
n
g
w
hen pe
r
for
m
ing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
Hi
p
p
I
m
pr
o
ved VDBE commen
t
on
U
PSERT cod
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
M
i
nor simplification of the previ
o
us checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avo
i
d
unnecessary
c
u
r
sor
seeks duri
n
g u
p
ser
t
processi
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhan
c
e U
P
SERT so t
h
a
t the U
P
DATE uses the
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
M
inor simplification of the
cursor alloc
a
ti
o
n logic
.
.
.
commit
|
commitdiff
|
tree
next