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
.
Ri
c
har
d
Hipp
I
m
proved er
r
or
and he
l
p
messages for
t
he "
.
arch
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-05-17
D
.
Richard Hipp
Fix memory errors assoc
i
ated w
i
th
argv in the CLI when
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hi
p
p
Enhance the sqlite3_str_new() interface so
that
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Rich
a
rd
Hip
p
Correct
outpu
t
f
or the fullkey column of json_
e
a
c
h
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
i
chard Hipp
Make
more ag
g
res
s
ive
u
se
o
f automatic indexe
s
when
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ric
h
ar
d
Hipp
Convert the schema creation logic in the
rt
r
e
e
extensio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Ex
p
ort the
d
ed
u
ce
D
atabaseType
(
)
func
t
ion t
h
e shell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
ichard Hipp
A
dd
the --a
p
pend option to the "
.
backup" co
m
mand in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Richard Hipp
In
the
C
L
I
, allow comment lines th
a
t begi
n
with
'#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
c
hard Hi
p
p
I
n the C
L
I
, return non-zer
o
if t
h
ere are
erro
r
s
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richar
d
Hipp
F
i
x a typo in
the help mess
a
ge from
the "
.
sha3sum
"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richa
r
d Hipp
Make sure th
e
open_d
b
()
r
outine in the CLI does not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Add 14
new
i
nte
r
f
aces to the loadable extensio
n
mec
h
anis
m
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
F
i
x minor
problems
wi
t
h
t
h
e sqlit
e
3_str interf
a
ce
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richar
d
Hipp
Mak
e
th
e
i
n
t
e
rnal dynamic string inte
r
face ava
i
l
able
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ric
h
a
rd Hipp
Fix
a
typ
o
in a
c
omment used
for docu
m
entati
o
n
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Rich
a
rd Hipp
Correctly forma
t
the STAT1
a
nd STAT
4
c
o
nten
t
in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
i
chard Hipp
F
ix
a harmless compiler warn
i
ng in fuzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hi
p
p
Fuz
z
tes
t
cases for UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichard Hipp
Activate the cell-overwrite opti
m
ization for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Improved co
m
ments on the c
e
ll-ov
e
rwrite optimization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
On an UPDATE, try to overwrite an existing btree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichar
d
Hipp
Fix ha
r
mless
c
ompile
r
wa
r
nings asso
c
i
ated with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hipp
F
i
x harmless compiler warni
n
gs in the ce
l
l-ove
r
write
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
chard
H
ip
p
Backout chang
e
[05fee1a21
e
a398f1e4d
6
f1cf3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In an ORDER BY LIMI
T
, make
s
ure t
h
e ORDE
R
B
Y
e
x
pressi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
F
i
x a s
l
ightly incorrec
t
corrupti
o
n dete
c
t
i
o
n
branc
h
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d
Hipp
Mer
g
e enhanceme
n
t
s from tr
u
nk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard Hipp
Fix requ
i
re
m
ent
s
marks
.
No c
o
d
e changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard
H
ipp
For the am
a
lgamation-tarbal
l
,
e
nabl
e
FTS5 a
n
d JS
O
N1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richar
d
Hipp
Make
a
sepa
r
ate limb in t
h
e EXPL
A
IN QU
E
RY PLAN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
In ORDER
BY
L
IMIT qu
e
r
ies, try to e
v
alu
a
te
t
he ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
F
ix
a
branch that has becom
e
un
r
eachabl
e
du
e
to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Improved secu
r
ity for VACU
U
M
.
This check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
Overhaul of EXPLAIN Q
U
ERY PLAN
.
The output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Optimizatio
n
s to the
new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Fix various
e
r
ror handling conditi
o
ns
o
n the
c
e
ll overwri
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The Bt
C
ursor
.
info fields are only v
a
l
i
d
i
f info
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard H
i
pp
Add m
o
re corruption checking to the c
e
ll overwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
B
u
g fixes
i
n the
o
verwrite o
p
timiza
t
i
o
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
The sqlite3BtreeInsert()
routine
trie
s
to overwri
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enh
a
nce EXPLA
I
N
Q
UERY PLAN to report th
e
gen
e
ration
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ich
a
rd Hipp
More
t
est case updates
.
Tests a
r
e all running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
pp
F
i
x tes
t
cases so that
they work with the new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
c
hard Hipp
Impro
v
ed EQP ou
t
pu
t
for re
c
ursive CTEs and multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
P
r
even
t
VACUUM from
r
unning any c
o
mmands in sqli
t
e
_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix
a dangl
i
ng-else
problem that
was cau
s
ing recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
p
p
Improvement
s
to th
e
EQP
d
isplay
f
or compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
r
d
Hipp
Begin reengi
n
eering
t
he EXPLAIN QUE
R
Y
PLAN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ric
h
a
r
d Hipp
The SQLITE_ALLOW_SQLIT
E
_MASTER_INDEX compile-
t
ime option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard H
i
p
p
De
f
er lo
a
d
ing
resu
l
t col
u
m
n value
s
i
n
t
o
r
egist
e
rs on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
Hipp
Test cases added for
S
QLITE_DBCONFIG_RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard
Hipp
A
dd the
SQLITE_DBCONFIG_RESET_DATAB
A
SE control
f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Add t
h
e SQLITE_DBCONFIG_RESET
_
DATABASE contr
o
l
as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Merge updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
Hipp
Prevent
deep recursions
o
n nested COLLATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hip
p
Fix compi
l
er warn
i
ngs in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard H
i
p
p
Add th
e
"PRAGMA reset_database=ON|OFF
"
command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
i
c
hard Hipp
Enh
a
n
c
e the comm
e
nts
i
n
t
h
e
t
e
mplatevt
a
b
.
c imp
l
ementatio
n
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
The previous fix for tick
e
t [
d
85fffd6ff
e
856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
h
a
r
d Hipp
Ens
u
re that new
.
* values of an UP
D
ATE do not
g
et
c
l
o
b
bered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hip
p
Clarific
a
t
ion
of
the beha
v
io
r
of a BEFORE
U
P
D
ATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
H
ipp
Imp
r
ov
e
d VDBE comme
n
t on the O
P
_Param opcode
.
No s
u
bsta
n
t
ia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add
new interfaces fo
r
accessing the list of SQL keywor
d
s:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add the new D
O
and NOTHING keywords to
the
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the
n
ew SQLIT
E
_SHEL
L
_INIT_PROC compile-ti
m
e entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hipp
Avoid many unnecessary call
s
t
o
sqlite3Rea
d
Schema
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an a
s
s
ert() to e
n
sure that sch
e
m
a
mutexes are
h
eld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
Do not attempt to use term
s
from the WHE
R
E clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Update
the
expe
r
t extension t
e
st case
s
t
o
account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard
Hip
p
All the OR optimization to proce
e
d even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard Hipp
A
d
d a hyperli
n
k to th
e
ticket on the code
comment
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
h
ard H
i
pp
En
h
ance th
e
CLI to re
n
der EXP
L
AIN Q
U
ERY PLAN usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
F
i
x a memory leak fo
l
lowing failur
e
to open
a
n ex
t
erna
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
a
rd Hipp
I
n EXP
L
AIN QUERY PLAN output,
do not sho
w
an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
Fix to chec
k
-in [ca3
4
c2dd20
e
e071e
]
- avoid a NUL
L
p
ointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a p
r
oblem in sqlite3ExprCompare()
associ
a
ted with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
F
i
x a formattin
g
issue in th
e
TreeView ou
t
put for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add t
h
e "
.
i
mposter off
"
va
r
iant of the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard
H
i
p
p
The "
.
selec
t
tr
a
ce 0x
2
000" command ca
u
ses
ju
s
t th
e
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
The "
.
selecttrace 4"
c
o
m
man
d
now
s
h
ows only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard
Hipp
Do not r
e
store the iSelec
t
Id
v
alue un
t
il after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
sel
e
cttrace" output, include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure that th
e
re are no bind-parameters or inco
r
rect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Fix a
n
unreachable
b
ran
c
h
as
s
ociated with stack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hi
p
p
P
e
r
formance impro
v
e
ments on the main loop of
the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
char
d
Hipp
En
h
ance LEM
O
N
to track which
s
ymbols actually
c
arry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichard H
i
pp
A
dd the %extra_context di
r
ective to lemon, a
s
an a
l
ter
n
ative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix
U
P
S
E
RT
so that it
p
lays nic
e
ly
with AUTOINCREM
E
NT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Add the
-
dDIRECTORY command-line option to L
E
MON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless compiler war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Avo
i
d the us
e
of sta
t
e
me
n
t journals on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid opening a statement j
o
urna
l
on
s
ingle-r
o
w
U
PDAT
E
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
Hipp
F
i
x a
V
DBE comment on upsert
.
Provide an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hip
p
Avoid unneces
s
ary curso
r
seeking
w
h
e
n performing a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Im
p
roved VD
B
E commen
t
on UPSER
T
c
o
de
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard H
i
pp
Minor simplific
a
tion of the previous
checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
void
u
nnecessary cursor seek
s
during upsert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
ch
a
rd
H
ipp
Enhance UPSERT so
t
hat the UPDAT
E
u
ses
the s
a
me set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Minor
s
implification
of the cu
r
sor allocat
i
on l
o
gic
.
.
.
commit
|
commitdiff
|
tree
next