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
.
Ri
c
ha
r
d Hipp
Fix vario
u
s erro
r
handl
i
ng
c
onditions on the c
e
ll overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
The BtCursor
.
info fields are
o
nly vali
d
if info
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
H
i
pp
Ad
d
mor
e
corrup
t
ion
checking to t
h
e cell
o
verw
r
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Bug fixes in the overwrite optim
i
z
ation
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
The sqlite3BtreeInsert()
routi
n
e tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard H
i
pp
Pre
v
ent
VAC
U
UM from runni
n
g any com
m
ands in sq
l
ite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
The
S
QLITE_ALLOW_SQLIT
E
_MASTER_INDEX compile-time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
Test cases added for S
Q
L
IT
E
_DBC
O
NFIG_RESET_
D
A
T
ABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
hard
H
i
p
p
A
d
d the S
Q
LI
T
E_DBCONFI
G
_
R
ESET_DATABA
S
E control
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
Add the
S
QLITE
_
DB
C
O
NFIG_RESET_DATABASE
c
ontrol
a
s a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Merge upd
a
t
es from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hi
p
p
Prevent deep recurs
i
on
s
o
n
nested COLLATE ope
r
ators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hip
p
Fix compiler
w
arnings
i
n
F
T
S3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hipp
A
d
d th
e
"
P
R
AGMA reset_database=ON|OFF"
comm
a
nd
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ri
c
hard Hipp
Enhance the comm
e
nts
i
n the te
m
platev
t
ab
.
c
i
mplementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
The previ
o
us
f
ix
f
o
r ticket [d85ff
f
d6ffe8
5
6092e
d
8d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure that
new
.
* values
of
an UPDAT
E
do not get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarifica
t
ion
o
f the behavior of a BE
F
ORE UPDATE tr
i
gg
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
I
m
proved VDBE comment on t
h
e OP_
P
aram
o
pcode
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard H
i
pp
A
d
d new inte
r
faces for ac
c
essing the list of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new
D
O and NOTHI
N
G k
e
ywo
r
ds to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Add the new SQLITE_SHELL_IN
I
T_PROC compile-time entr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard H
i
pp
Av
o
id many unn
e
cessary calls to sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard
H
i
p
p
Ad
d
an asser
t
()
to ensure
t
hat schema mutexes
a
re
held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Do
not
attempt to use terms
f
rom the WHERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
Update the
e
xpert
exte
n
sion
t
est
cases t
o
accou
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Al
l
t
he OR optimization to proce
e
d even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Add
a
hyp
e
rlink to the
t
icket
o
n the co
d
e c
o
mment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance the CLI to render EX
P
LAIN Q
U
ERY
PLAN
u
s
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a memo
r
y leak following failure t
o
open an
e
xternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLAIN
Q
UERY PLAN output, do
n
o
t
show
a
n EXECU
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
icha
r
d Hipp
Fix
t
o
c
heck-in [ca
3
4c2
d
d20ee071e] - avoi
d
a
N
ULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
Fix a proble
m
in
s
qlite
3
ExprCompare() associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Fix
a
fo
r
matting issue in
t
h
e
T
reeView output for
b
are
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Add the
"
.
imposte
r
o
f
f
"
variant of the "
.
i
mpo
s
ter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
T
he "
.
selecttrace 0
x
20
0
0"
command causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
H
i
p
p
The
"
.
s
e
le
c
ttrace
4" command now show
s
only a si
n
gle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Do not restore the i
S
electI
d
value
until af
t
er the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
In the "
.
sel
e
cttrace" ou
t
pu
t
,
include
t
he
E
XPLAIN
Q
UERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensu
r
e th
a
t
ther
e
are no bind
-
para
m
eters or
incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unreachable branch ass
o
ciate
d
with st
a
ck overf
l
ow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Performance improvements on t
h
e ma
i
n loop
of
the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ic
h
ard Hipp
E
n
han
c
e LEMON to track which symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
Add the %extra_contex
t
directiv
e
t
o lemo
n
, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd H
i
pp
Fix U
P
SERT so that it plays nicely with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hip
p
Add
t
he
-dDI
R
ECTORY comma
n
d-line opti
o
n to L
E
MON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Fix a ha
r
m
le
s
s
c
o
mp
i
ler
w
arning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
ar
d
Hipp
Av
o
id the use of statement journals o
n
DELETE
s
of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
icha
r
d Hipp
Avoi
d
ope
n
i
n
g
a
s
tatement journal on sing
l
e-row UP
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
Hipp
Fix a VDBE comment on upsert
.
Provide
a
n
erro
r
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
ha
r
d Hipp
Avoid
unnece
s
sary cursor s
e
eking
w
hen per
f
orming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ic
h
a
rd
Hipp
Improved VDBE
c
omment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
cha
r
d
H
ipp
M
inor sim
p
lification of
the previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
A
v
oid unnecessa
r
y cur
s
o
r
s
e
eks du
r
ing upsert
p
r
ocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
E
nhance UP
S
ERT so that th
e
UP
D
ATE uses the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
p
p
Minor si
m
plification of the cursor al
l
ocation l
o
gi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix the handlin
g
of "PRAGMA count
_
cha
n
g
es=O
N
" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hip
p
Minor
s
implificatio
n
to the upser
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hipp
Add the --u
p
sert option
to the wordcount te
s
t program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
h
a
rd Hipp
Add t
h
e ext/m
i
sc/tem
p
latevta
b
.
c
template for virtua
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
har
d
Hipp
F
ix
a
pro
b
lem in t
h
e new upsert implemention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Fix the tabl
e
n
am
e
ali
a
sing on INSERT so tha
t
it o
c
curs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
A
v
oid a NULL-poi
n
ter deref f
o
llo
w
ing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fi
x
a
test cas
e
inside distinct
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Improved ma
t
ching o
f
C
O
LLATE cl
a
use
s
wit
h
in th
e
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
a
rd Hipp
F
i
x a
p
roblem
i
n the sq
l
ite3ExprCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
ard Hipp
Ad
d
support
f
or PostgreSQL UPSERT sy
n
t
ax and
f
unct
i
onality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Fi
x
the build for S
Q
LITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the --s
o
rter
r
ef
N opti
o
n
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hip
p
Omit
some co
d
e not u
s
ed
w
ithout
S
QLIT
E
_ENABLE_SORTER_REFERE
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Remove
an unused local
v
ariable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ic
h
ar
d
Hip
p
Enhance ALTER TABLE ADD
C
OLUMN to support "D
E
FA
U
LT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
A
dd
checks to t
h
e CLI that issue
a warning if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new tes
t
c
ase()
macro
s
a
n
d fix a bug that was r
e
vealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unreachable branches
.
100
%
MC/DC in TH3 n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard
Hipp
Added
a
comment on the assert() added to
the prev
i
o
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hipp
Fixes to the logic for constr
a
in
t
c
h
eck reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
During PRAGMA vdbe_
a
ddo
p
tr
a
ce=ON, show calls
t
o sql
i
te3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
char
d
Hipp
T
K
_REGIST
E
R expre
s
si
o
ns nodes are probably not cons
t
a
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard H
i
pp
Si
m
p
l
if
i
c
ation to
t
h
e 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
.
R
icha
r
d Hipp
M
e
rge the
Lemon enhancem
e
nt
fro
m
trunk, resu
l
ting i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd H
i
pp
Lemon e
n
hancem
e
nts
:
(1
)
Do not all
o
cate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Re
m
ove the MySQL upsert syntax
.
As a
n
optio
n
al ali
a
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Add
s
upport f
o
r the "exclude
d
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
H
ipp
Merge changes from trun
k
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
I
n
c
rease t
h
e version numb
e
r to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
R
educ
e
t
he size o
f
the
N
ameContext
o
bject by
g
r
ouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richa
r
d
Hipp
Get up
s
ert work
i
ng
o
n WITHOUT ROWID
tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hip
p
Make sure c
o
nstraint che
c
k
s
occur in
t
he c
o
rrect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
First cut at logic to per
f
orm DO UPD
A
TE for
rowid
tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
h
a
rd
H
ip
p
Add infrast
r
ucture for doing
an UPDATE
as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Merge
the preupdate hook change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hi
p
p
Remo
v
e
an alw
a
ys-true branch
f
rom the preupdate h
o
ok
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
Ge
t
the ON CONF
L
I
CT
D
O
N
O
THING form o
f
upsert
w
o
r
king
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get the conflict-target c
l
ause par
s
ing
worki
n
g correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard H
i
pp
I
mprove
d
con
f
lict-target matchin
g
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
Back off of
t
he exten
d
ed upsert syntax that al
l
o
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Be
g
in adding upser
t
logic
.
This
is an incr
e
mental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Break out th
e
upsert code
i
nto a s
e
par
a
te source file
.
commit
|
commitdiff
|
tree
next