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 minor problems with the sqlite3_str interface.
2018-05-09
D
.
Richard Hipp
Fix
m
inor pro
b
l
e
ms w
i
th the s
q
lite3_str inter
f
a
c
e
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
ichard
H
ipp
Make
the internal
d
y
n
amic str
i
ng
interface available
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
ic
h
ard Hipp
Fi
x
a
ty
p
o in a
c
om
m
ent used for documentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
i
char
d
H
ipp
C
orrectly format the STA
T
1 and
S
TAT4 cont
e
nt in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richar
d
Hipp
Fix a harmless compiler warning i
n
fuzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ri
c
hard H
i
pp
F
uzz t
e
st cas
e
s for UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Activa
t
e t
h
e c
e
l
l
-ov
e
rwrite optim
i
z
at
i
on fo
r
index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Improved comments on the cel
l
-ove
r
w
r
ite optimizati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
h
ard Hi
p
p
O
n
an UPDATE, try t
o
overwri
t
e
an exist
i
n
g
btree c
e
ll
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
c
h
a
rd Hipp
Fix harmles
s
compiler w
a
r
n
i
n
gs ass
o
ciate
d
with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
hard H
i
pp
Fix harmless compiler warnings in the cell
-
o
v
erw
r
ite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
chard Hi
p
p
Backout c
h
ange [0
5
fee1a21
e
a398f1e4d
6
f1cf3]
because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Ric
h
ard Hipp
I
n
an OR
D
E
R BY LIMIT, make sure the ORDER B
Y
expre
s
sion
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slightly incorrect corrup
t
ion detec
t
io
n
branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
c
hard H
i
pp
Merge
enhancements f
r
om tr
u
nk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix
r
equirements marks
.
No c
o
de changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d
Hi
p
p
For the a
m
algam
a
tion
-
tarball,
e
nab
l
e FTS5 and
J
S
O
N1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard
H
ipp
Make a sep
a
rate limb
i
n the EXPLAIN QUERY
P
LAN out
p
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
I
n
ORDE
R
B
Y
L
IMIT queries, try to evalu
a
te th
e
ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix a b
r
anch that has become unreachable
due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Improved security for VACUU
M
.
T
his check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Ov
e
rhaul of EX
P
LAIN QUERY PLAN
.
The output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard
H
ipp
Optimiz
a
tion
s
to
the ne
w
EQP fr
a
mework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix vario
u
s e
r
ror handl
i
ng conditions on the c
e
ll overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
The BtCurso
r
.
i
nfo
fi
e
lds are only valid if
i
n
fo
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ar
d
Hipp
Add more
cor
r
uption checking to the cell overwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
har
d
H
i
pp
B
ug fixes in
the overwrite op
t
imization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The
s
q
lit
e
3BtreeI
n
sert() routine
trie
s
to
o
v
e
rwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Enhance
EXPL
A
IN
Q
UERY PLAN t
o
re
p
ort
the generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d Hipp
More test case updates
.
T
es
t
s are al
l
runn
i
ng now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix te
s
t cases so
that they work
w
ith the new EXPLAI
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d
H
ipp
Im
p
roved EQP
o
utput for recu
r
sive CTEs and
multi-valu
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hi
p
p
Prevent VAC
U
UM from ru
n
n
i
ng any commands in
s
qlite_mas
t
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Fix a dangling-else
problem that was causing recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd H
i
pp
Improve
m
e
n
t
s
t
o the EQP dis
p
la
y
for co
m
p
ound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd
H
ipp
Begin
r
eengineering the EXPLAI
N
QUER
Y
PLAN
f
unctio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ri
c
h
a
rd H
i
pp
The SQLIT
E
_ALLO
W
_SQLI
T
E_MASTER
_
INDEX compile-time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
D
e
f
e
r
loadin
g
re
s
ult
c
o
l
umn val
u
es into registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hi
p
p
Test
cas
e
s added for SQLITE_D
B
CONFIG_RE
S
E
T
_
D
ATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add the SQLITE_DBCONFIG
_
RE
S
ET_
D
AT
A
BASE c
o
ntrol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Add t
h
e SQ
L
ITE_DB
C
ONFIG_RES
E
T_DATA
B
ASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard
H
i
pp
Me
r
ge updat
e
s
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Pr
e
vent
de
e
p recursions on ne
s
te
d
COLLATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Fix compiler warnings in
FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
h
a
r
d
Hipp
Add
the
"
PRAG
M
A reset_da
t
abas
e
=ON|OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richar
d
Hipp
Enha
n
ce
t
he
c
o
mme
n
t
s in the tem
p
l
atevtab
.
c implementat
i
on
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
H
i
pp
T
h
e previ
o
u
s fix f
o
r
ticket [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure
t
hat
n
ew
.
*
v
alues of
a
n
UPDATE do n
o
t
get
cl
o
bbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd H
i
pp
Cl
a
rification of the behavior
o
f a BEFORE UPDATE
t
r
igger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hipp
Improved VDBE commen
t
on the
OP_P
a
ram opcode
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Add new interface
s
for accessing th
e
list o
f
SQL
k
eywo
r
ds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the
n
ew DO a
n
d NOT
H
ING keywords
to the
key
w
ord
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
h
ard Hipp
Add the new SQL
I
TE_SHELL_INIT_
P
ROC co
m
pi
l
e
-tim
e
entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid many unne
c
essary calls
to
sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Add an assert()
t
o ensu
r
e that sc
h
e
m
a
m
utexes
are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hi
p
p
Do n
o
t at
t
empt
t
o use terms from the
W
HERE cla
u
se to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the exp
e
rt ext
e
nsio
n
test ca
s
es t
o
a
c
c
ount for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hip
p
Al
l
t
h
e OR optimization
t
o proceed
even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyp
e
rlink
to the ti
c
ket on the code c
o
m
ment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
E
nhan
c
e t
h
e CLI to r
e
nder EX
P
LAIN QUERY PLAN
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
Fix a memory leak following failure to op
e
n
an
e
xt
e
rnal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
In EXPLAIN QUERY PLA
N
ou
t
put, do n
o
t
sh
o
w a
n
EXECU
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ic
h
ard Hipp
Fix t
o
check-in [ca3
4
c2dd
2
0ee071e] - avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
ch
a
rd Hipp
F
ix a problem in sql
i
te3
E
xpr
C
ompare() as
s
o
ciated
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
r
d Hipp
Fix a f
o
rmattin
g
issue in th
e
TreeV
i
e
w
output
f
o
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
Add the
"
.
imposter off" va
r
iant of
t
he "
.
im
p
os
t
er"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard H
i
pp
T
h
e "
.
selecttrace 0x2000"
command causes just t
h
e
t
op
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard
H
ip
p
The "
.
sel
e
cttrace 4" command now sh
o
ws onl
y
a
s
i
n
g
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not restore the iSelectId val
u
e until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In t
h
e "
.
selec
t
trace" output, include the
E
X
PLAIN QU
E
RY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
E
n
s
u
re that there a
r
e no
bind-parame
t
ers
o
r
incorr
e
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unrea
c
h
a
ble branch ass
o
ciated with stac
k
over
f
low
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
P
e
rformance improvements on the m
a
in lo
o
p of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
En
h
ance LEMO
N
t
o track whic
h
symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Ad
d
t
he %extra_context
direct
i
ve t
o
lemon,
a
s an alternativ
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
r
d Hip
p
Fix UPSERT
s
o that it p
l
a
ys nicely w
i
t
h AUTOI
N
CREM
E
NT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add th
e
-
dDIREC
T
ORY command-l
i
ne op
t
io
n
to
LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless
co
m
piler
w
a
rning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
Hipp
Avoid
the use of st
a
tement journals on
D
E
LETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
A
v
o
id open
i
ng a
s
tatement j
o
u
rnal on s
i
ngle-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDBE comment on up
s
e
r
t
.
Provide
an erro
r
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
ard Hipp
Avoid u
n
necessary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Improved VDBE comment on
UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Minor simp
l
ification of th
e
previous c
h
eckin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Avoid unnecessary curso
r
seeks during u
p
se
r
t processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
H
ip
p
Enhan
c
e UP
S
ERT so that the UPDATE use
s
the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
M
i
n
or sim
p
l
i
fi
c
ation of the cursor allocation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
har
d
Hipp
Fix the handling of "
P
RA
G
MA
c
o
unt_chan
g
es=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hi
p
p
Minor
simpl
i
fication to the up
s
e
rt
lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add
the
-
-upsert o
p
ti
o
n
to
the wordcount tes
t
p
r
ogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Add the
ext/
m
i
s
c
/templatevtab
.
c template for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Fix a problem in
t
he new
upsert implemention, d
i
scovere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the table
name alias
i
ng o
n
INSERT so that it occ
u
rs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a NULL
-
p
o
in
t
er
d
er
e
f f
o
llowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Fix a tes
t
case inside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Improved matchi
n
g of COLLATE
cla
u
s
e
s
w
i
thin the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard
H
ipp
F
ix a problem in the sqlite3ExprCompa
r
e() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hip
p
Ad
d
sup
p
ort for Post
g
reSQL UPSERT syn
t
ax and
fun
c
tio
n
a
lity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d Hipp
Fix the
b
u
il
d
fo
r
SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Add the
-
-s
o
rterref N op
t
io
n
to th
e
CLI
.
commit
|
commitdiff
|
tree
next