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 a harmless compiler warning.
2018-04-20
D
.
Rich
a
r
d Hipp
Fix a harmless co
m
piler warni
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd Hipp
Avoid th
e
use of statement
j
ournals on DELETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Avoid opening a
statement jou
r
na
l
on si
n
gle-row U
P
DATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
F
i
x a VDBE comment
on upsert
.
Provide
a
n
error
m
essage
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d
Hipp
A
v
o
id unne
c
e
s
sary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
I
m
p
rove
d
V
DBE commen
t
on UPSE
R
T
c
ode
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Minor simplif
i
ca
t
ion of the previous check
i
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
A
void un
n
e
c
essary cursor se
e
k
s
during upser
t
processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hip
p
E
n
h
a
nce UPS
E
RT
so that the UPDATE uses the
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
p
p
Minor simplification
of the c
u
rsor allocat
i
on logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Fix
t
he
h
andl
i
ng of
"
PRAGMA count_chan
g
es=ON" wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplif
i
cation
to the
u
psert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
Add
the
--upse
r
t
o
p
tion
t
o
the wordcount test
program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
c
hard Hipp
Ad
d
the e
x
t/mis
c
/te
m
platevt
a
b
.
c template
for vi
r
tual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Fix a probl
e
m
in th
e
n
e
w upsert implemention,
d
is
c
overe
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix the table name aliasing
on
I
NSERT
s
o that
it
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Avoid a NULL-poin
t
er
d
eref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a test
c
ase i
n
side distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Im
p
rov
e
d ma
t
ching of
COLLATE clauses within the O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a probl
e
m in the sqlite3Ex
p
rCo
m
p
a
re
(
)
f
u
ncti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add support for
P
ostg
r
eSQL UPSERT syntax a
n
d
f
unction
a
lity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix
t
he build
fo
r
SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
Hipp
Add
t
he --sort
e
rref N opti
o
n to t
h
e
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
i
pp
Omit some code n
o
t
used withou
t
SQ
L
ITE_ENABLE_SORTER_R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hip
p
Remov
e
an unu
s
ed loca
l
var
i
able
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Enhance A
L
TER
T
ABLE
ADD COLUMN to supp
o
rt "D
E
F
AULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard H
i
pp
A
dd
c
hecks to the CLI that issue a warn
i
ng if SQLi
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Add
n
e
w
testcase() macros and f
i
x a bug that was re
v
ealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hi
p
p
R
e
move u
n
re
a
chab
l
e
branches
.
100%
M
C
/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
char
d
Hip
p
Added a
c
o
mm
e
nt on
the as
s
ert
(
) adde
d
t
o
t
he previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
F
ix
e
s t
o
the l
o
gi
c
for cons
t
raint
che
c
k reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
D
u
r
i
n
g
PRAGMA vdbe
_
addoptr
a
ce
=
ON
,
show
c
all
s
to sqli
t
e3
V
dbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hi
p
p
TK_REGIS
T
E
R
expre
s
s
i
on
s
nodes ar
e
probably n
o
t co
n
stant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hi
p
p
Sim
p
lificat
i
on to the upse
r
t logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
N
e
w test cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
H
i
pp
M
e
r
g
e
t
he Lem
o
n enhancement from trunk, re
s
ulti
n
g in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd H
i
pp
Lemon enhancements:
(1) Do n
o
t allocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
Remove the
MySQL upsert syntax
.
As
a
n
optional ali
a
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hi
p
p
Add suppor
t
for the
"ex
c
luded
.
*
" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
h
ard
Hipp
Merge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
In
c
r
e
ase th
e
version nu
m
ber
to 3
.
2
4
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
r
d Hipp
Reduce the size o
f
th
e
NameContext
o
b
j
e
c
t
b
y
grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
hard Hipp
G
et upsert working on WITHOUT ROWID
t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
M
ake
s
ure constraint checks oc
c
ur in the co
r
rect
o
rder
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d
Hipp
F
i
r
st cut
at lo
g
ic to perf
o
r
m
DO
UPDA
T
E
for rowid tab
l
es
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard
Hipp
A
dd
i
nfra
s
tructure for
doing an UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
M
e
rge the preupd
a
te hook change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove an
always
-
true branc
h
f
r
om the preupdate
h
ook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard
H
i
p
p
Get the ON CONFLI
C
T DO NOTHING form o
f
u
p
sert workin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hip
p
Get the conflic
t
-target cl
a
use par
s
ing working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
I
mproved
confli
c
t-target
m
atching
l
o
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back o
f
f
of the extended upsert synta
x
that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
B
e
gin
adding upsert logic
.
This is a
n
increm
e
n
t
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
B
reak ou
t
the upsert
code into a separate source fi
l
e
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fi
x
another typo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Simpl
e
comment clarif
i
cation
.
No code
o
r lo
g
ic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Ext
e
nd the upsert syntax t
o
allow a WHERE clau
s
e on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Upd
a
te the
u
psert
p
a
r
sing so tha
t
it
a
ccepts confl
i
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
H
i
pp
Add the
U
psert objec
t
for holding u
p
sert clause
i
nformat
i
on
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hip
p
Merge changes from t
r
un
k
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
h
a
rd Hipp
H
e
l
p
the parser run faster by avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
ich
a
rd Hipp
Pr
o
hi
b
it bound p
a
rameter
s
in
t
he
a
r
g
u
m
ents to ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Versi
o
n 3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hip
p
Incr
e
a
s
e the
v
ersion numbe
r
to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
icha
r
d H
i
pp
Remov
e
an unnece
s
sary SQLITE_UNTESTABLE compi
l
e
-
time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard Hipp
Up
d
ate th
e
top-le
v
el README
.
md f
i
le to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard Hipp
U
p
dat
e
t
h
e top-
l
evel
READ
M
E
.
md file to point
t
o the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Min
o
r changes to
the input gram
m
ar
r
esulting in a fast
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
En
h
ance the query planner so tha
t
it d
e
tec
t
s when
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
I
mprovements to "
.
whe
r
etrace" outp
u
t
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
ard Hipp
Fix
a
(
h
arm
l
ess
)
signed
i
nteger
ov
e
rflow warnin
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard Hipp
M
o
re complete
p
a
rsing o
f
UPSERT
,
in
c
lud
i
ng UPSER
T
withi
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
De
m
onstrat
i
on of
how the parser c
a
n
be augmen
t
e
d
to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ric
h
ard Hipp
Enhance LEMON to
sho
w
precendence of symbols a
n
d
a
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
Fix the sqlite3W
h
e
r
eTrace me
c
han
i
sm
so t
h
a
t it compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard
Hipp
F
ix an error message in sp
e
edtest1
.
c and ma
k
e
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard H
i
p
p
F
ix
the genera
t
e
_
serie
s
virtual
t
able
so
t
ha
t
it
c
orrec
t
ly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
i
chard Hipp
Change
the LEFT JOIN
strength reduction optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richar
d
Hi
p
p
Versio
n
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ric
h
ard
Hip
p
Bette
r
solution
t
o
the LIKE
p
roblem f
r
om the
p
r
e
v
i
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hipp
Fix a logic
e
rr
o
r discove
r
ed by OSSFuz
z
that
c
a
n
cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
hard Hipp
Fix a
b
ug in the spell
f
ix ext
e
nsion c
a
using
it to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an off
-
by-one e
r
ror i
n
th
e
dist3 algorithm
o
f
the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Ric
h
ard Hipp
Modif
y
the
sqlite3OsFileControl
(
) interface t
o
detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ri
c
har
d
H
i
p
p
F
ix a harmless
c
o
mpiler
w
ar
n
in
g
i
n the
k
v
test
.
exe program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard H
i
p
p
Fix a harm
l
ess compiler warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
ip
p
Remov
e
tab
c
haracters
.
No log
i
cal changes to
c
ode
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richar
d
Hipp
Min
o
r comme
n
t
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Ric
h
ard
H
ip
p
Fix a
t
ypo in the R
E
ADME file f
o
r
I
CU
.
No cod
e
cha
n
ge
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard H
i
p
p
T
h
e p
u
sh-do
w
n optimization
w
as being too agg
r
essive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richar
d
Hipp
Pr
o
vide the ability for the VFS t
o
do a b
l
ock
i
ng
w
a
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
H
i
pp
Do no
t
inject
O
OM errors
o
n SQL
I
T
E
_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avoid a race condition that might caus
e
a busy
_
timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richa
r
d
H
ipp
Ad
d
inf
r
a
s
tructure to supp
o
r
t for
us
i
ng F_SETLKW
with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
Hip
p
Refact
o
r s
o
me inte
r
nal object element na
m
es u
s
ed by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richa
r
d
H
i
pp
Ad
d
testcas
e
(
)
m
acros and improve commen
t
s
in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
H
ipp
Ye
t
a
n
other fault in
t
he sqlite3ExprImpliesNo
t
Nul
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
B
u
g
f
i
x
in the LEFT JO
I
N
strength
reduction optimizatio
n
of
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
ichard
H
ipp
Pr
e
pend linkage
macros to th
e
sqlite3rebaser i
n
terfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
ichar
d
Hip
p
F
ix
the -readonly option
o
n t
h
e
CLI so t
h
at i
t
actua
l
ly
.
.
.
commit
|
commitdiff
|
tree
next