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
Remove the MySQL upsert syntax. As an optional alias to the insert table
2018-04-16
D
.
Ri
c
h
a
rd Hipp
Remove the MyS
Q
L
u
psert synt
a
x
.
As an o
p
tional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Add support
f
o
r the "excluded
.
*" n
a
m
e
s in the UP
D
ATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merg
e
changes fro
m
trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
Increase the
v
ersion number t
o
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
R
e
du
c
e the size of the
N
ameContext ob
j
ec
t
by group
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hipp
G
e
t
u
pser
t
working
on WI
T
HOUT ROWID ta
b
le
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ric
h
ard
Hipp
Make
sure co
n
s
t
r
a
int checks occ
u
r in the
correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
F
i
rst cut at lo
g
ic to perform DO UPDATE for rowid
t
ables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
Add i
n
frastructure
f
or doin
g
an UPDATE
a
s
part
o
f an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Merge the preupdate hook cha
n
ge
f
rom t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
R
em
o
ve an alway
s
-
true branch from the pr
e
update hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
G
et t
h
e
O
N CONFLICT
D
O N
O
T
H
ING
f
or
m
of up
s
ert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
rd Hipp
G
e
t
t
he c
o
n
f
l
i
ct-target c
l
ause parsing working
c
orrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d
Hipp
Impro
v
ed conflict-target
m
a
tching l
o
gic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
h
a
r
d Hipp
Back
off
o
f the extended u
p
sert s
y
ntax
that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
B
egin adding upsert logic
.
This is an
i
n
c
remental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hi
p
p
Bre
a
k out the ups
e
r
t
code into
a
sepa
r
ate source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hipp
Fix another typo
i
n a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d H
i
p
p
Simple commen
t
clarification
.
N
o
code or logic ch
a
n
ges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Extend the upser
t
synta
x
to
allo
w
a
WHERE clause
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Upd
a
te the upse
r
t parsing so that it
a
ccepts
c
onflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Add the
U
psert object for
h
olding up
s
ert clause in
f
ormation
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Merge change
s
from tr
u
nk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
hard Hi
p
p
H
e
lp the
pa
r
s
er run fa
s
ter by
avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
chard Hipp
Proh
i
b
i
t
b
ound parameters i
n
t
he
a
rgum
e
nts to
tabl
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard Hip
p
Vers
i
on 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richar
d
Hipp
Increase the vers
i
on number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard
Hipp
Re
m
ove an unnecessary SQLITE_UNTESTABLE
co
m
pile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top
-
level README
.
md file to
po
i
nt to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ich
a
rd Hipp
Update
t
he top-le
v
el README
.
md file to point t
o
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor cha
n
ge
s
to the input
g
r
ammar r
e
sulting in a
f
a
ster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
ichard Hi
p
p
Enhan
c
e the query planner s
o
th
a
t it d
e
te
c
ts when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard Hipp
Improv
e
m
e
nts to
"
.
where
t
race" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Fix
a
(harm
l
e
s
s)
signed
i
n
t
e
g
er o
v
erflow warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard Hipp
M
o
r
e complete parsing of UPSERT, including UPS
E
R
T
w
ithin
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard
H
ipp
Demonstration
o
f how the pars
e
r can
b
e augmented
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enh
a
n
c
e LEMON to show precende
n
ce of symbols a
n
d
all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
R
ichard
Hipp
Fix the
s
qlite3Wh
e
reTrac
e
mechanism so
th
a
t
it co
m
piles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix an er
r
o
r
m
e
s
sage in speedtest1
.
c and m
a
ke th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ri
c
hard Hipp
Fix the generate_series virtual
table so that
it
c
o
r
rectl
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard Hipp
C
h
ange the LEFT
JOIN strength reduction optimi
z
ation
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard
H
i
p
p
Version 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richa
r
d Hipp
B
e
tter solution to the LIK
E
problem fr
o
m
the previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hipp
Fix a logic er
r
or dis
c
overed by
O
SSFuzz that can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richar
d
H
ipp
Fix a bug in
the
s
pellfi
x
exte
n
sion causing i
t
to
c
o
m
p
ute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard H
i
pp
Fi
x
an off-by-one error in t
h
e dis
t
3 algorithm of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify the sqli
t
e3O
s
FileControl() interf
a
ce t
o
detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ri
c
hard
Hipp
Fix a
h
ar
m
l
e
ss compi
l
e
r
warning
i
n the kv
t
est
.
exe
program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fix a harmless compi
l
er war
n
ing
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richar
d
Hipp
Remove
tab char
a
cters
.
No l
o
gic
a
l
chang
e
s to c
o
de
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richar
d
Hipp
Minor comment
ch
a
nges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in the R
E
ADME f
i
le
for ICU
.
No code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hip
p
The push-d
o
wn
o
p
timi
z
a
t
ion
was
being to
o
a
ggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
i
chard Hi
p
p
Provide th
e
a
bility for the VFS
t
o
do a block
i
ng wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Rich
a
rd Hipp
Do not inject OOM
err
o
r
s on SQLI
T
E
_
FCN
T
L_LOCK_TIME
O
U
T
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
i
c
h
a
r
d
H
ipp
Avoid a race condition
th
a
t
migh
t
cause a bus
y
_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add inf
r
a
s
tructure to support for us
i
ng F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Re
f
actor some internal obje
c
t ele
m
ent names
u
sed by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
cha
r
d
Hipp
Add testc
a
se()
m
acros and improve comments
in t
h
e LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
ichard Hipp
Yet another fa
u
lt in
t
he
s
qlite3Exp
r
ImpliesN
o
tNu
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Rich
a
rd
H
ip
p
Bug fix in the LEFT JOIN
s
trength
r
eduction
o
ptimizatio
n
of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
Hipp
Prepend
l
i
nkag
e
m
acros to the sqli
t
e3r
e
baser interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the -reado
n
ly option on t
h
e
CLI so that it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix
typo
in a
comment used f
o
r documentation
.
N
o
chan
g
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Rich
a
rd Hipp
Fix an
e
rror in the
C
LI in
t
he
p
r
e
v
ious ([0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
F
ix the ANALYZE comman
d
so
t
hat
i
t will process table
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richar
d
Hipp
A
dd
the le
f
t
join strength reduction op
t
imization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hi
p
p
Add the --valid-s
q
l option to the op
t
fuzz
tes
t
program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Get
the optfuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Add the optf
u
zz
.
c p
r
ogram for verifying
the
quer
y
planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
R
elax LEFT-JOIN r
e
stric
t
ions
on the push
-
do
w
n optim
i
z
a
tion
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Do a more thor
o
ugh job of cleaning tra
c
e
s of
t
h
e
strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hip
p
I
f
te
r
ms of the WH
E
R
E
c
l
a
use requir
e
that the right
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
Hipp
Fix
i
ncorrect t
e
stcase l
a
bels on two cases in join
5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Imp
r
ovem
e
n
t
s to t
h
e HAVING-to-WHE
R
E
opt
i
mization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Rich
a
r
d
H
i
p
p
A
void unn
e
c
e
ssary
w
r
ite to the sqlite_seq
u
ence table
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Add t
h
e
a
b
ility to disable
the push-down
optimization
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
ichard Hi
p
p
Rem
o
v
e a
d
eb
u
g
ging
statement acc
i
dent
l
y
l
eft i
n
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
H
ipp
In t
h
e
CLI, avoid extra
.
selecttrace and
.
wheretra
c
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
cha
r
d Hipp
Closer re
a
d
i
ng of the
s
qlite
3
_db_co
n
fig(
)
d
ocumentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard H
i
pp
Fix a
minor fo
r
matti
n
g issue on the sqli
t
e3_db_conf
i
g
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d Hipp
A
dd the abi
l
ity to disable
the push-dow
n
optimizat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richar
d
Hipp
M
in
o
r im
p
ro
v
em
e
nts to "
.
selecttrace"
.
No c
h
anges to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hip
p
Enhanc
e
t
h
e comm
a
n
d-line completion extension to
r
eturn
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
R
i
cha
r
d Hipp
In th
e
c
ompile
_
op
t
i
o
n
s
pragm
a
, sho
w
the ac
t
ua
l
value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ri
c
h
a
rd Hipp
I
m
prove
d
"
.
selec
t
trace" output formatting
.
No
c
h
a
nges
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard Hipp
Do not use sqlite
3
_column_
d
ecltype() in the CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
De
t
e
c
t corruption
i
n
th
e
form of the sqlite_
s
equence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard
H
ipp
D
e
tect databas
e
s whose
s
c
hema is
c
o
rr
u
pted using a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Better err
o
r m
e
ssage text when the sc
h
em
a
is corrupted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Avoid writing
t
h
e
s
q
l
i
te_sequence table
when it has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard Hipp
Fix a
t
y
po i
n
a co
m
m
ent used to genera
t
e
doc
u
mentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard
H
ipp
Fi
x
an
issue with the
f
sdir() table-valued functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Ri
c
hard H
i
p
p
Add the SQLITE_DBSTATUS_C
A
CHE_S
P
ILL option to
sqlite3_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
R
icha
r
d
Hipp
D
i
sa
b
le o
n
e of th
e
test cases
from
c
h
eck
-
in
[
21ecbce1
3
78f3cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Ric
h
ard Hip
p
Add the SQL
I
TE_DBSTATUS_CAC
H
E_SPILL option to sqlit
e
3
_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hi
p
p
Fix the second callback argu
m
ent to the "p
r
ofile"
response
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hipp
Add supp
o
r
t
fo
r
INSERT OR
R
E
PLACE and INSERT OR IG
N
O
R
E
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hi
p
p
Improve
d
error mes
s
ages
f
rom the zipfile extension
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
hard Hipp
Avo
i
d harmle
s
s left-shifts of negative numbers in the
.
.
.
commit
|
commitdiff
|
tree
next