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
Merge enhancements from trunk, especially the CLI fixes.
2018-04-21
D
.
Richard Hipp
Add t
h
e
%extra_context directive
t
o
l
emon, a
s
an
a
lternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Fix UPSE
R
T
s
o
that it plays nicely with A
U
TOINCR
E
M
ENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d H
i
pp
Add
the -dDIRECTORY command
-
l
i
ne
op
t
ion
t
o LEMO
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
F
ix
a
harmless comp
i
ler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Av
o
id
the use of
statement journals on DELET
E
s of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
v
oid
o
pening a statement journal
o
n
single-row
U
PDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Fix a
V
D
B
E comment on u
p
sert
.
Pr
o
vide
an error
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Avoid unnecessary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Improved VDBE comment
o
n UP
S
ERT
c
ode
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
Minor s
i
mplificati
o
n
of the previo
u
s ch
e
c
k
in
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
ipp
Av
o
id unn
e
c
e
ssary cursor s
e
eks during ups
e
rt pr
o
cessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hip
p
Enh
a
n
ce UPSER
T
so th
a
t
the UPDATE uses the
s
ame set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor si
m
pl
i
f
i
c
ation of the cursor alloc
a
tion logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix th
e
handling of "PRA
G
MA count
_
cha
n
ges=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Minor simplification
t
o the upsert
l
og
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the --ups
e
r
t
option to the wordcount
t
est p
r
ogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Add the ext/
m
isc/templatevtab
.
c
t
emplate for virt
u
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a problem in t
h
e
new ups
e
rt imp
l
e
m
ention
,
dis
c
ove
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
Fi
x
the
table
n
ame ali
a
sing on INSER
T
so that it
o
ccu
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Avoid a N
U
LL-po
i
nter deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fi
x
a t
e
st case inside
d
istinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hi
p
p
I
mproved m
a
tching of COLLATE clauses wit
h
in the O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
F
ix a problem in the sqlit
e
3ExprCompare(
)
func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ic
h
ar
d
Hipp
A
dd
s
uppo
r
t for PostgreSQL UPS
E
R
T syntax and
f
unctional
i
ty
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ip
p
Fix the buil
d
for S
Q
LITE_OM
I
T_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard H
i
p
p
Add the -
-
sorterref N opt
i
on to the
C
L
I
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit s
o
me code
n
ot used with
o
ut SQLI
T
E_ENABLE_SORT
E
R
_REFER
E
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichar
d
Hipp
Remove
a
n un
u
sed local varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ic
h
a
rd Hipp
Enhance ALTER
TABLE ADD COLUMN to su
p
port
"DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d Hip
p
Ad
d
c
hecks to t
h
e CLI th
a
t
issu
e
a warning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new test
c
ase() macro
s
and fix a
bug that was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove
unreach
a
ble branches
.
100% MC/DC
in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Added a commen
t
on
t
h
e assert
(
) adde
d
to the pre
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
cha
r
d H
i
pp
Fixes to the logic for c
o
nstra
i
nt ch
e
ck
reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During PRAG
M
A vdbe_
a
ddoptrace=ON,
s
how calls to sqlite3Vdbe
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
har
d
Hip
p
TK
_
RE
G
IS
T
E
R
expressions node
s
ar
e
probably not
constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
Simpli
f
ication
t
o the
u
p
sert
logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ar
d
Hip
p
Ne
w
t
e
st
cas
e
s for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hip
p
Merge the Le
m
on enhanc
e
me
n
t
from
t
r
u
nk,
r
e
sult
i
ng in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Lemon e
n
han
c
e
m
ents:
(1) Do not
a
llocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hi
p
p
R
e
move the My
S
QL
upsert syntax
.
As an
optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
h
a
rd Hipp
Add
support f
o
r the "excluded
.
*" n
a
m
e
s in the UPDA
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Me
r
ge chan
g
es
f
r
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Inc
r
e
ase the ver
s
ion num
b
er to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Reduce the size of the NameConte
x
t object
b
y grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
ichard Hipp
Get
upsert work
i
ng on WITHOUT ROWID tab
l
es
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Mak
e
sure constraint chec
k
s
occur i
n
the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
ha
r
d Hipp
First cut at logic to p
e
rfor
m
DO UPDATE for
r
owid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard H
i
pp
Add infrastruct
u
r
e
for doi
n
g an UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hip
p
Merge the preupdate
h
oo
k
change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
Remove an alw
a
ys-true branch
f
rom th
e
preupda
t
e
hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
Ge
t
the O
N
C
O
NFLICT DO NOT
H
ING form of u
p
s
ert w
o
r
k
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
i
p
p
Get
t
he conflict-targe
t
clause parsing working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Imp
r
oved confli
c
t
-
t
arget matching
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
Back off
of the extended upse
r
t syntax that all
o
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begin add
i
ng upsert l
o
gic
.
Th
i
s is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d
H
i
pp
B
r
eak o
u
t
t
h
e u
p
sert code into a se
p
arate
s
o
u
rce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fix ano
t
her typo i
n
a
c
o
mm
e
nt
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Simple c
o
mment clarification
.
No code or logi
c
chang
e
s
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Extend the u
p
sert syntax to allow
a
WHE
R
E clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd
Hipp
U
p
date
the upsert parsin
g
so
that it ac
c
epts confl
i
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Add the Up
s
ert
o
bject for holding upsert cla
u
s
e
inform
a
tion
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hi
p
p
M
e
rge chang
e
s
from
t
r
u
nk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
char
d
Hipp
H
e
lp the parser run fast
e
r by avoiding th
e
"explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
Hipp
Pr
o
hibit
bound
p
a
r
a
mete
r
s in the arguments to tab
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
rd Hipp
Increase the version
n
u
mber to 3
.
2
3
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove an unneces
s
ary SQLITE_UN
T
E
STABLE c
o
mpile
-
tim
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
Hi
p
p
Update the top-level REA
D
M
E
.
md file to point to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
c
har
d
Hipp
U
p
dat
e
the top-level README
.
m
d file to
p
oi
n
t to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richar
d
Hipp
Mi
n
or ch
a
nges to the
i
nput grammar resulting in a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
i
chard Hipp
Enha
n
ce
the query pl
a
nner so th
a
t it detec
t
s
when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
I
mpr
o
vements to "
.
wh
e
ret
r
ace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
ichar
d
Hipp
F
i
x a (h
a
rm
l
ess) si
g
n
e
d
intege
r
ove
r
flo
w
w
a
rning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richa
r
d Hipp
More comple
t
e parsing of UPSERT, including
UP
S
ERT withi
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Demonstra
t
io
n
of how the parser
c
an b
e
augmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
cha
r
d Hip
p
E
n
h
ance
L
EMON
t
o s
h
ow precendence of symbols and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard
H
i
p
p
Fix
t
he s
q
lite3WhereTrace
m
e
c
han
i
sm so
t
hat
it compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richa
r
d Hipp
Fix an error message in speedtest
1
.
c and make
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
F
i
x th
e
ge
n
erate_
s
eries virt
u
al tab
l
e
s
o
t
hat
i
t
correctl
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
i
chard Hip
p
Ch
a
nge
t
h
e LEFT JOI
N
strengt
h
reductio
n
o
pti
m
iz
a
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ric
h
ard Hipp
Vers
i
on
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
B
etter solution to
t
he LIKE
p
roblem from the previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Ri
c
h
ard Hipp
Fix a lo
g
ic error discov
e
red by OSSFuzz that can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix a bug
in the spellfix
extension causing it to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
hard H
i
pp
Fi
x
an off-by-one error i
n
t
h
e
dist3 algo
r
ithm of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify the sqlite3OsFileControl(
)
i
nte
r
fac
e
to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard Hipp
F
i
x a harmles
s
c
o
mpiler w
a
rning in the kv
t
e
s
t
.
exe p
r
ogram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ri
c
h
a
rd Hipp
Fix a
harmless compiler wa
r
ning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ichard Hipp
Rem
o
ve tab
char
a
cters
.
No l
o
gical chang
e
s
to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard H
i
pp
Minor commen
t
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
F
ix
a
typo in th
e
README file
f
or
ICU
.
N
o
code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
T
h
e
push-d
o
wn o
p
timization w
a
s bei
n
g too a
g
gres
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provide
t
he abil
i
ty f
o
r
t
he VFS to do
a bloc
k
i
ng wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inject OOM errors on SQLITE_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
icha
r
d
H
ip
p
Avoid a race con
d
ition t
h
at might ca
u
s
e
a
busy_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add infrastruct
u
re to
support for
u
sing F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richar
d
Hipp
Refactor some internal obj
e
ct element names used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richar
d
Hipp
Add testcase
(
) m
a
cros and improve c
o
mments
i
n t
h
e LE
F
T
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Yet another f
a
ult
i
n the sq
l
i
te
3
E
x
p
rImpliesNotNull
.
.
.
commit
|
commitdiff
|
tree
next