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
Improved error and help messages for the ".archive" command and "-A" option
2018-05-17
D
.
Richard Hipp
Imp
r
oved error a
n
d help messages f
o
r the "
.
archive
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
.
Ric
h
ard Hipp
F
ix memory errors a
s
sociated with argv in the CLI when
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
Enh
a
nce the sqlite3_str_ne
w
(
)
interface so that it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richar
d
Hipp
Corre
c
t output for
the ful
l
key column of json_
e
ach
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Make
more aggressive use o
f
autom
a
tic ind
e
xes w
h
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
C
onvert the sche
m
a cr
e
a
tion logi
c
in the rt
r
e
e
extensio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Rich
a
rd Hipp
Ex
p
ort the
d
educeDatabaseTyp
e
() functi
o
n
t
he
s
hell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
i
c
h
ard Hipp
Add
t
he --appe
n
d option to
t
he "
.
bac
k
up" comman
d
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Ri
c
hard Hi
p
p
In the CLI, all
o
w comment
l
ines that
b
egin w
i
th '#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard Hipp
In the CLI,
r
eturn non-zero
if there are e
r
r
ors on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
chard
H
ipp
Fix a
t
ypo
i
n
the help message from t
h
e
"
.
sha3sum"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richa
r
d Hipp
M
a
ke sure the ope
n
_db() routine in
t
he CLI does not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
i
char
d
Hipp
Add
14 new interface
s
to the loadable ex
t
ension mechanism
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
hard
Hi
p
p
Fix minor pr
o
b
l
ems with the sqlite3_str interfac
e
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Make th
e
i
n
ternal dy
n
amic string
interface
a
vail
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
ha
r
d
H
ipp
Fix a typo in a
com
m
ent
u
s
e
d for documentation
.
N
o
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richa
r
d Hipp
C
orrectly form
a
t the STAT1 and STAT4 content i
n
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richar
d
Hipp
Fix a harmless compiler
w
arning in fu
z
z
c
heck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ric
h
ard Hipp
Fuzz test cases f
o
r UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
chard Hipp
Activate th
e
cell-overwrite op
t
imizat
i
on for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Rich
a
rd Hipp
Im
p
r
o
ved comme
n
ts on the cell-overwrite optimization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
char
d
Hip
p
O
n an U
P
D
ATE, try to ov
e
rwrite a
n
existing btree cel
l
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichard Hipp
Fi
x
h
a
rmless compiler warn
i
ngs
a
s
socia
t
ed
with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hi
p
p
F
i
x
h
armless co
m
piler warnings
i
n the ce
l
l-ove
r
wr
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Rich
a
rd Hipp
Backout c
h
a
n
ge [05fee1a21ea398f1e
4
d6
f
1c
f
3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard
H
ipp
I
n a
n
ORDER BY
LIMIT, make sure the ORDE
R
BY expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
F
i
x
a sli
g
htl
y
incorrect corruption detection bra
n
ch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
cha
r
d
H
i
p
p
Merge en
h
ancements from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix requirements
m
arks
.
No code changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard H
i
pp
F
o
r
the amalga
m
ation-
t
arball, enable
F
T
S
5 and J
S
ON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
char
d
Hipp
Make a s
e
parate limb in
t
he
E
X
P
LAIN QUERY PLAN outp
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
In ORDER BY LIMIT quer
i
es,
try
to ev
a
l
u
at
e
the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix a
branch that has become un
r
each
a
ble
d
u
e
t
o
recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
c
hard Hipp
Im
p
roved security for VACUUM
.
This check-in combin
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Overhaul of EXP
L
A
I
N QUERY PLAN
.
The outp
u
t
is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
O
p
timizations to the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
Fix various error hand
l
in
g
co
n
ditions on the cell o
v
erwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
The BtCursor
.
info fields are only valid if info
.
nSi
z
e!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichar
d
Hip
p
Add more corruption check
i
n
g to t
h
e cell ove
r
write
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Bug fixes
i
n the over
w
rit
e
optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
T
h
e
s
qlit
e
3
BtreeInsert() routine tries to o
v
erwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enhan
c
e
E
XP
L
AIN
QU
E
RY
PLAN to
r
epo
r
t the gener
a
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd
H
ipp
M
or
e
test case updat
e
s
.
T
ests
are all
running n
o
w
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix t
e
st cases so that
they work wi
t
h the new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
h
ard Hipp
Imp
r
ove
d
EQP ou
t
put for
r
e
cursive CT
E
s and mult
i
-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd Hipp
P
r
e
ven
t
VAC
U
UM from
r
unning any command
s
in sqlite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
H
ipp
Fix
a
dangling-else prob
l
em t
h
at was
c
a
u
s
ing
recur
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard Hip
p
Im
p
r
o
v
e
me
n
ts to t
h
e
E
Q
P
display f
o
r compo
u
nd se
l
ect
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
Be
g
i
n
r
e
e
ngineerin
g
the EXPLAIN QUERY
P
LAN fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ri
c
ha
r
d
Hipp
The SQLITE_ALLOW
_
SQLITE_MASTER_IN
D
EX
co
m
pile-tim
e
opt
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
D
e
fer lo
a
ding result
c
olumn values i
n
to reg
i
sters on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Test c
a
s
es
a
d
ded
f
o
r
SQLITE
_
D
B
C
ONFIG_RE
S
ET_DATAB
A
SE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Add the SQLITE_DBC
O
NFIG_RESET_DATABASE control
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hip
p
Add the SQLITE_DBCONFIG_RESE
T
_DATABASE control
as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
M
e
rge updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
Prev
e
nt
d
eep rec
u
rs
i
o
ns
o
n
n
e
sted COLLATE opera
t
o
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
F
i
x
compil
e
r warni
n
gs in
FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
A
dd the
"
PRAGMA
r
eset_database=ON|OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ri
c
h
a
rd Hip
p
Enhanc
e
the com
m
ents in the template
v
tab
.
c imp
l
ementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
The previ
o
us
fix for
t
icket [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard
H
i
p
p
Ensure that new
.
* val
u
e
s of an UPDATE do no
t
get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Clarif
i
cation of the behavior
of a BEFORE UPDATE
t
rigge
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Impro
v
e
d
VDBE comment on the OP
_
Param opcode
.
No su
b
stantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
A
dd new
interfaces for acce
s
sin
g
t
h
e
list
o
f S
Q
L
keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hi
p
p
Add the new DO and NOTHING keywords to the k
e
yword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Ad
d
the new SQLITE_SHELL_INIT_PROC compile-time ent
r
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid ma
n
y unne
c
essary
c
alls to sqlit
e
3ReadSche
m
a(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
A
d
d
an assert() to en
s
ure that schema mutex
e
s are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not a
t
tempt to use terms from the
W
H
E
R
E
clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard Hipp
Update
the expert e
x
t
ension test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
All the O
R
optim
i
zation to
p
roceed e
v
en
i
f the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
har
d
Hipp
Ad
d
a
h
y
p
erlink
to the ticket
on the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance the CLI to
r
ender
EX
P
LAIN Q
U
ERY P
L
AN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
Fix a memory l
e
ak following failure to
o
p
en
a
n
ext
e
rna
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
In EX
P
LAIN
QUE
R
Y PLAN outp
u
t, do not
s
ho
w
an EX
E
C
U
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
F
i
x
to check-i
n
[ca34c2dd20ee071
e
]
- avoid a NULL p
o
inter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hi
p
p
Fix a problem in sq
l
it
e
3ExprCompare()
associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard H
i
pp
Fix a fo
r
matting issue in the TreeVi
e
w output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ad
d
the "
.
imposter off" varia
n
t of
t
he "
.
impo
s
ter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selecttrace 0x2000
"
command causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
char
d
Hipp
The "
.
selecttrace 4" command now
sho
w
s only
a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
D
o
not
r
e
store the iSelectId value unt
i
l after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
sele
c
ttrac
e
" output, in
c
lude the EXPL
A
IN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Ensu
r
e that t
h
ere are no bin
d
-parameters or i
n
correct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ar
d
Hipp
Fix an unre
a
chable branch associated with
stack o
v
erflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
H
ipp
Per
f
ormance impro
v
em
e
nts on
t
h
e ma
i
n loop
of
t
he LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard H
i
pp
Enhance LEM
O
N to track which symbols actually c
a
rr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %e
x
tra_cont
e
x
t
direc
t
i
v
e
t
o
l
emon, a
s
an alt
e
rnative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ard Hipp
F
ix
U
PSERT so that it pla
y
s n
i
cely with AUT
O
INCRE
M
ENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
char
d
Hipp
Add the -d
D
I
RECTOR
Y
comman
d
-line
o
ptio
n
to LEMO
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fi
x
a harmless com
p
i
l
er
war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid th
e
use of sta
t
ement jo
u
rn
a
ls on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Avoid opening
a
statement jour
n
al on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDBE comment on u
p
sert
.
P
r
o
v
ide a
n
error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid u
n
nec
e
ssary cursor see
k
i
ng
when performing a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
Im
p
rove
d
VDBE comment
o
n
U
PSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d Hipp
Minor simplific
a
tion of
t
h
e previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd Hi
p
p
A
void unnecessary c
u
rsor seeks d
u
ring upsert p
r
ocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard H
i
p
p
En
h
ance U
P
SERT s
o
t
hat the
U
PDA
T
E uses the
s
ame s
e
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor s
i
mplificatio
n
of
t
he cursor allocati
o
n l
o
gic
.
.
.
commit
|
commitdiff
|
tree
next