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
Change the LEFT JOIN strength reduction optimization so that assumes that
2018-04-03
D
.
Richard Hi
p
p
Chan
g
e t
h
e
LEFT JOIN
stre
n
g
t
h reduct
i
o
n opti
m
izat
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Ve
r
sion 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard
H
ipp
Better solution to the LIKE problem
f
rom the previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Ri
c
hard Hipp
Fix a log
i
c
e
rror discover
e
d b
y
OS
S
Fuzz t
h
at can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
ar
d
Hip
p
Fix
a
bug in th
e
spellfix extensio
n
caus
i
ng
i
t
t
o
comp
u
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an off-b
y
-one
e
r
ror in th
e
dist3
algorithm of th
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hip
p
M
o
dif
y
the sqlite3OsF
i
l
eCont
r
o
l
(
) interface
to d
e
tect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richar
d
H
i
pp
Fix a
h
ar
m
less com
p
iler w
a
rn
i
n
g
in the kvte
s
t
.
exe program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hi
p
p
Fix a
h
armless co
m
pil
e
r
war
n
ing
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Remove tab
c
ha
r
acters
.
No logi
c
al changes to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard H
i
p
p
M
i
nor
comment c
h
anges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a
typo
in the
README file for ICU
.
No co
d
e
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d Hipp
The push-down
optimization was be
i
ng
t
o
o aggressiv
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d Hipp
Provide
the
ability
f
or the VFS to d
o
a blo
c
king w
a
it
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inje
c
t OOM errors
o
n SQLITE_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
i
cha
r
d Hipp
Avoid a r
a
c
e
condition th
a
t mig
h
t cause a b
u
sy_time
o
ut
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richar
d
Hipp
Add in
f
rastructure to support for using F_SET
L
KW wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richa
r
d Hipp
Re
f
actor s
o
me int
e
rnal o
b
j
e
ct element name
s
us
e
d by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard H
i
pp
Add testcase() macros and i
m
prove comments in the
LE
F
T
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Yet anothe
r
fault in the sqlite3ExprImpliesNot
N
u
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ri
c
har
d
Hipp
Bug
fix in the LEFT J
O
IN strength re
d
uction optimization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Prepend
l
inkage
m
acros to the sqlite3
r
e
b
a
ser
i
nterfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
icha
r
d Hipp
F
i
x
t
he
-
reado
n
l
y
op
t
ion on the CLI
s
o t
h
at it ac
t
ually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
ard Hipp
Fix typo
i
n
a co
m
ment
used for documentati
o
n
.
N
o
changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix an error in the CLI i
n
the previous ([0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the ANALYZE command so t
h
at it will pr
o
cess tabl
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hipp
Add the
l
eft join stren
g
th
reduction optimiz
a
tion
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
R
i
chard Hipp
Add the --valid
-
sql opti
o
n to the optfu
z
z test pr
o
g
ram
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
hard
H
ipp
Get the optfuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
hard Hip
p
Add the optf
u
zz
.
c program for
veri
f
ying
t
he query pl
a
nn
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Rich
a
rd Hipp
Relax
LEFT-JOIN re
s
tric
t
ions on the push-d
o
wn opti
m
izati
o
n
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Do a mor
e
th
o
rough job o
f
cleaning tr
a
ces
o
f the strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
c
ha
r
d Hi
p
p
If terms of the WHERE c
l
aus
e
r
equire that the
r
ight
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Fi
x
inco
r
rect testcase labels on two cases in
join5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
Hip
p
Impr
o
vements to t
h
e
H
AVING-to-WH
E
RE
o
p
timi
z
ation
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d Hipp
Avoid u
n
n
e
cessar
y
write to the sqlite_sequence ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Add t
h
e ability to
d
isable the p
u
sh-
d
o
w
n optimizat
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Remove a debug
g
in
g
st
a
t
ement accidently left in
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard Hipp
In the CLI, avo
i
d extra
.
selecttrace a
n
d
.
w
h
eret
r
ace
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d Hipp
Closer readin
g
of t
h
e
sqlite3_
d
b_config()
d
ocument
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
ichard
H
ipp
Fix
a
min
o
r format
t
i
n
g issue on the sqlite3_db_confi
g
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
c
hard Hipp
Ad
d
t
h
e ability to disable t
h
e push-d
o
wn optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
M
in
o
r
imp
r
o
v
ements to
"
.
s
e
lectt
r
ac
e
"
.
No c
h
anges
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
R
i
chard
Hipp
E
nhance the command-line completion extension to re
t
urn
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ri
c
ha
r
d
Hipp
In
the compi
l
e_optio
n
s pra
g
ma
,
show
the actua
l
value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ric
h
ard
Hipp
Im
p
r
ove
d
"
.
selecttr
a
c
e"
output
f
ormat
t
ing
.
No
changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard Hip
p
D
o not use sqlite3_column_decltype
(
) in the CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
R
ichard Hipp
Detect corru
p
tion in the form of
t
he sqlite_
s
equ
e
nce
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Det
e
ct database
s
whose schema
is co
r
rupted usin
g
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Better error message text
when
the schema
is corrup
t
ed
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ri
c
h
ard Hi
p
p
Avoid wr
i
t
i
ng the sqlite_sequence table when it has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
R
i
char
d
Hip
p
Fi
x
a
t
ypo i
n
a comment used to generat
e
d
o
cumenta
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard
H
i
pp
Fix an issue with the fsdir() table
-
valu
e
d f
u
nct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Ric
h
ard
Hipp
Add the
S
Q
L
ITE_DBS
T
ATUS_CACHE_SPILL opti
o
n
to sqlite3_
d
b_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Ric
h
ar
d
Hipp
D
isable one of
the test cases f
r
o
m che
c
k-in [21e
c
bce1378f3c
c
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard
H
ipp
Add the
S
QL
I
T
E
_D
B
STATUS_CA
C
H
E_SPILL opt
i
on to s
q
l
ite
3
_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
R
i
chard Hipp
Fix the secon
d
callback argument to
t
he "profile" response
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
har
d
Hipp
A
dd
s
upport for
I
NSER
T
OR REPLACE and
INSER
T
OR
IGNORE
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
R
i
chard Hi
p
p
I
mprov
e
d error messages
f
ro
m
the
z
ipfile extensio
n
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ric
h
ard
Hi
p
p
Avoid harmless left-
s
hifts of negativ
e
numbers in the
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hipp
Fi
x
the
z
ipfile extensio
n
so that it i
s
able t
o
c
r
e
a
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
ichard Hipp
Fix th
e
.
archive command in th
e
CLI so th
a
t
i
t a
c
tually
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
E
n
hance
t
h
e
"
.
ar" command in
the
C
L
I so that it is
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
icha
r
d Hipp
Setting "
.
s
t
ats
2" i
n
the CLI causes column metadata
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
Simplification to the shell_e
x
ec() mec
h
anism in the
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard
H
i
pp
F
i
x
a test
case i
n
zipfi
l
efault
.
test so that it only
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard H
i
p
p
Attempt to fix a harmless compiler war
n
ing from
C
la
n
g
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
Richa
r
d Hipp
A
dd
t
he --a
p
pend and
--zip op
t
io
n
s of
t
he CLI to
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
R
i
chard Hipp
Updates to
d
ocumentation
o
n
sqlite3_ser
i
alize() and
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richa
r
d
Hipp
Add the sessionfuzz te
s
t progr
a
m an
d
data obta
i
ned
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richa
r
d Hipp
Add the sq
l
ite3_serial
i
ze
(
)
and sqlite3_deserialize
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Ri
c
hard
Hipp
Mark an unr
e
achabl
e
branc
h
using N
E
VE
R
(
)
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Ri
c
ha
r
d
H
ipp
Improved documentation for sqlite3_serializ
e
(
) and
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
R
i
chard Hipp
Handle some
b
oun
d
ary ca
s
es in memdb associat
e
d with
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
R
i
chard
H
ipp
S
i
mpl
i
fi
c
atio
n
s
to the
memd
b
VFS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
R
i
c
h
ard
H
ipp
I
m
proveme
n
ts
to the memdb VFS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Richard H
i
pp
Mer
g
e the walIt
e
rato
r
Init
(
)
fix f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
R
i
chard Hipp
Fi
x
walIteratorInit()
s
o
that it a
l
ways leaves
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richard Hipp
Merge th
e
ses
s
ion fix f
r
o
m trunk
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
R
i
chard Hipp
Imp
r
oved comm
a
nd-line help
for the -A op
t
ion
o
n
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
R
i
chard
H
ipp
A new way
o
f doing a
r
chive
c
ommands
on the com
m
and
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Ric
h
ard Hipp
I
n
t
he C
L
I, add a n
e
w command
-
line option "--ar
c
h
ive
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richard H
i
pp
Merge
s
essi
o
n fi
x
es from trun
k
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
Ric
h
ard Hip
p
Allow the zSchema a
r
gument to sqlite3_seri
a
lize() to
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
Richard H
i
pp
Merge the la
t
est enh
a
ncements from trunk
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hip
p
Enhance
th
e
session
s
documentation to show
t
h
e
met
h
o
ds
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hip
p
Use
&
l
t;pre&
g
t
;
a
round code snippets in
t
he docu
m
en
t
ation
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hipp
Fix a potential NULL pointer
dere
f
fol
l
owing OOM i
n
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
Richard Hipp
Add support for TRUE
and FALSE
k
e
ywords and for operators
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
R
i
chard Hipp
Clean u
p
comments
and variable names
p
rior to
m
e
r
g
e
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
R
i
c
hard
Hi
p
p
Re
m
ove an
unnec
e
ssa
r
y decision
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hip
p
C
o
de si
m
plific
a
t
io
n
s
.
New test cases
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
Get th
e
"DEFAULT tru
e
" a
n
d "DEFAULT false" phr
a
ses
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richar
d
Hipp
Enhance TreeView so th
a
t it can disp
l
ay the new IS
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
Refac
t
or for c
o
rr
e
ct NUL
L
h
a
ndl
i
ng
i
n the I
S
TRUE,
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
i
chard Hipp
M
e
rge the fix for
d
etermin
i
n
g
truth
o
f floa
t
i
n
g point
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
Always interpret non-zer
o
flo
a
ting-
p
o
i
n
t
values as
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
ic
h
ard
H
ip
p
E
x
periment
a
l implementa
t
ion o
f
IS TRUE
a
nd IS FALSE
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Rich
a
rd Hipp
For the "SQL
i
te archive" link in the
READ
M
E
.
md file
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Richa
r
d Hipp
U
p
da
t
es to the RE
A
DME
.
md
file
.
Mention the abil
i
ty
.
.
.
commit
|
commitdiff
|
tree
next