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
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines
2018-04-13
D
.
Ri
c
h
a
r
d Hi
p
p
Add
i
nfrast
r
ucture for doing
an UPDATE as par
t
of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d Hipp
Mer
g
e the preup
d
a
te
hook change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hip
p
Remov
e
an al
w
ay
s
-true branch fr
o
m the
preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
a
r
d
H
ipp
Get the O
N
CONFL
I
CT DO NOTHING form
o
f upsert
w
orking
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Get the
conflic
t
-tar
g
et
c
l
a
use
p
ar
s
ing working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
Improve
d
c
o
nflict-ta
r
get ma
t
chi
n
g logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hi
p
p
Back
off of the extended upser
t
synta
x
t
h
at allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
rd Hipp
Begin
a
dding up
s
ert log
i
c
.
Th
i
s is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
B
reak o
u
t
the ups
e
rt code i
n
to a separate source
f
ile
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hipp
F
i
x
a
n
o
t
her typo in a c
o
mment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
char
d
Hi
p
p
Simp
l
e c
o
mment clarification
.
No
c
ode
o
r logic
c
h
a
ng
e
s
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Exte
n
d the upsert syntax to allow a WHERE cl
a
use
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Upd
a
te th
e
upsert pars
i
ng s
o
that it accep
t
s conf
l
ic
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Ad
d
the Upsert object for
h
o
l
ding
u
ps
e
rt
clause
information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Merge change
s
from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Help
t
he parser
run faster by avo
i
d
ing
t
h
e
"
e
x
plain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
P
r
o
hib
i
t bound parameters in the arguments to tabl
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
V
ersion 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ar
d
Hipp
I
n
crea
s
e the version
n
umber to 3
.
2
3
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
R
emo
v
e an unnece
s
sary SQLITE_UNT
E
STABL
E
compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-level
R
EADME
.
m
d file
t
o p
o
i
nt to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-le
v
e
l
README
.
m
d file
to point to
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor cha
n
g
e
s to t
h
e i
n
put grammar resulti
n
g
in
a faste
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
a
rd
H
ipp
Enhance the
query
p
lanner so t
h
at it dete
c
ts
when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard H
i
pp
Improvements to "
.
whe
r
etrace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hip
p
Fix a (
h
ar
m
less)
s
i
gn
e
d int
e
ger o
v
erflow
warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard H
i
pp
More
c
omplete parsing of UPSERT, incl
u
din
g
UPSE
R
T w
i
thin
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ri
c
hard Hipp
De
m
onstrati
o
n
o
f
how the parser can
be a
u
gmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
chard Hipp
Enhan
c
e LEMON to show precendence of symbols and
a
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
F
i
x
t
he sqlite3
W
hereTr
a
ce me
c
ha
n
i
s
m
so t
h
at it compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
a
r
d H
i
pp
Fi
x
an error me
s
sage
i
n
spe
e
dtest1
.
c and make
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix the generate
_
series
v
ir
t
ual table so
that i
t
correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hi
p
p
Change the LEFT JOIN
s
trengt
h
reduction optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ric
h
ard Hipp
Version 3
.
2
3
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard
H
ipp
B
e
tter
s
ol
u
tion to t
h
e
L
I
KE problem from th
e
previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Ric
h
ard
Hipp
F
ix a logic error discove
r
ed b
y
O
SSFuzz
that can
c
ause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
R
ic
h
a
r
d H
i
pp
Fi
x
a bug in th
e
s
p
ellfix
e
xtension
causi
n
g
it
to c
o
mp
u
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
ard Hipp
Fix an off
-
by-one erro
r
in the dist3 a
l
gor
i
thm of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
R
i
chard
H
ipp
M
o
dify the sqlite3O
s
FileCo
n
trol() inter
f
a
c
e to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard H
i
pp
Fix a ha
r
mles
s
c
ompiler warning in the
k
vtest
.
exe
p
rogram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
F
i
x a harm
l
ess
c
o
m
pile
r
warni
n
g
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ichard Hipp
Remove ta
b
characters
.
No logical changes to
c
o
d
e
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hip
p
Minor com
m
e
nt ch
a
nges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in the README fil
e
f
or ICU
.
No code c
h
anges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Ric
h
ard Hipp
The push-down
o
ptimiza
t
ion was being
t
oo ag
g
ressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
P
rovide the ability for the
VFS
to do a
b
locki
n
g
w
ait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inject OO
M
errors on SQLIT
E
_FCNTL_LOCK_TIM
E
O
UT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avoid a race
c
ondition that might
c
ause a busy_time
o
ut
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ric
h
ard Hipp
Add i
n
frastructure to
supp
o
rt
for using F_SET
L
KW
w
i
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refactor
s
o
me i
n
terna
l
object el
e
men
t
names us
e
d
by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Add test
c
a
s
e() macros and i
m
prove comments in
the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Rich
a
rd
Hipp
Yet another fault in the sqlite3E
x
prImpliesNotNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
chard Hipp
B
ug fix in the LEFT
JOIN streng
t
h reduct
i
on optimization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
P
repend linkage
m
a
c
ros to th
e
sqlite3rebaser interf
a
ces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
i
c
ha
r
d Hipp
Fix the -readonly option on
t
he CLI so that i
t
ac
t
ually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
ard Hipp
Fix typo in a comme
n
t used for documentati
o
n
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix an error in the CLI in the previous ([0249d9ae
c
f699
4
8
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix t
h
e
ANALYZE command so that it will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ric
h
ard Hipp
Add
t
he l
e
ft join st
r
engt
h
reduc
t
i
o
n
opt
i
mization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ri
c
hard
Hipp
Add the --valid-sql option
to th
e
optf
u
zz test program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
i
chard Hipp
Get
t
h
e
op
t
fuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Rich
a
rd
Hipp
Ad
d
t
h
e optfuz
z
.
c prog
r
am for verifying the query planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
hard Hipp
R
e
la
x
L
E
FT-JOIN re
s
tr
i
cti
o
ns
o
n the push-down
optimization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richar
d
Hipp
D
o
a
m
ore t
h
o
r
ough
j
ob of cleaning traces of the stre
n
gth
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
ic
h
ard Hipp
If terms of the WHERE clause require t
h
at
t
he right
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
F
i
x incorrect testca
s
e labels on two ca
s
e
s
in join5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard
H
ipp
Improvements to the
HA
V
I
N
G-t
o
-
W
HERE o
p
timization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Avoid unnecessary write to the sql
i
te
_
s
e
quence tabl
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard
Hipp
A
d
d
the
ability
to
disable the
p
ush-d
o
w
n
op
t
imizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Remove
a debugging stat
e
ment
a
ccide
n
tly
l
eft in
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard H
i
p
p
In the CLI, a
v
oid extra
.
selecttrace and
.
wheretrace
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
Closer rea
d
ing of the sqlite3_db_co
n
fig() documen
t
a
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Fix
a mi
n
or formatting
i
ssue
on
the s
q
lit
e
3_db_config
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Add th
e
ability to
disable the pu
s
h
-
d
own optimi
z
ation
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
Minor
imp
r
o
vements to "
.
selecttr
a
ce"
.
No changes to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
Enhance the command-line completion extension to retur
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
In the com
p
i
le_o
p
tions pr
a
gma
,
sho
w
the actual value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
Improved "
.
s
electtr
a
c
e" output formatting
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Ric
h
ard Hipp
D
o not use sqlite3_column_decltype
(
)
i
n th
e
CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ri
c
hard
Hip
p
Detect corrupt
i
on in the
f
orm of
the sqlite_sequence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
R
icha
r
d Hi
p
p
Detec
t
da
t
abases whose schema is cor
r
u
pted using a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
R
i
chard Hipp
Better error message text when
t
he
schema
i
s
corrupted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard H
i
pp
Avoid writing
the sql
i
te_sequence table whe
n
it has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richar
d
Hip
p
Fix
a
typo in a comment u
s
ed to generate docu
m
ent
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richar
d
H
i
pp
Fix
an issue w
i
th the fsdir()
table-valu
e
d fu
n
cti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
A
d
d t
h
e SQLITE_D
B
S
T
ATUS_
C
ACHE_SPILL o
p
ti
o
n to sqlite3_db_
s
ta
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richa
r
d
H
ipp
Disable one of the test cases from check-i
n
[21ecbce
1
378f3cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard H
i
p
p
Add the SQLITE_
D
BSTATUS_CACHE_SPILL opt
i
on to sqlite3_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
hard Hipp
F
i
x the s
e
cond callback argument to the "pr
o
f
i
l
e"
response
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard
Hipp
Add suppo
r
t for INSERT OR REPLACE and INSERT OR IGNORE
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Rich
a
rd Hipp
I
m
proved error messages f
r
om
the z
i
pfile extension
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hipp
Avoid ha
r
ml
e
ss left-shifts
o
f
negative numbers in
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hipp
Fi
x
t
h
e zipfile
e
xtens
i
on so
t
hat i
t
is abl
e
to create
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
Fi
x
the
.
archive co
m
m
and in
the
CLI so that it act
u
ally
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
Enhance the "
.
ar
"
comm
a
nd i
n
the CLI
s
o that it is
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
Set
t
ing "
.
stats 2"
i
n the CLI causes column metadata
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hi
p
p
Si
m
plification to the shell_
e
xec()
m
echanism
in
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
ichard Hipp
Fix a test case in zipfilefault
.
t
e
st so tha
t
it only
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Rich
a
rd Hipp
Attempt to fix
a harmless
compiler warning from Clang
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
Richar
d
Hipp
Add the --append and --zip
options of t
h
e CLI to
the
.
.
.
commit
|
commitdiff
|
tree
next