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 UPSERT so that it plays nicely with AUTOINCREMENT.
2018-04-21
D
.
Richard Hip
p
Fi
x
UPSERT so
t
ha
t
it plays nicely with AUTOI
N
CREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
d
d
t
h
e
-dD
I
RECTORY
c
o
mmand-line opti
o
n to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a ha
r
mles
s
compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
A
void t
h
e use of statem
e
nt journals o
n
DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
H
i
pp
Avoid o
p
enin
g
a statement journ
a
l on single-row U
P
DATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDBE com
m
ent on u
p
se
r
t
.
Provide
a
n erro
r
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hi
p
p
Av
o
i
d
unn
e
cessary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
Improved VDBE
c
om
m
ent on UPSERT cod
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
ch
a
rd Hipp
Mi
n
or simplification of
t
he prev
i
o
us
checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unnecessary cursor se
e
ks during
u
psert
p
r
oc
e
ssing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ic
h
ard Hipp
Enhance UPSER
T
so
that the UPDAT
E
uses
t
he same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Minor simpli
f
ication of th
e
cursor allocation
l
ogic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix t
h
e handling of "PRAGM
A
c
o
unt_changes=ON" wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplificatio
n
t
o the upsert logi
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
h
ard Hipp
Ad
d
the --ups
e
rt optio
n
to the
w
ordcount test
p
rog
r
a
m
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd
H
ipp
Add the
e
xt/m
i
sc/templatevtab
.
c t
e
mplate f
o
r virtu
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard
Hipp
Fix a problem in the
n
ew ups
e
rt
i
m
pl
e
mention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
th
e
table nam
e
aliasing on I
N
SERT so
t
hat
it occ
u
rs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hi
p
p
Avoid a NULL-pointer der
e
f following
O
OM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Fix a test
c
a
se inside d
i
stinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
Hipp
I
mproved matching of COL
L
ATE clauses wi
t
h
i
n
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix
a
problem in the s
q
lite3Ex
p
rCompare(
)
function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Add support
f
or
Po
s
tgreSQL UP
S
ERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Fix
t
he build for SQLITE
_
OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Ad
d
th
e
--s
o
rterref N option to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit som
e
c
ode not us
e
d
without SQLITE
_
ENA
B
LE_SORT
E
R
_
REFERE
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
R
e
mo
v
e an unused local variab
l
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Enhanc
e
ALTER
T
ABLE A
D
D
COLUMN to suppor
t
"DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add c
h
ecks to the CLI that
issue a w
a
r
n
ing if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ich
a
rd Hipp
Ad
d
new testcase(
)
macros
a
nd
f
ix a bug t
h
a
t was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hipp
Remov
e
u
nreachab
l
e b
r
anches
.
100
%
MC/DC in
TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Add
e
d a comment on the assert() a
d
d
e
d to t
h
e previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
H
ipp
Fixes to the
l
ogi
c
for
c
on
s
traint
c
h
eck
r
eordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hipp
During PRAGMA vdbe_addoptra
c
e=ON, show c
a
lls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
TK_REGISTER ex
p
ress
i
on
s
nodes are probably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
Simplification to the u
p
sert l
o
gic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
New t
e
s
t
cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Merge
t
he Lemon
enhancement
from tr
u
nk, r
e
sulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Lemon enhancements:
(
1
)
Do
not al
l
oc
a
t
e
space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Remove the
M
ySQL
u
p
sert syn
t
ax
.
As an
o
ptional
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
A
dd support for the "excl
u
ded
.
*" nam
e
s in the UPDAT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard
H
ipp
Merge cha
n
ges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Increa
s
e the version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hi
p
p
Reduce
t
he s
i
ze of the NameContext object by grou
p
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hipp
G
et up
s
e
rt working on WI
T
HOU
T
ROWID ta
b
les
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make
s
u
re constraint
c
he
c
ks occur in
the cor
r
ect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
First cut at
logic to perform DO UPDATE for
r
owi
d
tab
l
es
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Add inf
r
astructure for doing an UP
D
A
TE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
Merge the
p
re
u
pdate h
o
o
k
change from
trun
k
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Re
m
ove an always-true branch from the
preup
d
ate
h
ook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
r
d
Hipp
Get the ON CONFLICT DO NOTHING fo
r
m of upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
G
et t
h
e conf
l
ict-target clause parsin
g
wo
r
k
i
ng correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard
Hipp
Impr
o
ved
conflict
-
t
ar
g
et matching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back
off of th
e
extende
d
u
psert s
y
n
tax that
a
l
lows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard H
i
pp
Begin adding upsert
l
o
g
i
c
.
Th
i
s is an
i
ncrement
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ich
a
rd Hipp
Break out the ups
e
rt code into
a
s
e
parate sour
c
e file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
F
i
x
a
nother typo in a comme
n
t
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hipp
Simple
c
omment clarification
.
No c
o
de or logic
c
hanges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
E
x
tend t
h
e up
s
ert
s
yntax to allow
a WHERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Update the u
p
s
e
rt parsi
n
g so
t
hat it accepts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
A
dd the Upsert obj
e
ct for hold
i
ng upsert clause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
H
ipp
Merge
chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
ichard Hipp
Help
t
he parser run
f
aster by avoidi
n
g the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Proh
i
b
it bound param
e
t
e
r
s i
n
th
e
a
rguments
t
o table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard Hip
p
V
ersion 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard
H
ipp
Incr
e
ase t
h
e
vers
i
on n
u
mbe
r
to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ri
c
h
a
rd
H
ipp
Remove
a
n unnecessary SQLITE_UNTESTAB
L
E c
o
mp
i
le-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
H
ipp
Update the
t
op-level RE
A
DME
.
md file to
p
o
int to
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-level REA
D
ME
.
md f
i
le to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd Hipp
Mino
r
changes to the input g
r
a
mma
r
resultin
g
in a faste
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Enhan
c
e the que
r
y plann
e
r
s
o tha
t
i
t
detects when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richa
r
d Hipp
Improvements to
"
.
wheretra
c
e"
o
utpu
t
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
i
ch
a
rd Hipp
Fix a (har
m
less)
s
igned integer overflow warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richar
d
Hip
p
More compl
e
te
p
a
rsing o
f
UPSERT, i
n
clud
i
ng
UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Demons
t
ration of how
the par
s
er
c
an be augmented t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhance LEMON to
s
how prece
n
den
c
e of symbo
l
s and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richa
r
d Hipp
Fix the
s
q
lite
3
Whe
r
eTrace mech
a
nism so
t
hat it compi
l
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix a
n
e
rror message in speedtest1
.
c and m
a
ke the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard
H
ipp
Fix
the
g
enerate_series virtu
a
l table so that it c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change the LE
F
T JOIN strength redu
c
tion optimizati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
i
ch
a
rd Hipp
Vers
i
on
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Better so
l
ution to the
L
IKE problem from t
h
e
p
r
eviou
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richa
r
d Hipp
F
ix
a logic error discovered by OSSF
u
zz tha
t
can c
a
use
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix
a
bug in the spellf
i
x extension causing it
t
o
c
ompute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
hard Hipp
Fix an off-by-o
n
e error
in the d
i
st3 algorit
h
m of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify th
e
sq
l
ite3OsFileControl() interface
to de
t
ect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
F
ix
a
harmless c
o
m
p
iler w
a
rnin
g
in the kvtest
.
exe
p
rogram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fix a harmless
compiler warni
n
g
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard
Hi
p
p
Remove tab charac
t
er
s
.
No logical
c
hanges
to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
M
i
nor comment cha
n
ges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hi
p
p
Fix a typo in th
e
README file for IC
U
.
No code chang
e
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
The p
u
sh-
d
own optimi
z
atio
n
was be
i
ng too aggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provide the abil
i
ty for
the VFS
to do a
b
locking
wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richar
d
H
ipp
Do not inject OOM e
r
rors on SQLITE_FCNTL_LOCK_
T
IM
E
O
UT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avoid
a race condi
t
ion that might c
a
use a bu
s
y_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add i
n
frastructure to
support fo
r
using F
_
S
ETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard H
i
pp
Re
f
actor som
e
internal object elem
e
nt names used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
H
ipp
Add testcase(
)
m
a
cros and improve comment
s
in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Ye
t
another
fa
u
lt in the sq
l
ite3ExprImplie
s
NotNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
Hipp
Bug fi
x
in the
LEFT JOIN strength reduction opt
i
mization of
commit
|
commitdiff
|
tree
next