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 vario
u
s erro
r
han
d
ling conditions
o
n the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
h
ard Hipp
T
h
e Bt
C
ursor
.
info fields are only vali
d
if info
.
nSize!=
0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
har
d
Hipp
Add mo
r
e
corr
u
pti
o
n
c
h
ecking t
o
the cell ov
e
rwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Bug fixes
in th
e
overwrite optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
The sqlite3B
t
reeInse
r
t(
)
routine tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
H
ipp
P
r
e
ve
n
t VACUUM from running any commands in
s
qlite
_
m
a
ste
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
T
h
e SQLITE_ALLO
W
_SQL
I
TE_MASTER_INDEX
compile
-
tim
e
option
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
ch
a
rd
H
ipp
Test
ca
s
es a
d
ded for SQ
L
I
TE
_
D
B
CONFIG_RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
A
dd the
S
QLITE_DBC
O
NFIG_RESET_DATABASE co
n
t
rol fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hipp
Add
t
h
e SQLITE_DBCONFIG_RESET_DATABASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hip
p
M
e
rge
updat
e
s
from t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hipp
Prevent de
e
p
r
ecur
s
ions o
n
nested COLLATE
o
perators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fix compiler warnings in
FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add th
e
"PRAGMA
re
s
e
t_database=ON|OFF
"
comma
n
d
.
W
hen
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
i
chard Hipp
Enhanc
e
t
h
e com
m
ents in the templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
The previous fix
f
o
r
t
i
cket [d
8
5fffd6ffe85609
2
ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure th
a
t n
e
w
.
* v
a
lue
s
of an
U
P
DATE
do not get c
l
obb
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hip
p
Cla
r
ificatio
n
of the
behavior of a
BEFORE U
P
DATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improv
e
d VDBE comment on the OP_Param opcode
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
Add new interf
a
c
es for accessing the l
i
st of
S
QL key
w
o
rds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
h
a
r
d Hipp
A
d
d the new DO
a
n
d NOT
H
ING ke
y
words to
t
h
e
keywor
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
char
d
Hipp
Add the new SQ
L
I
TE_SHELL_
I
NIT_PROC compile-ti
m
e entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avo
i
d many unnecessar
y
c
alls
t
o sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
r
d
Hip
p
Add an a
s
sert() to ensure tha
t
s
chema mut
e
xes are he
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do no
t
a
tt
e
mpt
to use t
e
rms from the WHERE c
l
ause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hi
p
p
U
p
d
ate
the
expe
r
t extens
i
on tes
t
cases to
acc
o
u
nt for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
A
ll the
O
R optimization to proceed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
H
ipp
Add a hyperlink to the
t
icket
o
n t
h
e code c
o
m
ment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hip
p
E
nhance th
e
CLI to
render EX
P
LAIN QUERY PLAN
usi
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
pp
F
i
x a memory
leak following f
a
ilure t
o
o
p
en an e
x
t
ernal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLAIN QUE
R
Y PLAN output, do not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix to
c
heck-i
n
[ca
3
4
c2dd20ee
0
71e
]
-
avoid a
N
U
LL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd
Hipp
Fix a problem in sqlite3ExprComp
a
re
(
)
associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
F
i
x a
f
ormatting issue i
n
the
TreeVi
e
w output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
Add the "
.
im
p
oster off" vari
a
nt of
th
e
"
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
T
he "
.
selecttrace 0x200
0
"
comman
d
causes
j
ust the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
sele
c
ttrace 4" c
o
mman
d
n
ow show
s
onl
y
a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Do not
r
esto
r
e the iSelectId value until af
t
er the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
In the "
.
selectt
r
ac
e
" outpu
t
,
inc
l
ude the
EXPLAIN Q
U
ER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure th
a
t th
e
r
e
ar
e
no bind-parameters or in
c
o
rr
e
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an
unreachable branch associ
a
t
e
d wi
t
h
s
t
ack over
f
low
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Pe
r
formance impr
o
v
e
ments on the main loop
o
f the LE
M
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichard Hipp
Enhance LEMO
N
to t
r
ack
whi
c
h
symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d Hipp
Ad
d
the %
e
xt
r
a_context directive to lemon, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hipp
Fix UPSERT so that it pl
a
y
s
nicely w
i
th AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Ad
d
the -dDIRECTORY co
m
mand
-
line
o
ption to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Fix a h
a
rmless compile
r
war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avo
i
d the
u
se of statement journals on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid openi
n
g
a
stat
e
ment journal on single-row UP
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDB
E
co
m
ment on upsert
.
Provide an
e
rror message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd Hipp
Avoid u
n
n
ecessary cursor seeki
n
g when performi
n
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hip
p
Impro
v
ed
VDBE comment on UP
S
ERT cod
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
M
inor s
i
mplif
i
cation of the previou
s
checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Avoid unnecessar
y
cursor
seeks dur
i
ng upsert proce
s
sing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
ipp
E
nhan
c
e
UPSERT so tha
t
the UPDATE uses the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd Hipp
M
i
n
o
r
simplifica
t
ion
o
f the cursor allocation
l
ogic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
c
h
ard Hipp
Fix the handling of "PRAG
M
A co
u
n
t
_
c
hanges=
O
N" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
M
inor simplif
i
cati
o
n to the ups
e
rt logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ip
p
Add the --u
p
s
e
rt opt
i
on to t
h
e
wo
r
d
c
o
unt test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the ext/
m
isc/templatevtab
.
c tem
p
late for
virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Fix a probl
e
m in the new upsert implemention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the
t
a
b
le
name
a
lia
s
i
n
g
on I
N
S
E
R
T so that it oc
c
urs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avo
i
d a NUL
L
-pointer deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
cha
r
d Hi
p
p
Fi
x
a
t
es
t
case in
s
ide distinc
t
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Improved
m
atching of COLLATE clause
s
within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a pr
o
blem in
the sqli
t
e3ExprC
o
mpar
e
() func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hi
p
p
Add su
p
port f
o
r PostgreSQL UPSER
T
syn
t
ax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix
the build for SQLIT
E
_OMIT
_
UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
d
d the
--sorte
r
ref N
o
ption to
t
he CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
cha
r
d Hipp
O
mit
so
m
e c
o
de not
u
sed without SQLITE_ENABLE_
S
ORTER_R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Re
m
ove an unused local vari
a
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ic
h
a
r
d Hipp
Enhance
A
LTER TABLE ADD COLUMN to
s
upport "DEF
A
U
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Add checks to the
CLI
t
hat
issue a warning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new
t
estcase() mac
r
os and fix a bug that
w
as re
v
ealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
H
i
p
p
Remove
u
nreachab
l
e
br
a
n
c
hes
.
100% MC/DC in
TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
Added
a com
m
ent on the a
s
sert() added to the previ
o
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
F
i
xes to
the log
i
c for co
n
s
t
raint
c
h
eck
re
o
rdering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Dur
i
ng PRAGMA
vd
b
e_addo
p
trace=
O
N, show c
a
l
l
s t
o
sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard H
i
pp
TK_REGI
S
T
ER expressio
n
s
n
o
de
s
are
probably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ic
h
ard Hi
p
p
S
i
mp
l
ification to
t
he up
s
ert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard
H
ipp
New
test
c
ases for u
p
se
r
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Me
r
g
e
the Lemon enhan
c
ement f
r
om trunk, resultin
g
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard
Hipp
Lem
o
n
enhancements
:
(1
)
Do
not
a
l
l
ocate
spac
e
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
R
e
m
ove th
e
MySQL u
p
sert sy
n
tax
.
As an op
t
ional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichar
d
Hipp
Add support
f
o
r t
h
e
"excluded
.
*" names
in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard H
i
pp
M
e
rg
e
c
hanges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
h
ard Hipp
Increase the vers
i
on
num
b
er
t
o 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Reduce the size of t
h
e Name
C
o
ntext ob
j
ect by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richa
r
d Hipp
Get u
p
s
ert working on WITHOUT RO
W
ID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make sure constraint checks
o
ccur
in the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
hard Hipp
F
irst cut at log
i
c to perfo
r
m
DO UPD
A
TE
f
o
r
rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ich
a
rd Hi
p
p
Add infrastructu
r
e f
o
r doin
g
a
n
U
P
DATE as
p
art of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
icha
r
d H
i
pp
Mer
g
e the preupda
t
e
hook change
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d H
i
p
p
Re
m
ove an
alwa
y
s-true branch
f
rom the preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
G
et the
O
N CONFLICT DO NOTH
I
NG fo
r
m
o
f upser
t
worki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard
Hipp
Get
t
he conflict-target
claus
e
p
a
rsing working c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Impro
v
ed conflict-target matching
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back off of
the extended
u
p
se
r
t s
y
nta
x
that allo
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Beg
i
n adding upser
t
logic
.
This is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
h
a
rd Hipp
Brea
k
out the up
s
er
t
c
o
de into a
separate sou
r
ce
f
ile
.
commit
|
commitdiff
|
tree
next