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
Minor simplification of the cursor allocation logic for update.
2018-04-20
D
.
Richard Hipp
Minor simplif
i
cation of the cursor
allocation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the handling of "PRAGMA
c
ount_changes=ON"
wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplification to
t
h
e
u
psert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the
--upsert option t
o
the wordcount test p
r
ogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Add th
e
e
x
t/misc
/
templatevt
a
b
.
c
t
empla
t
e for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard
Hip
p
Fix a problem in
t
he ne
w
u
p
ser
t
implemention, discovere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
the table name ali
a
sing on INSERT so that
it occu
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d Hipp
Avoid a N
U
L
L-poi
n
te
r
deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd
Hipp
Fix a test case
i
nside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard H
i
pp
I
m
proved matching of COL
L
ATE clause
s
withi
n
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fix a
p
rob
l
em in the sqlite3
E
x
p
r
Compa
r
e(
)
func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
Hipp
Add
s
upp
o
rt for Postg
r
eSQL
UPS
E
RT syntax an
d
functio
n
ality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Fix
the build for
S
QLI
T
E_OMI
T
_
UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the --sorte
r
ref N
option
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Omit some
c
ode not u
s
ed
without SQLITE_ENABLE
_
SORT
E
R
_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hi
p
p
Rem
o
ve an unus
e
d local variab
l
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Enha
n
ce
A
L
TER TABLE ADD C
O
L
U
MN to su
p
port "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add che
c
ks to
the CL
I
that issue a warning if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Ad
d
new
t
estcase()
m
acros and fix a
bug tha
t
was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
H
ipp
Remove
u
nr
e
achab
l
e branches
.
100%
M
C/DC
i
n
T
H
3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Added a
c
omment on the assert
(
)
added to th
e
previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Fixes
t
o
the logic for c
o
nstraint
check
reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
ha
r
d
H
i
pp
During PRAGMA vdb
e
_
addoptr
a
ce=ON, s
h
o
w
calls
t
o
s
qlite3V
d
beR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
TK_RE
G
ISTER expression
s
nodes are
p
r
o
babl
y
no
t
constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
r
d
Hipp
S
i
mplification to the
upse
r
t log
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
New test cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
M
er
g
e
the Lemon enhanc
e
men
t
f
r
om
t
runk, res
u
lting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hip
p
Lemon enha
n
c
e
men
t
s
: (
1
) Do not al
l
oca
t
e sp
a
ce for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
hard Hipp
Remove t
h
e MySQL upsert syntax
.
A
s
an optio
n
al alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
har
d
Hipp
Add suppo
r
t for the
"
excluded
.
*"
names in
t
h
e UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge changes from t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
i
pp
Incre
a
se the vers
i
on
n
u
mber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Reduce
the siz
e
of the
NameContext object by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richa
r
d
Hipp
Get
u
p
s
ert working on
W
ITHOUT ROWID tabl
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hipp
Make
sure constraint ch
e
cks occur in the
cor
r
ect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
First
c
ut
at logic to
p
erform DO
UPDAT
E
for rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
i
p
p
Add infra
s
tructure for doing an
UPDATE as pa
r
t of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Merge the
preupdate hook change
from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove a
n
always
-
true
b
r
anch from t
h
e preupdate
hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
Get the O
N
CONFLICT DO NOTHING form of upsert
w
o
r
k
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d H
i
pp
Get the con
f
lict-
t
arg
e
t
clause parsing
w
orki
n
g c
o
rrec
t
ly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Improv
e
d c
o
nflict-ta
r
get
ma
t
chi
n
g lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ic
h
ard Hipp
Back of
f
of the exten
d
ed upsert syntax that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
hard Hipp
Begi
n
a
d
d
ing upsert logic
.
This is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
hard
H
ipp
B
r
eak
out the upsert
c
ode
into a separa
t
e sou
r
ce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Fix anothe
r
t
y
po in a comme
n
t
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Simple comment clarif
i
catio
n
.
No c
o
de
o
r logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Extend the upsert
s
yntax t
o
a
llow
a
WH
E
RE cla
u
se on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Update the upsert parsing so
t
hat it acce
p
t
s
confl
i
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Add the Upsert objec
t
f
o
r holding upsert clau
s
e i
n
fo
r
mation
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hipp
M
e
rge chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richar
d
Hi
p
p
Hel
p
the par
s
er ru
n
faster
b
y
a
voiding the "explai
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
hard Hipp
Prohibit bound param
e
ters in the arg
u
ments
to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Versi
o
n 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
Increase the version number to
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove an unnecessary SQLITE_UNTESTABLE compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
H
ipp
Update th
e
top-level
README
.
md file to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard Hipp
Upda
t
e the top-level
R
EA
D
M
E
.
md file to point
to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
Hipp
Min
o
r chan
g
e
s
to
th
e
i
nput grammar re
s
u
l
ting in a fas
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Enhance th
e
query pla
n
ner so that it detects whe
n
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Improve
m
ents to
"
.
w
heret
r
a
ce
"
output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Fix
a (har
m
le
s
s) si
g
n
ed in
t
eger
overflow w
a
rnin
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
R
icha
r
d Hip
p
More c
o
mplete parsing of
UPSERT, i
n
cluding UPSERT
wi
t
hin
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ri
c
hard H
i
pp
Demonstrati
o
n of h
o
w th
e
parser ca
n
b
e
a
ugmente
d
to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
ic
h
ard Hipp
Enhance LEMON to show precendence
o
f symbols and all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Ric
h
a
rd Hipp
Fix the
sqlite3Whe
r
eTrace mechanis
m
s
o
that
it c
o
mpiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
i
chard
Hipp
Fix an e
r
ror
m
ess
a
ge in sp
e
edtest1
.
c and
make
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hi
p
p
F
i
x
t
he g
e
nerat
e
_ser
i
es
v
irtua
l
t
ab
l
e so that it corr
e
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change the LEFT JOIN stre
n
gth reduction optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ric
h
ard Hipp
V
ersion 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard
H
ipp
Bet
t
er
sol
u
tion to
t
he
L
I
K
E problem from t
h
e previ
o
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard
Hip
p
Fix a log
i
c error
discovered by OSS
F
uz
z
that can caus
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard
H
ipp
Fi
x
a
b
ug in th
e
spellfix
ex
t
ension causi
n
g
it
to co
m
pute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard
Hipp
Fix a
n
off-by-one
e
rror in t
h
e dist3 algorit
h
m of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify
th
e
s
q
l
i
te3OsFileControl
(
) inte
r
face to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fix
a
harml
e
ss compiler
warning
i
n the kvtest
.
exe program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
F
ix a har
m
less co
m
p
i
ler warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
R
e
move tab characte
r
s
.
No logical changes to c
o
de
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
ipp
Mi
n
or comme
n
t cha
n
ges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hip
p
F
i
x
a typo
i
n
t
he READM
E
file fo
r
ICU
.
No code c
h
a
n
ges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Th
e
push-down op
t
imization
was being
too
a
ggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard H
i
pp
Provide the ab
i
lity
f
or the
VFS
t
o do a blo
c
k
i
ng w
a
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richa
r
d
Hipp
Do not inject OOM errors on SQLI
T
E_FCNT
L
_LOCK_
T
IMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
ichard Hipp
Avoid a rac
e
c
o
n
d
ition that
m
ight caus
e
a bu
s
y_timeo
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
A
d
d
i
n
f
rastructure
to
s
u
p
por
t
for using F_SETLK
W
with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refa
c
tor some internal ob
j
ect element n
a
mes
used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Add
t
estcase() macros a
n
d imp
r
ove comme
n
ts in t
h
e LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Yet
a
nother fault in the sqlite3Exp
r
ImpliesN
o
tNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
Hi
p
p
Bug fix in th
e
LEFT JO
I
N stre
n
g
th reduction optimization o
f
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richar
d
H
i
pp
Prepend linkage
macro
s
to the sqli
t
e3rebaser i
n
ter
f
aces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the -reado
n
ly o
p
tion
o
n
t
h
e CLI so that it
actua
l
ly
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix typo i
n
a comment used
f
o
r do
c
um
e
ntation
.
No cha
n
g
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix an error in the CLI in the previous ([0249d9ae
c
f69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
i
chard Hipp
Fix the A
N
ALYZE
c
o
mma
n
d so that it will pr
o
c
e
ss tab
l
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hip
p
Add
t
he
left join strength reduction optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hipp
A
d
d the
-
-va
l
id-sql option to the op
t
fuzz tes
t
program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
ich
a
r
d
H
ipp
Get the optfuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hip
p
Add the optfuzz
.
c
p
rogra
m
for
verifying the query planne
r
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
h
a
r
d Hip
p
R
e
l
a
x
L
EFT-JOIN restrictions
o
n the p
u
sh-down op
t
imization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d Hipp
Do a more thor
o
u
g
h job
o
f cleaning t
r
aces
of t
h
e st
r
eng
t
h
.
.
.
commit
|
commitdiff
|
tree
next