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 various error handling conditions on the cell overwrite optimization.
2018-05-03
D
.
Richard Hipp
Fix various error han
d
ling conditions on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The
BtCursor
.
info fields are only
valid if
i
nf
o
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
A
dd m
o
re corruption
c
he
c
king
to the cell
ov
e
rwr
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
Bug fixes
in
t
he ove
r
write optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The sqlite3Bt
r
eeInsert
(
) rou
t
ine tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Prev
e
nt VACUUM
fr
o
m
ru
n
ning any com
m
and
s
in sqlit
e
_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ric
h
a
r
d Hipp
The SQLITE_A
L
LOW_SQLITE_MASTE
R
_INDEX compile-
t
ime
o
p
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Tes
t
case
s
a
dde
d
for SQLI
T
E_D
B
C
ONF
I
G_RE
S
ET_DA
T
A
BASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hipp
Add the SQLITE_DBCONFIG_RESET_DATA
B
A
SE
c
ontrol fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add the SQL
I
TE_
D
B
C
ONFIG_RESET_
D
ATABA
S
E contro
l
as
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hip
p
Merge
updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
Prevent deep recu
r
sion
s
on nested COLLAT
E
operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d
Hipp
Fix
c
omp
i
ler warni
n
gs in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichar
d
Hipp
Add the "
P
RAGMA reset_data
b
as
e
=ON|OFF" c
o
mma
n
d
.
W
hen
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enh
a
nce the comm
e
nts in t
h
e templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hipp
The previ
o
us fix for ticket [d85fffd6f
f
e856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richar
d
Hipp
Ensure th
a
t new
.
*
values of an UPDATE do not ge
t
clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd
Hipp
C
l
ar
i
fication of the
b
ehavior
of a
BE
F
ORE UPD
A
TE trig
g
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
ha
r
d Hipp
I
mproved VDBE comment
on
t
h
e O
P
_Par
a
m opcode
.
No s
u
b
stantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard H
i
pp
A
d
d
new
int
e
rfaces for accessing the l
i
st
of SQ
L
keyw
o
rds
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
r
d
H
ipp
Add the ne
w
DO and
NOTHING keyw
o
rds to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
Add the new SQLITE_SHELL_INIT_
P
ROC compil
e
-time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
a
r
d Hipp
A
v
o
id many un
n
ecessary c
a
lls to sqlite3ReadSc
h
e
ma(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
A
d
d an ass
e
rt(
)
to en
s
ure that schema mutexes ar
e
h
e
ld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard Hipp
Do
n
ot a
t
tempt to us
e
te
r
ms from the WHERE cl
a
us
e
to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ich
a
rd
H
ipp
Update the expert
e
xte
n
s
i
on test cases to
accoun
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the
OR
opti
m
ization to proceed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Add a hyp
e
rlink to the
t
icket on the code comment fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Enhance the CLI
t
o render E
X
PLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Fix a m
e
mory leak follo
w
ing failure to open an
e
xternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hip
p
In EXP
L
AIN QUERY PLAN output, do
no
t
s
how an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
p
p
Fix to check-in [ca34c2d
d
20e
e
071e] - avoid
a N
U
LL po
i
n
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Fix a p
r
oblem
i
n sqlite3ExprCompare
(
) asso
c
iated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
h
a
rd Hipp
Fix a format
t
ing issue
in
t
he
T
reeView o
u
tput for b
a
r
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
A
d
d the "
.
imp
o
ster
o
ff" variant of the "
.
imposte
r
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
The "
.
s
electtrace 0x
2
000"
command c
a
uses just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
cha
r
d
Hipp
T
he "
.
select
t
race
4" com
m
an
d
no
w
shows onl
y
a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
h
ard Hipp
Do not restore the iSele
c
tId value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
In the "
.
selecttrace" output, i
n
cl
u
d
e
th
e
EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Ensure that there ar
e
no bind-parameters or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd H
i
p
p
Fix an unreachable branch associated with s
t
ack
o
verflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichar
d
Hipp
Pe
r
formance improvements on the main loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard
Hipp
Enhan
c
e LE
M
ON to track w
h
ich symbols actual
l
y carr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
Add th
e
%
extra
_
context di
r
ec
t
ive t
o
lemon
,
as an alternat
i
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hip
p
Fix UPSERT
so
t
hat
i
t
plays n
i
cely with
A
U
TOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
a
r
d Hipp
Add the -dDIRECTORY co
m
ma
n
d-line o
p
tion to
LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless compiler
warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the
use of st
a
temen
t
journals
on DELET
E
s of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Avo
i
d openin
g
a stateme
n
t jo
u
r
nal on sing
l
e
-
row
U
P
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Fix a VDBE comment on
ups
e
r
t
.
P
r
o
v
ide an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unne
c
essary
cursor seekin
g
when performin
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
I
mp
r
o
v
ed VDBE comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
Minor simplificatio
n
of the previous checki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ich
a
rd
H
ipp
Avoid unnec
e
s
sary cursor see
k
s during upsert
processi
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Enhance
UPSER
T
so
th
a
t the
U
PDATE use
s
the same se
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
M
i
nor simp
l
ifi
c
ation of the cursor all
o
cat
i
o
n logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Fi
x
the
h
andli
n
g of "PR
A
GMA
c
ount_changes=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
M
i
nor simplification to t
h
e
u
psert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Add the --
u
psert
opt
i
on to t
h
e w
o
rdcount te
s
t
p
r
og
r
am
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
A
dd the ex
t
/m
i
sc/templ
a
tevtab
.
c temp
l
ate for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Fix a problem in th
e
new upsert impleme
n
tion, discov
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the ta
b
le name aliasing on I
N
SERT so
t
hat it occu
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
A
v
oi
d
a NULL-pointer
deref f
o
l
lowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
ch
a
rd
Hipp
Fix a test c
a
se inside dist
i
nct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ich
a
rd
Hipp
Improved matching of COLLATE
clauses
w
ithin
t
he ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fi
x
a pr
o
blem in the
sq
l
ite3ExprComp
a
re() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichar
d
Hipp
Add suppo
r
t
f
or P
o
stgreSQL UPSERT syntax and f
u
nctionalit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Fix the b
u
i
l
d
for SQLITE
_
O
M
IT_UPS
E
RT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
H
i
p
p
Add
the --so
r
te
r
ref N op
t
ion
to the CL
I
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Omit some co
d
e not us
e
d
without
S
QLITE_ENABLE_S
O
RTER_REFE
R
E
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove a
n
unus
e
d
l
o
c
al variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Enhance AL
T
ER
T
A
BLE ADD COLUMN to support
"DEFAUL
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d H
i
pp
Add ch
e
cks to
t
h
e
CLI that issue
a
w
a
r
n
i
n
g
if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
H
i
p
p
Ad
d
new tes
t
case() ma
c
ros a
n
d fi
x
a
b
ug that was
revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Remove unreac
h
able br
a
nches
.
1
00% MC/DC in TH3
n
ow
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hipp
Ad
d
ed a
comment
o
n the assert() ad
d
ed to
the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Fixes
to
t
he logic for
c
onst
r
aint
c
h
eck re
o
rdering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d Hipp
During
PR
A
GMA vdbe_ad
d
opt
r
ace=ON
,
show calls to sqlit
e
3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ic
h
ar
d
H
i
pp
TK_R
E
GISTER
e
xpressions node
s
are
p
robably not
c
o
nstant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Sim
p
lificatio
n
to the
upsert lo
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
N
e
w test c
a
s
e
s f
o
r
upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Merge the Lemon enhancem
e
nt from tr
u
n
k
, resu
l
t
ing in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Lemon enhance
m
ents
:
(1) Do not allo
c
ate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Re
m
ove the MySQL upsert syntax
.
As an
optional a
l
ias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
Add support for the "ex
c
lu
d
ed
.
*" names
in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd
H
ipp
Increase the v
e
rsion num
b
er to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ic
h
ard Hi
p
p
Reduce the
s
ize of
t
h
e
N
ameC
o
ntext
object by groupin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
G
et upse
r
t workin
g
on WIT
H
OUT ROWID
tab
l
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hipp
Make sure constraint ch
e
cks occur in the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
First cut at logic to perfor
m
DO UPDATE for rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add in
f
rastr
u
cture
f
or doing an UPDATE as p
a
rt o
f
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Merge t
h
e
preupdate hook
change from trun
k
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Remov
e
an alwa
y
s-true branch
from the preupdat
e
hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get the
O
N CONFL
I
CT
DO NO
T
HING fo
r
m
o
f
u
psert
w
o
rking
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Get the
c
onflict-target clause
p
arsing worki
n
g
co
r
rectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
Im
p
ro
v
ed conf
l
i
ct-tar
g
et matching log
i
c
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
a
rd Hip
p
Ba
c
k off o
f
the extend
e
d
upsert
s
y
ntax
t
hat allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begin adding upsert logic
.
This is an
increme
n
tal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Break ou
t
t
h
e upsert code into a
separ
a
te source file
.
commit
|
commitdiff
|
tree
next