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 harmless compiler warnings in the cell-overwrite logic.
2018-05-07
D
.
Ric
h
ard Hipp
F
i
x
h
a
rm
l
e
ss comp
i
l
e
r warnings in t
h
e cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge
e
nhancements from
t
runk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix req
u
irements marks
.
No code
cha
n
ges
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ri
c
hard Hipp
For t
h
e amalgamatio
n
-tar
b
all, enable FT
S
5 and JSO
N
1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
ch
a
rd
H
ipp
Make a separate
l
i
m
b i
n
the E
X
PLAIN QUER
Y
PLA
N
output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard
H
ipp
In
O
RDER
BY LIMIT q
u
eries,
t
ry t
o
evaluate the OR
D
ER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
Fix a bran
c
h that has become unreach
a
ble due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
I
m
proved secur
i
t
y for
VACUUM
.
T
his check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard
H
ipp
Ove
r
h
aul
o
f EX
P
LAIN Q
U
ERY PLAN
.
The output
i
s no
w
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Opti
m
izations
to the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
Fix various
e
r
r
o
r
handling
conditions on the ce
l
l overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hi
p
p
The
BtCursor
.
inf
o
fields are only valid if info
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Add
m
ore corruption
c
heck
i
ng
t
o the
c
ell overw
r
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Bug fixes i
n
the o
v
erwrite optimi
z
a
ti
o
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
T
he sqlite3B
t
reeInse
r
t() routine t
r
ies to overwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
char
d
Hi
p
p
E
nha
n
ce
E
X
P
LAIN QUE
R
Y PLAN to report the ge
n
era
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
More test case updates
.
Tests are all ru
n
ning
now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix test cases so that they work wi
t
h
th
e
new
EX
P
L
AIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Im
p
roved
E
QP o
u
tput for
re
c
ursive CTEs and
multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
H
ipp
Pre
v
ent VACUUM from running any commands in s
q
lite_m
a
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
Hipp
Fix
a
dangling-else probl
e
m
t
h
at w
a
s causing recursiv
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hipp
I
m
pr
o
v
e
ments to the EQP di
s
play
for compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin reengi
n
eering the EX
P
LAIN QUERY P
L
AN f
u
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
icha
r
d Hipp
T
h
e SQLITE
_
ALLOW
_
S
Q
L
I
T
E
_MASTE
R
_INDEX co
m
pile-t
i
me opti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
Defer loading resu
l
t column value
s
int
o
registe
r
s on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
H
i
pp
Te
s
t cases a
d
ded for SQLITE_DBCONFIG_RES
E
T_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
Hipp
Add the
S
Q
L
I
T
E
_DBCONFIG_RESET_DAT
A
B
ASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Add the SQLITE_D
B
CONFI
G
_RESET_DATABASE
c
ontrol a
s
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
M
e
rge
u
pd
a
tes from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
ha
r
d Hipp
P
r
eve
n
t deep recur
s
ions o
n
ne
s
te
d
COLLATE
oper
a
tors
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
r
d
H
i
pp
Fix compiler warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Add
t
he
"PRAGM
A
reset_dat
a
base=
O
N|OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhance the comments
i
n t
h
e templ
a
tevtab
.
c implementa
t
i
o
n
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
c
hard Hipp
Th
e
pre
v
i
o
us fix for tic
k
et [d85fffd
6
ffe8
5
6
09
2
ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richar
d
Hipp
Ensure that new
.
* values of an UPDATE
do
not get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
Clar
i
f
ication
o
f t
h
e be
h
a
vior
of a BEFORE UPDATE t
r
igger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
Im
p
roved VDB
E
comment on the OP
_
Param o
p
code
.
No
s
u
bstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard Hipp
Add new i
n
terfaces
f
or accessi
n
g t
h
e
l
i
s
t of SQ
L
keywor
d
s:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
Add
th
e
new
DO and NOTHING keywords
t
o
the
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hi
p
p
Add the new SQLITE_SHELL_INIT_PROC co
m
pile
-
time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid many unnecessary calls
t
o sqlite3ReadSche
m
a(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard Hipp
Add an assert()
t
o ensure that sc
h
e
m
a mutex
e
s are h
e
ld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Do not attempt t
o
use terms
f
rom th
e
WHERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard
Hipp
Update the e
x
pert e
x
t
e
ns
i
on test cases to account f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
All t
h
e OR optimization to proceed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hy
p
erli
n
k to the
t
icke
t
on the cod
e
comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard H
i
pp
Enhance
the CLI to render EXPLAIN QUERY PLAN usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a
mem
o
ry leak foll
o
wing failure to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
H
ipp
In
E
XPLAI
N
QUERY
P
LAN output, do not sh
o
w an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hi
p
p
Fix
t
o che
c
k-in [c
a
34c2dd20ee071e] - avoi
d
a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
cha
r
d Hipp
F
ix a
p
robl
e
m in s
q
lite3E
x
prCompar
e
()
a
s
sociated
w
i
th
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Fix
a
formatting issu
e
in th
e
TreeView output f
o
r ba
r
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
hard Hipp
A
d
d the "
.
imposter off" variant of the "
.
impost
e
r"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The
"
.
selecttrace 0x2000" command causes just
the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
r
d Hipp
The
"
.
selecttr
a
ce 4" comman
d
now shows only a si
n
gle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hi
p
p
Do
n
ot restor
e
the iSelect
I
d val
u
e until after th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In th
e
"
.
selecttrace" out
p
ut
,
i
n
c
l
ude the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure that t
h
ere a
r
e no bind-parameters
o
r incorrec
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix
an unre
a
chable bran
c
h associat
e
d with st
a
ck ove
r
flow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
i
pp
Perfor
m
ance improvement
s
o
n
the mai
n
loop
of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
i
p
p
Enhance LEMON to track whi
c
h symb
o
ls actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Add th
e
%extra_context directive
t
o lemon, as an alterna
t
i
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
c
h
ar
d
Hipp
Fix UPSERT so t
h
at i
t
plays nicely wit
h
AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
dd th
e
-dDIRECTORY command-line
option t
o
LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a h
a
rm
l
ess compile
r
wa
r
ning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
p
p
Avoid
t
h
e
use of statement journ
a
ls on DE
L
ETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Avoid op
e
ning a
s
tat
e
m
e
nt journal on
si
n
gle-row UPDATE
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Fi
x
a VDBE comment on upsert
.
Provide
an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unnecessar
y
c
urso
r
seeking when performin
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
Improved VDBE comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor s
i
mplification of the p
r
evious checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
ipp
Avoid unnecessary c
u
r
sor seeks during
u
p
sert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d Hipp
Enh
a
n
c
e
UPSERT so t
h
at the UPDATE uses
t
h
e same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
har
d
H
ipp
Mino
r
sim
p
lif
i
c
atio
n
o
f the cursor allo
c
ation logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the h
a
n
d
ling of "PRAGMA count_ch
a
nges
=
ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Minor simplification
to the
upse
r
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Add the --ups
e
rt option to
t
he wordc
o
u
nt test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
A
d
d the ext/m
i
s
c/templatevtab
.
c
t
emplate for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Fix a prob
l
em i
n
the new upsert implemention, discove
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the
t
ab
l
e n
a
m
e
aliasing
on INSERT so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Avoid a
N
ULL
-
pointer
d
eref follow
i
n
g OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Fi
x
a test case inside dis
t
inct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
char
d
Hi
p
p
Improved
matching of
COLLATE clauses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a proble
m
i
n the sq
l
ite3ExprCompare() f
u
n
c
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Add su
p
port f
o
r PostgreSQL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
pp
Fix the
b
uild for SQLITE_OMIT_UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
a
r
d Hip
p
Add the
-
-sorterr
e
f N optio
n
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Omit some code
n
ot
u
s
ed w
i
th
o
u
t
S
QL
I
TE_ENA
B
LE_
S
O
RTER_
R
EFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
har
d
Hi
p
p
Re
m
ove an unused local
variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
ha
r
d Hipp
Enhance ALTER TAB
L
E ADD C
O
L
UMN to support "
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Add chec
k
s to the CLI that i
s
sue a warnin
g
if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
h
ard Hipp
Ad
d
new testcase() macros and fix a
bug th
a
t was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
Remove unrea
c
h
a
ble b
r
a
n
ches
.
100% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
A
d
d
e
d a commen
t
on the assert() a
d
ded t
o
the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
har
d
Hipp
F
ixe
s
to the
logic for c
o
nstraint check reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
During PRAGMA vdbe_addoptrac
e
=O
N
, show ca
l
ls to sq
l
i
t
e
3
Vdbe
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard
H
ipp
TK_REGISTER expr
e
ssion
s
nodes a
r
e proba
b
ly not co
n
stant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hi
p
p
Simpl
i
f
i
catio
n
to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hipp
N
e
w test case
s
for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Mer
g
e
the Lemon enhancement from
t
r
unk, resulting in
.
.
.
commit
|
commitdiff
|
tree
next