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 a typo in a comment used for documentation. No code changes.
2018-05-09
D
.
R
i
c
h
ard Hipp
Fix a typo in a comment used for
d
o
c
u
mentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hip
p
Correctl
y
fo
r
mat the STAT1 and STAT4 content i
n
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard H
i
pp
Fix a harmless com
p
iler war
n
in
g
i
n
f
u
z
z
ch
e
ck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Rich
a
rd Hi
p
p
Fuzz test cases
f
or UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hipp
Activ
a
te the cell-o
v
erwrite
optimization for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ar
d
H
i
p
p
Improved comme
n
ts on the cell-overwrite
optimization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hipp
On an UPDATE,
t
ry to overwrite an existing
btree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
H
i
pp
F
ix harmless
c
om
p
iler warnin
g
s assoc
i
ated with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
Hipp
Fi
x
har
m
l
e
ss compiler warnings in the cell-ove
r
w
r
ite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Backou
t
c
hang
e
[05fee1a21
e
a398f1e4d6
f
1cf
3
]
bec
a
use
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In
an
O
R
DE
R
B
Y
LIMIT, make sure the ORDER BY expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slightly incorre
c
t
corruption dete
c
tion
b
ranch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge enha
n
c
emen
t
s f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard H
i
pp
Fix requirements marks
.
No c
o
de chan
g
es
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
For t
h
e amalgamation-tarball, enable FTS5 an
d
JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Make a sepa
r
ate limb in
t
he EXPLAIN QUERY
P
LAN
o
utput
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
cha
r
d Hipp
In ORDER BY LIMIT
queries
,
t
ry to eval
u
ate th
e
ORDE
R
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
Fix a bra
n
ch
t
hat ha
s
bec
o
me unreacha
b
l
e
d
ue
t
o
recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hi
p
p
Impro
v
e
d
security for VACUUM
.
This check-
i
n c
o
mbines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
Hipp
Ove
r
h
aul of EXPLAIN QUERY PLAN
.
Th
e
out
p
ut is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
Optimizations to t
h
e new
EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Fix vario
u
s error handling conditions on the cell ov
e
r
w
rite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hi
p
p
T
he BtCur
s
o
r
.
info
f
i
elds ar
e
only valid if i
n
fo
.
nSiz
e
!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Add
more corr
u
ption
c
heckin
g
to the c
e
ll o
v
erwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
Bug fix
e
s in the overwri
t
e optimi
z
atio
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The
sq
l
ite3Btre
e
Insert() routine tries to
overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enhance EXPLAIN QUERY
PLAN to report the
g
e
ner
a
t
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
c
hard Hipp
More test c
a
s
e
u
p
da
t
es
.
Tests a
r
e a
l
l running
now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
Hi
p
p
Fix test cases so
t
hat they work with th
e
new E
X
PLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard
Hipp
Im
p
r
o
ved EQP output for
r
ecu
r
sive
C
TEs
a
nd m
u
l
ti-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Pr
e
vent VACUUM from running a
n
y com
m
ands
i
n sqlit
e
_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hip
p
Fix a dangling-else p
r
o
b
lem
t
hat was
ca
u
sing
r
e
c
ursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Improvements to the EQP display
f
or compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Begin reenginee
r
in
g
the
EXPLAI
N
QUERY P
L
AN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
T
h
e SQLITE_ALLOW_SQLITE_
M
ASTER_INDEX compile-
t
ime
o
ption
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richa
r
d
Hipp
De
f
er loading
r
esult column values into regi
s
t
e
r
s on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Tes
t
c
a
ses added for
SQLITE_DBCONFIG_RES
E
T_DATA
B
ASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
icha
r
d
H
ipp
Add the SQL
I
TE_DBCO
N
FIG_RES
E
T_DATABAS
E
contr
o
l for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add
the SQLITE_DBCONFIG_RESET_DATABASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hi
p
p
M
e
r
ge upd
a
tes fr
o
m tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Preven
t
deep recursions o
n
n
e
sted COLLATE op
e
rators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fi
x
compiler warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
icha
r
d Hip
p
A
d
d th
e
"PRAGMA reset_datab
a
se=ON|OFF"
c
ommand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ric
h
a
rd
Hi
p
p
En
h
ance the c
o
mments i
n
the templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
h
a
r
d
H
ipp
The p
r
evious fix for ticket [d85fffd
6
ffe856092
e
d
8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d
Hipp
En
s
u
re that new
.
*
va
l
ues of
a
n
UP
D
ATE
d
o
n
ot
g
et clobbere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard
H
i
p
p
Clar
i
f
i
c
a
tion of the behavior o
f
a
BEFORE
UPD
A
TE
trigg
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
H
i
pp
I
m
p
ro
v
e
d
VDB
E
comment on the OP_Pa
r
am opcode
.
No s
u
bstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
A
d
d
n
ew i
n
terfaces for ac
c
ess
i
ng
t
he list
of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Add the
n
ew D
O
a
n
d
NOT
H
ING k
e
y
w
o
r
ds to
t
he keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard H
i
pp
Add the
new S
Q
L
I
TE_
S
H
ELL_
I
NIT_PROC co
m
p
i
le-t
i
me e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d H
i
p
p
Avoid many unnecessary
calls to sql
i
te3Read
S
chema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an assert() to ensure
that schema mutex
e
s
are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not attempt to use terms from t
h
e WHER
E
c
lause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hip
p
Upd
a
t
e the expert exten
s
ion test cas
e
s to ac
c
ount for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
A
ll the OR optimization to proceed
eve
n
if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyperlink to t
h
e ticke
t
on t
h
e code comm
e
nt for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance the CLI to re
n
der EXPLAIN QUERY PLAN
u
s
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
char
d
H
i
pp
Fix a memory leak following failu
r
e to open an exte
r
nal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In
EXPLAIN
QUERY PLAN ou
t
put, do not show an EXEC
U
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard
H
i
pp
Fix
t
o c
h
eck-in
[
ca
3
4c2dd20ee07
1
e] - avoid a N
U
L
L pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
Fix a probl
e
m i
n
s
q
lite3ExprCompare() assoc
i
ated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd H
i
pp
Fix a formatting is
s
u
e
in the
T
reeView
o
utput for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Add the "
.
imposter o
f
f"
variant of the "
.
i
m
poster
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
rd Hipp
T
he "
.
selecttrace 0x2000" com
m
and causes just
t
he top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selecttrace 4" comma
n
d
now shows
onl
y
a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not re
s
tore the iSele
c
tId v
a
lue unti
l
a
fter the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard
Hip
p
In th
e
"
.
selecttr
a
c
e
" o
u
tpu
t
, include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensu
r
e that
there are no bind-parame
t
er
s
or inc
o
rrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
r
d Hipp
Fix an un
r
eachable
b
ranch ass
o
c
iated with
stack
o
v
er
f
low
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hi
p
p
Perform
a
nce improveme
n
ts
o
n the
m
ain
l
oop of the LEM
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Enhance L
E
MON
t
o track which symbols actually ca
r
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d Hipp
Ad
d
the %extra_context directiv
e
to lemon, as an alt
e
rnative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d Hipp
Fix UPSERT
s
o th
a
t
i
t plays n
i
cel
y
with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Add
th
e
-dDIRECTORY c
o
m
mand-line opt
i
on to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless compi
l
er wa
r
ning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the use of statement jou
r
n
a
ls on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
a
r
d H
i
pp
Avoid opening a statement journal on single-row
U
P
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Fix a VDB
E
comme
n
t on
u
psert
.
Provide an e
r
ror messag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unnecessary cursor seeking wh
e
n
performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
I
m
proved V
D
BE
c
omm
e
nt on U
P
S
ERT cod
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Min
o
r
sim
p
lification of t
h
e previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Avoi
d
u
n
necessary cursor seeks during ups
e
rt process
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UPS
E
R
T
so that the UPDATE
uses th
e
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
icha
r
d Hipp
Minor s
i
m
p
lifi
c
a
tion
of
t
h
e
c
ur
s
o
r
a
llocati
o
n logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
cha
r
d Hipp
Fix the
h
andling o
f
"PRA
G
MA count_ch
a
n
ges=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
M
inor simplification to the up
s
ert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Add the --upsert option to t
h
e wordcoun
t
test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard Hipp
A
d
d th
e
ext/misc/temp
l
atevt
a
b
.
c
t
e
mpla
t
e for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a
p
r
oblem in the ne
w
upsert i
m
plemention
,
discov
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Fix the table name
aliasing on INSERT so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
void
a NULL-
p
oin
t
er
d
ere
f
following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a test
case inside di
s
tinct
.
tes
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
I
mproved m
a
tching of C
O
LLATE clauses wi
t
h
in the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Fix a pr
o
b
l
em in the sqlite3ExprComp
a
re
(
)
f
unction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichar
d
H
ipp
Add support
for Post
g
reS
Q
L UPSERT synt
a
x
a
n
d func
t
ional
i
t
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix the build for SQ
L
ITE_
O
MIT_UP
S
ERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Add
t
he
--sorter
r
ef N option t
o
the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
H
i
pp
O
mit
s
ome code not u
s
e
d without SQLITE_ENABLE_SORTER_RE
F
EREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Remove an unused local var
i
able
.
commit
|
commitdiff
|
tree
next