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
Simplification to the upsert logic.
2018-04-17
D
.
Richard Hipp
Simplific
a
tion to the upse
r
t
logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
New tes
t
cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard
H
i
pp
Merge the Lemon
enhancement f
r
om trunk, result
i
ng in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Lem
o
n enhance
m
en
t
s: (1
)
Do not allo
c
ate
space
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
R
e
move the M
y
SQL up
s
ert syntax
.
As an optional a
l
ias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Add support for the "
e
xc
l
uded
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Merg
e
cha
n
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
hard Hipp
Inc
r
ease the
v
ersion
number to 3
.
2
4
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Red
u
ce the size of
the NameContext object by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
chard H
i
p
p
G
e
t
upsert wo
r
king
on WITHO
U
T ROWID
t
a
bl
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
c
hard Hipp
Make su
r
e
c
onstr
a
int checks occur in the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
First cut at lo
g
i
c to perform DO
U
P
DATE fo
r
rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
hard Hipp
A
dd infr
a
structur
e
for doing an UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
H
i
pp
Merge
the preupdate
hook chang
e
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Rem
o
ve an al
w
ays
-
t
r
ue branch from
t
he preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
Ge
t
the
O
N
C
ONFLICT DO NOTHING form of upser
t
worki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard H
i
pp
Get the
c
onflict-targe
t
cla
u
se
parsing wo
r
kin
g
correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
h
ard H
i
pp
Improved conflic
t
-
target
ma
t
c
h
in
g
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
B
ack off of the extended upsert syntax that all
o
ws
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
Begin adding upsert lo
g
ic
.
This is an in
c
rem
e
ntal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard H
i
pp
Brea
k
out
the
upser
t
code into a separate
sour
c
e
f
ile
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
a
r
d Hipp
F
i
x anothe
r
typ
o
in
a
comm
e
nt
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
S
i
mple comme
n
t clarificatio
n
.
No code or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hip
p
Ex
t
end the upser
t
syn
t
ax to allow
a
W
HERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
U
pdate the
u
p
s
e
r
t parsing so tha
t
it
a
ccepts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
r
d
Hipp
A
dd the Upser
t
ob
j
ect f
o
r ho
l
ding upse
r
t
clause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Merge
c
hange
s
f
rom
t
runk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richar
d
Hipp
Hel
p
the
p
a
r
ser run faster b
y
avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
ichard Hipp
P
rohibit bound param
e
te
r
s i
n
the arguments to t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard Hipp
Increase the v
e
rsio
n
number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ri
c
hard Hipp
Remove an unnecessary SQL
I
T
E_
U
NTESTABLE compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-l
e
ve
l
README
.
m
d fil
e
to point
to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
ch
a
rd Hipp
Update
t
h
e
top-level README
.
md file to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor cha
n
ges to the
input
g
rammar resu
l
ting in a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd
H
i
pp
Enhance the query p
l
anner
so
th
a
t it
det
e
cts
when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
H
ipp
Improvements
t
o
"
.
wheretrac
e
" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard Hipp
Fix a (harm
l
ess
)
s
i
gned integer overflow war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Ric
h
ard Hip
p
More co
m
plete p
a
rsing
of UPSERT, includi
n
g UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richa
r
d Hipp
Demonstration of how
the parser can be aug
m
en
t
ed to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
ichard
H
ip
p
Enha
n
ce
L
E
MON to show precendence of
s
ymbo
l
s and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard H
i
p
p
Fix
t
he sqlite3Wher
e
Trace mech
a
n
i
sm s
o
that it compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard
Hipp
F
ix an erro
r
m
e
ssage i
n
speedtest
1
.
c
and make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ri
c
hard Hipp
Fix th
e
g
e
nerat
e
_
serie
s
virtual table so that it correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
i
chard Hipp
Ch
a
nge
t
he LEFT
J
OIN
s
t
rength redu
c
tio
n
opt
i
miz
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Version 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
i
chard Hipp
Bett
e
r solut
i
on to the LIKE problem fro
m
t
h
e
previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hipp
Fix a logic error discover
e
d by OSSFuzz
t
hat ca
n
cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard
H
ipp
F
ix a bug in the spellfix extension c
a
using it to
c
o
m
pute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
a
r
d Hipp
Fix an o
f
f-by-o
n
e
error in the dist3 algorit
h
m of
the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Ri
c
hard Hipp
Modify the sqlite3OsFi
l
eControl() int
e
rfa
c
e to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Rich
a
r
d
Hi
p
p
F
i
x a ha
r
mle
s
s com
p
ile
r
warning in the kvtest
.
exe pro
g
ram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
c
hard Hipp
F
i
x a harmless compiler warn
i
ng
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
c
h
ard Hipp
Rem
o
ve ta
b
character
s
.
No log
i
cal change
s
t
o code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ichard Hipp
Mi
n
or comment changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in the README file
f
o
r
ICU
.
No code
c
han
g
e
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
The
push-down optimizati
o
n wa
s
being too
a
ggre
s
sive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provid
e
the ability
f
or the
V
F
S
t
o do a bl
o
cking wa
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inject OOM errors on SQLITE_FCNTL_LOCK_
T
IMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
Hipp
Avoid a rac
e
condition that mi
g
h
t
caus
e
a busy_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
i
c
h
a
rd
Hipp
A
d
d in
f
ra
s
truc
t
u
r
e to
s
upport
for
using F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
R
efactor some
internal ob
j
ect el
e
ment
n
ames used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hip
p
Add t
e
s
tcase() macros and improv
e
c
o
mment
s
in t
h
e LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Yet another fault i
n
the
s
qlite3ExprImpl
i
es
N
otNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hip
p
Bu
g
fix in the LEF
T
J
O
I
N strength
r
eduction opti
m
ization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
H
i
p
p
Prepen
d
linkage macros to the sqlite3rebaser
interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hip
p
Fix the -reado
n
ly op
t
ion on the CLI so that it actu
a
lly
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fi
x
typo in a com
m
ent used for
documentati
o
n
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
ard
H
ipp
F
i
x
an
e
rror
in
the CLI i
n
th
e
prev
i
ous
(
[
0
2
49d9aecf699
4
8
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard
H
i
pp
Fix t
h
e ANALYZE comman
d
s
o
t
hat it wi
l
l process t
a
bles
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ric
h
ard Hipp
A
d
d
th
e
left joi
n
streng
t
h
reducti
o
n o
p
timiza
t
i
on
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
R
ichard
Hipp
Add the --
v
alid-sql option t
o
t
h
e optfuzz test
p
ro
g
r
a
m
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Get th
e
optfuzz prog
r
am
wor
k
ing
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
i
chard
Hipp
Ad
d
the
o
ptfu
z
z
.
c program for verifyi
n
g the query planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hi
p
p
Relax LEFT-JOIN restri
c
t
i
ons on the push-down o
p
timiza
t
ion
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Do a more
thoro
u
gh
job
o
f cleaning trac
e
s
o
f the st
r
ength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
If terms of the
W
HE
R
E clau
s
e requi
r
e that the
right
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Rich
a
rd Hi
p
p
Fix incorrect t
e
stcase l
a
bel
s
on two case
s
in
j
oin5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard H
i
pp
Imp
r
ovem
e
nts
t
o the HA
V
ING-t
o
-WHERE optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Avoi
d
unnece
s
sary write to the sqlite_sequence table
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Add the ability to disa
b
le the push-do
w
n
o
p
ti
m
iza
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard H
i
pp
Remove
a
debugging statem
e
nt
a
ccidently left
i
n
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
I
n
the CLI, avoid extra
.
selecttrace and
.
whe
r
e
t
r
ac
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Closer r
e
ading of
the sqlite3_db_con
f
ig() documentat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Fix a minor
f
o
rmatting issu
e
on the sqlite3_db_co
n
fig
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
Add the ability to disable
t
he push-d
o
wn optim
i
zation
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richar
d
H
i
pp
Minor improvements to "
.
selecttrace"
.
No changes t
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard
H
ipp
E
n
ha
n
ce t
h
e comma
n
d-line complet
i
o
n extension to return
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard
H
ipp
I
n
t
h
e compi
l
e_options pra
g
ma, s
h
ow
the actual value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard H
i
pp
Imp
r
ov
e
d "
.
selectt
r
ace" output formatting
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard Hipp
Do not use sqlite3_column
_
decltype()
i
n
the C
L
I
if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard
Hipp
Detect
corruption i
n
the form
o
f
t
he sqlit
e
_sequence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richar
d
Hipp
D
etect datab
a
s
e
s who
s
e
schema
i
s c
o
rrup
t
ed
u
sing
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Bet
t
e
r
error
mes
s
a
g
e text when the
s
chema is
c
orrupted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richa
r
d Hipp
Avo
i
d writi
n
g th
e
sqlite_sequenc
e
table
when i
t
has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Rich
a
r
d
Hipp
Fix a typo
i
n a com
m
e
n
t
u
sed to g
e
n
e
r
a
te
documentati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard Hipp
Fix an
i
ssue wit
h
t
h
e
f
sdir()
t
able-valued fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
R
ichard Hi
p
p
A
d
d t
h
e
SQLITE_DBSTATUS
_
CAC
H
E_SPILL o
p
tion t
o
sqlite3_db_st
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
Di
s
able one of
the test ca
s
es from
c
h
eck-in [2
1
ecbce1378
f
3cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
Add the SQLITE_DB
S
TATUS_
C
ACH
E
_
S
PILL
o
p
tion to sqlit
e
3_db_sta
.
.
.
commit
|
commitdiff
|
tree
next