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
.
Richa
r
d Hipp
Fix UPSE
R
T so that i
t
plays ni
c
e
ly with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
d
d
t
he -d
D
IR
E
CTO
R
Y command
-
line option
to
L
E
M
ON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
H
ipp
Fix a
ha
r
mless compiler warn
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard H
i
pp
Avoid the use o
f
statement journals on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Avoid
o
pe
n
i
n
g
a stateme
n
t journal on single-r
o
w UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDB
E
comment
o
n upsert
.
Provide an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
icha
r
d Hipp
A
v
o
id unnecessa
r
y
curso
r
seeking when p
e
r
forming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
H
ip
p
Improved VDBE comment on UPSERT
c
ode
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor
s
i
mplifi
c
ation of t
h
e previ
o
u
s checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
a
r
d Hi
p
p
Avoid unn
e
ces
s
ary cursor seeks dur
i
ng
u
psert
p
r
ocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Enhance UPSERT s
o
that the UPDATE u
s
es the sam
e
s
e
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Min
o
r
simp
l
ification of
t
he cursor allo
c
ation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the ha
n
dling of
"
P
RAGMA
c
ount
_
changes=O
N
"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichar
d
H
ip
p
Mi
n
o
r
s
i
m
p
lific
a
tion to
the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
A
d
d
t
he --ups
e
r
t
optio
n
to the wor
d
count test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Add the e
x
t/misc/templatev
t
ab
.
c template f
o
r virt
u
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
Hipp
Fix a prob
l
em i
n
the new
u
psert implemention
,
discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
Fix the table name al
i
asing on INSE
R
T
so that it o
c
curs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Avoi
d
a NULL-point
e
r
deref
f
ollow
i
ng OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
Hip
p
Fix a test case insid
e
d
is
t
i
nct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hip
p
Improved
mat
c
hing of C
O
L
LAT
E
clauses
wi
t
hin the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Fix a prob
l
em in th
e
s
q
lite3ExprCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Add support for
P
o
stgreSQL UPSER
T
syn
t
ax
and f
u
nction
a
lity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
F
ix the
build for
S
QLITE_OMIT_UP
S
ER
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
d
d
the --sorte
r
re
f
N option to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omi
t
som
e
code not
u
sed wit
h
out S
Q
LITE_
E
NABLE_SORTER
_
REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove an unu
s
ed
l
ocal variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hi
p
p
Enhance A
L
T
ER TABLE
A
DD COL
U
MN to supp
o
rt "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
p
p
A
dd checks to
the C
L
I
t
hat iss
u
e
a
warning if SQL
i
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ip
p
Add new testc
a
se()
macros and
f
ix a
bug that w
a
s revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
H
ipp
Remov
e
unreachab
l
e branches
.
1
00% MC/DC
in
T
H3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard H
i
pp
Add
e
d
a com
m
ent
on the assert
(
) a
d
ded to
t
he previou
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
ha
r
d Hipp
Fixes
t
o the logic
for constraint ch
e
ck reo
r
dering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
D
uring PRAGMA vdbe_
a
ddop
t
race=ON, show c
a
l
ls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
TK_REGISTER expr
e
ss
i
ons nodes are probably n
o
t con
s
tant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplific
a
tion to the ups
e
rt log
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
hard
H
i
p
p
N
e
w
test cases
f
or upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
Merge the Lemon enhanc
e
ment f
r
om trun
k
, result
i
n
g in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Lemon enhancements:
(1)
Do not allo
c
a
te s
p
ace
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Rem
o
ve the
M
y
SQL upsert synt
a
x
.
As an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Ad
d
supp
o
r
t
f
or
th
e
"excluded
.
*
"
names
i
n the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
ha
r
d Hipp
Merge ch
a
n
ges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Increase
the versio
n
number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Reduc
e
the size of the
Nam
e
C
o
n
t
ext object by
g
r
ouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hipp
Get upsert
w
orking on WITH
O
UT
R
OWID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard H
i
p
p
Make sure cons
t
raint checks occur in the corr
e
ct
order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
First cu
t
at
logi
c
t
o
pe
r
form DO
U
PDA
T
E f
o
r ro
w
i
d
ta
b
les
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard
Hipp
Add infrastru
c
ture for doing an UPDATE a
s
part o
f
a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Mer
g
e the pr
e
update hook chan
g
e f
r
om
t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove
a
n a
l
ways-true
b
ranch from
t
he preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get
the ON
C
ONFLICT DO NOTHING form of
u
p
sert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd
H
ipp
Get the confl
i
ct-target claus
e
p
a
r
s
i
n
g working
c
orr
e
ctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
I
m
proved
c
onf
l
ict-
t
a
r
get
m
a
tch
i
ng lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
rd Hip
p
Back
off of th
e
extended upsert syntax that allow
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
H
ipp
Begin
a
dding upsert logic
.
This is
an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
hard Hipp
Break out the
upsert
c
ode into a separate source
f
i
le
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Fix anot
h
er typ
o
in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
h
a
rd Hipp
Simple comm
e
nt clarification
.
No cod
e
o
r
log
i
c changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Extend the up
s
ert syntax to allow a WHERE c
l
aus
e
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
U
pdate t
h
e
u
psert
p
arsing so th
a
t it a
c
cepts c
o
nflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
H
ipp
Ad
d
t
he
Upsert object for holding ups
e
rt c
l
ause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard
H
ipp
M
erge changes fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ric
h
a
r
d Hipp
Help the parser run faster by a
v
o
i
ding th
e
"expl
a
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Rich
a
rd H
i
pp
Prohi
b
it b
o
und
p
arameters in the a
r
gu
m
ent
s
t
o
table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichar
d
Hipp
Version
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Increase the version number
to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d H
i
pp
Remove an unnecessary SQLITE_UN
T
ESTABLE c
o
m
pile-t
i
me
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
a
rd Hipp
Up
d
ate the top-level README
.
md fi
l
e to point t
o
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard Hipp
Upd
a
t
e the
t
op
-
level
R
EADM
E
.
md
file
t
o point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd Hipp
M
inor changes
t
o t
h
e input gramma
r
resulting in a
f
a
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Enh
a
nce th
e
query plan
n
e
r
so that i
t
de
t
ec
t
s when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
I
m
provem
e
nts
t
o "
.
where
t
race" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
h
a
rd Hipp
F
ix a (har
m
less)
s
igned integer
o
verflo
w
warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Rich
a
r
d
Hipp
More
co
m
plete
p
ars
i
ng
of UPSE
R
T, incl
u
ding UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richa
r
d Hipp
Dem
o
n
s
t
ration of how
the parser can be
a
ugmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ric
h
ard Hipp
Enhance LEMO
N
to show
precendence of
s
ymbols and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Ri
c
hard Hi
p
p
Fix the sqlite3
W
here
T
race mechan
i
s
m
s
o tha
t
it compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richar
d
Hipp
Fix
a
n err
o
r messag
e
in
speedtest1
.
c
a
nd make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix the gener
a
te_seri
e
s
virtual table so th
a
t it c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard
Hipp
Change
t
he L
E
FT
J
O
I
N
stre
n
gth reduct
i
on opt
i
mization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ri
c
hard Hip
p
Version
3
.
2
3
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
i
chard Hipp
B
etter
s
olut
i
on to the LIKE pr
o
bl
e
m f
r
om
t
he pre
v
i
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard H
i
pp
Fix a l
o
gic error discovered by OS
S
Fu
z
z
that c
a
n c
a
use
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix
a bug in the s
p
ellfix ext
e
n
sion ca
u
s
ing it to comp
u
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
hard Hipp
Fix
a
n off-by-one e
r
ror in the dis
t
3 al
g
o
rith
m
of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
M
o
d
i
fy the sq
l
ite3OsFileControl() i
n
terface to detec
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ri
c
h
a
r
d Hipp
Fix a harmless compiler w
a
rning in the kvtes
t
.
exe
p
r
o
gra
m
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
ipp
Fix
a harmless co
m
p
iler warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Remove
t
ab cha
r
acter
s
.
No logical
c
h
a
nges
t
o
c
ode
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Minor comment
c
h
ange
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in the READ
M
E file for ICU
.
No
code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d
Hi
p
p
The pu
s
h
-down
optimization was being too aggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provide the
ability
f
or the VFS to
d
o a blocking
w
ait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
i
chard Hi
p
p
D
o not
i
nject OOM errors on SQLITE_FCN
T
L
_
LOCK
_
TI
M
EOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hip
p
Av
o
i
d a race
c
o
ndi
t
i
o
n that
might cause a busy_tim
e
o
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add infrastr
u
cture
to support for
u
sing F_SETLKW wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refactor some internal objec
t
e
l
em
e
nt na
m
es used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Add t
e
stcase() macros an
d
improve comments
in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richar
d
Hipp
Yet ano
t
h
er fault
i
n the
sq
l
ite3Exp
r
ImpliesNotNu
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Bug fix
i
n t
h
e LEFT JOIN strength redu
c
tion op
t
im
i
zation of
commit
|
commitdiff
|
tree
next