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
New test cases for upsert.
2018-04-17
D
.
Rich
a
r
d
Hipp
New
t
est c
a
ses for
upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Merge the Lemo
n
enhancement from trunk, re
s
ultin
g
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d H
i
pp
Le
m
on e
n
hancements: (1) Do
n
o
t allocate
s
pace fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
R
e
m
ove
t
he
M
y
S
QL upsert
s
yntax
.
As an optional
a
lias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ich
a
rd Hipp
A
d
d sup
p
ort fo
r
the "excluded
.
*" n
a
m
e
s
i
n
th
e
U
P
DATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
h
ard Hipp
M
e
rge changes from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard
H
i
pp
In
c
r
ease t
h
e version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Reduce the
size of
t
he
N
ameCont
e
xt ob
j
ect by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert
w
o
rking on WI
T
HOUT ROWI
D
tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
M
ake su
r
e cons
t
r
a
i
nt checks occur in
t
h
e
corr
e
ct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hip
p
Fi
r
st cut at logic to perfor
m
DO
U
P
DATE for row
i
d tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard
H
ipp
Add infrastru
c
ture for doing an
U
PDATE
as part
o
f an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Merge the preup
d
ate
hook
c
h
ange from
t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
R
emove an always
-
true
branch from the
p
reupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hi
p
p
Get t
h
e ON CONFLI
C
T D
O
N
OTHING
f
or
m
of up
s
ert
w
orking
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
G
et the con
f
lict-targ
e
t clause
p
a
rsing wo
r
king co
r
re
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
ha
r
d
Hipp
I
m
p
r
oved conflict-target matchin
g
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
a
r
d Hipp
Back off of the extended up
s
e
rt s
y
ntax that allo
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard
H
ipp
Begin
adding upsert
l
ogic
.
This
i
s an incr
e
mental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Break ou
t
t
h
e upse
r
t
code
i
nt
o
a separate sour
c
e file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
F
ix another typo in
a
comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Sim
p
le c
o
m
ment
c
larif
i
c
a
tion
.
No code or logi
c
ch
a
nges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
H
ipp
Extend the upsert syntax
t
o allo
w
a WHERE
c
lause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hi
p
p
Update the upsert parsing
s
o that it accept
s
conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
char
d
Hipp
Add the Upsert object
f
or holding
u
ps
e
rt clause i
n
format
i
o
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard
H
ipp
Merge changes
f
rom
trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
chard Hipp
Hel
p
the pa
r
ser run faster by avoiding the
"
explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richa
r
d H
i
pp
Prohibit
bound para
m
eters in the argu
m
ents
to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Increa
s
e
t
h
e vers
i
on nu
m
ber to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove an unnecessary S
Q
LITE_UNTEST
A
BLE compile
-
t
ime
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
rd Hi
p
p
U
pdate the top-le
v
el
READM
E
.
md fil
e
to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
U
p
date the top-level README
.
md
file to po
i
nt to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
i
char
d
H
i
pp
Minor changes
t
o the input gra
m
mar
r
esulting in a fa
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Enhance the
q
uery planner so
t
h
at it detects when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard H
i
pp
Improve
m
ents to "
.
wheretr
a
ce" o
u
tput
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richa
r
d Hipp
Fi
x
a (
h
arml
e
ss) signed integer over
f
low warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
R
i
ch
a
rd Hipp
More
complete par
s
ing of UPS
E
R
T, includ
i
ng UP
S
ERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hip
p
Demonstration of how the parser can b
e
augmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhance LEMON to show p
r
ecendence of symbols and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Ric
h
ard Hipp
F
ix th
e
s
qlite3Wh
e
r
eTra
c
e mechan
i
sm so that it com
p
i
les
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix an err
o
r me
s
s
a
ge in speedtest1
.
c and make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richar
d
Hipp
Fix the
generate
_
series vir
t
ual table so that it correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
ard Hipp
Ch
a
ng
e
th
e
LEFT JOIN
strengt
h
reduc
t
i
on optimiz
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Version 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Better
so
l
u
tion to t
h
e
LIKE problem f
r
om th
e
previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Ric
h
ard Hipp
F
ix a
l
ogic err
o
r discovered by OSSFuzz tha
t
can cau
s
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
h
a
r
d
H
ipp
Fix a bug in the s
p
el
l
f
i
x extension
causing i
t
to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Rich
a
r
d
Hipp
Fix a
n
off
-
by-o
n
e error
i
n the dist3 algorith
m
of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Ric
h
ard Hipp
Modify th
e
sqli
t
e3OsFileContr
o
l() int
e
rface to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ric
h
ar
d
Hipp
Fix a har
m
l
e
ss compiler warning in the kvt
e
st
.
e
x
e
progr
a
m
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard H
i
pp
Fix a
harmles
s
compi
l
er warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
ipp
Remove tab charact
e
rs
.
No l
o
gical
c
hanges to
c
o
d
e
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard Hipp
Minor comm
e
nt change
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a
typo in the READM
E
file for ICU
.
No code
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
The push-d
o
wn optimization
w
as
b
e
ing to
o
a
ggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard
H
ipp
Pro
v
i
de the ab
i
l
it
y
for
t
h
e VFS
t
o do a blockin
g
wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richa
r
d
Hipp
Do not
injec
t
OOM errors on SQLITE_FCNTL_LOCK_TIMEOU
T
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avo
i
d a ra
c
e conditi
o
n
t
h
at might c
a
u
s
e a busy_timeo
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
Hi
p
p
A
d
d infra
s
tr
u
cture to su
p
port for
us
i
n
g
F_SETL
K
W wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
R
e
fact
o
r some interna
l
o
b
j
ect
e
l
ement
names us
e
d by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Ad
d
tes
t
ca
s
e() macros and im
p
ro
v
e c
o
mments in
t
h
e
LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
H
i
pp
Yet another fault in
t
he sqlit
e
3ExprImpliesN
o
tNu
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richa
r
d Hi
p
p
Bug fi
x
in
the
LEFT JOIN strengt
h
r
e
duction
optim
i
z
ation of
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
chard Hipp
Prep
e
nd link
a
ge
macros to
t
he sqlite3rebaser interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richar
d
Hipp
Fix the -readonly opt
i
on
on the CLI so that it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fi
x
typ
o
in a comment
used for documentation
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
hard Hi
p
p
Fix
a
n error in the
C
L
I in the
p
re
v
i
ous (
[
0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Rich
a
rd Hipp
Fix
the ANALYZE command
so that it will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hip
p
Add
t
he left joi
n
strength
r
e
d
ucti
o
n optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ri
c
h
a
rd
Hipp
A
d
d
the --valid-sql option t
o
the op
t
fuzz t
e
st program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hi
p
p
Get
th
e
optfuz
z
program wo
r
kin
g
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
i
ch
a
rd H
i
pp
Ad
d
the optf
u
zz
.
c prog
r
am for verifyi
n
g
the query
p
lanner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
hard Hipp
Relax LEFT-JOIN restrictions on the push-down
o
ptimization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
D
o
a
more thoro
u
gh job of
cleanin
g
traces of the strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hi
p
p
If
t
erms
of the WHERE clau
s
e require t
h
at
t
he r
i
g
ht
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Fix in
c
orrect te
s
tcase la
b
els on two c
a
s
e
s
in jo
i
n5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Im
p
rove
m
ents to t
h
e HAVING-to-WHERE optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
Av
o
id unnecessary write
t
o the
s
qlit
e
_sequence ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hip
p
Add the ability
t
o disabl
e
the push-down optimi
z
ati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
ha
r
d Hipp
Re
m
ove a debug
g
ing
state
m
ent
a
ccidently left
i
n
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
H
ipp
In
th
e
C
L
I,
avoid
e
xtra
.
sele
c
ttrac
e
a
nd
.
wheretrace
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Cl
o
s
e
r rea
d
i
n
g of the s
q
lite3_db_
c
o
n
fig()
documentation
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Fix a
m
i
nor for
m
attin
g
i
s
sue on the
s
q
l
i
te3
_
db_con
f
ig
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Add th
e
a
bi
l
i
ty to
di
s
able
t
he pus
h
-down optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ric
h
ar
d
H
i
p
p
Minor improvem
e
nts
to "
.
sel
e
cttrace"
.
No changes to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ric
h
ard Hipp
Enhance the com
m
and-li
n
e comple
t
i
o
n
extension to return
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Rich
a
r
d
Hi
p
p
In
t
he compile_options pragma, show the actua
l
valu
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard
Hipp
Improved "
.
sele
c
tt
r
a
ce" output formatting
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard Hi
p
p
Do not
use
sqlite3_col
u
m
n
_d
e
cltype() in
t
he CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
De
t
ect corrupti
o
n in the fo
r
m of the
s
qlite
_
sequence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ri
c
h
ard Hip
p
Detect databases
whose schema i
s
co
r
rupt
e
d usin
g
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Better e
r
ror message t
e
xt whe
n
t
he schema
i
s
corrupted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Avoid wr
i
ting the sqlite_seque
n
ce table when it has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard Hip
p
F
i
x
a typo in a commen
t
used to gener
a
te docume
n
t
ation
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard Hipp
F
i
x an i
s
su
e
with the fsdir() table-valued
f
un
c
ti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Rich
a
r
d
Hipp
Add the
S
QLITE_DBSTATUS_
C
ACHE
_
SPILL o
p
tion to sqlite3_db_st
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Rich
a
rd Hipp
D
i
sab
l
e
o
n
e of the te
s
t cases fr
o
m check-in [2
1
ecbce1378f3
c
c
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
A
d
d
th
e
S
Q
L
ITE
_
DBSTATUS_CACHE_SPILL option to sqlite3_db_
s
ta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
R
i
c
h
ard
H
i
pp
Fix the secon
d
callback a
r
gument to the "profi
l
e" res
p
onse
.
.
.
commit
|
commitdiff
|
tree
next