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
.
Ric
h
ard Hipp
Fix various error handling
conditions o
n
t
h
e cell overw
r
ite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
The BtCursor
.
i
n
fo fields ar
e
on
l
y
valid if info
.
n
Si
z
e!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
Add more cor
r
uption checking to
t
he cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
i
pp
Bu
g
fix
e
s i
n
th
e
overwrite o
p
ti
m
iza
t
ion
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The sqlite
3
BtreeInse
r
t() ro
u
tine
t
ries t
o
ove
r
w
rit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard
H
i
p
p
P
revent VACUUM
f
rom
r
unning any commands in sqlite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
ic
h
a
rd Hip
p
The S
Q
LITE_ALLOW_SQLITE_MA
S
TE
R
_IND
E
X comp
i
le-time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hipp
Test ca
s
es a
d
ded
f
or SQLITE_DBC
O
NF
I
G_RESE
T
_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Ad
d
t
he SQLITE_DBCO
N
F
I
G_RES
E
T
_
DAT
A
BA
S
E
co
n
trol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
H
ip
p
A
dd th
e
SQLITE_
D
BCONF
I
G
_
RESET_DATAB
A
SE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Merge upda
t
es from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
P
reve
n
t deep recursions on nes
t
ed COLLAT
E
operator
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fix compiler warnings in F
T
S3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
char
d
Hipp
Add
th
e
"
P
RAGMA reset
_
da
t
abase=ON|OFF" c
o
mmand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
i
chard H
i
p
p
Enhance the comments
i
n the temp
l
atevt
a
b
.
c implementat
i
on
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richar
d
Hipp
Th
e
pr
e
vious
f
ix
f
or t
i
cket
[d8
5
ff
f
d
6
ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
Ensure that new
.
* v
a
lues of an
UPDATE do not get cl
o
b
b
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard
H
ipp
Clarification o
f
the
behavio
r
of a BEFORE
UPD
A
TE trigg
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VDBE comment on the OP_Param
o
pcode
.
No subs
t
a
n
t
i
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard Hipp
Add new
interface
s
for accessing the
l
ist of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
A
dd the new DO and NOTHI
N
G keywords to th
e
keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ar
d
H
i
pp
A
d
d
the new S
Q
LITE_SHELL_
I
NIT_PROC comp
i
le-t
i
me
entr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Avoid m
a
ny u
n
n
ecessary calls to sqlite3
R
eadSch
e
m
a
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an asser
t
() to ensur
e
that schem
a
mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not attempt
t
o
use terms from the WHERE cla
u
se to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hip
p
Update the expert extension te
s
t
c
a
s
es
t
o ac
c
ount for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
All the OR optimization to
pro
c
eed even
if the OR
i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
H
i
pp
Add
a hy
p
erlink to the ti
c
ket on
t
he code
c
omme
n
t
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard
Hipp
Enhance the CLI
t
o
rend
e
r EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
H
i
p
p
Fix
a
memory lea
k
following
f
ailur
e
to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
I
n
EXPLAIN QUERY PLAN output, d
o
not show an EXECUT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Fix to check-in [ca
3
4
c
2dd
2
0ee071e] - avoid a
N
ULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fi
x
a
problem in
s
qlite3Exp
r
Compar
e
()
as
s
ociated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
Fix a
f
ormatt
i
ng issue in the T
r
eeView
o
u
t
put fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Add the "
.
imposter off" variant
o
f
the "
.
i
m
poster"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichar
d
Hi
p
p
The "
.
sel
e
cttrace
0
x
2
0
0
0
" command
cau
s
es just
the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard H
i
pp
The "
.
selecttrace 4"
c
o
mmand now shows only a sin
g
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
r
d Hipp
Do not
r
estore the iSele
c
tId val
u
e u
n
til after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
s
electtrace" ou
t
put, include th
e
EXPLAIN QUER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure
t
hat
t
her
e
are no
b
i
n
d-pa
r
amete
r
s
or i
n
correct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Fix
an unreachable
b
ranch associated with stack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
P
erf
o
rmance i
m
provements
o
n the ma
i
n
l
o
op of
the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
ipp
Enhance LEMON to track which symbol
s
a
c
t
u
ally ca
r
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %extra_conte
x
t
d
irective to lemon, as
a
n alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
F
i
x UP
S
ERT so that it plays nic
e
ly
with A
U
TOI
N
C
REMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Add the -dD
I
RECTORY comma
n
d-li
n
e option to L
E
MON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless comp
i
ler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
i
d the use of statement journals on DELET
E
s
o
f a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
icha
r
d Hi
p
p
Avoi
d
opening a
st
a
tement jour
n
al on singl
e
-row U
P
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Fix a VDBE
c
omment on
u
psert
.
Pr
o
vide an err
o
r mess
a
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
A
void
u
nnecessary curso
r
seeking when performing a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Impr
o
ved
V
D
B
E comment on UPSER
T
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor simpl
i
fication of the pr
e
vious check
i
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Avoid unnecessary cu
r
sor seeks d
u
ring upse
r
t processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enha
n
ce
U
PSERT so that the UPDAT
E
us
e
s the same
s
e
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
Minor si
m
plification
o
f
the cur
s
or a
l
location logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the
handling of "PRAGMA count_c
h
anges=ON
"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor s
i
mplification to th
e
u
p
sert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard H
i
pp
Add the --up
s
ert option to
the wordcount
t
e
st program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard Hipp
A
d
d the ext
/
misc/templ
a
t
e
vtab
.
c template for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a p
r
oblem
i
n the new up
s
ert implemention, disc
o
v
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hipp
Fix
t
h
e table name
a
l
i
a
sing on INSERT s
o
t
hat it
o
c
cu
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a
N
U
LL-p
o
inter
d
ere
f
followi
n
g OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
ard Hip
p
F
ix
a
test case
inside distin
c
t
.
tes
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Improv
e
d
matching of
COLL
A
TE clauses wi
t
hi
n
t
h
e ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a prob
l
e
m
in th
e
sqlite3ExprC
o
mpare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
a
rd Hip
p
Add s
u
p
p
ort for P
o
stgreS
Q
L UPSERT syntax and functionalit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fi
x
the build for
S
QLITE_O
M
IT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Add the --sorterref N option
to the C
L
I
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Omit some code
n
ot used without
SQLITE_ENABLE_SORTE
R
_
REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Remove an unused local varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Enhance
ALT
E
R TABLE AD
D
COLU
M
N
to support "
D
E
F
AULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add check
s
to the CLI that issue
a
wa
r
ning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new testcase() macros
and fix a bug t
h
a
t
was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
R
e
move u
n
rea
c
hable branches
.
10
0
% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d H
i
pp
Added a comment on
t
he ass
e
rt() a
d
ded
t
o th
e
pr
e
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Fixes to th
e
logic for constr
a
i
n
t check
r
eordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Durin
g
PRAGMA vd
b
e_
a
ddoptrace=ON, show
c
alls
t
o sql
i
te3Vd
b
eR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
TK
_
R
EGISTER expre
s
sions n
o
des are pr
o
bably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Si
m
plificati
o
n
to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
New test cases
for
u
p
sert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Merge
t
he
L
emon enhan
c
ement from
trunk,
r
e
sult
i
ng
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Le
m
on enh
a
nceme
n
ts: (1)
D
o n
o
t allocate
s
pace
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Remove the MySQL upsert synt
a
x
.
As a
n
op
t
ional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
char
d
H
i
pp
Add suppor
t
f
o
r the
"
exc
l
uded
.
*"
n
ames in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hi
p
p
Merge chang
e
s
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Increa
s
e the
version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce the
size of the
N
am
e
Con
t
ext ob
j
ect b
y
group
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert
w
o
rki
n
g on WIT
H
OUT ROWID
t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hi
p
p
Make s
u
re constraint ch
e
cks
o
c
cur in th
e
correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
F
irst cut at logic to perfo
r
m DO UPDATE for rowid table
s
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d Hipp
Add infrast
r
ucture
for d
o
i
ng an
U
PDAT
E
as pa
r
t of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hi
p
p
Merge t
h
e preup
d
ate hook
c
hange fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Remove an
alwa
y
s-true branch from the preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
Get the ON CONFLICT DO NOTHING f
o
rm of up
s
ert workin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
G
e
t the con
f
li
c
t-targe
t
clause pars
i
ng working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Improved c
o
n
flict-
t
a
r
get matchin
g
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Back off of
t
he
e
xtended
upsert syntax that
a
llows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
cha
r
d Hipp
Begin add
i
ng upser
t
logic
.
This is
a
n incr
e
men
t
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Break out the ups
e
rt c
o
de into a separate
s
ource
f
ile
.
commit
|
commitdiff
|
tree
next