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
Avoid unnecessary cursor seeking when performing an UPSERT.
2018-04-20
D
.
Rich
a
rd
Hi
p
p
Avoid unn
e
c
e
ssary cursor seeking when performi
n
g an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Improved VDBE c
o
m
ment o
n
UP
S
ERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Minor simp
l
ifica
t
ion of the previous check
i
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
icha
r
d Hipp
Avo
i
d unnec
e
s
s
ary cursor seek
s
during upsert proc
e
ssing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UP
S
ERT so th
a
t
t
he UPDAT
E
u
s
es the sa
m
e set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
Hipp
Minor si
m
plifi
c
ation
of th
e
cursor
a
l
l
o
cation logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd
Hip
p
Fix
t
he handling of
"PRAGM
A
count_changes=O
N
" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
M
inor simp
l
ifica
t
ion to the upse
r
t l
o
gi
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hipp
Add t
h
e --upsert
o
pt
i
o
n
t
o t
h
e wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add th
e
ext/misc/templatevtab
.
c template for vi
r
t
u
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a problem
in the new u
p
sert impleme
n
tion, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix
t
he table nam
e
al
i
asing on INSERT so that
i
t
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Avoid a NULL-pointer
d
eref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Fi
x
a test
c
a
se inside
d
is
t
i
nct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Impro
v
ed matching of COLLATE clauses w
i
t
h
in th
e
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a p
r
o
b
lem in
t
he sqlite3E
x
p
rCo
m
pare(
)
function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add support
for Pos
t
greSQL UPSERT syntax
and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Fix th
e
build for
SQL
I
TE_OMIT_UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the
--s
o
rterref
N
option to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard
Hipp
Omi
t
s
o
m
e
code n
o
t use
d
w
it
h
out SQLITE_ENA
B
LE_SO
R
TER_REF
E
REN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
H
ipp
Remove an u
n
used loca
l
variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d H
i
pp
En
h
an
c
e ALTER TABLE ADD COLUMN
t
o s
u
pport
"
DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
Hi
p
p
Add c
h
ecks to
the
CL
I
that issue a
warning if SQLi
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
H
i
p
p
Add new test
c
ase
(
) macros and fix
a
b
u
g that was reve
a
l
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hipp
R
em
o
ve unr
e
ach
a
ble bra
n
che
s
.
100% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
Ad
d
ed a com
m
ent on the assert
(
)
added
to the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Fix
e
s to the logic for cons
t
raint check reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During
P
RAGMA vd
b
e_addoptrace=ON,
sh
o
w calls to sqli
t
e3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
T
K_REG
I
STER express
i
ons nod
e
s are probably
n
ot constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Simplificatio
n
to the up
s
ert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
N
e
w test cases
for up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
M
erge t
h
e Lemon enha
n
cem
e
nt from
tr
u
nk
,
res
u
lting i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hip
p
Lemon enhance
m
ents: (1) Do not allocate
s
pace for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
r
d
Hipp
Remo
v
e the MySQL upser
t
syntax
.
As an optional
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hip
p
Add support f
o
r the "excluded
.
*
"
names in th
e
UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Me
r
ge
c
h
anges
from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
Increase the version numb
e
r to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Red
u
ce the size of
t
h
e NameCo
n
text object by grou
p
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richar
d
H
i
pp
Ge
t
upsert worki
n
g on
WI
T
HOUT RO
W
ID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hip
p
Make
s
u
r
e constraint che
c
k
s
occur i
n
the c
o
rrect ord
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
First cut a
t
log
i
c
to
p
erfo
r
m DO UP
D
ATE for rowid table
s
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Add in
f
rastructure for do
i
ng
a
n UPDATE as part of a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Me
r
ge the pr
e
update ho
o
k change
from
t
r
u
nk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Remove an always-true branch fr
o
m t
h
e
preupdate hoo
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
h
a
rd Hipp
Get the ON CONFLI
C
T D
O
NOTHING form of upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hi
p
p
Get the
conflict
-
target c
l
ause pa
r
si
n
g
working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hipp
Improved conflict-
t
arget matching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back off of the extended upsert syntax
t
hat allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
B
egin adding
u
p
sert log
i
c
.
T
h
is is an i
n
crement
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hipp
Break out the upsert
c
ode
i
n
to a separ
a
t
e source f
i
le
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fix another typ
o
i
n
a c
o
mment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
S
imple comment clarificati
o
n
.
No code or logic
c
hanges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Exte
n
d the
ups
e
rt
synta
x
to allow a WHE
R
E
c
lause
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Up
d
ate the u
p
ser
t
parsin
g
so that it acc
e
pt
s
c
o
nf
l
ict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
Add
t
he Upsert object
f
or h
o
lding upse
r
t clause i
n
f
orm
a
tion
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
M
erge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
H
e
lp the parser run f
a
s
t
er by avoid
i
ng the
"
explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richa
r
d
H
i
pp
Prohibit bound parame
t
ers
in t
h
e
argum
e
nts to ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version
3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
Hipp
I
nc
r
ease
t
h
e ve
r
s
ion
n
umber
to
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remo
v
e
an
unneces
s
ary SQLIT
E
_UNTES
T
ABLE compile-tim
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard Hi
p
p
Update
the top-level
R
EAD
M
E
.
md file
t
o poi
n
t to t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Update the
to
p
-l
e
vel README
.
m
d
file to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard Hi
p
p
M
i
n
or cha
n
ges to the in
p
u
t
gra
m
mar resul
t
ing in a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
ic
h
ard Hipp
Enhan
c
e
t
he query planner so that it det
e
cts
w
he
n
th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hi
p
p
Improvements to
"
.
whe
r
etrac
e
" out
p
ut
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd H
i
pp
Fix a (harmless) signed
in
t
e
ger overflow warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard
H
ip
p
More c
o
mpl
e
te parsing of
UPSERT, including U
P
SERT
w
ith
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard
Hipp
D
e
mon
s
trat
i
on of h
o
w
the parser can
be
a
ugmente
d
to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
chard H
i
pp
Enhance LE
M
ON to sho
w
precen
d
en
c
e of symbo
l
s and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Ric
h
ard Hipp
Fix
the sqlite3WhereTrace
mechanis
m
so that i
t
compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
ard H
i
pp
F
i
x an error message
in
s
peedt
e
st1
.
c
and make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard Hipp
Fix the
generate_series virtual t
a
ble so that it correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change the
L
E
F
T JOIN strength reduct
i
on opti
m
iz
a
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Vers
i
o
n
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard H
i
pp
B
e
tter so
l
ution to the LIKE problem
f
rom the
pre
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
R
ichard Hip
p
Fix a
logic err
o
r d
i
scovered
b
y OSSFuzz
t
hat can
c
ause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
ard Hi
p
p
Fix a bu
g
i
n the sp
e
llfix ex
t
ension causing it to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix
a
n off-by-one error in
the
dist3 al
g
orit
h
m
o
f
th
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richa
r
d Hipp
Mod
i
fy the
sqlite3OsF
i
leCo
n
tro
l
() interf
a
ce to d
e
t
e
ct
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ic
h
ard Hi
p
p
Fix a harml
e
ss compiler warning in the kvtest
.
exe program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ic
h
ard H
i
pp
Fix a
h
arml
e
ss
compil
e
r warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ri
c
hard Hipp
Remove tab cha
r
acters
.
N
o
logical cha
n
ges
t
o
c
ode
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
c
hard Hipp
Minor comm
e
nt chan
g
es
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in th
e
REA
D
ME file for
I
CU
.
No c
o
de changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard H
i
pp
The
p
ush-down optim
i
zation was
being
t
oo aggres
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Ri
c
har
d
Hipp
Prov
i
d
e the ability for the VFS to do a block
i
ng
wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hip
p
D
o
not inject OO
M
errors on SQL
I
TE_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ric
h
ard H
i
pp
A
v
oid a race co
n
d
i
tio
n
tha
t
might
cause a
busy_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ric
h
ard
Hipp
Add i
n
frast
r
uct
u
re to s
u
ppo
r
t f
o
r using F_SE
T
LKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refactor
s
ome int
e
rnal object element n
a
mes us
e
d by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Add test
c
ase() macros and
i
mprove co
m
ments in the L
E
FT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Rich
a
rd Hipp
Yet another fault in the sqli
t
e
3Exp
r
Impl
i
e
s
NotN
u
ll
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richa
r
d
H
ipp
Bug fix in the
L
E
FT JOIN st
r
ength redu
c
tion o
p
t
i
miz
a
tion
of
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
icha
r
d Hipp
Pre
p
e
n
d
li
n
k
a
g
e m
a
cros to the sq
l
ite3reba
s
er interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the -
r
eadonly
o
p
t
ion
on th
e
CLI
s
o that it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
ha
r
d Hipp
Fix typo in
a comment
u
s
ed f
o
r documentation
.
No chang
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
i
chard H
i
pp
Fix an err
o
r in the
C
L
I in the
previous ([0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the
AN
A
LYZE command so t
h
at
i
t will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richa
r
d Hip
p
Add
the l
e
ft join
s
trength re
d
uction opti
m
i
zation
.
.
.
.
commit
|
commitdiff
|
tree
next